What is an operational database and a data warehouse? How are they different?
What will be an ideal response?
Answer: An operational database stores data related to operating a business. The data is collected from enterprise accounting transactions, such as vendor transactions, customer transactions, and employee payroll. It also includes data about people, for example customers, vendors, and employees. The data is stored with primary keys so specific data may be retrieved.
A data warehouse stores data from a variety of sources. The data may be current, historical, or future estimates.
The difference is the data in an operational database is used for routine business activities. The data in a data warehouse is used for business intelligence to improve management decision making.
You might also like to view...
Of minority groups in the United States, __________________ own the most small businesses.
Fill in the blank(s) with the appropriate word(s).
When the writer needs to create a lengthy message they know will be read on the mobile device, which of the following will be most effective for the audience?
A) Linear organization B) Inverted pyramid C) Executive summary D) Micro rests E) Indirect approach