J.H. ter Bekke, Semantic data modeling

J.H. ter Bekke, Semantic data modeling Course: Database Design
Lectures 0/4/0/0, ECTS: 5
Lecturers: Dr. Ir. J.H. ter Bekke and Ir. J.A. Bakker

Contents:

Textbooks

Software

Teaching

Overview

Sheets

Papers

Textbooks:
J.H. ter Bekke,
Semantic Data Modeling (first edition),
Prentice Hall, Hemel Hempstead (1992),
ISBN 0 - 13 - 806050 - 9.
or:
J.H. ter Bekke,
Semantic Data Modeling (second print),
Faculty ITS, TU Delft (2001)

J.H. ter Bekke,
Database Ontwerp (derde druk),
Kluwer Bedrijfswetenschappen, Deventer (1993),
ISBN 90 - 267 -1864 - 0.
of:
J.H. ter Bekke,
Database Ontwerp (derde druk, tweede oplage),
Faculteit ITS, TU Delft (2001)

Top of Page

Software:

Manual Xplain DBMS versie 5.8 - info in Nederlands (index file in html-format)

Syntax of the Xplain data language - info in English (file in pdf-format, 27 KB)

Top of Page

Teaching in Year 2003 - 2004: International MSc students and TI students:
Second quarter, Tuesday and Thursday 13.30 - 15.30, Room FF (Zuidplantsoen 4).

Deeltijdopleiding informatica:
Derde kwartaal, Maandag, Zaal G (Mekelweg 4).

Top of Page

Overview:

The course introduces fundamental concepts and general principles of data modeling. Practical cases illustrate the theory where appropriate. Recent developments in the database area are included. The course is organized in four main parts:
Overview of the discipline, including an assessment of the relational theory. An overview of seven modern data modeling approaches is also presented in this part.
Fundamentals of data modeling, introducing semantic concepts leading to proper object modeling.
Data modeling, illustrated with numerous practical examples. Conversion into suitable traditional models (including relational), by applying just a few simple rules, makes the collection of data and query structures reliable and easier to understand.
Case studies. Semantic data modeling is illustrated with several cases. They illustrate data modeling in complex situations and the problem of formulating queries in practical environments.
Relational systems have become widely accepted the last few years. However, many pitfalls have also been discovered in the relational theory. The course presents an in-depth analysis of the problems and offers a deeper understanding. By putting emphasis on the semantic structure of a database, reliable solutions are created for both data modeling and data manipulation problems. The theory is based on both theoretical and practical research. It is illustrated with many examples and exercises.

Top of Page

Top of Page

Recent papers:

J.H. ter Bekke and J.A. Bakker, Modeling and Querying Recursive Data Structures I: Introduction Proceedings of the Seventh International Conference on Artificial Intelligence and Soft Computing, Banff , Canada (2003), pp. 278-282.

J.H. ter Bekke and J.A. Bakker, Modeling and Querying Recursive Data Structures II: A Semantic Approach Proceedings of the Seventh International Conference on Artificial Intelligence and Soft Computing, Banff, Canada (2003), pp. 283-289.

J.H. ter Bekke and J.A. Bakker, Fast recursive data processing in graphs using reduction, Proceedings of the 21st IASTED International Conference on Applied Informatics, Innsbruck, Austria (2003), pp. 490-494.

J.H. ter Bekke and J.A. Bakker, Recursive queries in product databases, Flexible Query Answering Systems, Proceedings 5th International Conference FQAS 2002, Copenhagen, Denmark, October 27-29, 2002, Lecture Notes in Computer Science (Subseries LNAI) Volume 2522, T. Andreasen, A. Motro, H. Christiansen, H. Legind Larsen (Eds.), Springer-Verlag, Berlin-Heidelberg (2002), pp. 44-55.

J.A. Bakker and J.H. ter Bekke, Supporting data completeness in active databases, Proceedings of the Sixth International Conference on Artificial Intelligence and Soft Computing, Bannf, Canada (2002), ed. H. Leung, pp. 113-117.

J.A. Bakker and J.H. ter Bekke, Efficient maintenance of derived information in active databases, Proceedings of the Sixth International Conference on Artificial Intelligence and Soft Computing, Bannf, Canada (2002), ed. H. Leung, pp. 118-122.

J.H. ter Bekke and J.A. Bakker, Content-driven specifications for recursive project planning applications, Proceedings of the International Conference on Applied Informatics (AI 2002), Innsbruck, Austria (2002), ed. M.H. Hamza, pp. 448 - 452.

J.J. Bouma and J.H. ter Bekke, Getting information from dispersed databases through hyperqueries, Proceedings of the International Conference on Applied Informatics (AI 2002), Innsbruck, Austria (2002), ed. M.H. Hamza, pp. 443 - 447.

J.H. ter Bekke and J.A. Bakker, Limitations of relationships constructed from coinciding data, Proceedings of the International Conference on Intelligent Systems and Control (ICSC 2001), Clearwater, Florida, ed. M.H. Hamza, pp. 247 - 252.

J.A. Bakker and J.H. ter Bekke, Maintaining derived information using dynamic rule ordering, Proceedings of the International Conference on Intelligent Systems and Control (ICSC 2001), Clearwater, Florida, ed. M.H. Hamza, pp. 253 - 260.

Bert Bakker and Johan ter Bekke, Foolproof query access to search engines, Proceedings of the Third International Conference on Information Integration and Web-based Applications & Services (IIWAS 2001), Linz, Austria (2001), eds. W. Winiwarter, St. Bressan, I.K. Ibrahim, pp. 389 - 394.

Berend de Boer and J.H. ter Bekke, Applying semantic database principles in a relational environment, Proceedings of the IASTED International Symposia Applied Informatics (AI2001), Innsbruck, Austria (2001), ed. M.H. Hanza, pp. 400 - 405.

J.H. ter Bekke, Semantic requirements for databases in casual environments; Proceedings SAICSIT '99, Johannesburg (1999).

J.H. ter Bekke, Advantages of a compact semantic meta model; Proceedings 2nd IEEE Metadata Conference, Silver Spring (1997).

J.H. ter Bekke, Comparative study of four data modeling approaches; Proceedings 2nd international EMMSAD workshop, Barcelona (1997), eds. K. Siau, Y. Wand and J. Parsons, B1-B12.

J.H. ter Bekke, Can we rely on SQL?, Proceedings 8th international DEXA workshop, Toulouse (1997) ed. R.R. Wagner, IEEE Computer Society, 378-383.

J.H. ter Bekke, Semantic modeling of successive events applied to version management; Proceedings International Symposium on Cooperative Database Systems for Advanced Applications (CODAS '96) Kyoto (1996), in: Cooperative Databases and Applications, eds. Yahiko Kambayashi and Kazumasa Yokota, World Scientific, Singapore (1997), 440-447.

J.H. ter Bekke, Meta modeling for end user computing; Proceedings Workshop on Data and Expert Systems Applications DEXA 1995, London (1995) eds. N. Revell and A Min Tjoa, pp. 267-273.

J.H. ter Bekke, Complex values in databases; Proceedings International Conference on Data and Knowledge Systems for Manufacturing and Engineering, Hong Kong (1994) ed. Nelson Chen, pp. 449-455.

Books:

J.H. ter Bekke, Database ontwerp (3e druk); Kluwer Bedrijfswetenschappen, Deventer (1993).

J.H. ter Bekke, Semantic data modeling; Prentice Hall, Hemel Hempstead (1992).

J.H. ter Bekke, Semantic data modeling in relational environments; Doctoral Dissertation, Technische Universiteit Delft, (1991).

Top of Page