|November 20, 2000|
Oracle Aims To Bring Data Warehousing To Net Speed
Oracle9i database will include data transformation, personalization, and OLAP
By Rick Whiting
|More on data warehousing:|
Send Us Your Feedback
Data warehouses usually are separate from operational systems. Typically, information is transferred from operational systems to the data warehouse daily, weekly, or monthly; analysts then study it for sales, marketing, and business-performance purposes.
But that's too slow for most Internet economy applications. E-commerce companies, for example, want to improve their Web sites' personalization capabilities by combining clickstream data generated by site visitors with warehoused historical information for real-time analysis.
By building business-intelligence and data-transformation capabilities directly into the core database, Oracle9i, available this spring, will integrate data from operational systems and data warehouses for real-time analysis, the vendor says. That should let users such as call-center employees and reservation agents make better-informed customer-related decisions. Earlier this year, NCR Corp. introduced a similar concept called "active warehousing."
"The idea is to close the loop between the decision-support system and the operational or transaction system," says Lou Agosta, a Giga Information Group analyst. On the downside, conducting real-time analysis within an operational database could slow the system, he says.
The new features may make up for potential slowdowns. Oracle plans to embed OLAP technology into Oracle9i and create a Java component-based architecture and a Java API. Database owners and third-party software vendors would use the API to develop analytical applications to take advantage of the OLAP capabilities. Oracle9i also will include built-in data-extraction, transformation, and loading technology, as well as an embedded real-time recommendation engine for personalization.
Oracle also will add data-mining technology to Oracle9i release 2, a move that IBM, Microsoft, and NCR have already made. Says Agosta, "The strategic direction here is to drive data mining into the database."
- BYOD into the Cloud: The Next Phase of Enterprise Mobility -
- Big Data: Architecting Systems at Speed - E2 Conference Boston
- Get practical information on how to develop your organization's mobile commerce application - Mobile Commerce World - Mobile Commerce World
- Mobile Connect - E2 Conference Boston - E2 Conference Boston
- How to Choose a SaaS Vendor - E2 Conference Boston
This Week's Issue
Free Print SubscriptionSubscribe
Current Government Issue
- The Government CIO 25: These influential and accomplished government IT leaders are finding ways to be cost efficient and still innovate.
- Rethink Video Surveillance: It's not just about networked cameras anymore. New technology provides analytics, automation, facial recognition, real-time alerts and situational-awareness capabilities.
- Read the Current Issue
- HP Newsletter with Gartner Research: Maximizing Your Infrastructure through Virtualization
- Understanding Holistic Database Security 8 Steps to Successfully Securing Enterprise Data Sources
- Information Protection: The Impact Of Big Data
- A How-To Guide on Using Cloud Services for Security-Rich Data Backup
- IBM index reveals key indicators of business continuity exposure and maturity