DBMS/Storage Manager

From Wikibooks, open books for an open world
Jump to navigation Jump to search

Storage manager module of the database provides the interface between the following component:

  • data stored in the database
  • the application programs
  • queries submitted to the system

Components of a Storage Manager[edit | edit source]

file manager[edit | edit source]

function of the file manager is to manage disk space for storage and manage data structure used for storing information.

buffer manager[edit | edit source]

The buffer manager reads disk pages into a main memory page as needed. The collection of main memory pages (called frames) used by the buffer manager for this purpose is called the buffer pool. This is just an array of Page objects. The buffer manager is used by (the code for) access methods, heap files, and relational operators to read / write /allocate / de-allocate pages. The Buffer Manager makes calls to the underlying DB class object, which actually performs these functions on disk pages.

Replacement policies for the buffer manager can be changed easily at compile time.

data integrity manager[edit | edit source]

transaction manager[edit | edit source]

Storage access[edit | edit source]

Indexing and hashing[edit | edit source]

Many queries reference only a small proportion of records in a file. For example, finding all records at Perryridge branch only returns records where bname = ``Perryridge. We should be able to locate these records directly, rather than having to read every record and check its branch-name. We then need extra file structuring.

Parsing and translation[edit | edit source]

Optimization[edit | edit source]

Evaluation[edit | edit source]

As we know that, computer has two storage memories 1.primary storage 2.secondary storage