Oracle 10g Free training- Database Introduction:This tutorial covers the basics of Database Management Systems, Various types of Databases, The Relational Model, Benefits of RDBMS and Oracle Database along with Frequently Asked Questions.

Database Management Systems

A database can be regarded as having two major components, and these are the data and the software needed to manage the data. There are a variety of terms used to describe the software and the two most commonly used are

• Database Management System
• Information Management system and the terms are often used interchangeably.

There have been a variety of kinds of systems developed and a convenient but rough classification is

• Flat file
• Networked
• Hierarchical
• Relational
• Text
• Geographical or Spatial

When we consider each of these it is useful to have some criteria to work with, and the following prove useful

• There must be a way of describing the data - this means the ability to handle a variety of data types including numbers (integers and reals), text (often of varying length), currency, dates, times, logical or boolean, spatial data, graphical objects maps, census data, satellite image data, vector and raster data;
• There must be a way of describing the relationship that exists between the data items, i.e. what structure the data has or what structure can be imposed on the data;
• There must be a way of getting the data into the database;
• There must be a way of examining the data;
• There must be a way of generating reports based on the data.

A typical database system will therefore have to provide ways of achieving the above tasks. Most commercial systems will also provide a variety of ways of making each of the above tasks easier, i.e. the use of menu driven front ends to guide the user through each of the stages in the design and implementation of a complete database system.

Various types of Databases

Flat File Systems

Historically these kinds of systems were the first to be developed. An analogy that is useful is that of a filing cabinet full of files. This is the basis of a flat file system. There is often no significant structure, and this generally means applications using systems like this are quick to develop. Indices are generally used to improve the performance of the overall system.

These systems are widely available on most computer systems, from micros to mainframes. Most systems available on micros are in fact flat file systems. Many however call themselves relational - a popular buzz word, and much over-used in advertisements for database packages. Micro based flat file systems are relative cheap in software terms, and generally, but not always, perform poorly with large volumes of data. Program language interfaces are available for many systems, and some commonly available languages are C, COBOL, Pascal, FORTRAN, assembler and PL/1.

Networked Systems

The term essentially describes the logical and physical view of the data as a group of records with links between records - and hence a network of data and links. A key concept in this kind of system is that of a navigation path required to get to the data item or record of interest, i.e. the way you move round the mesh to get at the data you want.

Hierarchical Systems

The term describes the view of the data - in this case as a hierarchy. Again we have the problem of only being able to access data by navigation - in this case through the hierarchy. The key concept with the relational model is the view of the data as a table. This has proved to be a very useful concept and has enabled relationships between data items and records to be expressed not through physical links as with the networked and hierarchical approaches, but through properties of data in one or more tables. Let us consider how we get at the information on a Senior Analyst in the Advisory Group. All we do is search the two domains of interest (which may or may not be indexed) for data values that satisfy our criteria, i.e. we search the Group domain for people in Advisory, and the Title domain for Senior Analyst. Adding new domains is relatively easy, and hence design decisions are rarely as problematic as with the network and hierarchical data models.

Database management systems have evolved from hierarchical to network to relational models. The most widely accepted database model is the relational model. Oracle extends the relational model to an object-relational model, which makes it possible to store complex business models in a relational database.

Some DBMS Commercial Packages available in the market are:

• Hierarchical Model - IMS
• Network Model - IDMS
• Relational Model - Oracle, DB2

The Relational Model

In 1970 an IBM researcher, Dr. E. F. Codd, came up with a better way—the relational data model. In this model, the database management system (DBMS) itself keeps track of all table relationships independent of hardware or outside programming languages. In the relational model, the user only needs to understand the logical structure of data, not how it is physically stored. In this model data is represented in simple two-dimensional tables (relations), which consist of rows (tuples) and columns (attributes). A relational database is simply a collection of tables.

The relational model has three major aspects:

Structures are well-defined objects (such as tables, views, indexes, and so on) that store or access the data of a database. Structures and the data contained within them can be manipulated by operations.

Operations are clearly defined actions that allow users to manipulate the data and structures of a database. The operations on a database must adhere to a predefined set of integrity rules.

Integrity rules are the laws that govern which operations are allowed on the data and structures of a database. Integrity rules protect the data and the structures of a database.

Next Page: Oracle 10g Free training- Database Introduction - Page 2