Discussion Locked

database/files

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

5 replies

by senftk

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)

by vivek_sriwastava

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

by otl

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.

by otl

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.

This discussion is closed to new replies.