8/6/2019 olap& oltp 2003

1/14

PRESENTATION

ON

OLAP

&

OLTPPRESENTED BY:-

AMIT JAIN

ANANTA SHARMA

MRIDUL AGGARWAL

PRIYANKA TYAGI

SANJAY KUMAR

8/6/2019 olap& oltp 2003

2/14

4-2

Business

Intelligence

Database

OLTP

OLAP

Relational

DatabaseDBMS

Data

Warehouse

Data

Mining

Databases and Data Warehouses

8/6/2019 olap& oltp 2003

3/14

- OLTP (On-line Transaction Processing) is characterized by alarge number of short on-line transactions (INSERT, UPDATE,DELETE). The main emphasis for OLTP systems is put on very fastquery processing, maintaining data integrity in multi-accessenvironments and an effectiveness measured by number of

transactions per second. In OLTP database there is detailed andcurrent data, and schema used to store transactional databases is theentity model.

- OLAP (On-line Analytical Processing) is characterized byrelatively low volume of transactions. Queries are often very

complex and involve aggregations. For OLAP systems a responsetime is an effectiveness measure. OLAP applications are widelyused by Data Mining techniques. In OLAP database there isaggregated, historical data, stored in multi-dimensional schemas.

8/6/2019 olap& oltp 2003

4/14

OLTP

ONLINE TRANSACTION PROCESSING

The term OLAPwas created as a slight modification of thetraditional database term OLTP (Online Transaction

Processing)Online transaction processing, or OLTP, refers to a class ofsystems that facilitate and manage transaction-oriented

applications, typically for data entry and retrievaltransaction processing. The term is somewhat ambiguous;

some understand a "transaction" in the context ofcomputer or database transactions, while others (such as

the Transaction Processing Performance Council) define it interms of business or commercial transactions.

8/6/2019 olap& oltp 2003

5/14

BAISC CHARACTERSTICS OF OLTP

Online transaction processing increasingly requires support fortransactions that span a network and may include more than onecompany. For this reason, new OLTP software uses client/serverprocessing and brokering software that allows transactions to runon different computer platforms in a network.

In large applications, efficient OLTP may depend on sophisticatedtransaction management software (such as CICS) and/or databaseoptimization tactics to facilitate the processing of large numbers ofconcurrent updates to an OLTP-oriented database.

For even more demanding Decentralized database systems, OLTPbrokering programs can distribute transaction processing among

multiple computers on a network. OLTP is often integrated intoservice-oriented architecture (SOA) and Web services.

8/6/2019 olap& oltp 2003

6/14

TYPES OF OLAP

MULTIDIMENSIONAL

MOLAP

RELATIONAL

ROLAP

HYBIRD

HOLAP

8/6/2019 olap& oltp 2003

7/14

MOLAP

MOLAP is the 'classic' form of OLAP and is

sometimes referred to as just OLAP. MOLAP

stores this data in an optimized multi-

dimensional array storage, rather than in a

relational database. Therefore it requires the

pre-computation and storage of information in

the cube - the operation known as processing.

8/6/2019 olap& oltp 2003

8/14

ROLAP

ROLAP works directly with relational databases.The base data and the dimension tables arestored as relational tables and new tables arecreated to hold the aggregated information.Depends on a specialized schema design.Thismethodology relies on manipulating the datastored in the relational database to give theappearance of traditional OLAP's slicing and

dicing functionality. In essence, each action ofslicing and dicing is equivalent to adding a"WHERE" clause in the SQL statement

8/6/2019 olap& oltp 2003

9/14

HOLAP

There is no clear agreement across theindustry as to what constitutes "Hybrid OLAP",except that a database will divide data

between relational and specialized storage.For example, for some vendors, a HOLAPdatabase will use relational tables to hold thelarger quantities of detailed data, and use

specialized storage for at least some aspectsof the smaller quantities of more-aggregate orless-detailed data.

8/6/2019 olap& oltp 2003

10/14

Applications of OLAP

Business reporting for sales

Marketing

Management reporting

Business process management

Budgeting & forecasting

Financial reporting

and similar areas

8/6/2019 olap& oltp 2003

11/14

8/6/2019 olap& oltp 2003

12/14

12

OLTP vs. OLAP

OLTP: On Line Transaction Processing

Describes processing at operational sites

OLAP: On Line Analytical Processing

Describes processing at warehouse

8/6/2019 olap& oltp 2003

13/14

13

OLTP vs. OLAP

Mostly updates

Many small transactions

Mb-Tb of data

Raw data

Clerical users

Up-to-date data

Consistency, recoverability

critical

Mostly reads

Queries long, complex

Gb-Tb of data

Summarized, consolidated

data

Decision-makers, analysts

as users

OLTP OLAP

8/6/2019 olap& oltp 2003

14/14

CONCLUSION

Online Transaction Processing has two key

benefits: simplicity and efficiency. Reduced

paper trails and the faster, more accurate

forecasts for revenues and expenses are both

examples of how OLTP makes things simpler

for businesses.

OLAP is Beneficial for data mining to enhancethe Business Processes.