Problem solve

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

• Help with data warehouse disaster recovery planning

  We're implementing a data warehouse (built with Oracle 10g, OWB) and need resources to help us form a business continuity/disaster recovery plan. When do you address ETL in a disaster?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

• Extracting data from a specific period

  In a data warehouse environment what is the best way to extract data for a specific period and populate to another database?Continue Reading

• How many disk groups for our data marts?

  Should we create separate disk groups for each of the data marts or should we create one big disk group and throw all the data in it?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