Operational Data Store (ODS)

-
What is an ODS?


An environment:
  1. where data from different OLTP databases is integrated
  2. which provides a view of enterprise data
  3. that addresses operational challenges across more than one business function

Characteristics of ODS:
  1. subject-oriented - catered to specific function or application (customer-centricity, risk management)
  2. integrated - from multiple legacy systems or new and legacy systems
  3. timely - data is continuously/ frequently being updated, typically more frequently than daily
  4. current - data is typically current with little history
  5. detailed - data is sufficiently detailed; not only at a summarized level
  6. central version of reference data
ODS should be a separate data store from the data warehouse.

Difference between ODS and Data Warehouse

ODSDW
Data CurrencyCurrent/ near-currentHistorical snapshot
Data LoadingInsert/ Update/ Deletion allowedOnly loaded

Comments

Post a Comment

Popular posts from this blog

Understanding ITIL Service Management the UML way…

-
Image
I originally had a great deal of difficult reconciling the differences amongst ITIL Change Management, Incident Management, and Problem Management. Having researched on the subjects and understanding them better now, I’ve tried to put the concepts together using a UML class diagram to capture my understanding and to keep it imprinted. Similarly, I wanted to differentiate the various categories of changes (Standard, Emergency, Normal) using an easy to understand & self-explanatory manner – a UML Activity Diagram!
Read more

How to depict (Professional-Looking) Logical Network Diagrams in Astah

-
Image
I have always had to create (professional-looking) UML diagrams using Visio-like icons. You’ve got to admit that showing a bunch of boring UML boxes hardly interests anyone less technical (like anyone whose designation has the words “manager” or “director”). This is actually possible in Astah! I’ve created a template for future projects that allows me to produce logical network diagrams that look like the following: To create this diagram, you need to do the following: Assign various icons to stereotypes. I created the following for my use: Create a new UML Deployment Diagram Every element in the diagram is created as a Node The nodes are subsequently assigned the appropriate <<stereotype>>. E.g. Internet is <<internet>>, WebZone FW is <<firewall>>, Web LB is <<loadBalancer>> Ensure the “Icon Notation” is set to “Customized Icon” for each node Instead of the boring boxes, the corresponding icons automatically gets displayed!
Read more