What is transactional and analytical database?

Question

Transactional data supports the daily operations of an organization (i.e. describes business events).Analytical data supports decision-making, reporting, query, and analysis (i.e. describes business performance). 2 июн. 2011 г.

What is transactional database?

Transactional databases are optimized for running production systems—everything from websites to banks to retail stores. These databases excel at reading and writing individual rows of data very quickly while maintaining data integrity.

What is analysis database?

An analytic database, also called an analytical database, is a read-only system that stores historical data on business metrics such as sales performance and inventory levels. Business analysts, corporate executives and other workers run queries and reports against an analytic database.

What is an example of a transactional database?

Some examples include: Financial transactional data: insurance costs and claims data, or a purchase or sale; Deposits or withdrawals in case of banks. Logistical transactional data: shipping status, shipping partner data. Work-related transactional data: employee hours tracking.

What is transactional data analysis?

Transactional data relates to the transactions of the organization and includes data that is captured, for example, when a product is sold or purchased. Master data is referred to in different transactions, and examples are customer, product, or supplier data.

Expert · Answer