Research on Improving Data Query Speed Methods

Feng Qin Wang; Yu Liu; Qing Long Han

doi:10.4028/www.scientific.net/AMM.556-562.5825

Paper Titles

QoS-Aware Dynamic Virtual Resource Management in the Cloud
p.5809

Study on the Cloud Computing in Digital Libraries
p.5813

Web Visualized Method Oriented to Internet Education Text Resources
p.5817

Computer Network Behavior Research Based on the Theory of Complexity
p.5822

Research on Improving Data Query Speed Methods
p.5825

Pearson-III Frequency Curve Plotting in Excel Table
p.5829

Construction of Cloud Geographic Information System Based on Hadoop
p.5835

A Software Component Library Implemented by Using Faceted Classification Scheme and Component Management Protocol
p.5839

A Handover Process Analysis Method in LTE-A Heterogeneous Network
p.5843

HomeApplied Mechanics and MaterialsApplied Mechanics and Materials Vols. 556-562Research on Improving Data Query Speed Methods

Research on Improving Data Query Speed Methods

Abstract:

In order to improve data query speed, there are four methods: optimization of SQL (Structured Query Language) statements and reasonable use of index, temporary tables and views are researched. Practice demonstrates these four methods can improve query speed and database performance.

You might also be interested in these eBooks

View Preview

Info:

Periodical:

Applied Mechanics and Materials (Volumes 556-562)

Pages:

5825-5828

DOI:

https://doi.org/10.4028/www.scientific.net/AMM.556-562.5825

Citation:

Cite this paper

Online since:

May 2014

Authors:

Feng Qin Wang*, Yu Liu, Qing Long Han

Keywords:

Data Query, Database Performance, Index, Structured Query Language, Temporary Table, View

Export:

RIS, BibTeX

Price:

Permissions CCC:

Request Permissions

Permissions PLS:

Request Permissions

Сopyright:

Citation:

* - Corresponding Author

References

[1] Huang Jingjing. Analysis Database Query Optimization based on SQL server [J] Enterprise Information. 2006 (8): 181.

Google Scholar

[2] Zhu Dong. Query Optimization based on SQL Server [J] Information and Computer . 2011 (11): 172.

Google Scholar

[3] Li Junmin. Details of SQL-Structured Query Language [M] Beijing: People's Posts and Telecommunications Press . 2008 (8).

Google Scholar

[4] Niu Xinzhuang. Performance Tuning and Optimization of DB2 Database [M]. Beijing: Tsinghua University Press, (2009).

Google Scholar

[5] Xiao Jun. ORACLE Database Performance Tuning and Optimization [D]. Wuhan: Wuhan University, (2004).

Google Scholar

[6] Zhu Yanmei, Shao Yuanshan. DB2 database application system performance optimization methods [M] based. Hefei: Hefei Institute of Management, (2006).

Google Scholar

[7] Taojian Wen. Design and implementation of a distributed Web Log Mining System [J]. Computer Simulation, 2006 (10) : 133-134.

Google Scholar