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