oracle
- This is a preview of the essay.
To view the full text you must login!
Major components
Transaction Processing
Data Warehousing
Management Tools
Reliability
Security
Data Integration and Messaging
Content Management
1. Transaction Processing
Row Level Locking
In general, multi-user database require that data is "locked" to prevent destructive interaction between different users or programs accessing or updating the same data at the same time. With Oracle 9i Database, only the individual row that contains the data in question is locked.
Materialized Views
Materialized views are used to pre-compute and store aggregated data such as a sum of monthly sales figures.
Data Partitioning
Partitioning allows tables and indexes to be subdivided into smaller pieces, enabling these database objects to be managed and accessed at a finer level of granularity.
Query Optimization
Query optimization is of great importance for the performance of a relational database, especially for the execution of complex SQL statements.
2. Data Warehousing
Integrated OLAP
Oracle 9i OLAP provides valuable insight into business operations and markets using features previously found only in specialized OLAP databases.
Data Mining
Oracle 9i Data Mining allows companies to build advanced business intelligence applications that mine corporate databases to discover new insights, and integrate those insights into business applications.
3...