Manage
Learn to apply best practices and optimize your operations.
Oracle data warehousing
New services complete Oracle Cloud Platform offering, Ellison says
The addition of more than two dozen cloud computing services will allow users to move everything in their data centers to the Oracle cloud, according to CTO Larry Ellison. Continue Reading
At the Collaborate conference, optimize BI with Oracle 12c
At the Collaborate 15 conference, Kai Yu wants to share his experience working in BI and as a DBA and how to use Oracle Database 12c to improve BI. Continue Reading
Oracle data analytics tools target a spectrum of user needs
In an Oracle Collaborate session on Oracle data analytics, an expert outlined the range of tools available -- from canned reports to big data analysis. 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
Hadoop for big data requires IT-wide teams, like Oracle Exadata
Oracle Exadata forces IT silos to talk to one another, and Hadoop big data projects will do the same. 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
Best practices for Oracle real-time data integration
Preparation, education and enforcement are just three of the best practices for a successful Oracle real-time data integration project.Continue Reading
Real-time data collection for Oracle data warehouses
Time is almost always an issue when it comes to extracting information from data warehousing software. Data integration can help.Continue Reading
Oracle acquires data quality management software maker Silver Creek
By acquiring Silver Creek's data quality management software, Oracle fills a gaping hole in its data quality portfolio and takes a step toward offering a data quality stack solution.Continue Reading
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.Continue Reading
-
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.Continue Reading
Oracle New Year's resolutions, part 2: GRC tips and customer resolutions revealed
Oracle customers reveal their New Year's resolutions, and one analyst says now is the time for customers to push Oracle on GRC.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
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
Implementing partitioning before data warehouse upgrade
I am currently running an 8i data warehouse and considering partitioning a 40-million-row table. The database is also in the process of being upgraded to 10g. Will I encounter any problems or performance degradation if I implement my partition ...Continue Reading
How to move large data warehouse for upgrade?
I have a large data warehouse running under 9.2.0.6. I want to transport it and upgrade to 10g on another server. What is the easiest way to move the data (on Unix)? It is too large to export/import?Continue Reading
Data warehouse woes? Blame your CEO
If you're disappointed with your data warehouse performance, find out whether your CEO is doing a good job integrating disparate business units.Continue Reading
Clarification: Problem when re-enabling referential integrity
TDWI experts outline 'trading places' strategy
Users and experts at The Data Warehousing Institute conference agree that confusion and finger pointing plague many data warehouse projects. TDWI gurus say that one way to prevent trouble is to have data warehouse team members trade places with ...Continue Reading
Best backup strategy for a data warehouse
How can I integrate my data warehouse into the Web?
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