14

Data Warehousing, OLAP, and Data Mining

1.   What are decision-support systems? What are the various tools and techniques that support decision-making activities?

Ans: Decision-support systems (DSS) are systems that aim to extract high-level information stored in traditional databases (such as network, hierarchical, relational and object-oriented), and use that information in making a variety of decisions that are important for the organization. The various tools and techniques that support decision-making activities are data warehousing, online analytical processing (OLAP) and data mining. Data warehouses contain consolidated data from many sources, augmented with summary information, and covering a long time period. OLAP refers to the ...

Get Express Learning: Database Management Systems 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.