Email Alerts
-
Oracle data warehousing tutorial
In this Oracle data warehousing tutorial, learn data warehousing basics and data warehousing concepts. Get tips on using data warehousing tools, find out the most useful Oracle data warehousing features and learn about the most common data warehousin... Learning Guide
-
Oracle business intelligence guide
In this Oracle business intelligence guide, learn how to start an Oracle business intelligence implementation with BI advice from the experts. Get the latest Oracle business intelligence news, understand basic business intelligence concepts and learn... Learning Guide
-
Retail developer builds Oracle business intelligence on JD Edwards
Retail development company Benderson Development used a “build and buy” approach to creating its Oracle business intelligence platform on top of JD Edwards. News | 26 Apr 2012
-
Oracle Big Data Appliance now available, but at what cost?
The Oracle Big Data Appliance is now generally available, as is Oracle’s big push into the field of big data. But some think that an appliance isn’t really a good fit for big data. News | 09 Jan 2012
-
Interview: Oracle, Cloudera on Big Data Appliance
Oracle and Cloudera executives talk about the Oracle Big Data Appliance, which became generally available on Jan. 10. Q&A | 09 Jan 2012
-
LinkShare explains why it dumped DB2 for the Exadata database machine
LinkShare’s BI director says the need for scalability was a key factor in moving the affiliate marketing company’s data warehouse to Oracle Exadata. Q&A | 15 Dec 2011
-
Home care business implements 'right time' Oracle BI
ResCare turned to Oracle BI to improve the way it collected more than 60 business metrics, compiling and distributing them eight weeks after each fiscal quarter. News | 07 Jul 2011
-
Larry English offers tips for improving information quality processes
Information quality guru Larry English says the keys to improving quality include proactive monitoring and ferreting out the root cause of problems. News | 02 Jun 2011
-
Five goals for implementing Oracle Business Intelligence Applications
Selecting the right approach and handling change management are two of the five important topics when installing Oracle Business Intelligence Applications (OBIA), according to one BI consultant. News | 13 Apr 2011
-
Oracle Exadata server guide
Read everything you want to know about Oracle Exadata: specs, news stories, opinion columns, and videos from customers. Guide | 08 Apr 2011
-
Oracle Sun enterprise server hardware guide
Knowing what hardware works best for your Oracle databases, middleware and applications is key to optimizing performance. This Oracle Sun enterprise server hardware guide should help you on your way. Guide | 08 Apr 2011
-
Oracle with new 5 terabyte Sun StorageTek tape drive
Oracle on Monday announced a 5TB tape drive called the T10000C. It signals Oracle's commitment to developing tape storage through its Sun StorageTek brand, and continues the company's desire to push its chip-to-application stack on enterprises. News | 31 Jan 2011
- See More: News on Oracle data warehousing
-
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. Tip
-
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 manag... Tip
-
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. Tip
-
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. Tip
-
Saving lives with Oracle
Thanks to rapidly falling disk costs, companies can now afford to store trillions of bytes of valuable information. However, data professionals know that the real challenge is making sense from these huge data stores and mining them for statistically... Tip
-
Why OLAP deserves more attention
This tip offers an overview of OLAP technology and explains why more organizations should be using it. Tip
-
Virtualization in the data center
Virtualization is a certainty for the data center. When it does arrive, the impact will be far-ranging, but no loss of jobs. Tip
-
Beyond reporting: Getting value out of your data
An introduction to the various types of advanced analytics and OLAP technologies. Tip
-
Role of brick and blade servers in the data center
Bricks, blades not a cure-all, but they offer power, save space Tip
-
Weighing centralized, distributed data centers
Client/servers vs. mainframes in the data center. Tip
- See More: Tips on Oracle data warehousing
-
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. Answer
-
How will the Sun acquisition affect Oracle data warehouse strategy?
Find out how Oracle’s acquisition of Sun may affect Oracle data warehouse strategy and what it means for users. Also, see what role packaged BI software plays in Oracle’s strategy. Answer
-
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? Ask the Expert
-
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? Ask the Expert
-
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. Ask the Expert
-
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? Ask the Expert
-
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? Ask the Expert
-
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? Ask the Expert
-
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? Ask the Expert
-
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? Ask the Expert
- See More: Expert Advice on Oracle data warehousing
-
operational data store (ODS)
An operational data store (ODS) is a type of database that's often used as an interim logical area for a data warehouse. Definition
-
multidimensional database (MDB)
A multidimensional database (MDB) is a type of database that is optimized for data warehouse and online analytical processing (OLAP) applications. Multidimensional databases are frequently created using input from existing relational databases. Definition
-
repository
In information technology, a repository (pronounced ree-PAHZ-ih-tor-i) is a central place in which an aggregation of data is kept and maintained in an organized way, usually in computer storage. Definition
-
BI strategies of Oracle and the megavendors
Mark Smith, CEO of Ventana Research, compares Oracle's business intelligence software to SAP and IBM. Oracle's recent database and middleware releases impact the stack but customers need to keep a close eye on TCO, Smith says. Video
-
Has Oracle's BI strategy become smarter with Hyperion?
Has Oracle's BI strategy been bolstered by the Hyperion CPM software acquisition? Get Forrester's Boris Evelson's take in this podcast. Podcast
-
Exadata: A first look at Oracle's entry into the appliance market
Software analyst Curt Monash discusses the new Oracle Exadata product line, which includes the Oracle Exadata Storage Server and HP Oracle Database Machine. In this podcast, learn about Exadata's pros and cons, how it compares to similar products fro... Podcast
-
IOUG chief discusses OpenWorld, DBA pay and security
SearchOracle talks with Ian Abramson from the IOUG about his goals as president, the IOUG's role at Oracle OpenWorld and the surprising results of two recent IOUG surveys on security and DBA salaries. Podcast
-
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. Tip
-
Retail developer builds Oracle business intelligence on JD Edwards
Retail development company Benderson Development used a “build and buy” approach to creating its Oracle business intelligence platform on top of JD Edwards. News
-
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. Answer
-
Oracle Big Data Appliance now available, but at what cost?
The Oracle Big Data Appliance is now generally available, as is Oracle’s big push into the field of big data. But some think that an appliance isn’t really a good fit for big data. News
-
Interview: Oracle, Cloudera on Big Data Appliance
Oracle and Cloudera executives talk about the Oracle Big Data Appliance, which became generally available on Jan. 10. Q&A
-
LinkShare explains why it dumped DB2 for the Exadata database machine
LinkShare’s BI director says the need for scalability was a key factor in moving the affiliate marketing company’s data warehouse to Oracle Exadata. Q&A
-
Home care business implements 'right time' Oracle BI
ResCare turned to Oracle BI to improve the way it collected more than 60 business metrics, compiling and distributing them eight weeks after each fiscal quarter. News
-
Larry English offers tips for improving information quality processes
Information quality guru Larry English says the keys to improving quality include proactive monitoring and ferreting out the root cause of problems. News
-
Five goals for implementing Oracle Business Intelligence Applications
Selecting the right approach and handling change management are two of the five important topics when installing Oracle Business Intelligence Applications (OBIA), according to one BI consultant. News
-
Oracle Exadata server guide
Read everything you want to know about Oracle Exadata: specs, news stories, opinion columns, and videos from customers. Guide
- See More: All on Oracle data warehousing
About Oracle data warehousing
Oracle is a market leader in large-scale data warehousing, a critical technology that consolidates and integrates enterprise data so it can be more easily managed, accessed and analyzed. This section contains tips and expert advice about designing, installing and administering Oracle Warehouse Builder, Oracle Data Mining, Oracle OLAP and more.