Different Database Structures:
The relationships among the many individual records in databases are based on one of several logical data structures or models.  DBMS is designed to provide end users with quick, easy access to information stored in databases.  Five fundamental database structures are:
Hierarchical:
Early mainframe DBMS packages used the hierarchical structure, in which:



- Relationships between records form a hierarchy or tree-like structure.
- Records are dependent and arranged in multilevel structures, consisting of one root record and any number of subordinate levels.
-Relationships among the records are one-to-many since each data element is related only to one element above it.
- Data element or record at the highest level of the hierarchy is called the root element.  Any data element can be accessed by moving progressively downward from the root and along the branches of the tree until the desired record is located.
Network Structure: 
- Can represent more complex logical relationships, and is still used by many mainframe DBMS packages.
- Allows many-to-many relationships among records.  That is, the network model can access a data element by following one of several paths because any data element or record can be related to any number of other data elements.
Relational Structure:
- Most popular of the three database structures.
- Used by most microcomputer DBMS packages, as well as many minicomputer and mainframe systems.
- Data elements within the database are stored in the form of simple tables.  Tables are related if they contain common fields.
- DBMS packages based on the relational model can link data elements from various tables to provide information to users.
Multidimensional Structure:
- Is a variation of the relational model that uses multidimensional structures to store data and relationships between data.
- A major benefit of multidimensional databases is that they are a compact and easy-to-understand way to visualize and manipulate data elements that have many interrelationships. 
- Multidimensional databases have become the most popular database structure for the analytical databases that support online analytical processing (OLAP) applications.  
Object-Oriented Structure:
- Is considered to be one of the key technologies of a new generation of multimedia web-based applications.
- In an object-oriented structure, an object consists of data values describing the attributes of an entity plus the operations that can be performed upon the data.  This encapsulation capability allows the object-oriented model to better handle more complex types of data (graphics, voice, text) than other database structures.



- Supports inheritance, that is, new objects can be automatically created by replicating some or all of the characteristics of one or more parent objects.
-Object-capabilities and inheritance have made object-oriented database management systems (OODMS) popular in computer-aided design (CAD) applications.  Designers can develop product designs, store them as objects in an object-oriented database, and replicate and modify them to create new product designs. Multimedia web-based applications for the Internet and corporate intranets and extranets have become a major application area for object technology.

Next
This is the most recent post.
Previous
Older Post
Mukesh Rajput

Mukesh Rajput

I am a Computer Engineer, a small amount of the programming tips as it’s my hobby, I love to travel and meet people so little about travel, a fashion lover and love to eat food, I am investing a good time to keep the body fit so little about fitness also..

Post A Comment:

0 comments:

Thanks
Mukesh Rajput