Database systems for programmable logic controllers

  • Gultekin Ozsoyoglu
  • Wen-Chi Hou
  • Ade Ola
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 420)


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.


Query Processing Application Program Relational Algebra Host Computer Output Buffer 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [AB84]
    PLC-3 Programmable Controller Programming Manual, Allen-Bradley Co., 1984.Google Scholar
  2. [AB85]
    PLC-5/15 Programmable Controller Processor Manual, Allen-Bradley Co., 1985.Google Scholar
  3. [AbGM88]
    R. Abbott, H. Garcia-Molina, "Scheduling Realtime Transactions", ACM SIGMOD RECORD 1988.Google Scholar
  4. [Chen76]
    P. Chen, "The Entity-Relationship Model: toward a Unified View of Data", ACM Trans. on Database Systems, 1976.Google Scholar
  5. [Chri83]
    Christodoulakis, S., "Estimating Record Selectivities", Information Systems, Vol 8, 1983.Google Scholar
  6. [HP88]
    Hewlett-Packard Announcement of the HP RTDBS, Sept. 1988.Google Scholar
  7. [Klug81]
    A. Klug, "ABE — A Query Language for Constructing Aggregate-by-Example", 1st LBL Workshop on Statistical Database Management, Dec. 1981.Google Scholar
  8. [HoOT88a]
    W-C Hou, G. Ozsoyoglu, B. Taneja, "Statistical Estimators for Relational Algebra Expressions", ACM PODS conference, March 1988.Google Scholar
  9. [HoOT88b]
    W-C Hou, G. Ozsoyoglu, B. Taneja, "Processing Aggregate Queries with Hard Time Constraints", Proc., ACM SIGMOD Conference, May 1989.Google Scholar
  10. [HouO88]
    W-C Hou, G. Ozsoyoglu, "Statistical Estimators for Aggregate Relational Algebra Expressions", May 1988. (submitted for publication).Google Scholar
  11. [HRTS88]
    Tutorial, IEEE Hard Real-Time Systems, 1988.Google Scholar
  12. [Liu89]
    Y.M. Liu, "A Main-Memory Real-time Database Management System—Implementation and Experiments", M.S. Thesis, CWRU, July 24, 1989.Google Scholar
  13. [OlaO89]
    A. Ola, G. Ozsoyoglu, "A Family of Incomplete Relational Database Models", Proc., VLDB 89, Amsterdam, 1989.Google Scholar
  14. [OlaO88]
    A. Ola and G. Ozsoyoglu, "Geometric Modeling of Incomplete Relational Databases", Tech. Rep., CWRU, Dec. 1988.Google Scholar
  15. [OzMO89]
    G. Ozsoyoglu, V. Matos, Z.M. Ozsoyoglu, "Query Processing Techniques in the Summary-Table-by-Example Database Query Language", ACM TODS, Dec. 1989.Google Scholar
  16. [OzsM85]
    G. Ozsoyoglu, V. Matos, "On Optimizing Summary-Table-by-Example Query", ACM PODS conference, 1985.Google Scholar
  17. [OzsW89]
    G. Ozsoyoglu, H.Q. Wang, "A Relational Calculus with Set Operators, its Safety and Graphical Languages", IEEE Transactions on Software Engineering, September 1989.Google Scholar
  18. [Rowe85]
    Rowe, N. C., "Antisampling for Estimation: An overview", IEEE Trans. on Software Engineering, October 1985.Google Scholar
  19. [RTSS87]
    Procedings, IEEE Real-Time System Symposium, Dec 1987.Google Scholar
  20. [Shen89]
    J. Shen, "A Main-Memory Incomplete Information Database Management System—Implementation and Experiments", M.S. Thesis in progress, CWRU, 1989.Google Scholar
  21. [SnoA85]
    R. Snodgrass, I. Ahn, "A Taxonomy of Time in Databases", ACM SIGMOD Conf. 1985.Google Scholar
  22. [SSDB86]
    Panel on Scientific Databases, Third Int. Workshop on Statistical and SCientific Database Management, 1986.Google Scholar
  23. [Star87]
    R.J. Staron, "A Toolset to Develop Programmable Controller Systems", unpublished manuscript, Allen-Bradley Co., March 1987.Google Scholar
  24. [StZa88]
    J. Stankovic and W. Zhao "On Real-Time Transactions", ACM SIGMOD RECORD 1988.Google Scholar
  25. [TaAO89]
    A.U. Tansel, M.E. Arkun, G. Ozsoyoglu, "Time-by-Example Query Language", IEEE Trans. on Software Engineering, April 1989.Google Scholar
  26. [ToeF82]
    T.J. Teorey, J.P. Fry, "Design of Database Structures", Prentice-Hall, 1982.Google Scholar
  27. [Ullm88]
    J.D Ullman, "Principles of Database and Knowledge-Base Systems", Computer Science Press, 1988.Google Scholar
  28. [Zloo77]
    M.M. Zloof, "Query-by-Example: A Database Language", IBM System Journal, 1977.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1990

Authors and Affiliations

  • Gultekin Ozsoyoglu
    • 1
  • Wen-Chi Hou
    • 2
  • Ade Ola
    • 3
  1. 1.Department of Computer Engineering and ScienceCase Western Reserve University
  2. 2.Department of Computer ScienceUniversity of Southern Illinois at CarbondaleCarbondale
  3. 3.Department of Computer ScienceUniversity of DaytonDayton

Personalised recommendations