Problem solve
Get help with specific problems with your technologies, process and projects.
Oracle data warehousing
Oracle RDBMS vs. NoSQL databases in the era of big data
While NoSQL databases are a lower-cost, scalable alternative to Oracle RDBMS, they pose risks of data loss, says an expert at Oracle Collaborate 2014. Continue Reading
Oracle 12c's heat map tool and data optimization can improve storage
The heat map tool and Automatic Data Optimization features in Oracle 12c should help Oracle database shops improve data storage and compression. Continue Reading
Understanding Oracle Exadata Smart Scan
Expert Shyam Varan Nath explains what Oracle Exadata Smart Scan does and how it can improve query performance on Exadata. Continue Reading
-
Data warehouse based on operational data model
When trying to design a data warehouse, we often try to model the database on the operational data model. Are there any guidelines in trying to create a data warehouse based on the operational data model? Continue Reading
Designing a generic "Product" table
I work in a product-based company. I am planning to build a generic data mart for all our future customers. we need to design our "Product" table generically, so that it can accomodate any type of products. Please suggest what is the best way to ... Continue Reading
Method other than DB link for large data transfer
We are working on the development of a datamart (in 9i) which takes data from two source systems. Since this is a transaction system, there is a lot of data. Currently we are doing incremental loads using a spool file and external tables. But the ...Continue Reading
Data migration with ETL
I am new to Oracle's ETL tool and I need information on data migration using Oracle ETL.Continue Reading
Using PL/SQL for ETL
How can PL/SQL be best used for the ETL process?Continue Reading
Core principles of data warehouse design
This excerpt from "Database Modeling and Design: Logical Design, Fourth Edition" by Toby Teorey provides an overview of the fundamentals of data warehousing, one of the three core tools of business intelligence.Continue Reading
Learning Guide: Data warehousing and business intelligence
This learning guide compiles articles, analysis, tips and expert advice on basic and in-depth data warehousing and business intelligence topics.Continue Reading
-
Basic steps for implementing a DBMS
What basic steps should we take in implementing a DBMS?Continue Reading
Design recommendations for FACT TABLE and DIMENSIONS
We are in the phase of warehouse designing. What are the recommendations and restrictions for FACT TABLE and DIMENSIONS?Continue Reading
Star schema advice for healthcare data warehouse
Data warehousing project for large insurance company
Business Objects as a data warehousing tool
Role of brick and blade servers in the data center
Bricks, blades not a cure-all, but they offer power, save spaceContinue Reading
Five myths of data mining
Many successful companies have discovered is that the myths that have grown up around data mining are just that: myths.Continue Reading
Implementing a data warehouse: Outsource or in-house with consultants?
Operational data store versus a data warehouse
Scrollable cursors in Oracle
Best backup strategy for a data warehouse
Data warehouse for hospital patient information
Building a human resources data warehouse
Why data warehousing projects fail
No one can guarantee a DW project won't fail, but with a little planning, you can avoid some of the common roadblocks.Continue Reading
Four methods for designing a data warehouse/data mart environment
There are (at least) four different ways to design your data warehouse/data mart environment. Learn how to choose your design and what to consider when designing your data warehouse in this tip.Continue Reading