How are tables stored on disk?, Database Management System

How are tables stored on Disk?

We realise that every record of a table can have different amounts of data. This is due to in some records; some attribute values may be "zero". Or, some attributes might be of type varchar (), and thus each record may have a dissimilar length string as the value of this attribute. Thus, the record is stored with each subsequent attribute splitted by the next by a special ASCII character known as a field separator. Of course, in every block, we may place several records. Every record is separated from the next, again by another special ASCII character known as the record separator.

 

 

Posted Date: 3/7/2013 6:07:22 AM | Location : United States







Related Discussions:- How are tables stored on disk?, Assignment Help, Ask Question on How are tables stored on disk?, Get Answer, Expert's Help, How are tables stored on disk? Discussions

Write discussion on How are tables stored on disk?
Your posts are moderated
Related Questions
Demonstrate the UML model Using UML, it is possible to generate code in any of the programming language from UML model (called forward engineering) and rebuild a model from an


Locks: Serialisabilty is just a test whether a given interleaved schedule is ok or has a concurrency related trouble. Though, it does not make sure that the interleaved concurrent

Surgeons identified by doctor ID (DOCID) operate on patients identified by patient ID (PATID) in operating theaters identified by room numbers (ROOMNO). Each surgeon can operate on

Fragmentation: It is definite as partitioning of a relation into various fragments.Every fragment can be stored at a dissimilar site.

Why do you go for sorting your query results? SQL SELECT command to fetch data from MySQL table. Whenever you select rows, the MySQL server is free to return them in any order

List the internal controls that should be in effect solely because a EDP system is employed, classifing them as (1) Those controls pertaining to input of information and (2) All ot

What are the function of DBA?

Design an algorithm to implement operations  Each and every operation specified in the functional model could be formulated as an algorithm. The algorithm indicates how operat

folding method and mid square method using visual basic