Issues relating to the design of the physical database files, Database Management System

The issues relating to the Design of the Physical Database Files

Physical File is a file as stored on the disk. The major issues relating to physical files are:

 •      Constructs to link two piece of data:

•     Sequential storage.

•    Pointers.

  • File Organisation: How the files are in order on the disk?
  • Access Method: How will the data can be retrieved based on the file Organisation?

 

Posted Date: 3/7/2013 6:05:58 AM | Location : United States







Related Discussions:- Issues relating to the design of the physical database files, Assignment Help, Ask Question on Issues relating to the design of the physical database files, Get Answer, Expert's Help, Issues relating to the design of the physical database files Discussions

Write discussion on Issues relating to the design of the physical database files
Your posts are moderated
Related Questions
Define the Wait for graph Ans: The wait-for-graph is a directed graph and consist of nodes and directed arcs; the nodes of the graph are active transactions. An arc of the grap

Creation of Indexes Automatically: When a primary key or Unique constraint is show in a table definition then a unique index is formed automatically. Manually: User can

what is the need of a log in dbms

Define multivalued dependency and 4NF.  Ans:  Multivalued Dependency - Assume R be a relation schema and let α ⊆ R and β ⊆ R. The multivalued dependency  α →→β   holds o

State about the Tables- DBMS Data is stored in columns and rows (much like a spreadsheet -main difference is how data is organised). Every row in a table is known as a record

Why do so various organizations use MySQL? Advantages: Open source Highly efficient Offers a high scalability in terms of size and connectivity. Highly prote

After going by the database architecture, let us now dwell on an important query: how is the data organised in a database? There are a lot of basic structures that exist in a datab

Entity types that do not have any key attribute, and therefore cannot be identified independently, are known as weak entity types. A weak entity can be recognized uniquely only by

The Update Operations : Update operations are used for altering database values. The constraint violations faced by this operation are logically the similar as the problem faced

List the string operations supported by SQL? 1) Pattern matching Operation 2) Concatenation 3) Extracting character strings 4) Converting among uppercase and lower cas