Switch to
| Predicate | Object |
|---|---|
| rdf:type | |
| lifeskim:mentions | |
| pubmed:issue |
6
|
| pubmed:dateCreated |
1990-1-12
|
| pubmed:abstractText |
Conventional relational database management systems fail to address three features of statistical data management in a biomedical/clinical database, namely, that (1) statistical and medical data (SMD) require a great deal of space and need to be stored in a reduced form with minimal duplication; indeed, SMD have many derived/calculated and summary statistics that make the number of attributes in a relation (i.e., a set of records) grow rapidly and dynamically; (2) most SMD have hierarchical structures that are difficult to manage using the relational data model since SMD are stored in separate relations for duplication and space considerations; and (3) the management of SMD is made easier if it is possible to reorganize relations or group data, a capability lacking in conventional relational database management systems. In this paper, we (1) introduce five extended relational operators, (lattice) NEST, (lattice) UNNEST, MERGE, SPREAD, and GEN, to reorganize relations; (2) integrate the extended operators with conventional relational algebra and introduce the concept of the lattice relational model; and (3) give applications of the extended relational operators and the lattice relational model in solving the problems of statistical data manipulation in medical databases.
|
| pubmed:language |
eng
|
| pubmed:journal | |
| pubmed:citationSubset |
IM
|
| pubmed:status |
MEDLINE
|
| pubmed:month |
Dec
|
| pubmed:issn |
0010-4809
|
| pubmed:author | |
| pubmed:issnType |
Print
|
| pubmed:volume |
22
|
| pubmed:owner |
NLM
|
| pubmed:authorsComplete |
Y
|
| pubmed:pagination |
516-31
|
| pubmed:dateRevised |
2004-11-17
|
| pubmed:meshHeading | |
| pubmed:year |
1989
|
| pubmed:articleTitle |
Extended relational operators for statistical data manipulations in medical databases.
|
| pubmed:affiliation |
Department of Computer Engineering and Science, Case Western Reserve University, Cleveland, Ohio 44106.
|
| pubmed:publicationType |
Journal Article
|