Question

Write about Oracle product of Database product. your findings should include

Usage, new server versions, Advantages, Disadvantage ,components Server and workstations, Physical structure Logical structure, Portability, Backup Recovery Performance and References

Answer 1

Oracle delivers a database server, related tools and utilities, networking features, 3GL application development and deployment facilities, and integration products unique to the platform.it is a multi model database management system. This set of products and facilities allows operating systems to host the same Oracle platform as UNIX, Linux, and other systems on which the Oracle database runs. The integration products allow widely used operating system components such as CICS TS, IMS TM, and DB2 to participate in an Oracle Database application.

Server

The current product is Oracle Database 10g release 2 (10.2) for IBM z/OS on System z. As with all prior Oracle versions, the z/OS implementation of this product is compiled from the same C language source code as on other platforms, differing only in the thin layer of programming that adapts it to the host operating system. This means the SQL and PL/SQL languages, Java facilities, SQL statement optimizer, and other Oracle features work the same on z/OS as they do on other Oracle platforms. Oracle Database applications developed with a non-z/OS Oracle server generally can be switched to a z/OS Oracle server or vice versa without changes.

It is a database commonly used for running online transaction processing (OLTP), data warehousing (DW) and mixed (OLTP & DW) database workloads. Oracle Database is available by serveral service providers on-prem, on-cloud, or as hybrid cloud installation. It may be run on third party servers as well as on Oracle hardware (Exadata on-prem, on Oracle Cloud or at Cloud at Customer ). Exclusively for Cloud customers Oracle offers Oracle Autonomous Database providing fully automated operation procedures.

It is the best known database management systems which has many advantages like

1. Union operator

2. Intersect operator

3. window functioning

4. Parallel querry

5. Merge joins

6. common table expansion

7. blobs and clobs

8. outer and inner joins

9. except operator

10. inner selects

but it also have some disadvantages

1. It does not contain system version tables.

2. Attribute based access control.

Because the physical and logical structures are separate, the physical storage of data can be managed without affecting the access to logical storage structures.

PHYSICAL STRUCTURE

Every Oracle database has one or more physical datafiles. The datafiles contain all the database data. The data of logical database structures, such as tables and indexes, is physically stored in the datafiles allocated for a database.

SOME CHARACTERSTIS ARE

A datafile can be associated with only one database.
Datafiles can have certain characteristics set to let them automatically extend when the database runs out of space.
One or more datafiles form a logical unit of database storage called a tablespace.

LOGICAL STRUCTURE

Oracle Database allocates logical space for all data in the database. The logical units of database space allocation are data blocks, extents, segments, and tablespaces. At a physical level, the data is stored in data files on disk. The data in the data files is stored in operating system blocks.