DMBI Unit-2
DMBI Unit-2
DMBI Unit-2
•
•
•
•
•
•
•
OLAP in the Data Warehouse
Limitations of other analysis methods (OLTP)
Online transaction processing refers to more than just financial
transactions. Telemarketers use OLTP for their phone surveys, call
centers use it to access customer data and companies use it to
manage customers' online accounts. Businesses also use it to
facilitate e-commerce, their internal communications and numerous
applications. If your company doesn't use don't use OLTP, it may
lose sales opportunities and operational efficiencies. However, OLTP
also comes with important disadvantages and limitations.
Unscheduled Downtime
Your business can suffer considerable losses when the OLTP system
goes down, even temporarily. This can happen due to network
outages, data corruption or hardware failure. Companies can protect
their operation by building redundancy into the business platform,
but that may not prove cost-effective for smaller businesses. To
mitigate these concerns, hire competent IT personnel who are
available 24/7 to respond to critical issues. You also must maintain
good lines of communication with your institutional partners, so
that you can get support when you need it and pass information
along to others who may be affected.
Concurrency Challenges
OLTP systems allow multiple users to access and modify the same
data at the same time. For obvious reasons, you can't allow one user
to change data while another person is modifying it. You must
devise an efficient way to ensure people aren't working at cross
purposes while retaining a system that is responsive for everyone.
This may require costly systems designs and maintenance. OLTP
concurrency best practices have evolved in step with the growth of
the Internet and OLTP itself, so the solutions are available in the
form of OLTP software packages, but if you can't implement them
yourself, you must hire a professional to do it.
Atomicity
• Accessibility: The OLAP tool also let to access data needed for
the analysis from all heterogeneous enterprise data sources
such as relational, non-relational, and legacy methods.
Characteristics of OLAP
Fast
It defines which the system targeted to deliver the most
feedback to the client within about five seconds, with the
elementary analysis taking no more than one second and
very few taking more than 20 seconds.
Analysis
It defines which the method can cope with any business
logic and statistical analysis that is relevant for the
function and the user, keep it easy enough for the target
client. Although some preprogramming may be needed
we do not think it acceptable if all application definitions
have to be allow the user to define new Adhoc
calculations as part of the analysis and to document on
the data in any desired method, without having to
program so we excludes products (like Oracle Discoverer)
that do not allow the user to define new Adhoc
calculation as part of the analysis and to document on
the data in any desired product that do not allow
adequate end user-oriented calculation flexibility.
Share
It defines which the system tools all the security
requirements for understanding and, if multiple write
connection is needed, concurrent update location at an
appropriated level, not all functions need customer to
write data back, but for the increasing number which
does, the system should be able to manage multiple
updates in a timely, secure manner.
Multidimensional
This is the basic requirement. OLAP system must provide
a multidimensional conceptual view of the data, including
full support for hierarchies, as this is certainly the most
logical method to analyze business and organizations.
Information
The system should be able to hold all the data needed by
the applications. Data sparsity should be handled in an
efficient manner.
Features of OLAP
Online Analytical Processing (OLAP) is usually contrasted from
Online Transactional Processing (OLTP) and is a way of storing
data so that it can be used for better analytical queries. The
biggest difference in OLAP is that data is stored in what is
commonly referred to as an OLAP cube. In OLTP however, the
data is stored in tables and it uses a relational database system.
Advantages of OLAP
Disadvantages of OLAP
Functions of OLAP
OLAP can be used for data mining or the discovery of previously
undiscerned relationships between data items. An OLAP
database does not need to be as large as a data warehouse,
since not all transactional data is needed for trend analysis. Using
Open Database Connectivity (ODBC), data can be imported from
existing relational databases to create a multidimensional
database for OLAP.
OLAP operations:
•
•
BASIS FOR
ROLAP MOLAP
COMPARISON
of data cubes.
kept in MDDBs.
BASIS FOR
ROLAP MOLAP
COMPARISON
•
•
•
•
•
•
•
•
•
Business Analysis
Working from the results of the Opportunity Assessment, and using the Data
Warehouse Strategy as a framework, the Senior Business Analyst identifies
the detailed requirements for the solution.
The Senior Business Analyst works with end users to capture their intended
use of the information for business growth, determine what information they
need to see, and how they need to see it:
Based on findings from the Business Analysis service, the Data Warehouse
Architect works with the company’s Data Administrator to determine the
data sources that are required to support the business needs, and the quality
of the data in those sources.
If similar data exists in more than one source, we work with the Data
Administrator and business user to determine the single authoritative source
Data quality improvement may involve one-time and ongoing activities such
as removing duplicates, standardizing names and addresses, deriving implied
values, and improving data validation or logic in the operational system
which generates the data.