• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Data Storage Options

When organizations make the switch to a combination of OLTP and OLAP computer systems, they frequently do not plan their computer network architectures fully. Usually, these organizations go through a trial-and-error approach, in which they deploy their computer systems, realize that mistakes were made, and then deploy the same computer systems again. The results of redeployment are usually significant in both time and money. Planning a good data storage strategy is one of the most vital components to successfully deploying an efficient OLTP/OLAP system.

Storing large amounts of data on individual laptop and desktop computers, or on network computers without data recovery mechanisms such as backups in place, can lead to disaster if the data is ever compromised or lost. Products such as SQL Server provide for backups, transaction recovery and transaction rollbacks, advanced indexing for finding data more quickly, and automated database management wizards. (Chapter 12, “Maintaining Data Reporting and Analysis Systems,” covers data management in more detail.)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint