General discussion

Locked

database/files

By vivek_sriwastava ·
what is differnce between file structure and database structure?
how they stored in the hard disk?

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by senftk In reply to database/files

Here is the basic definitions of file/database structures as they pertain to databases. How this helps!

A database consists of a number of related files.

A file (sometimes called a table) consists of a number of related records.

A record consists of a number of related fields.


So the file structure is the structure of the file (# of related records)

The database structure is the structure of the database (# of related files)

Collapse -

by senftk In reply to

Check out these 2 sites:

There is an example layout: http://www.chesapeakebay.net/awta/guide/Table2.pdf

Many files make up the database. In this example there are 21 files that make up the database.

There is a basic example/explanations at:
There is a more basic example at http://www.theteacher99.btinternet.co.uk/theteacher/gcse/newgcse/module5/task1.htm

Collapse -

by vivek_sriwastava In reply to database/files

The answer is not satisfactory.
please provide some solid arguments about the question .
can you draw some pictorial representation of your statements.

Collapse -

by OTL In reply to database/files

File structure;

Root directory (main) then sub directories;

Stored on the HD as Name, hex location, attributes/type (file/directory), creation/edited date.

Database structure;

File in a directory/sub directory.

Structure is stored within the file as name, type, string size. Actual data follows the structure definition within the file.

Collapse -

by OTL In reply to

Sleeping on this one;

File structure;

Would be the afore mentioned database structure;

Database structure would be the way the files are interlinked, usually via another program/process.

Back to Desktop Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums