Storage Has an Impact on Database Performance

Koopmann, James F.
February 2007
Database Trends & Applications;Feb2007, Vol. 21 Issue 2, p18
The article discusses the impact of storage on database performance. After enumerating the steps in storing database, the author declares that there is little collaboration between the database and storage administrator. He investigates small and large database shops and asked them the different application of RAID level and the allocation of new database storage. Based from the response, he reveals that the administrators did not know the implications of one configuration to another. Consulting a storage vendor is recommended to obtain optimal performance from storage array.


Related Articles

  • Dynamic Storage Fragmentation and File Deterioration. Leung, Clement H.C. // IEEE Transactions on Software Engineering;Mar86, Vol. 12 Issue 3, p436 

    As a result of insertions and deletions, a file tends to be cluttered with deleted records which are physically present. These unwanted records cause fragmentation within the file and give rise to additional access overhead because they have to be skipped over during processing. A connection...

  • Where to Start to Understand Metadata? Schraml, Todd // Database Trends & Applications;Jan2006, Vol. 20 Issue 1, p26 

    The article explores the topic of metadata. The essentiality of metadata is often lost because there is no definite understanding as to what metadata really is, and as to how it can be applied to the day-to-day business. According to the author, metadata can define one's perception of the world,...

  • Federated database manages change. Nielsen, John // Network World;3/20/2006, Vol. 23 Issue 11, p41 

    The article discusses the advantages of a federated configuration management database (FCMD) over a regular configuration-management database that serves as a central repository of information that documents changes to a network. The FCMD operates in such a way that the configuration data is...

  • The Most Important Thing is Recoverability. Mullins, Craig S. // Database Trends & Applications;Dec2007, Vol. 21 Issue 12, p26 

    This article focuses on database administration. Many database administrations will claim that managing performance is the most significant thing they do, but they are confusing frequency with importance. It discusses that it is the task of the database administrator to keep the information in...

  • Database Storage Management is Challenging. Mullins, Craig S. // Database Trends & Applications;Jan2006, Vol. 20 Issue 1, p26 

    The article discusses the challenges associated with database storage management (DBMS). There is a need for database administrators (DBA) to be proficient in the different syntax and methodologies for each DBMS. They must also assure availability and performance of the databases being managed....

  • Controlling the Use and Evolution of Database Systems: A Prolog-based Approach. Rozenshtein, David; Minsky, Naftaly // Journal of Management Information Systems;Summer86, Vol. 3 Issue 1, p5 

    This paper presents a model that provides a single comprehensive mechanism to control the use, operation, and evolution of database systems. This model unifies several concepts generally considered to be quite distinct. In particular, it minimizes the formal distinction between the users of the...

  • The Consequences of Dimension Degeneration When Building a Star Schema. SCHRAML, TODD // Database Trends & Applications;Jun2013, Vol. 27 Issue 2, p56 

    The article offers information related to establishing star schema for expanding databases. It is suggested to use a combination of all dimension keys plus all degenerated attributes to form table and columns for databases. It is suggested to avoid degeneration in designing star schema. It is...

  • The Log is the Database. Mullins, Craig S. // Database Trends & Applications;Sep2005, Vol. 19 Issue 9, p26 

    This article defines and describes the function of the database log, or transaction log, which is a fundamental component of a database management system (DBMS). All changes to application data in the database are recorded serially in the database log. Using this information, the DBMS can track...

  • Managing a messy PC. O'Shanassy, Terry // Australian PC User;Jul2006, Vol. 18 Issue 7, p110 

    The article offers tips in organizing personal computers. The best approach is to create a new folder structure, sort through existing files folder by folder and move them across to the appropriate new storage locations, and delete the old haphazard structure. Folders should be used in a tree or...


Read the Article


Sorry, but this item is not currently available from your library.

Try another library?
Sign out of this library

Other Topics