Evergreen Database Technologies, Inc.
Arthur C. Clarke wrote that any sufficiently advanced technology is indistinguishable from magic, and it sometimes makes troubleshooting seem like magic, or perhaps art. But it is neither magic nor art; it is process and this presentation uses a case study, such as resolving the ORA-03136 “connection lost” error, to demonstrate that process and to […]
Star schemas (a.k.a. dimensional data models) are demanded by BI analysts in data marts and data warehouses. Star transformations are the optimal join method to access star schemas in Oracle. Bitmap indexes are required by the star transformation process, but bitmap indexes quickly become literally infeasible without partitioning. Why isn’t this documented? How do all […]
Star schemas (a.k.a. dimensional data models) are demanded by BI analysts in data marts and data warehouses. Star transformations are the optimal join method to access star schemas in Oracle. Bitmap indexes are required by the star transformation process, but bitmap indexes quickly become literally infeasible without partitioning. Why isn’t this documented? How do all […]
Oracle E-Business Suites upgrade projects are complex and lengthy. There are dozens or hundreds of steps, so checkpointing your work and taking backups is key to avoiding the disaster of a mishap or misstep. Data virtualization for E-Business Suites is a better solution than backups, and this presentation and webinar describes how. Presented as an […]