A relational model of data for large shared data banks
Communications of the ACM
Volume testing of statistical/database software
SSDBM'81 Proceedings of the 1st LBL Workshop on Statistical database management
| Hi-index | 0.00 |
This paper discusses the use of the ORACLE relational database management system to solve data manipulation problems and produce frequency distributions from complex data structures typical of social science statistical data processing applications. First a brief review of relational database technology is presented, followed by a description of ORACLE and its nonprocedural data language, SQL. Then ORACLE solutions are presented for four complex data manipulation problems posed using two different databases. The relational approach, and ORACLE in particular, are especially well suited to the types of data manipulation required by the problems presented; two of the problems can be solved with a single SQL statement.