What are the purpose for having variable length records, Database Management System

Assignment Help:

What are the purpose for having variable length records? What kinds of separator characters are required for each?

Variable-Length Records - Variable-length records are those records that are of various sizes. A file may holds variable-length records in any of the subsequent situations:

• Records having variable length fields - In this case, the end-of-field symbol along with end-of-record symbol could be used as the separator characters.

• Records having repeating fields - In this case, the number of repetitions of repeating area can be used along with end-of-record symbol as the separator characters.

• Records having optional fields - In this case, the end-of-field symbol along with end-of-record symbol could be used as the separator characters.

• File containing records of various record types - In this case, a special field (or control field) can be prefixed with every record and end-of-record symbol could be used as the separator characters.

In each of the above situations either we can use end-of-record symbol or the length of every record can be prefixed at the starting of the record for the separation of the variable-length records.


Related Discussions:- What are the purpose for having variable length records

Relationship, what is the relationship between receipt and owner entities i...

what is the relationship between receipt and owner entities in computer sales and service company

Example-revoke all on emp from mca12, Example:  //REVOKE ALL ON EMP FROM MC...

Example:  //REVOKE ALL ON EMP FROM MCA12;                              (All permissions will be cancelled) You can also cancel only some of the permissions. Drop: A user-

Write short notes on domain relational calculus, Write short notes on domai...

Write short notes on domain relational calculus The domain relational calculus uses domain variables that take on values from an attribute domain rather than values for whole t

RDBMS, Benefits and limitations

Benefits and limitations

Explain the ansi sparc architecture, Explain the ANSI SPARC architecture ...

Explain the ANSI SPARC architecture The three-schema architecture is as well known as ANSI SPARC architecture. The aim of the three-schema architecture is to separate the user

Process of implementing system design in dynamic models, Process of impleme...

Process of implementing system design in dynamic models There are three essential approaches to implementing system design in dynamic models. These approaches are as below:

What is magnetic disks, What is magnetic disks?explain it? Magnetic dis...

What is magnetic disks?explain it? Magnetic disk provides the bulk of secondary storage of modern computer system. The disk capacity is growing at over 50% per year. But the st

Describe analysis of access paths, Describe analysis of access paths To...

Describe analysis of access paths To describe analysis of access paths, consider an example of the design of a company's employee skills database. A part of the object model fr

Anomalies, define anomalies and different types of anomalies with example

define anomalies and different types of anomalies with example

Determine the benefits of object oriented design, Determine the benefits of...

Determine the benefits of Object oriented design OOD also gives reusability, which saves time, costs and productivity gains through direct mapping to properties of Object-Orie

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd