OLTP – OLAP


OLTP (Online Transaction Processing) – row oriented

OLAP (Online Analytical Processing) – column oriented

OLTP - OLAP

good design

To check if OLAP is installed and correctly configured, use this statement:
select comp_name, version, status, modified from dba_registry where comp_name like ‘%OLAP%’;

COMP_NAME VERSION STATUS MODIFIED

OLAP Analytic Workspace 10.2.0.1.0 VALID 29-OCT-2005 01:37:54
Oracle OLAP API 10.2.0.1.0 VALID 29-OCT-2005 01:37:54
OLAP Catalog 10.2.0.1.0 VALID 29-OCT-2005 01:37:56

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: