- Advanced Analytic Services
New services are provided by the database for OLAP and data mining, exposed through Java APIs.
- Additional SQL extensions to provide more analytic functions
Oracle9i adds a hypothetical rank function, a histogram function, and an inverse percentile function.
- ETL functionality in the database
Oracle9i moves some types of extraction, transformation, and loading functionality into the core database. This functionality will increasingly be leveraged by ETL tools such as Oracle Warehouse Builder.
Get Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
