Martin K. Solomon
Abstract
PEIRCE is an interactive relational database management system intended for mini and microcomputers, with an extensible command facility, QUERY, based on Codd's relational algebra and supporting a clerk oriented interface.
PEIRCE contains three major independent on-line modules: DBA, QUERY, and CSU.
DBA provides the data definition and data dictionary facilities and is discussed in Section 2.
QUERY provides both a relational algebra data manipulation language and a clerk oriented interface. QUERY is also discussed in Section 2.
Command sequences are discussed in Section 3.
We discuss the virtual file facilities of PEIRCE (which include the updating of virtual files) in Section 4.
The underlying storage structure, namely entry order sequence with secondary indexes, was chosen primarily with simplicity of recovery in mind and is discussed in section 5.
In Section 6 we discuss the control commands IF and FOR, which help to conveniently avoid having a host language facility.
We conclude in Section 7 by describing further work planned on PEIRCE.
- 1 Aho, A.V. and J.D. Ullman {1979}, "Universality of data retrieval languages", Proc. Sixth ACM Symposium on Principles of Programming Languages, pp. 110-120. Google Scholar
Digital Library
- 2 Astrahan, M.M., et al. {1976}, "System R a relational approach to data management", ACM Trans. on Database Systems 1:2, pp. 97-137. Google ScholarDigital Library
- 3 Date, C.J. {1977}, An Introduction to Database Systems, Addison-Wesley, Reading, Mass. Google ScholarDigital Library
- 4 Furtado, A., et al. {1979}, "Permitting updates through views of databases", Information Systems Vol. 41, pp. 269-283.Google ScholarCross Ref
- 5 Solomon, M.K. {1980}, PEIRCE User's Manual, Graduate School of Management, Rutgers University.Google Scholar
- 6 Stonebraker, M.E., et al. {1976}, "The design and implementation of Ingres", ACM Trans. on Database Systems 1:3, pp. 189-222. Google ScholarDigital Library
- 7 Tarski, A. {1941}, "On the calculus of relations", Journal of Symbolic Logic 6:3, pp. 73-89.Google ScholarCross Ref
- 8 Ullman, J.D. {1980}, Principles of Data Base Systems, Computer Science Press, Potomac, Md. Google ScholarDigital Library
- 9 Klug, A. {1980}, "Calculating constraints on relational expressions", ACM Trans. on Database Systems 5:3, pp. 260-290. Google ScholarDigital Library
- 10 Severance, D.G. and G.M. Lohman {1976}, "Differential files: their application to the maintenance of large databases", ACM Trans. on Database Systems 1:3, pp. 256-267. Google ScholarDigital Library
Index Terms
- PEIRCE: A relational DBMS for small systems
Recommendations
PEIRCE: A relational DBMS for small systems
SIGSMALL '81: Proceedings of the 1981 ACM SIGSMALL symposium on Small systems and SIGMOD workshop on Small database systemsPEIRCE is an interactive relational database management system intended for mini and microcomputers, with an extensible command facility, QUERY, based on Codd's relational algebra and supporting a clerk oriented interface.
PEIRCE contains three major ...
Comments