General discussion

Locked

Types of databases

By clintpace ·
What are a hierarchical and a relational database?

This conversation is currently closed to new comments.

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

All Comments

Collapse -

Types of databases

by SyscoKid In reply to Types of databases

Good descriptions here:


http://www.horizon-sys.com/rdbms.html
http://www.dbstar.org/doc/UG_Ch2.htm

(Sometimes when I cut and paste URL's it looks ok to me but once the answer is posted, an extraneous space will have crept in. Make sure youdelete any extraneous spaces or the page won't load).

Collapse -

Types of databases

by clintpace In reply to Types of databases

The question was auto-closed by TechRepublic

Collapse -

Types of databases

by donq In reply to Types of databases

They are essentially one-in-the-same. A relational database stores data in a hierarchical structure consisting of "Tables" and "Fields". Each table supposedly contains data about only one subject (i.e., "Employees") while each field within the Employees table contains a specific piece of information about that employee (i.e., does he/she pick their nose, shoe size, last name, DOB, etc.).

The hierarchical structure is ALWAYS there and fields in one table then "relate" to fields in a different table (through Key Fields). Database relationships are a little complex to explain in a TechRepublic answer but nearly every database software product is based on the same international database connectivity standard (or ODBC) where mainframe, PC, server, and/or midrange computer databases are built to do the same thing based on the same hierarchical structure and relationship functionality.

I hhope this helps some - you asked?

Collapse -

Types of databases

by clintpace In reply to Types of databases

The question was auto-closed by TechRepublic

Collapse -

Types of databases

by clintpace In reply to Types of databases

This question was auto closed due to inactivity

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

Related Discussions

Related Forums