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 the main difference between read-only and update methods? A read-only method does not affect the values of a variable in an object, whereas an update method may alter t

how to write a in a text and load it on mysql

Data Control The data control mostly refers to commands that permit system and data privileges to be passed to several users. These commands are usually available to database admi

What is aggregate function? Briefly describe it? Aggregate functions are functions that take a collection of values as input and return a one value. SQL offers 5 built-in aggre

Data Definition Language It organises the data in the form of columns and rows. But what does the data field column of table accumulate? How do you describe it using SQL? Th

Question : (a) Database Management Systems (DBMS) is the foundation of business intelligence. Explain the following concepts related to DBMS: (i) Entity Relationship Diagr


What is meant by buffer blocks and disk buffer   The blocks residing temporarily in main memory are referred to as buffer blocks. The area of memory where blocks reside t

Question (a) Differentiate between the following terms: (i) Distributed Database v/s Distributed Database management System (ii) Homogeneous Distributed Database v/s Hete

Define Shared locks? Ans: Shared lock: Throughout concurrent execution of transactions, earlier than a transaction can access a data item, it has to obtain a lock on it. Now he