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
Oracle's integration tools for real-time data
Oracle GoldenGate, Data Integrator and Data Profiling are all tools that can be used for real-time data integration in Oracle environments. Continue Reading
-
Las Vegas expands its Oracle business intelligence horizons for better government transparency
The city of Las Vegas underwent a three-year Oracle business intelligence project to bring more data to its employees and the public. The city's IT manager explains how it happened. 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
Tip: Exposing logical attributes with virtual columns
Data modelers are often faced with the dilemma of how to model logical attributes in their data warehouse schema design. A new feature in Oracle 11g called virtual columns solves this dilemma by exposing logical attributes while reducing object ...Continue Reading
Separate database for each client in Oracle 10g
We need to create a data warehouse in Oracle 10g. Is there a way to create a separate database for each client?Continue Reading
ORA-600 error and slow server response after upgrade
We upgraded from 9i to 10g on a data warehouse database. Since then we are facing a lot of problems, such as the ORA-600 error and slow server response.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
RAC node scaling in DSS workloads vs. OLTP
What are your experiences with RAC node scaling in DSS workloads vs. OLTP? Also, isn't the primary bottleneck in scaling out the overhead of the cachefusion lock management protocols, not the actual interconnect?Continue Reading
-
Learning more about data warehousing and Teradata
I'm working on Oracle (SQL and PL/SQL) right now. I want to know how this will help me to learn about data warehousing. Also, what is Teradata?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
Importing 8i dump file to 9i
How can I import data from an Oracle 8i dump file to the 9i database?Continue Reading
Using export/import process to clone to data warehouse
I work for a university and we have built a data warehouse and two data marts for archived data. Currently we are using an export/import process to clone our online system to our test data warehouse. We are trying to determine if we should do ...Continue Reading
What is a surrogate key?
What is a surrogate key in a table?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
External tables explained
Deciding what hardware to purchase for a data warehouse
More on healthcare data warehouse star schema
Using star schemas for warehousing financial data
Loading data from CSV file into Oracle table using SQL*Loader
Star schema advice for healthcare data warehouse
Data warehousing project for large insurance company
Schematics of data warehouse infrastructure
Inconsistent data retrieval speeds
BI tools for dynamic reporting
Referencing a dimension table from a fact table
Reducing risks in data warehouse maintenance
Why OLAP deserves more attention
This tip offers an overview of OLAP technology and explains why more organizations should be using it.Continue Reading
Retaining constraints on the fact table
Primary keys and foreign keys on fact tables
Printing and capturing data in ASCII format
Loading data into an Oracle database using SQL*Loader
Business Objects as a data warehousing tool
Beyond reporting: Getting value out of your data
An introduction to the various types of advanced analytics and OLAP technologies.Continue Reading
Role of brick and blade servers in the data center
Bricks, blades not a cure-all, but they offer power, save spaceContinue Reading
Weighing centralized, distributed data centers
Client/servers vs. mainframes in the data center.Continue 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?
Should unrelated data marts be on the same instance?
Determining instances for a data mart
Comparing the current and next rows in data warehousing
Use this technique to compare values between current and next records instead of cursoring through the entire table.Continue Reading
Can we estimate maximum rate data can be loaded?
Generate flat files from a data warehouse
Generate flat files, one for each table from a given schema, by executing this single Oracle procedure.Continue Reading
Operational data store versus a data warehouse
Using the ANALYZE command
Getting detailed information about SAP's data warehousing product
Scrollable cursors in Oracle
Best backup strategy for a data warehouse
Data warehouse vs. database to support daily operations
Data warehouse for hospital patient information
Information on the FTI model
Benefits and drawbacks to data warehouses
Building a human resources data warehouse
Updating fact tables while loading the data warehouse
Who are the big players in data warehousing?
Time phased/temporal data warehouse explained
Determining the right DBMS and OS for a data warehouse, continued
Industry standard for data warehousing?
Architecture for the real estate industry
Tiers and data marts
Can I use IBM data load software to migrate Tandem DB to UDB?
Find out about IBM data load software, including tips for using IBM's DB2 Universal Enterprise and Extended Enterprise Edition for a migration project.Continue Reading
What are the advantages of having a multi-dimensional database in data warehousing solution?
What should I do to take up a career in data warehousing?
Tips for the ETL tool evaluation and comparison process
Uncover tips for ETL tool evaluation and comparison and advice for using ETL for a conversion and migration project in this Q/A.Continue Reading
How do other DW teams deal with in-and-out flows?
How reliable is the data in your data warehouse?
Beyond tuning: An alternative approach to maximizing data warehouse performance
Good customer service will not a warehouse give
There are three options for designing the data warehouse: normalized data structures, star schemas, or snowflake schemas.Continue Reading
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
The data warehousing year in review
Nothing is permanent except change...especially in the data warehousing world.Continue Reading