Pr.Pg Next Pg

Overview of Oracle tutorials

  • Oracle is a multi-user, Relational Data Base Management System.

  • An Oracle database, is a collection of data treated as a unit.

  • The purpose of a database, is to store and retrieve related information.

  • A database server is the key, to solving the problems of information management. In general, a server manages a large amount, of data in a multiuser environment, so that many users, can concurrently access the same data.

  • Oracle is one of many database servers, that can be plugged into a client/server equation.

 

Relational Database Model:

  • A relational database is a collection of data items organized as a set of formally described tables from which data can be easily accessed.

  • RDBMS offers strong concurrency control. It allows multiple users to access the same group of resources such as tables or rows.

  • RDBMS also offers strong consistency guarantees. It uses transactions that provide "All or Nothing", meaning each unit of work performed in a database must either complete entirely or have no effect at all.

  • A relational database is created using the relational model. The relational model has the following major aspects:

  • Structures: Well-defined objects store or access the data of a database.

  • Operations: Clearly-defined actions enable applications to manipulate the data and structure of a database.

  • Integrity Rules: Integrity rules govern operations on the data and structure of a database.

 

Oracle Features:

  • A feature is a set of functionality that enhances the use of Oracle database.

  • Apart from the clearly defined database options, Oracle Database may include many semi-autonomous software sub-systems which Oracle Corporation sometimes refers as Features.

  • SQL * Plus, a program that allows users to interact with oracle database via SQL and PL/SQL command line.

  • Scalability and Performance:

    • Manageability

    • Backup and Recovery

    • Data Guard for High availability.

    • Business Intelligence

    • Content Management

    • Security

    • Data integrity/Triggers

    • Data providers for .NET, Visual Studio, ASP.net, OLE DB

    • UCP Universal Connection Pool a connection pool based on Java and supporting JDBC, LDAP and JCA.

    • Generic Connectivity for connecting non-Oracle System.

    • OMF Oracle managed files, a feature allowing automated naming, creation and deletion of data files at the operating system level.

    • The Oracle server technologies product set is more than a database.

    • There is Oracle Application Server and the Oracle Enterprise Manager.

    • Taken together, these are the server technologies that make up the Grid.

Pr.Pg border                                              Next Pg