• 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