Article | REF: H3702 V1

Optimization of databases

Authors: Anne DOUCET, Hubert NAACKE

Publication date: August 10, 2007 | Lire en français

You do not have access to this resource.
Click here to request your free trial access!

Already subscribed? Log in!

Automatically translated using artificial intelligence technology (Note that only the original version is binding) > find out more.

    A  |  A

    3. Data storage

    Data is stored permanently in a mass storage device, usually a hard disk (see Magnetic and optical storage devices ). Data is stored on concentric circular tracks divided into several sectors. A block is made up of several contiguous sectors of the same track, and corresponds to the elementary quantity of information that can be read or written in a single operation. The size of a block, generally 4 kB, is set when the disk is formatted and is independent of the database's specificities.

    The access time to any given block depends on the radial travel time of the read head to the track, the rotation of the disk until the first sector to be read is placed under the head, and the time taken to read the sectors. The performance of a hard disk is measured by two values: latency corresponds to the average time taken for the read head to move to any page,...

    You do not have access to this resource.

    Exclusive to subscribers. 97% yet to be discovered!

    You do not have access to this resource.
    Click here to request your free trial access!

    Already subscribed? Log in!


    The Ultimate Scientific and Technical Reference

    A Comprehensive Knowledge Base, with over 1,200 authors and 100 scientific advisors
    + More than 10,000 articles and 1,000 how-to sheets, over 800 new or updated articles every year
    From design to prototyping, right through to industrialization, the reference for securing the development of your industrial projects

    This article is included in

    Software technologies and System architectures

    This offer includes:

    Knowledge Base

    Updated and enriched with articles validated by our scientific committees

    Services

    A set of exclusive tools to complement the resources

    Practical Path

    Operational and didactic, to guarantee the acquisition of transversal skills

    Doc & Quiz

    Interactive articles with quizzes, for constructive reading

    Subscribe now!

    Ongoing reading
    Data storage