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

Query optimization in database system, Problem : AirwaysCentre, an inte...

Problem : AirwaysCentre, an international airline booking company currently uses a relational database system for their operations, which includes the following relations: P

Illustration of implementation of inheritance, Illustration of implementati...

Illustration of implementation of inheritance Let us take the illustration of implementation of inheritance. Suppose that we are about to implement the Stack class and by now w

Determine Which is not a consequence of concurrent operation, Determine Whi...

Determine Which is not a consequence of concurrent operations? Ans: Update anomaly.

DBMS, give some example real life situation where DBMS are most suitable

give some example real life situation where DBMS are most suitable

Data modelling and normalization methodology, MOSS VALE is a town with 1500...

MOSS VALE is a town with 15000 inhabitants. The fire department wishes to develop a system that automates the despatch of fire engines to attend fires. The ERD below describes the

What are the acid properties?, Question 1 What are the advantages of DBMS ...

Question 1 What are the advantages of DBMS approach in managing data? Question 2 What are the services provided by a database system Question 3 List and briefly describe

List the sql domain types, List the SQL domain Types? SQL supports the ...

List the SQL domain Types? SQL supports the following domain types. 1) Char(n) 2) varchar(n) 3) int 4) numeric(p,d) 5) float(n) 6) date.

What are advantages of object models, What are advantages of object models?...

What are advantages of object models? Object models are efficient for communicating with the application experts and reaching a consensus about the significant aspects of the p

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