OLAP vs OLTP
OLAP or “on-line analytical processing” is an enabling application technology and database model that grants users—such as functional managers—strategic decision making capabilities. OLAP analyzes the results of daily business, so tactical and strategic decisions can be made to change the way business is done and gain competitive advantage. OLAP tools include programs that show Multi-Dimensional Data, rather like a spreadsheet with six or seven dimensions instead of only two with drill down capability. While OLTP or “on-line transaction processing” applications enhance transaction processing by relating atomized data across business processes, OLAP applications and databases provide users with the ability to view "multi-dimensional data," thereby enhancing the manager's ability to create business models. The significance of a "multi-dimensional view" of data is that it allows decision-makers to view many, summarized, historical data records, and group them by subject. In short, it allows for consolidation of data. Rather than executing queries that view data by record and file—such a
. . .
Some common words found in the essay are:
OLTP Database, Multi-Dimensional Data, Queries Relatively, Mart Source, , Updates Short, OLAP Type, relational databases, complex queries, ability execute, database thereby, olap data, data records, atomized data, historical data, business processes, olap tools,
Approximate Word count = 743
Approximate Pages = 3 (250 words per page double spaced)
|