Abstract
In this paper, we identify the database issues associated with programmable logic controllers (PLC), special-purpose computers used in scientific and industrial applications, e.g., in factories in manufacturing environments. We propose as a PLC database system a single-user, real-time, scalable main-memory-only relational database system with a two-level architecture having historical data modeling and manipulation capabilities, and query processing techniques incorporating time- and/or error-constrained query evaluation. We revise the ladder logic language, the most common PLC language, to incorporate data manipulation language instructions. We add a separate time component into the PLC processor scan time to handle database updates, backup, integrity enforcement and data archival issues.
This research is supported by the National Science Foundation under Grants DCR-860554, and IRI-8811057.
This is a preview of subscription content, log in via an institution.
Preview
Unable to display preview. Download preview PDF.
References
PLC-3 Programmable Controller Programming Manual, Allen-Bradley Co., 1984.
PLC-5/15 Programmable Controller Processor Manual, Allen-Bradley Co., 1985.
R. Abbott, H. Garcia-Molina, "Scheduling Realtime Transactions", ACM SIGMOD RECORD 1988.
P. Chen, "The Entity-Relationship Model: toward a Unified View of Data", ACM Trans. on Database Systems, 1976.
Christodoulakis, S., "Estimating Record Selectivities", Information Systems, Vol 8, 1983.
Hewlett-Packard Announcement of the HP RTDBS, Sept. 1988.
A. Klug, "ABE — A Query Language for Constructing Aggregate-by-Example", 1st LBL Workshop on Statistical Database Management, Dec. 1981.
W-C Hou, G. Ozsoyoglu, B. Taneja, "Statistical Estimators for Relational Algebra Expressions", ACM PODS conference, March 1988.
W-C Hou, G. Ozsoyoglu, B. Taneja, "Processing Aggregate Queries with Hard Time Constraints", Proc., ACM SIGMOD Conference, May 1989.
W-C Hou, G. Ozsoyoglu, "Statistical Estimators for Aggregate Relational Algebra Expressions", May 1988. (submitted for publication).
Tutorial, IEEE Hard Real-Time Systems, 1988.
Y.M. Liu, "A Main-Memory Real-time Database Management System—Implementation and Experiments", M.S. Thesis, CWRU, July 24, 1989.
A. Ola, G. Ozsoyoglu, "A Family of Incomplete Relational Database Models", Proc., VLDB 89, Amsterdam, 1989.
A. Ola and G. Ozsoyoglu, "Geometric Modeling of Incomplete Relational Databases", Tech. Rep., CWRU, Dec. 1988.
G. Ozsoyoglu, V. Matos, Z.M. Ozsoyoglu, "Query Processing Techniques in the Summary-Table-by-Example Database Query Language", ACM TODS, Dec. 1989.
G. Ozsoyoglu, V. Matos, "On Optimizing Summary-Table-by-Example Query", ACM PODS conference, 1985.
G. Ozsoyoglu, H.Q. Wang, "A Relational Calculus with Set Operators, its Safety and Graphical Languages", IEEE Transactions on Software Engineering, September 1989.
Rowe, N. C., "Antisampling for Estimation: An overview", IEEE Trans. on Software Engineering, October 1985.
Procedings, IEEE Real-Time System Symposium, Dec 1987.
J. Shen, "A Main-Memory Incomplete Information Database Management System—Implementation and Experiments", M.S. Thesis in progress, CWRU, 1989.
R. Snodgrass, I. Ahn, "A Taxonomy of Time in Databases", ACM SIGMOD Conf. 1985.
Panel on Scientific Databases, Third Int. Workshop on Statistical and SCientific Database Management, 1986.
R.J. Staron, "A Toolset to Develop Programmable Controller Systems", unpublished manuscript, Allen-Bradley Co., March 1987.
J. Stankovic and W. Zhao "On Real-Time Transactions", ACM SIGMOD RECORD 1988.
A.U. Tansel, M.E. Arkun, G. Ozsoyoglu, "Time-by-Example Query Language", IEEE Trans. on Software Engineering, April 1989.
T.J. Teorey, J.P. Fry, "Design of Database Structures", Prentice-Hall, 1982.
J.D Ullman, "Principles of Database and Knowledge-Base Systems", Computer Science Press, 1988.
M.M. Zloof, "Query-by-Example: A Database Language", IBM System Journal, 1977.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1990 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Ozsoyoglu, G., Hou, WC., Ola, A. (1990). Database systems for programmable logic controllers. In: Michalewicz, Z. (eds) Statistical and Scientific Database Management. SSDBM 1990. Lecture Notes in Computer Science, vol 420. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-52342-1_28
Download citation
DOI: https://doi.org/10.1007/3-540-52342-1_28
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-52342-0
Online ISBN: 978-3-540-46968-1
eBook Packages: Springer Book Archive