Tuesday, March 27, 2007

Some Features of Oracle I Like More

Oracle stands out from the crowd of numerous other databases due to its sheer array of outstanding features, some of them are discussed below:

Oracle allows simultaneous access to same data by multiple users without any locking issues. It is done through Oracle powerful transaction mechanism.

Read Consistency:
It means that while accessing the data, the reader of same data never block other reader and writer. The writers don't block the readers of same data. Only writer of same data block the other writers.

Oracle has got the ability to operate on all major platforms. It can be transferred from one platform to other with little or no effort at all.

Self Managing Database:
To ease the burden of DBA and make him more productive, Oracle 10g has automated many things like space and memory management, undo management and backup/recovery etc.

High Availability:
Being an enterprise level database, Oracle understands the need of enterprise across the world regarding 24/07/365 availability. It tackles this issue with Real Application Cluster (RAC), RMAN, Data Guard, Oracle Flash Back, Redo Mechanism etc.

Unicode Support:
The rapidly shrinking world has introduced many new challenges. One of them is the support of multi-lingual support. In order to represent the multiple language, a global character set has been developed, which is Unicode. The latest release of Unicode is its version 4, in which it can support 1,226 new characters. Oracle's Unicode character sets, AL32UTF8 and AL16UTF16, have been updated to support Unicode 4.0 in Oracle Database 10g Release 2. The Globalization Development Kit (GDK) is also included in Oracle 10g with enhanced features.

Miscellaneous Features:
Moreover, Oracle throws its shadows on various areas. Its scope ranges from Data mining to Data Warehousing, from OLAP to BI, from Multimedia to Spatial, from mid-tier software to front end developer suites and much more.

No comments: