A researcher wants monthly average lengths of stay for various hospitals and link to other indicators. Which database?

Flat databases store data in a single table without relationships, making them less efficient for tasks requiring complex queries or data linking. While they can hold average lengths of stay, they lack the ability to easily connect this data with other indicators, limiting their utility for comprehensive analysis.

Knowledge management systems focus on the organization and sharing of knowledge within an organization, rather than on data storage and retrieval. While they may help in managing information related to hospital stays, they do not provide the structured query capabilities needed to analyze monthly averages or link to diverse indicators.

Transactional databases are optimized for processing large volumes of transactions and ensuring data integrity during these operations. They are typically used for operational purposes rather than for analytical tasks, making them unsuitable for deriving monthly averages and linking multiple indicators.