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
Making Common Behaviour Abstract Let us define abstraction "Abstraction means to focus on the necessary, inherent aspects of an entity and ignoring its accidental features". O

Q.   Why would you choose a database system instead of simply storing data in operating system file? Define  at a base concept in details. Sol. Advantages of Database over Fil

The natural join is equal to which product? The natural join is equal to Combination of projection and Cartesian product

what is difference between circular inked lust and grunded linked list

What is data independence? Data Independence: Techniques which permit data to be changed without affecting the applications in which procedure it. There are two types of data

Consider the following relational schema: PERSON (SS#, NAME, ADDRESS) CAR (REGISTRATION_NUMBER, YEAR, MODEL) ACCIDENT (DATE, DRIVER, CAR_REG_NO) OWNS (SS#, LICENSE) Constru

Law Associates is a large legal practice based in Sydney.  You have been asked to design a data model for the practice based upon the following specification: The practice emplo

What are the different approaches for database design? There are two basic approaches for database design which are as follows: Attribute driven: It compiles a list of att

What is object identity? An object retains its identity even if some or all the values of variables or explanations of methods change overtime.

For the relations answer the following queries in SQL Street (name, location, city) House (number, street_name) Lives (name, house_number) (i) Obtain the names of persons who liv