|
To compete effectively in business environments undergoing rapid change
driven by the Internet and other technologies, executives must have a
better
understanding than their competitors of how those changes will affect
their business and their industry. Increasingly, decisions are based
on highly sophisticated market intelligence collected from customers
and other sources. As a market intelligence capability, data warehousing
enables businesses to attain a higher level of business-critical understanding.
Oracle9i, by delivering the ability to create, manage and deliver data
warehouses, and by making them more manageable and scalable than other
competing solutions has helped TruTek deliver tremendous competitive
advantages to its customers.
TruTek expands upon Oracle9i's high-end functionality, providing Decision Support
services that utilize Oracle's Business Intelligence tools, Oracle Discoverer
and Express products, to give higher performance and better productivity,
thereby supporting better decisions that can be made more quickly.
Data
Warehouse Design Services:
- Logical Design
- Physical Design
- Improving Query Rewrite Capabilities
- Partitioning Design Considerations
- Hardware and I/O Considerations in Data Warehouses
- Integrity Constraints
- Security Issues with Materialized Views
- Dimension Analysis
- Aggregation
Implementation Solutions:
- 9i Data Warehouse
- 9i Data Marts
- Data Archival
- Transportation Solutions - Using Transportable Tablespaces
- Extracting, Loading and Transformation Services
Data Warehouse Performance
Services:
- Optimizing Star Queries
- Parallel Execution Tuning
- Bitmap Indexes
- Bitmap Join Indexes
- Local Indexes
- Parallel Execution
- Partitioning and Materialized Views
- Implement Materialized Views With Partitioned Tables
- Implement Partitioning to Improve Data Warehouse Refresh
- Materialized Views for Data Warehouses
- Materialized Views for Distributed Computing
- Materialized Views for Mobile Computing
- Rolling Materialized Views
|