What is the difference between ODS and Dataware house?

Other Mainframe related questions which attracts you and there is no suitable Forum you find for it and related FAQs.
Previous topicNext topic

Topic Author
Deepa
Registered Member
Posts: 16
Joined: Wed Mar 12, 2014 1:08 pm

What is the difference between ODS and Dataware house?

Post by Deepa » Sun Oct 22, 2017 10:41 pm

Hi,

What is the difference between an ODS system and data-ware house technology? Are not they both serving us the same? Then why to have both them? Can someone please explain it to me?



User avatar

Anuj Dhawan
Founder
Posts: 2624
Joined: Sun Apr 21, 2013 7:40 pm
Location: Mumbai, India
Zodiac: Sagittarius

Re: What is the difference between ODS and Dataware house?

Post by Anuj Dhawan » Sun Oct 22, 2017 11:10 pm

An operational data store, commonly known as "ODS" is a database designed to integrate data from multiple sources for additional operations on the data, for reporting, controls and operational decision support. This is "collection of loosely connected data-sources from the enterprise" to give end user an access to the data they don't have any control but needs to drive a conclusion based on that. It's not like a production master data store as in the data is not passed back to operational systems. It may be passed for further operations and to the data warehouse for reporting.

Because the data originate from multiple sources, the integration often involves cleaning, resolving redundancy and checking against business rules for integrity. An ODS is usually designed to contain low-level or atomic (indivisible) data (such as transactions and prices) with limited history that is captured "real time" or "near real time" as opposed to the much greater volumes of data stored in the data warehouse generally on a less-frequent basis. An ODS is not a replacement of DWH and should never be looked at as a substitute for a data warehouse.

DWH, Data warehouse, on the other hand is a "place" to store current and historical data in one single location and are used for creating analytical reports for knowledge workers throughout the enterprise.

In 2017, rather interesting question is - with the advent of Big Data and Cloud how relevant the EWH is, thoughts!? :)


Thanks,
Anuj

Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.


nicc
Global Moderator
Global Moderator
Posts: 597
Joined: Wed Apr 23, 2014 8:45 pm

Re: What is the difference between ODS and Dataware house?

Post by nicc » Mon Oct 23, 2017 5:34 pm

Do you mean Operational Data Store or Output Delivery System. As did not specify I assume that you did not research first otherwise you would have known to specify what you are referring to. You should do your research first.


Regards
Nic

User avatar

Robert Sample
Global Moderator
Global Moderator
Posts: 1379
Joined: Fri Jun 28, 2013 1:22 am
Location: Dubuque Iowa
Zodiac: Virgo

Re: What is the difference between ODS and Dataware house?

Post by Robert Sample » Mon Oct 23, 2017 7:37 pm

What is the difference between an ODS system and data-ware house technology?
When you use an acronym such as ODS, you need to use the full name the first time before referencing just the acronym. This is because there are a lot of identical acronyms in the world and IT in particular -- www.acronymfinder.com returns 61 meanings for ODS, for example. To a SAS programmer, ODS is Output Delivery System.




Topic Author
Deepa
Registered Member
Posts: 16
Joined: Wed Mar 12, 2014 1:08 pm

Re: What is the difference between ODS and Dataware house?

Post by Deepa » Thu Oct 26, 2017 10:51 pm

I thought ODS was a common term like mainframes. I was asking about Operational Data Store. According to me no other synonym of it can be compared with DWH technology.



User avatar

Robert Sample
Global Moderator
Global Moderator
Posts: 1379
Joined: Fri Jun 28, 2013 1:22 am
Location: Dubuque Iowa
Zodiac: Virgo

Re: What is the difference between ODS and Dataware house?

Post by Robert Sample » Thu Oct 26, 2017 11:12 pm

ODS is a common term for SAS programmers to refer to the Output Delivery System.

You did it again, by the way -- you may ASSUME (and we know what that does) that "DWH" means data warehouse, but www.acronymfinder returns ELEVEN meanings for DWH. When you want to use an acronym, explain it FIRST.



User avatar

Robert Sample
Global Moderator
Global Moderator
Posts: 1379
Joined: Fri Jun 28, 2013 1:22 am
Location: Dubuque Iowa
Zodiac: Virgo

Re: What is the difference between ODS and Dataware house?

Post by Robert Sample » Fri Oct 27, 2017 6:41 pm

Oh, and by the way, data warehouses are NOT specific to mainframes -- if you Google data warehouse, one of the 61,400,000 results returned on the first page (at least for me) refers to Microsoft Azure Data Warehouse -- which certainly is not running on any mainframe! My company, for example, has a mainframe that is used for financials, customer ordering, inventory control -- but our data warehouse is kept on the network on Linux machines. The mainframe feeds the data warehouse but that's the only interaction between the mainframe and the data warehouse.




Topic Author
Deepa
Registered Member
Posts: 16
Joined: Wed Mar 12, 2014 1:08 pm

Re: What is the difference between ODS and Dataware house?

Post by Deepa » Sat Oct 28, 2017 9:08 am

Sorry all if I started asking so confusing question. I wanted to ask the difference between operational data store and Data ware-house.



Previous topicNext topic

Return to “Other Mainframe Topics, Off-Topics, FAQs.”