Question

Conduct some independent research on a popular Database Management System of your choice. Then discuss the following.

• What type of DBMS is it and what are some of its features?
• What are the hardware and software requirements for it?
• Offer at least one example environment for where this DBMS would be the best option to use and why?

Answer 1

Oracle Database

Oracle database is developed by Oracle Corporation and it is the fourth generation of Relational database management system. Oracle database is used mostly by big companies that need to manage a large amount of data. Oracle database is very flexible and it most useful features are integrity constrains, triggers, shared SQL, and Locking.

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 reliably manages a large amount of data in a multiuser environment so that many users can concurrently access the same data. All this is accomplished while delivering high performance. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.

Oracle Database is the first database designed for enterprise grid computing, the most flexible and cost effective way to manage information and applications. Enterprise grid computing creates large pools of industry-standard, modular storage and servers. With this architecture, each new system can be rapidly provisioned from the pool of components. There is no need for peak workloads, because capacity can be easily added or reallocated from the resource pools as needed.

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.

Features-

• Application Development

• Availability

• Business Intelligence

• Clustering

• Content Management

• Database Overall

• Database Security

Hardware requirement for oracle database

• AMD Opteron, Intel Pentium® at 500 MHz or faster, or Intel EM64T
• Minimum 500 MB free disk space for installation, 10 GB recommended
• Minimum 1 GB physical memory, 4 GB recommended

Software requirement for oracle database

• Operating System

• Oracle Database 11g Release 2 Enterprise Edition, including the options specified in "Oracle Database Requirements".

• Oracle Business Intelligence Suite Enterprise Edition 11.1.1.5 or higher. See "Oracle Business Intelligence Suite Enterprise Edition" (this is Optional for Oracle Airlines Data Model and Sample Reports installation steps but is required to deploy the Oracle Airlines Data Model sample reports RPD and webcat and to view the sample reports on the Business Intelligence Suite Enterprise Edition 11g instance)

An Oracle database is an accumulation of information regarded as a unit. The reason for a database is to store and recover related data. Oracle Database is the primary database which is being used for big business processing, due to its adaptability and practical approach to handle data and software applications.

It has plenty of uses all over the globe in many fields for some of its features like; adaptibiliity, faster recovery, it makes management & processing of information simpler.

Oracle is a database that reacts exceptionally well to magnificent execution in requesting situations. It is a trustworthy database with its additional highlights those are tested through the ACID test, which is vital in guaranteeing the respectability of information. This is essential since information is the core of any framework in the association.

Its common usage is –

• Storing a pre-defined type of data
• Supporting the Standard Query Language (SQL)
• Managing and manipulating the data
• Storing information
• Storing massive data