A Query Optimization Technology Based on Data Partition

Article Preview

Abstract:

With the promotion of 3G networks and upcoming 4G network, mobile phone users in constant rise. The volume of data they produce will soar every day. A variety of data appear results in the database have rapid increasing. Some application system in access to these heterogeneous, huge databases is bound to access difficulties, the problem of low efficiency of access. Query optimization technology is proposed in this paper, based on data partitioning, by reducing the database size to solve the problem of memory and huge amounts of data access problems. From the experiment test, the method can effectively improve the efficiency of huge amounts of data access, can get satisfactory results.

You might also be interested in these eBooks

Info:

Periodical:

Pages:

512-515

Citation:

Online since:

April 2014

Authors:

Export:

Price:

Permissions CCC:

Permissions PLS:

Сopyright:

© 2014 Trans Tech Publications Ltd. All Rights Reserved

Share:

Citation:

[1] EBERHARD P J, TRIPATHI P A. Mechanisms for object caching in distributed applications using java rmi[J]. Software Practice and Experience, 2007, Vol-37(no. 8): 799-831.

DOI: 10.1002/spe.783

Google Scholar

[2] Sun Microsystems. Java remote method invocation specification, http: /java. sun. com/j2se/1. 4. 2/docs/guide/rmi/spec/rmiTOC. html, (2003).

Google Scholar

[3] YE X T. The research of heterogeneous database middleware model[C]. Proceedings of the 3rd WSEASinternational conference, 2009: 243-246.

Google Scholar

[4] SONG X Z, ZHANG R Z. Research on constructing distributed large database based on J2EE[C]. IEEE, 2008: 704-707.

Google Scholar

[5] LIU F. A method of design and optimization of database connection pool[C]. IHMSC 2012 4th International Conference, 2012, Vol-2: 272-274.

Google Scholar

[6] BAI Y. JDBC api and JDBC drivers[M]. Wiley-IEEE Press, 2011: 89-111.

DOI: 10.1002/9781118104651.ch3

Google Scholar

[7] The Self-Managing Database Oracle Database 10g Release 2. An Oracle White paper, (2006).

Google Scholar