Software·43,836 discussions

Types of databases

Locked

What are a hierarchical and a relational database?

Topic

Types of databases

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).

Types of databases

In reply to Types of databases

The question was auto-closed by TechRepublic

Types of databases

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?

Types of databases

In reply to Types of databases

The question was auto-closed by TechRepublic

Types of databases

In reply to Types of databases

This question was auto closed due to inactivity

[Author]

Replies