Research on the Performance Optimization of Massive Data Query Based on the Index

Peng Wang; Ai Xue  Tian

doi:10.4028/www.scientific.net/AMR.765-767.867

Paper Titles

Cloud Computing Environment Data Mining Storage Management Design
p.850

A Project-Based Approach to Teaching Programmable Logic Controller Course
p.854

Teaching Reform and Practice of Computer Control System
p.858

An Approach to Website Structure Optimization Based on Navigation Cost
p.863

Research on the Performance Optimization of Massive Data Query Based on the Index
p.867

A Function Level Randomization Technique to Mitigate ROP Attacks
p.871

Efficiency of Dynamic GOP Length in Video Stream
p.879

Analysis of the Remote Emergency Care in Wartime
p.885

The Application of Internet of Things in Crop Production Management Research
p.889

HomeAdvanced Materials ResearchAdvanced Materials Research Vols. 765-767Research on the Performance Optimization of...

Research on the Performance Optimization of Massive Data Query Based on the Index

Abstract:

The explosive growth in data quantity today, massive data query performance is good or bad becomes important. In order to avoid system response time is long, wasted resources from happening. We are actively exploring methods and strategies to make massive data query performance optimization. Massive data query performance optimization is a systematic project, involving many aspects, in which the index plays an important role. This article obtains from the index, based on Oracle, the paper analyzes the structure of B-tree index, the way of data scanning, as well as how to correctly use the index and rely on the index attribute to optimize massive data query performance.

You might also be interested in these eBooks

View Preview

Info:

Periodical:

Advanced Materials Research (Volumes 765-767)

Pages:

867-870

DOI:

https://doi.org/10.4028/www.scientific.net/AMR.765-767.867

Citation:

Cite this paper

Online since:

September 2013

Authors:

Peng Wang, Ai Xue Tian

Keywords:

Index, Massive Data Query, Oracle, Performance Optimization

Export:

RIS, BibTeX

Price:

Permissions CCC:

Request Permissions

Permissions PLS:

Request Permissions

Сopyright:

Citation:

References

[1] Wenping Hou: The Art of Database Performance Optimization (China Machine Press, In Chinese).

Google Scholar

[2] Jiang Zhang: Modern Computer December (2012), pp.15-18.

Google Scholar

[3] Nengji Chen, Boya Guo: Performance testing of diagnostic analysis and optimization(Publishing House of Electronics Industry, In Chinese).

Google Scholar

[4] Yong Chen, Xusheng Xie and Genya Wei: Computer and modern 10th in 2008 , pp.56-59.

Google Scholar

[5] Xiaoqiu Gu, Dechang Li: Computer engineering and applications 26th in 2005, pp.174-176.

Google Scholar

[6] Huaiyuan Tan: Let Oracle run faster 2 - based on the database design and optimization of massive data (Publishing House of Electronics Industry, In Chinese).

Google Scholar