Chapter 22 Advanced Querying and Information Retrieval

Chapter 22: Advanced Querying and Information Retrieval

Decision Support Systems

Decision-Support Systems: Overview

Data Analysis and OLAP

Relational Representation of Crosstabs

Three-Dimensional Data Cube

Online Analytical Processing

Hierarchies on Dimensions

Cross Tabulation With Hierarchy

OLAP Implementation

OLAP Implementation (Cont. )

Extended Aggregation

Extended Aggregation in SQL: 1999

Extended Aggregation (Cont. )

Extended Aggregation (Cont. )

Extended Aggregation (Cont. )

Ranking

Ranking (Cont. )

Ranking (Cont. )

Ranking (Cont. )

Windowing

Windowing (Cont. )

Data Mining

Data Mining

Applications of Data Mining

Applications of Data Mining (Cont. )

Classification Rules

Decision Tree

Construction of Decision Trees

Construction of Decision Trees (Cont. )

Best Splits

Best Splits (Cont. )

Best Splits (Cont. )

Finding Best Splits

Decision-Tree Construction Algorithm

Decision Tree Constr’n Algo’s. (Cont. )

Other Types of Classifiers

Naïve Bayesian Classifiers

Regression

Association Rules

Association Rules (Cont. )

Finding Association Rules

Finding Support

Other Types of Associations

Clustering

Hierarchical Clustering

Clustering Algorithms

Collaborative Filtering

Other Types of Mining

Data Warehousing

Data Warehousing

Data Warehousing

Components of Data Warehouse

Components of Data Warehouse (Cont. )

Data Warehouse Schemas

Warehouse Schemas

Information Retrieval

Information Retrieval Systems

Information Retrieval Systems (Cont. )

Keyword Search

Relevance Ranking Using Terms

Relevance Ranking Using Terms (Cont. )

Relevance Using Hyperlinks

Relevance Using Hyperlinks (Cont. )

Relevance Using Hyperlinks (Cont. )

Similarity Based Retrieval

Synonyms and Homonyms

Indexing of Documents

Measuring Retrieval Effectiveness

Web Crawling

Web Crawling (Cont. )

Browsing

Classification DAG

A Classification DAG For A Library Information Retrieval System

Web Directories