
	The relational model


	Home > Ask the Oracle Experts > Database Design and Architecture Questions & Answers > Database vs. relational database

Ask The Oracle Expert: Questions & Answers

EMAIL THIS

Database vs. relational database

EXPERT RESPONSE FROM: Brian Peasland

		Pose a Question

		Other Oracle Categories

		Meet all Oracle Experts
		Become an Expert for this site

Oracle tips, scripts, and expert advice

Digg This! StumbleUpon Del.icio.us

QUESTION POSED ON: 27 October 2006
What are the differences between a database and a relational database?

EXPERT RESPONSE
In simplest terms, a "database" is a collection of records. There are many types of database models. Databases can be as simple as flat files. Databases can follow the hierarchical model, the relational model, the object-oriented model or the XML model. In the hierarchical model, the records are organized in a defined hierarchy. In the object-oriented model, records are stored as objects which have defined methods for access. The XML model stores the records in XML format. The relational model stores records according to how they relate to each other. For more information on the relational model, please see this Wikipedia article.

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Database Design and Architecture
	How do you size spatial tables and indexes?
	Creating db links from Oracle 10g to 8i
	Failed stored procedure through db link in Oracle
	Using Oracle's Virtual Private Database, aka Fine-Grained Access Control
	How would referential integrity work in this situation?
	Recreating advanced queuing objects during database upgrade
	Can I restrict data in a single schema?
	How DDL and DML commands work in Oracle
	When should an Oracle database be reorganized?
	Can I drop a column in SYS schema?

The relational model

Happy birthday Oracle -- 30 years!

Retrieve last row inserted into table in Oracle

Relationship between schema and datafile in Oracle

Oracle does not maintain order of inserted records

Why is Oracle 8 an "ORDBMS"?

Mike Ault's Oracle "good practices": Oracle design

Oracle revamps TimesTen In-Memory Database

Geeks pick the top movies of 2007

Network model for databases

Network, hierarchical and relational data models

Oracle tutorials, tips and FAQs

How to create a database link in Oracle

Most clicked stories of 2007

How do I do that in Oracle?

Counting a row's NULL columns

How many redo log files?

How to start multiple instances in Oracle 10g

Is it possible to assign a role to a profile?

Difference between RECYCLEBIN and 'DROPPED' column

How to find transactions being committed to Oracle database

How to create a database schema in Oracle?

Oracle tutorials, tips and FAQs Research

RELATED GLOSSARY TERMS

Terms from Whatis.com − the technology online dictionary

E. F. Codd (SearchOracle.com)

multidimensional database (SearchOracle.com)

object-oriented database management system (SearchOracle.com)

Oracle (SearchOracle.com)

relational online analytical processing (SearchOracle.com)

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

SEARCH

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.


TechTarget Corporate Web Site \| Media Kits \| Reprints \| Site Map All Rights Reserved, Copyright 2003 - 2008, TechTarget \| Read our Privacy Policy