|
IAF Coaster™ for Oracle9i is an innovative metadata management tool for Oracle 9i OLAP Services that allows customers to create and manage their own analytic models without changing data structures in a corporate data warehouse.
This unique solution helps speed the design and administration of OLAP analytic models by leveraging patent-pending technologies, such as flexible modeling features and powerful segmentation functions.
|
|
|
|
• Each user has a different request
• Major back log
• Pressure to reduce costs
• Extensive technology expertise required — Oracle, SQL, OLAP DML, Java, etc.
|
• Requests from users minimized
• No back log
• Costs dramatically reduced
• Only need to focus on one technology
|
|
A company needs to add a new level to its customer rankings — adding Platinum to the existing rankings of Gold, Silver and Bronze. Below is a quick comparison of traditional OLAP development methods and IAF Coaster.
|
|
|
|
1.
| Define user requirements |
| 2. | Change relational database schema |
| 3. | Extract data from relational database using SQL or ETL tools |
| 4. | Create OLAP cube and load dimension values by OLAP DML |
| 5. | Load data and aggregate
|
| CORPORATE WAREHOUSE IS CHANGED
|
|
|
1.
| Define corporate view into metadata |
| 2. | Define user requirement |
| 3. | Add or change parts in metadata if needed |
| 4. | Choose parts to make analysis models |
| 5. | Create or update OLAP cube without SQL or OLAP DML |
|
|
|
• Flexible modeling to support complex hierarchies
• Sophisticated segmentation to help users analyze from their own perspective
• Meta management to help organizations share their analytic know-how
• OLAP model (cube) management without programming
|
