USING RELATIONAL DATABASES IN THE ENGINEERING REPOSITORY SYSTEMS

Erki Eessaar

2006

Abstract

Repository system can be built on top of the database management system (DBMS). DBMSs that use relational data model are usually not considered powerful enough for this purpose. In this paper, we analyze these claims and conclude that they are caused by the shortages of SQL standard and inadequate implementations of the relational model in the current DBMSs. Problems that are presented in the paper make usage of the DBMSs in the repository systems more difficult. This paper also explains that relational system that follows the rules of the Third Manifesto is suitable for creating repository system and presents possible design alternatives.

References

  1. Allsop, D. J., Harrison A., & Sheppard, C. (2002). A database architecture for reusable Common KADS agent specification components [Electronic version]. Knowledge-Based Systems, Vol. 15, No. 5, 275-283.
  2. Bernstein, P. A. (1998). Repositories and Object-Oriented Databases [Electronic version]. SIGMOD Rec. Vol. 27, Issue 1, Mar. 1998), 88-96.
  3. Bernstein, P. A., (2003). Applying Model Management to Classical Meta Data Problems [Electronic version]. In Proceedings of the Conference on Innovative Data Systems Research 2003, 209-220.
  4. Ceri, S., Cochrane, R., & Widom, J. (2000). Practical Applications of Triggers and Constraints: Success and Lingering Issues [Electronic version]. In Proceedings of the 26th international Conference on Very Large Data Bases, 254-262.
  5. Chen, Y.F., Nishimoto, M. Z., & Ramamoorthy, C. V. (1990). The C Information Abstraction System [Electronic version]. IEEE Transactions on Software Engineering, Vol.16, No. 3, March 1990, 325-334.
  6. Cochrane, R. J., Pirahesh, H., & Mattos, N. M. (1996). Integrating triggers and declarative constraints in SQL database sytems [Electronic version]. In Proceedings of the 22th international Conference on Very Large Data Bases, 567-578.
  7. Codd, E. F. (1970). A relational model of large shared data banks [Electronic version]. Comm. ACM, Vol. 13, No. 6, 377-387.
  8. Constantopoulos, P., Jarke, M., Mylopoulos, J., & Vassiliou, Y. (1995). The Software Information Base: A Server for Reuse [Electronic version]. VLDB Journal, 4 (1995), Boxwood Press, Pacific Grove, CA, 1- 43.
  9. Date, C. J., & Darwen, H. (2000). Foundation for Future Database Systems: The Third Manifesto, AddisonWesley. Reading, Massachusetts, 2nd edition.
  10. Date, C. J. (2003). An Introduction to Database Systems, Pearson/Addison Wesley. Boston, 8th edition.
  11. Date, C. J. (2005) Database in depth : relational theory for practitioners, O'Reilly. Beijing; Cambridge.
  12. Date, C. J., & Darwen, H., & Lorentzos, N. A. (2003). Temporal Data and the Relational Model, Morgan Kaufmann. San Diego, CA.
  13. Dittrich, K., Tombros, D., & Geppert, A. (2000). Databases in Software Engineering: a roadmap [Electronic version]. In Proceedings of the Conference on the Future of Software Engineering. ICSE 7800. ACM Press, New York, NY, 293-302.
  14. Eessaar, E. (2005). Truly Relational Databases as a Platform for the Artifact Management. In Proceedings of the Fourteenth International Conference on Information Systems Development: Pre-Conference 14-17 August 2005, Karlstad, Sweden, 207-218.
  15. Emmerich, W., Schäfer, W., & Welsh, J. (1992). Suitable Databases for Process-centred Environments Do not yet Exist [Electronic version]. In Proceedings of the EWSPT 7892, 94-98.
  16. Engle, P. (2003). Data Modeling - Left and Right. The Data Administration Newsletter, Issue 24, April 2003. Retrieved October 07, 2005, from http://www.tdan.com/i024hy03.htm#_edn15
  17. Gray, P. (1997). CASE tool construction for a parallel software development methodology [Electronic version]. Information and Software Technology, Vol. 39, Issue 4, 235-252.
  18. Greenfield, J., & Short, K. (2004). Software Factories: Assembling Applications with Patterns, Models, Frameworks, and Tools, John Wiley & Sons. Indianapolis.
  19. Gulutzan, P., & Pelzer, T. (1999). SQL-99 Complete, Really, Miller Freeman. Lawrence.
  20. Hardwick, M. (1984). Extending the relational database data model for design applications [Electronic version]. In Proceedings of the 21st Conference on Design Automation. IEEE Press, Piscataway, NJ, 110- 116.
  21. Hardwick, M., & Spooner, D. L. (1989). The ROSE data manager: Using object technology to support interactive engineering applications [Electronic version]. IEEE Transactions on Knowledge and Data Engineering. Vol. 1, no. 2, 285-290.
  22. Haynie, M. N. (1981). The relational/network Hybrid data model for Design Automation Databases [Electronic version]. In Proceedings of the 18th Conference on Design Automation. IEEE Press, Piscataway, NJ, 646- 652.
  23. Katz, R.H. (1990). Toward a Unified Framework for Version Modeling in Engineering Databases [Electronic version]. ACM Computing Surveys 22:4, 1990, 375- 408.
  24. Lange., C., Sneed, H. M., & Winter, A. (2001). Comparing Graph-based Program Comprehension Tools to Relational Database-based Tools [Electronic version]. In Proceedings of the 9th International Workshop on Program Comprehension. IEEE Computer Society. Los Alamitos. 209--218.
  25. Linton, M. (1984). Implementing relational views of programs [Electronic version]. In Proceedings of ACM SIGSOFT/SIGPLAN Software Engineering Symposium on Practical Software Development Environments, 132-140.
  26. Liu, C., Li, H., & Orlowska, M. E. (1996). ObjectOriented Design of Repository for Enterprise Workflows. Retrieved October 5, 2005 from University of Queensland, DSTC Web site http://www.dstc.uq.edu.au/Research /Distributed_Databases/papers/Liu-OOD-1996.ps
  27. Lloyd, J. (1994) Practical Advantages of Declarative Programming [Electronic version]. Invited Lecture, GULP-PRODE 7894.
  28. Mahnke, W., & Ritter, N. (2002). The ORDB-based SFB501-Reuse-Repository [Electronic version]. In Proceedings of the 8th International Conference on Extending Database Technology, 745-748.
  29. Marder, U., Ritter, N., & Steiert, H. P. (1999). A DBMSbased Approach for Automatic Checking of OCL Constraints [Electronic version]. In OOPSLA'99- Workshop "Rigourous Modeling and Analysis with the UML: Challenges and Limitations", Denver, Co.
  30. Mattos, N., & DeMichiel, L. G., (1994). Recent design trade-offs in SQL3 [Electronic version]. SIGMOD Rec. 23, 4 (Dec. 1994), 84-90.
  31. Melton, J., ISO/IEC 9075-2:2003 (E) Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation). August, 2003. Retrieved December 26, 2004, from http://www.wiscorp.com/SQLStandards.html
  32. Miguel, L., Kim, M. H., & Ramaroothy, C. V. (1990). A Knowledge and Data Base for Software Systems [Electronic version]. In Proceedings of the 2nd International IEEE Conference on Tools for Artificial Intelligence, 417-423.
  33. Oracle® Database SQL Reference 10g Release 1 (10.1) Part Number B10759-01. Oracle Corp., Retrieved October 4, 2005, from http://downloadwest.oracle.com/docs/cd/B14117_01/server.101/ b10759/toc.htm
  34. Pascal, F. (2000). Practical issues in Database Management. A Reference for the Thinking Practioner, Addison-Wesley. Boston, Mass, 1st edition.
  35. PostgreSQL 8.0.3 Documentation. Retrieved October 4, 2005, from http://www.postgresql.org/docs/8.0/ interactive/index.html
  36. Serrano, J. A. (1999). Formal Specifications of Software Design Methods [Electronic version]. 3rd Irish Workshop on Formal Methods.
  37. Taylor, R.N., Belz, F.C., Clarke, L.A., Osterweil, L., Selby, R. W., Wileden, J. C., Wolf, A. L., & Young, M. (1988). Foundations for the Arcadia environment architecture [Electronic version]. In Proceedings of the Third ACM SIGSOFT/SIGPLAN Software Engineering Symposium on Practical Software Development Environments. SDE 3. ACM Press, New York, NY, 1-13.
  38. Türker, C., & Gertz, M. (2001) Semantic integrity support in SQL:1999 and commercial (object-) relational database management systems [Electronic version]. The VLDB Journal, Vol. 10, No. 4 (Dec. 2001), 241- 269.
  39. Voorish, D. (2005). An Implementation of Date and Darwen's "TutorialD". Retrieved March 26, 2005 from http://dbappbuilder.sourceforge.net/Rel.html
  40. Zhang, N., Ritter, N., & Härder, T. (2001). Enriched Relationship Processing in Object-Relational Database Management Systems [Electronic version]. In Proceedings of the 3rd International Symposium on Cooperative Database Systems for Advanced Applications, 53-62.
  41. Zimbrão, G., Miranda, R., Souza, J.M., Estolano, M.H., & Neto, F.P. (2003). Enforcement of Business Rules in Relational Databases Using Constraints [Electronic version]. SBBD 2003, 129-141.
Download


Paper Citation


in Harvard Style

Eessaar E. (2006). USING RELATIONAL DATABASES IN THE ENGINEERING REPOSITORY SYSTEMS . In Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-972-8865-41-2, pages 30-37. DOI: 10.5220/0002455800300037


in Bibtex Style

@conference{iceis06,
author={Erki Eessaar},
title={USING RELATIONAL DATABASES IN THE ENGINEERING REPOSITORY SYSTEMS},
booktitle={Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2006},
pages={30-37},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002455800300037},
isbn={978-972-8865-41-2},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - USING RELATIONAL DATABASES IN THE ENGINEERING REPOSITORY SYSTEMS
SN - 978-972-8865-41-2
AU - Eessaar E.
PY - 2006
SP - 30
EP - 37
DO - 10.5220/0002455800300037