Cs Online Analytical Procc

National Institute of Science & Technology

TECHNICAL SEMINAR PRESENTATION

OnLine Analytical Processing Seminar Presentation By Murali Mohan Rath CS200117198

Under the guidance of Mr. Indraneel Mukhopadhyay

Murali Mohan Rath

CS200117198

[1]

National Institute of Science & Technology

TECHNICAL SEMINAR PRESENTATION

What is OLAP OnLine Analytical Processing ia a technology that uses multidimensional view of aggregate data for quicker access to strategic information.

Murali Mohan Rath

CS200117198

[2]

National Institute of Science & Technology

TECHNICAL SEMINAR PRESENTATION

How OLAP Helps It helps in decision making, business modeling, and operations research activities by transforming raw Data warehouse data into strategic information

Murali Mohan Rath

CS200117198

[3]

National Institute of Science & Technology

TECHNICAL SEMINAR PRESENTATION

Four Main Characteristics of OLAP –Use multidimensional data analysis techniques –Provide advanced database support –Provide easy-to-use end user interfaces –Support client/server architecture

Murali Mohan Rath

CS200117198

[4]

National Institute of Science & Technology

TECHNICAL SEMINAR PRESENTATION

Multidimensional Data Analysis Techniques –The processing of data in which data are viewed as part of a multidimensional structure. –Multidimensional view allows end users to consolidate or aggregate data at different levels.

Murali Mohan Rath

CS200117198

[5]

National Institute of Science & Technology

TECHNICAL SEMINAR PRESENTATION

Multidimensional Data Analysis Relational databases contains lists of records whose information is organised into fields and is based on a row and column data format(one dimensional). However some relational tables where there is more than a one-to-one relationship between the fields lends itself to multidiensional represtation. Murali Mohan Rath

CS200117198

[6]

National Institute of Science & Technology

TECHNICAL SEMINAR PRESENTATION

Single Dimensional View Product

Region

Sales

Nuts

East

50

Nuts

West

60

Nuts

Central

100

Bolts

East

90

Bolts

West

120

Bolts

Central

140

Screws

East

40

Screws

West

70

Screws

Central

80

Washers

East

20

Washers

West

10

Washers

Central

30

Murali Mohan Rath

CS200117198

[7]

National Institute of Science & Technology

TECHNICAL SEMINAR PRESENTATION

Multidimensional View

East

West

Central

Nuts

60 120 70 10

100 140 80 30

Murali Mohan Rath

CS200117198

50 Bolts 90 Screws 40 Washers 20

[8]

National Institute of Science & Technology

TECHNICAL SEMINAR PRESENTATION

OLAP Architecture –Three Main Modules ◆OLAP

Graphical User Interface (GUI)

◆OLAP

Analytical Processing Logic

◆OLAP

Data Processing Logic

–OLAP systems are designed to use both operational and Data Warehouse data. Murali Mohan Rath

CS200117198

[9]

National Institute of Science & Technology

TECHNICAL SEMINAR PRESENTATION

OLAP Server Arrangement Murali Mohan Rath

CS200117198

[10]

National Institute of Science & Technology

TECHNICAL SEMINAR PRESENTATION

OLAP Server With Multidimensional Data Store Arrangement

Murali Mohan Rath

CS200117198

[11]

National Institute of Science & Technology

TECHNICAL SEMINAR PRESENTATION

Relational OLAP Relational On-Line Analytical Processing (ROLAP) provides OLAP functionality by using relational database and familiar relational query tools. Extensions to RDBMS

Multidimensional data schema support within the RDBMS

Data access language and query performance optimized for multidimensional data

Support for very large databases Murali Mohan Rath

CS200117198

[12]

National Institute of Science & Technology

TECHNICAL SEMINAR PRESENTATION

Multidimensional Data Schema Support within the RDBMS Normalization

of tables in relational technology is seen as a stumbling block to its use in OLAP systems. DSS

data tend to be non-normalized, duplicated, and pre-aggregated. ROLAP

uses a special design technique to enable RDBMS technology to support multidimensional data representations, known as star schema. Star

schema creates the near equivalent of a multidimensional database schema from the existing relational database Murali Mohan Rath

CS200117198

[13]

National Institute of Science & Technology

TECHNICAL SEMINAR PRESENTATION

A Typical ROLAP Client/Server Architecture

Murali Mohan Rath

CS200117198

[14]

National Institute of Science & Technology

TECHNICAL SEMINAR PRESENTATION

LIMITATIONS The real limitation of OLAP databases is

almost always the number of cells and not the number of dimensions.

As the number of dimensions increases the number of cells increases expotentially so a 16 dimension database with 5 members in each has 152 billion cells.

Most OLAP servers reach their limit in cell

numbers before they hit their dimensions limit Murali Mohan Rath

CS200117198

[15]

National Institute of Science & Technology

TECHNICAL SEMINAR PRESENTATION

CONCLUSION

In essence OLAP technology is fast, flexible data summarisation and analysis.

OLAP servers are a superior technology for Business Intellgence applications.

OLAP servers and relational databases can work in harmony to create an environment that delivers data quickly to perform the analysis needed to make the best business decisions. Murali Mohan Rath

CS200117198

[16]

National Institute of Science & Technology

TECHNICAL SEMINAR PRESENTATION

Murali Mohan Rath

CS200117198

[17]