Compare a data warehouse used for decision support to an operational database. How do the data...

Compare a data warehouse used for decision support to an operational database. How do the data warehouse and the operational database differ in their purpose, their structure, the technology they use, and the way they are managed? Why would a company need both?

Solutions

Expert Solution

Operational Database and Data warehouse both are generally maintained by an organization in which the role of both the database differ. The operational database is a very much dynamic database which collects and stores daily transactional and almost everyday the data is loaded in to the same. Such databases are used to generate reports and details regarding anything because they possess the latest data that is getting updated each and every regular interval. On the other hand data warehouse is the database in which data is loaded in bulk based on various intervals like weekly, or semi monthly or monthly and while loading, the history is also stored and maintained in the process. Operational database may update existing data but in warehouse it is always maintaining the history as well that will help the organization in this context.

The technology used may also differ because in loading of operational database there can be UI entries or Batch job processing and on the other hand the warehouse loading includes Informatica mappings, datastage, etc.

keosha answered 11 months ago

Next > < Previous

Related Solutions

How do you used clinical decision support system in practice. What do you see as some...

How do you used clinical decision support system in practice. What do you see as some of the benefits and challenges with these type of system?

What are the similarities and differences between database, data warehouse, and data mining?

discussed big data , data warehouse and google database for big data and bootstrapping technique for...

discussed big data , data warehouse and google database for big data and bootstrapping technique for data analytics to a real life business scenario.

With a cube from a database or data warehouse, you are bringing data "forward." Explain what...

With a cube from a database or data warehouse, you are bringing data "forward." Explain what this means and how it impacts the front-end and back-end user from a database perspective. Provide examples to illustrate your ideas. typed please

For an airlines company, identify three operational applications that would feed into the data warehouse. What...

For an airlines company, identify three operational applications that would feed into the data warehouse. What would be the data load and refresh cycles for each? data warehousing

1. Clinical Decision Support Systems Things to know: What is it used for? How does it...

1. Clinical Decision Support Systems Things to know: What is it used for? How does it work and where does the data come from (sources)? What are its benefits? What are its drawbacks? 2. Meaningful Use Things to know: What are the requirements? Who do they apply to? What are the objectives of these requirements? What problems have been encountered? 3. Health Information Exchange Things to know: What is it used for? How does it work and where does the...

Database administrators use backups and replication to protect data stored in a database. Compare and contrast...

Database administrators use backups and replication to protect data stored in a database. Compare and contrast the two operations. Describe a business application scenario, and provide and discuss a sample query of a common backup or restore operation.

Question