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
What is meant by mean time to failure? The mean time to failure is the amount of time that the system could run continuously without failure.

Consider a table student (std_id, std_name, date_of_birth, percent_marks, dept_name). Write a QBE query to display names of Computer Science department students who have scored mo

Create centralized relational database using Top down method- Construction of Logical Model: Translation EERD into Relational Schema: Use the 8 steps algorithm of converting EERD


What is meant by object-oriented data model? The object-oriented paradigm is based on encapsulation of data and code related to an object in to a one unit, whose contents are n

ERD Diagram of Medical Recruitment Agency?


Implementation of association as an object Implement as a separate association object, independent of either class, as in Figure. An association object is a group of pairs

Give the Introduction of OBJECT DESIGN Strategies which are selected during system design are carried out in object-oriented design. In this procedure, objects which are identi

Domain Constraints Domain constraints are primarily formed for defining the logically correct values for an attribute of a relation. The relation allows attributes of a relatio