Oracle数据仓库解决方案-推荐.pptVIP

* Overall, 9iAS offers six core capabilities. Specifically - Oracle9iAS Release 2 provides a productive Application Server environment for developers to develop and deploy Internet Applications based on open standards such as full support for Java2 Enterprise Edition (J2EE), XML and Emerging Web Services standards. With Oracle9iAS, you can simplify access to these applications by creating Enterprise Portals that provide a single point for users to access these applications either from desktop browsers or Wireless Devices. Through a comprehensive Enterprise Integration framework, modeling tools, Pre-built adapters and Web Services, you can redefine your business processes and integrate your Applications with legacy systems, databases, packaged applications, and business partners. You can deliver tailored 1:1 customer experiences via real-time Personalization, assess and correlate web site traffic patterns using Clickstream Analysis, and satisfy demands for up-to-the minute Business Intelligence about your applications using Oracle9iAS. * * In the ETL process, the data extracted from a source system passes through a sequence of transformations before it is loaded into a data warehouse. Complex transformations are implemented in a procedural manner, either outside the database or inside the database using PL/SQL. When the results of a transformation become too large to fit into memory, they must be staged by materializing them either into database tables or flat files. This data is then read and processed as input to the next transformation in the sequence. Oracle9i ’s table functions provide the support for pipelined and parallel execution of such transformations implemented in PL/SQL, C or Java. The scenarios mentioned above can be done without requiring the necessity the use of intermediate staging tables, which interrupt the data flow through various transformations steps. * The restrictions prior to Oracle9i were to guarantee the same operating system, the sa