All kinds of information systems require a database, ranging from Accounting Information Systems, Executive Information System and Management Information Systems. What is a database? A database is a data storage medium of an information system. In this post, I will discuss on one database software, the Oracle Database.
Oracle Database is an object-relational database management system (ORDBMS), where an object-based relational database. Oracle Database is created by Oracle Corporation.
Most Oracle database installations traditionally come with a standard called the SCOTT schema. After the installation process, therein have been prepared sample table, the user can log into the database using the username 'Scott' and password 'Tiger'. The name of the SCOTT schema originated with Bruce Scott, one of the first employees at Oracle (then Software Development Laboratories), which has a cat named Tiger.
Oracle Corporation has emphasized the use of the SCOTT schema, as some newer features that have been released by Oracle. Most recent example is provided by Oracle Corporation or the reference standard HR schema OE.
Here is the output sequence of the Oracle Database:
- Oracle v5
- Oracle v6
- Oracle7: 7.0.16-7.3.4
- Oracle8 Database: 8.0.3-8.0.6
- Oracle8i Release 1 database: 8.1.5.0-8.1.5.1
- Oracle8i Release 2 database: 8.1.6.0-8.1.6.3
- Oracle8i database Release 3: 8.1.7.0-8.1.7.4
- Oracle9i Database Release 1: 9.0.1.0-9.0.1.5 (December 2003)
- Oracle9i Database Release 2: 9.2.0.1-9.2.0.8 (April 2007)
- Oracle Database 10g Release 1: 10.1.0.2-10.1.0.5 (February 2006)
- Oracle Database 10g Release 2: 10.2.0.1-10.2.0.5 (April 2010)
- Oracle Database 11g Release 1: 11.1.0.6-11.1.0.7 (September 2008)
- Oracle Database 11g Release 2: 11.2.0.1-11.2.0.2 (November 2010)
Over the development time, Oracle Database distinguished in various editions for reasons of marketing and licensing. This database there are free and some are paid.
- Enterprise Edition (EE), memilliki more features than the 'Standard Edition', particularly in the areas of performance and security. This product is typically used for servers that run four or more CPUs. This edition has no memory limit.
- Standard Edition (SE), this edition contains the basic functions of the database. This product is usually to the server consisting of one to four CPUs. If the number of CPUs exceeds 4 CPUs, then the user must convert to an Enterprise license. SE has no memory limits.
- Standard Edition One (SE1 or SEO) is introduced with Oracle 10g, has some additional feature-restrictions. This edition is used on systems with one or two CPUs. This product has no memory limitations.
- Express Edition ("Oracle Database XE"), introduced in 2005, offers Oracle 10g that can be used on Windows and Linux platforms. This product has a footprint of only 150 MB and is limited to the use of a single CPU, a maximum of 4 GB of user data. Although it can be installed on the server with the maximum memory of 1 GB. Support for this version comes exclusively through on-line forums and not through Oracle support.
- Oracle Database Lite, intended to run on mobile devices. This product is located on the mobile device and can synchronize with a server-based installation.
Oracle Database is the first database that supports XML programming language. This database is also the first database that can run on Linux. That was a brief explanation of the Oracle Database. If there are errors or omissions please justified or added. May be useful.
0 komentar
Posting Komentar