Q

Defining Oracle database repository vs. information repository

Oracle expert Brian Peasland explains how to understand the difference between a database repository and an information repository in Oracle.

What is the difference between an Oracle database repository and information repository?
At first glance, they might be the same things. And one may use a database to be its information repository. But these are two different things.

An information repository is a store house for information. This information can be unstructured or have a free form. The data in the information repository can have any attributes to describe any entities.

A database is much stricter with its data. A database has a specified number of entities with predescribed attributes. The data must conform to certain rules (called constraints). When adding, updating, or removing data, the database must conform to the ACID properties (atomic, consistent, isolated and durable).

This was last published in June 2009

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close