Focus: management information systems. Basic concepts of a database management system.

Laboratory information systems are now found in almost every clinical laboratory. Since laboratory information systems are simply database management systems, an understanding of how databases work can greatly enhance their usefulness. All data stored in a database must have property and relationshi...

Descripción completa

Detalles Bibliográficos
Publicado en:Clinical Laboratory Science Vol. 12; no. 3; pp. 174 - 181
Autor principal: Fowler DG
Formato: CEU exam questions Journal Article
Publicado: American Society for Clinical Laboratory Science 1999 May-Jun
Acceso en línea:Ver este registro en EBSCOhost
Descripción
Sumario:Laboratory information systems are now found in almost every clinical laboratory. Since laboratory information systems are simply database management systems, an understanding of how databases work can greatly enhance their usefulness. All data stored in a database must have property and relationship descriptions that axe stored in a data dictionary for use by the database management system. There are three different types of data relationships that can exist. These include one-to-one, one-to-many, and many-to-many. Types of databases include the flat file, relational, object-oriented, and main memory databases. Of these four types the relational database is the most commonly used in healthcare. This type of database offers many advantages to data storage and retrieval such as providing data independence, data sharing, data accuracy, ad hoc queries, report generation, database size, and importing. As new technology becomes available, the more recent database types such as object-oriented and main memory will become the database of choice for laboratory information systems.