Download - olap& oltp 2003
-
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.