AN OVERVIEW OF ORACLE

Oracle is a multi-user relational database management system. It is a software product that specializes in managing a single, shared set of information among many concurrent users. Oracle products are based on a concept known as Client /Server technology. The concept involves segregating the processing of an application between two systems. One performs all activities related to the database (server) and the other the activities that help the user to interact with the application (client). A client or front-end database application also interacts with the database by requesting and receiving information from the database server. It acts as an interface between the user and the database. The database server and back-end is used to manage the database tables optimally among multiple clients who concurrently request the server for the same data. It also enforces data integrity across all client applications and controls database access and other security requirements. CODD’S RULES SUPORTED BY ORACLE: • Information rule • Guaranteed access. • Systematic treatment of null values. • Database description. • Comphrensive data sub languages. • Insert and Update rule. • Distribution rule. • Non-subversion rule. CODD RULES PARTILLY SUPPORTED BY ORACLE: • View updating rule. • Physically data independence. • Logical data independence. • Integrity independence. FEATEURS OF ORALCE: • Oracle Is Portable: Oracle RDBMS is available on wide range of platforms ranging from PC’ a or Super Computer stand as multi-user Network loadable module for Novel NetWare. If you develop application on one system you can run the same application on any system without any modification. • Oracle Is Compatible: Oracle commands can be used for communication with IBM DB2 mainframe RDBMS, which is different from Oracle, i.e., Oracle is compatible with DB2. • Manageable Security: To protect against unauthorized database access and use, Oracle provides fail-safe security using grant and revoke to limit the access of information down to the row and column levels. Views are valuable features for limiting access to the primary tables in the database. • Large Database And Space Management Control: Oracle supports the largest of database, potentially hundreds of gigabytes in size. To make efficient use of expensive hardware devices if allows full control of space usage. Features of Oracle 8.0: Oracle supports the largest to ORDBMS with the following new features: • Abstract data types. • Collections. • Partitioned tables. • Scope references. • Object views. • Large objects. • New indexes. • Referenced cursor. • Triggers