Are you ready for Business Intelligence?

Changes in hardware technology always precede changes in software technology, and Oracle is no exception.  As disk platter devices experience an unprecedented fall in cost, disk has become insanely cheap, with over a terabyte available for under $10,000.  As a direct result of this hardware priced change, Oracle DBAs are being told to keep larger and larger amounts of historical data, and to start providing management with tools to analyze and leverage this critical business information.  This process is called Oracle business intelligence.

All Oracle databases collect information about ongoing business processes and its only a matter of time before management starts to seek specialized information about their data.  Eventually, all Oracle DBAs are faced with these requests for analysis of operational data, and these requests form the foundation of Oracle data warehousing and business intelligence.

As disk becomes insanely inexpensive, business managers are now choosing keep their operational data over years and use this valuable data to help them with basic Oracle business intelligence, the planning and execution of business analysis processes.  Lets take a quick look at the stages of this evolution into Oracle business intelligence:

- Data collection This phase involved the ETL (Extract, test and Load) processes, taking operational data and saving it for analysis.  The Oracle Data Warehouse Builder tool provides a framework for business intelligence, allowing for data extraction and loading of advanced data warehouse applications.

- Summary and aggregation Managers start the business intelligence process by making requests for summaries and rollups of critical business metrics.

- Predictive analytics At this stage, business intelligence requests become more sophisticated, and management will ask the DBA to extract historical data and make predictions using regression techniques.

- Hypothesis testing As the managers begin to see the value of their data they will start requesting advanced business intelligence, full-blown modeling and the capability to perform hypothesis testing. 

Sooner or later, all Oracle DBAs will be asked to perform business intelligence tasks and all Oracle professionals should become familiar with the common BI tools and techniques for Oracle business intelligence operations.  See the link below for more details:

http://www.dba-oracle.com/t_sql_tuning_tricks.htm

*****************************************
Oracle performance analysis made easy

Using the principles of decision support systems technology, BC has developed an important new Oracle tuning tool, Ion for Oracle.  Ion quickly isolate the reports on the important optimization issues, separating the wheat from the chaff like no other performance tuning software.

After several years of hard work, Ion for Oracle is finally available for general release.  Ion is unlike any other Oracle tool on the market, a tool that encapsulates expert techniques to allow a DBA to quickly visualize important trends and signatures.

Predictive analytics if the key to repairing Oracle problems before they cripple your database, and I created Ion for Oracle to allow any DBA to quickly identify changing workloads and unobtrusive patterns of data access.  To try Ion for free, see here:

www.ion-dba.com

*****************************************

Need a Health Check?

Oracle is the world's most complex and robust database and there are hundreds of sub-optimal setting that can cripple your database performance.

Burleson Consulting has a great Oracle health check where we identify all database bottlenecks to ensure that your mission critical system is running at optimal speeds.

Just call 800-766-1884 to schedule your health check.

*****************************************

Need Oracle Training?

The very best Oracle training comes from Burleson Consulting, where you get an on-site visit by an experienced Oracle expert and author.  Whether it's one-on-one mentoring or getting a customized on-site Oracle training class, there is no substitute for BC Oracle training.  Just call 800-766-1884 for details, and check out our on-site Oracle training catalog at the following link:

http://www.dba-oracle.com/bc-catalog.pdf