DocumentCode :
554892
Title :
The design research on the Storage structures for large amount of Data of the database
Author :
Huaqiang Zhou ; Zhihong Yao ; Han Xiao
Author_Institution :
Zhongyuan Univ. of Technol., Zhengzhou, China
fYear :
2011
fDate :
11-13 Aug. 2011
Firstpage :
384
Lastpage :
388
Abstract :
As a running core of the corporate data, the performance and efficiency of the database play an important role during the daily productive process. The technicians usually concentrate on some technical questions, such as the query algorithm, SQL Tuning, the underlying principle of the database software, etc. However, they have overlooked the importance of completely understanding the storage and design of the initial data. On the basis of the real features of the data, the Data Storage Design Patterns have closely analysed the data direction, the features of the data access, the data quantity, the increment of the data, and the life circle of the data. After classifying the data, the Data Storage Design Patterns will design storage policies for different types of data. If the Data Storage Design Patterns have been properly used, the efficiency of the data access will be doubled.
Keywords :
SQL; database management systems; storage management; SQL tuning; data access; data direction; data incrementation; data life circle; data quantity; data storage design patterns; database; design research; query algorithm; storage structures; Business; Data models; Indexing; Memory; Planning; SQL Tuning; data driven; index; life circle of the data; partition; storage parameter;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
Advanced Mechatronic Systems (ICAMechS), 2011 International Conference on
Conference_Location :
Zhengzhou
Print_ISBN :
978-1-4577-1698-0
Type :
conf
Filename :
6024921
Link To Document :
بازگشت