8 Business Intelligence
Business intelligence has become a buzzword in recent years. The database tools found under the heading of business intelligence include data warehousing, online analytical processing (OLAP), and data mining. The functionalities of these tools are complementary and interrelated. Data warehousing provides for the efficient storage, maintenance, and retrieval of historical data. OLAP is a service that provides quick answers to ad hoc queries against the data warehouse. Data mining algorithms find patterns in the data and report models back to the user. All three tools are related to the way data in a data warehouse are logically organized, and performance is highly sensitive to the database design techniques used [Barquin ...
Get Database Modeling and Design, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
