11. A hospital administrator wants real-time ED wait ×. Which database?

Answer: C

Explanation:

Transactional Database

A transactional database is the most suitable choice for a hospital administrator seeking real-time emergency department (ED) wait times. This type of database is designed to handle a high volume of transactions at rapid speeds, making it ideal for capturing and processing real-time data.

A) Warehouse

A warehouse is not appropriate for real-time data needs as it is primarily used for analytical purposes and historical data storage. It is designed to consolidate data from various sources for reporting and analysis rather than for immediate, transactional updates required for real-time monitoring.

B) Relational

While relational databases can support various applications, they may not be optimized for the high-speed transactions necessary for real-time ED wait times. They typically require more complex queries and do not perform as efficiently under the load of continuous, instantaneous updates compared to transactional databases.

C) Transactional

A transactional database is specifically built for managing real-time operations and is capable of processing numerous transactions simultaneously. This makes it ideal for accurately capturing the wait times in an ED setting, allowing administrators to access up-to-date information instantly.

D) Registry

A registry is generally used for maintaining lists of entities, such as patient information or medical records, but it is not focused on real-time transaction processing. Therefore, it does not provide the immediate data needed for monitoring ED wait times effectively.

Conclusion

The transactional database stands out as the correct choice for monitoring real-time ED wait times due to its ability to handle fast, concurrent transactions efficiently. Other options, such as warehouses and registries, lack the necessary capabilities for real-time data processing, while relational databases may not perform optimally under the required conditions. Thus, the transactional database is the definitive solution for the hospital administrator's needs.