| ORACLE | ||||||||
| ||||||||
| ||||||||
| ||||||||
| ||||||||
| ||||||||
| ||||||||
| ||||||||
|
Oracle - Introduction
Oracle is a trademark of Oracle Corporation and in common usage, refers to the database ( a relational database with added object-oriented features) engine and a range of front-end products. Oracle database products deliver innovative technologies and leading price/performance, from the enterprise to small workgroups, from the cloud to mobile devices, from super-clusters to single servers.
Over the past few decades, Oracle grew from being one of many vendors that developed database product to being widely recognized as the database market leader. In every database release, Oracle has improved the scalability, functionality, and manageability of the database.
Oracle database is available in five editions, each edition is suitable for different development and deployment scenarios. There are also several database options, packs, and other products that enhance the capabilities of Oracle database for specific purposes. Here is the list of Oracle database editions :
Note: Oracle Database Standard Edition, and Oracle Database Enterprise Edition. Personal Edition includes all of the components that are included with Enterprise Edition, as well as all of the options that are available with Enterprise Edition, with the exception of the Oracle Real Application Clusters option, which cannot be used with Personal Edition.
Provides efficient, reliable, and secure data management for enterprise level, critical transactional applications, query-intensive data warehouses, and mixed workloads. Here are some important information on Oracle databases:
| Database | Description |
|---|---|
| Oracle NoSQL Database | Provides multi-terabyte distributed key/value pair storage, enabling scalable throughput and performance. |
| Oracle MySQL | Provides cost-effective delivery of reliable, high-performance, and scalable web and embedded applications through the world's most popular open source database. |
| Oracle TimesTen In-Memory Database | A pure in-memory relational database that offers microsecond response time and extremely high throughput for online transaction processing (OLTP) applications. Applications connect and access the database using industry-standard interfaces. TimesTen also supports in-memory analytics and R programming. |
| Oracle Database Mobile Server | Provides secure connections of embedded devices and mobile applications to Oracle Database. Allows management applications, users, devices, and data on large deployments of mobile or remote devices. |
| Oracle Berkeley DB | Provides an open source embeddable database library, allowing developers the choice of SQL, Key/Value, XML/XQuery or Java Object storage for their data model. At its core is a fast, scalable, transactional database engine with proven reliability and availability. |
| Oracle Database Express Edition | An entry-level, small-footprint database based on the Oracle Database code base. It is free to develop, deploy, and distribute; fast to download; and simple to administer. |
| Java DB | Provides a fully transactional multiuser relational pure-Java database that can be embedded in data-rich applications or deployed as a stand-alone server. Its SQL and JDBC support ensure a path to an enterprise-level database when the need arises. |
| Oracle Rdb | Provides a full-featured, relational database management system for mission-critical applications on OpenVMS platforms. |
| Oracle Essbase | Quickly leverage and integrate data from multiple existing data sources and distribute filtered information to end-user communities in the format that best meets the users's needs. |
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. The database has logical structures and physical structures. Because the physical and logical structures are separate, the physical storage of data can be managed without affecting the access to logical storage structures. Here are some important information on Oracle databases architecture :
SQL and PL/SQL form the core of Oracle's application development stack. Most enterprise and web applications access databases using SQL. Enterprise Applications generate XML from SQL queries, and content-repositories are built on top of SQL tables. It is a simple, widely understood, unified data model and also used in many standalone applications. It is invoked directly from Java (JDBC), Oracle Call Interface (OCI), Oracle C++ Call Interface (OCCI), or XSU (XML SQL Utility). Stored packages, procedures, and triggers can all be written in PL/SQL or in Java.