Oracle Database Concepts
1.What is a Database?
A database is an organized collection of related information.
Some familiar databases are:
telephone directories
address books
mailing lists and
inventory lists.
These are classified as databases because they are collections of like information that are useful to a particular organization, or are used for a particular purpose.
Although database structures may vary from one environment to another, their overall purpose is the same: to keep information logically organized.
2. What is a DBMS?
A Database Management System (DBMS) is a computer-based record keeping system that facilitates the storage, retrieval, and manipulation of information. DBMS software is a sharable resource that allows users to access shared data and retrieve information.
Part of the advantage of a DBMS is the maintained integrity of the data in the database file. A properly kept database will ensure that this single source of information is correct, and that consistency is maintained.
Further, a DBMS provides users with an efficient means of organizing, managing, and analyzing large amounts of related information. This data can then be summarized, grouped, and formatted into meaningful reports for easier interpretation.
3. What is a RDBMS? (Relational Database)
A relational database is a conceptual view of data and offers many advantages. The most important advantage is that the relationships between data can be determined at the time the user requests information from the database, instead of at the creation of the database.