Erki Eessaar

Associate Professor in Department of Software Science, Tallinn University of Technology
A member of the Business Information Technology Group.
Programme director of the microdegree "Andmebaasid" (Databases)
Read some more information about the degree (in Estonian)

Postal address: Department of Software Science, Akadeemia tee 15A, EE-12618 Tallinn, Estonia.
Room: ICT-626
Phone: +372 6 202 306
e-mail: Erki.Eessaar@taltech.ee

CV in the Estonian Science Information System
Researcher ID
ORCID
Google Scholar Profile
My database blog (in Estonian)
My YouTube channel about SQL and databases (mainly in Estonian)

---

Education		Teaching		Graduation Theses		Research	Publications
Awards		Software		Environment		Photography	Travels

---

Education

• Doctor of Philosophy in Engineering (in informatics; Tallinn University of Technology) since 2006. Title of the doctoral thesis: Relational and Object-Relational Database Management Systems as Platforms for Managing Software Engineering Artifacts (Relatsioonilised- ja objekt-relatsioonilised andmebaasisüsteemid kui tarkvaraarenduse tulemite haldamise platvorm) (Eessaar, E. Relational and Object-Relational Database Management Systems as Platforms for Managing Software Engineering Artifacts. Theses of Tallinn University of Technology. Tallinn : Tallinn University of Technology Press, 2006.)
• Master of Science in Engineering (in informatics; Tallinn University of Technology) since 2001. Title of the master thesis: Pattern Based Development of the System that Assists Usage of Patterns (Mustrite kasutamist abistava süsteemi mustritel põhinev projekteerimine)
• Bachelor of Science in Engineering (in informatics; Tallinn University of Technology) since 1999. Title of the bachelor thesis: Strategic Analysis of Information System for Managing Data About the Estonian Repressed Persons (Eesti Represseeritute Registri haldamise infosüsteemi strateegiline analüüs)

Back to the beginning

---

Courses that I Currently Teach in Tallinn University of Technology (TalTech)

• ITI0206 Databases I (in spring)
  • Homepage with general information (in Estonian)
  • Homepage with general information (in English)
  • Estonian homepage (partly password-protected)
    • Homepage in the spring of 2023 (guest access - username: SIS2 password: SIS2)
  • English homepage with all the materials (guest access has the password: ITI0206)
  • Concept maps about the covered topics (in Estonian)
  • Recorded lectures (spring 2023; in Estonian)
  • Timetable of classes of the current (or approaching) semester
  • A powerpoint presentation about some database topics (in English) about which I am passionate and try to reflect these in the courses
  • Introductory talk about databases (in Estonian) and the supplemential materials of the talk
• ITI0207 Databases II (in autumn)
  • Homepage with general information (in Estonian)
  • Estonian homepage (partly password-protected)
    • Homepage in the autumn of 2023 (guest access - username: SIS2 password: SIS2)
  • Concept maps about the covered topics (in Estonian)
  • Recorded lectures (autumn 2023; in Estonian)
  • Timetable of classes of the current (or approaching) semester

Previous Courses

• IDU0220 Databases I
• IDU0230 Databases II
• IDU3381 Database Design
• IDU0120 Programming of Databases
• IDU3382 Database Design - Project
• IDU3430 Database Systems
• IDU3530 Introduction to Information Systems

Animations about different database topics that my supervised bachelor students have created as a result of their thesis (the page and animations are in Estonian).

A page with a lot of database/information system development-related material (in Estonian) that I have created over the years. Username/password that is needed to log in are displayed on the entry page.
Essentially there is a full database design book in Estonian. Some sample chapters (in Estonian).

• The relational data model (+ some words about hierarchical and network data models that problems let the relational model shine)
• Object-oriented, NoSQL, and NewSQL Database Management Systems
• Some trends in data management and database technology

There are also materials in English. Here are some examples.

• The first overview of databases and database design topics (a PowerPoint file)
• The Basic Concepts of Databases
• The Relational Data Model
• Relational Algebra, Derived Relvars
• SQL
• Information System Development and the Place of Database Development in it
• How to Find the Main Entity Types?
• System Analysis Artifacts (business rules, state machine, use cases, conceptual data model, CRUD matrix, activity diagram, contracts of database operations)
• Checking and Improving the Results of Logical Database Design
• An Example of Creating a Logical Design Data Model From a Conceptual Data Model by Using Transformation Rules
• Typical Problems in SQL Statements and Comments Before the SQL Test
• Some SQL Differences Between MS Access and PostgreSQL
  • MS Access database Scott
  • PostgreSQL database Scott. You can test the PostgreSQL statements in DbFiddle.

Back to the beginning

---

Graduation Theses

• Some general thoughts about suitable topics of bacherol's and master's theses and how to approach these topics in your work (the page is in Estonian).
• Some possible topics of bacherol's and master's theses (the page is in Estonian).
• Some general thoughts about the presentation that has to be made during the defense of each thesis (the page is in Estonian).
• Theses that I have supervised (the page is in Estonian). In total I have successfully supervised 55 master theses, 159 bachelor theses, and 9 diploma works. Some of these are group works.
• My supervised bachelor's and master's theses that are in the digital library of Tallinn University of Technology (contains works starting from 2014; new theses are added with a delay that does not depend on me).
  • Some of the theses are in English.
• A collection of references to the writers of theses (the page is in Estonian).

Back to the beginning

---

Research Interests

Data models, including the relational data model and object-relational data model; database design and evolving databases; automation of the database design and evolutions process as well as checking of the database design; the use of database design theory outside the scope of databases (for instance, the theory of normalized systems); metamodeling systems; metadata management; metamodeling; model and pattern-driven development of information systems; software measures; domain-specific languages.

Research-administrative Experience

Member of Programme Committee

• ADBIS (East-European Conference on Advances in Databases and Information Systems) 2016-2018 conferences.
• ISD (Information Systems Development) 2008-2010, 2013-2014 conferences.

Session Chair

• Two sessions in ICEIS (International Conference on Enterprise Information Systems) 2006 conference.
• One session in ICEIS (International Conference on Enterprise Information Systems) 2008 conference.

Reviewer

• Two end reports of grants provided by The Estonian Research Fund (Sihtasutus Eesti Teadusfond) (in 2011, 2013).
• Two proposals of grants provided by The Estonian Research Fund (Sihtasutus Eesti Teadusfond) (in 2008).
• Manuscripts of the journal IEEE Access (one in 2017, two in 2018, one in 2019, two in 2021).
• A manuscript of the journal Frontiers in Pediatrics (in 2022).
• A manuscript of the journal Computer Standards & Interfaces (in 2016).
• A manuscript of the journal IEEE Transactions on Education (in 2014).
• A manuscript of the journal WSEAS Transactions on Computers (in 2008).
• Reviewer of papers that were submitted to CISSE (International Joint Conferences on Computer, Information, and Systems Sciences, and Engineering) 2007, 2008, 2009, 2013 conference.

Back to the beginning

---

Books

1. Eessaar, E. Andmebaaside projekteerimine. Tallinn: TTÜ kirjastus, (2008). [Lehekülg eesti keeles] [Page in English]

Reviewed Journal Publications (in reverse chronological order)

1. Eessaar, E. The Database Normalizaton Theory and the Theory of Normalized Systems: Finding a Common Ground. Baltic Journal of Modern Computing, ISSN 2255-8950 (Online), Vol. 4, No. 1, pp. 5-33 (2016)
2. Eessaar, E. On Applying Normalized Systems Theory to the Business Architectures of Information Systems. Baltic Journal of Modern Computing, ISSN 2255-8950 (Online), Vol. 2, No. 3, pp. 132-149 (2014)
3. Eessaar, E., Soobik, M. A Decision Support Method for Evaluating Database Designs. Computer Science and Information Systems, ISSN 1820-0214, Vol. 9, No. 1, January 2012, pp. 82-106 (2012)
4. Eessaar, E. On Specification and Evaluation of Object-Relational Data Models. WSEAS Transactions on Computer Research, ISSN 1991-8755, Vol. 2, Issue 2, February 2007, pp. 163 - 170 (2007)
5. Eessaar, E. SQL or Third Manifesto Compliant Object-Relational Database Management Systems as the Platforms for Maintainaning the Whole-Part Relationships in a Database. WSEAS Transacions on Computers, ISSN 1109-2750, Vol. 5, Issue 10, October 2006, pp. 2440-2447 (2006)
6. Eessaar, E. Guidelines about Usage of the Complex Data Types in a Database. WSEAS Transacions on Information Science and Applications, ISSN 1790-0832, Vol. 3, Issue 4, April 2006, pp. 712-719 (2006)

Reviewed Conference Publications (in reverse chronological order)

2023

1. Eessaar, E. On the Naming of Database Objects in the SQL Databases of Some Existing Software. In: Software Engineering Research in System Science, Vol 1: 12th Computer Science On-line Conference 2023 (CSOC 2023), April 26, - April 29, 2023. Silhavy, R., Silhavy, P. (eds). Switzerland: Springer International Publishing, ISBN: 978-3-031-35311-6, pp. 534-550. (Lecture Notes in Networks and Systems: 722) (2023) [SpringerLink].
   • The accompanying catalog of problem detection queries: https://github.com/erki77/database-design-queries (Collection: Find problems about names).

   2022

2. Eessaar, E. On the Design of Base Tables in the SQL Databases of Some Existing Software. In: Software Engineering Perspectives in Systems, Vol 1: 11th Computer Science On-line Conference 2022 (CSOC 2022), April 26, - April 30, 2022. Ed. Silhavy, R. Switzerland: Springer International Publishing, ISBN: 978-3-031-09069-1, pp. 309-324. (Lecture Notes in Networks and Systems: 501) (2022) [SpringerLink].
   • The accompanying catalog of problem detection queries: https://github.com/erki77/database-design-queries (Collection: Find problems about base tables).

   2021

3. Eessaar, E. The Usage of Declarative Integrity Constraints in the SQL Databases of Some Existing Software. In: Software Engineering and Algorithms, Vol 1: 10th Computer Science On-line Conference 2021 (CSOC 2021), April 29, - May 2, 2021. Ed. Silhavy, R. Switzerland: Springer International Publishing, ISBN: 978-3-030-77441-7, pp. 375-390. (Lecture Notes in Networks and Systems: 230) (2021) [SpringerLink].
   • The accompanying catalog of problem detection queries: https://github.com/erki77/database-design-queries (Collection: Find problems about integrity constraints).

   2020

4. Eessaar, E. Automating Detection of Occurrences of PostgreSQL Database Design Problems. In: Databases and Information Systems: 14th International Baltic Conference 2020 (DB&IS 2020), Tallinn, Estonia, June 16–19, 2020. Eds. Robal, T., Haav, H.-M., Penjam, J., Matulevièius, R. Switzerland: Springer International Publishing, ISBN: 978-3-030-57671-4, pp. 176–189. (Communications in Computer and Information Science; 1243) (2020) [SpringerLink].
   • The accompanying catalog of problem detection queries: https://github.com/erki77/database-design-queries.
   • Video of the presentation.

   2018

5. Eessaar, E., Käosaar, E. On Finding Model Smells Based on Code Smells. In: Software Engineering and Algorithms in Intelligent Systems, Vol 1: 7th Computer Science On-line Conference 2018 (CSOC2018), April 25-28, 2018. Ed. Silhavy, R. Switzerland: Springer International Publishing, ISBN: 978-3-319-91185-4, pp. 269-281. (Advances in Intelligent Systems and Computing; 763) (2018) [SpringerLink].
   • The accompanying catalog of model smells: https://github.com/erki77/model-smells.

   2016

6. Eessaar, E. A Data-Centric Algorithm for Identifying Use Cases. In: Software Engineering Perspectives and Application in Intelligent Systems, Vol. 2: 5th Computer Science On-line Conference 2016 (CSOC2016), April 27 - 30, 2016. Eds. Silhavy, R., Senkerik, R., Oplatkova, Z.K., Silhavy, P., Prokopova, Z. Switzerland: Springer Verlag, ISBN: 978-3-319-33620-6, pp. 303-316. (Advances in Intelligent Systems and Computing; 465) (2016) [SpringerLink].
7. Eessaar, E. Searching Orthogonality Problems in Software Languages in the Example of a Data Model. International Conference on Systems, Computing Sciences and Software Engineering (SCSS 14). Springer.

   2015

8. Eessaar, E., Voronova, J. Using SQL Queries to Evaluate the Design of SQL Databases. In: New Trends in Networking, Computing, E-learning, Systems Sciences, and Engineering, Lecture Notes in Electrical Engineering, Vol. 312: International Conference on Systems, Computing Sciences and Software Engineering (SCSS 13). Eds. Elleithy, K., Sobh, T. Springer, ISBN: 978-3-319-06763-6, pp. 179-186 (2015) [SpringerLink]
9. Eessaar, E. On Query-based Search of Possible Design Flaws of SQL Databases. In: Innovations and Advances in Computer, Information, Systems Sciences, and Engineering, Lecture Notes in Electrical Engineering, Vol. 313: International Conference on Systems, Computing Sciences and Software Engineering (SCSS 12). Eds. Sobh, T., Elleithy, K. Springer, ISBN: 978-3-319-06772-8, pp. 53-60 (2015) [SpringerLink]

   2014

10. Eessaar, E. A Set of Practices for the Development of Data-Centric Information Systems. In: Information System Development. Improving Enterprise Communication.: 22nd International Conference on Information Systems Development (ISD2013), Seville, Spain, September 2-4, 2013. Eds. José Escalona, M.; Aragón, G.; Linger, H.; Lang, M.; Barry, C.; Schneider, C. Switzerland: Springer. ISBN 978-3-319-07214-2, pp. 73-84 (2014) [SpringerLink]
11. Eessaar, E. Specifying Business Architecture as a Step Towards Achieving Normalized Systems. In: Databases and Information Systems: 11th International Baltic Conference on DB and IS, June 8-11, 2014, Tallinn, Estonia. Eds. H.-M. Haav, A. Kalja, T. Robal Tallinn: Tallinn University of Technology Press. ISBN 978-9949-23-632-9, pp. 425-432 (2014)

    2013

12. Eessaar, E., Sgirka, R. An Ontological Analysis of Metamodeling Languages. In: Information Systems Development Reflections, Challenges and New Directions: 20th International Conference on Information Systems Development (ISD2011) Edinburgh, Scotland, August 24-26, 2011. Eds. R, Pooley, J. Coady, C. Schneider, H. Linger, C. Barry, M. Lang. Springer New York. ISBN 978-1-4614-4950-8, pp. 381-392 (2013) [SpringerLink]
13. Eessaar, E., Saal, E. Evaluation of Different Designs to Represent Missing Information in SQL Databases. In: Innovations and Advances in Computer, Information, Systems Sciences, and Engineering, Lecture Notes in Electrical Engineering, Vol.152: International Conference on Systems, Computing Sciences and Software Engineering (SCSS 11). Eds. K. Elleithy, T. Sobh. Springer. ISBN: 978-1-4614-3534-1, pp. 173-187 (2013) [SpringerLink]

    2012

14. Eessaar, E., Aaberg, E. Extending UML Profiles to Model Integrity Constraints in SQL Databases. In: Information Modelling and Knowledge Bases XXIII: 21st European Japanese Conference on Information Modelling and Knowledge Bases June 4-8, 2011 Tallinn, Estonia. Eds. Henno, J.; Kiyoki, Y.; Tokuda, T.; Jaakkola, H.; Yoshida, N.. Amsterdam: IOS Press, (Frontiers in Artificial Intelligence and Applications), ISBN: 978-1-60750-991-2, pp. 39 - 58 (2012) [IOS Press]
15. Eessaar, E. On Using a Semiotic Quality Framework to Evaluate the Quality of Conceptual Database Schemas. In: Emerging Trends in Computing, Informatics, Systems Sciences, and Engineering, Lecture Notes in Electrical Engineering, Vol. 151: International Conference on Systems, Computing Sciences and Software Engineering (SCSS 10). Eds. T. Sobh, K. Elleithy. Springer. ISBN 978-1-4614-3557-0, pp. 103-115 (2013) [SpringerLink]
16. Sgirka, R., Eessaar, E. A Quality Model of Metamodeling Systems. In: Emerging Trends in Computing, Informatics, Systems Sciences, and Engineering, Lecture Notes in Electrical Engineering, Vol. 151: International Conference on Systems, Computing Sciences and Software Engineering (SCSS 10). Eds. T. Sobh, K. Elleithy. Springer. ISBN 978-1-4614-3557-0, pp. 543-555 (2013) [SpringerLink]

    2011

17. Eessaar, E., Aaberg, E. Extending UML Profiles to Model Integrity Constraints in SQL Databases. Proceedings of the 21th European-Japanese Conference on Information Modelling and Knowledge Bases. Tallinn, Estonia, June 06 - 10, 2011. Vol. 1. Eds. J. Henno, Y. Kiyoki, T. Tokuda, N. Yoshida. Tallinn University of Technology. pp. 47-65 (2011)

    2010

18. Eessaar, E. A UML Profile for Developing Databases that Conform to The Third Manifesto. In: Innovations in Computing Sciences and Software Engineering: International Conference on Systems, Computing Sciences and Software Engineering (SCSS 09). Eds. T. Sobh, K. Elleithy. Springer Netherlands. ISBN: 978-90-481-9111-6, pp. 69-74 (2010) [SpringerLink]
19. Eessaar, E., Sgirka, R. A SQL Database Based Meta-CASE System and its Query Subsystem. In: Innovations in Computing Sciences and Software Engineering: International Conference on Systems, Computing Sciences and Software Engineering (SCSS 09). Eds. T. Sobh, K. Elleithy. Springer Netherlands. ISBN: 978-90-481-9111-6, pp. 57-62 (2010) [SpringerLink]
20. Zub, D., Eessaar, E. Selecting Patterns for the Evaluation of Systems. In: Technological Developments in Networking, Education and Automation: International Conference on Engineering Education, Instructional Technology, Assessment, and E-learning (EIAE 09). Eds. K.Elleithy, T. Sobh, M. Iskander, V. Kapila, M.A. Karim, A. Mahmood. Springer Netherlands. ISBN: 978-90-481-9150-5, pp 77-82 (2010) [SpringerLink]
21. Eessaar, E., Sgirka, R. A Database-Based and Web-Based Meta-CASE System. In: Advanced Techniques in Computing Sciences and Software Engineering: International Conference on Systems, Computing Sciences and Software Engineering (SCSS 08). Ed. K. Elleithy. Springer Netherlands. ISBN: 978-90-481-3659-9, pp. 379-384 (2010) [SpringerLink]
22. Zub, D., Eessaar, E. Pattern-Based Usability Analysis: Comparison with a Case-Study. In: Technological Developments in Education and Automation: International Conference on Engineering Education, Instructional Technology, Assessment, and E-learning (EIAE 08). Eds. M. Iskander, K. Vikram, A. Mohammad. Springer Netherlands. ISBN: 978-90-481-3655-1, pp. 225-230 (2010) [SpringerLink]

    2009

23. Eessaar, E. A Semiotic Approach to Quality in Specifications of Software Measures. In: Enterprise Information Systems: 10th International Conference, ICEIS 2008, Barcelona, Spain, June 12-16, 2008, Revised Selected Papers. Eds. Filipe, J., Cordeiro, J. Lecture Notes in Business Information Processing. Volume 19. Springer Berlin Heidelberg. ISBN 978-3-642-00669-2, pp. 73-86 (2009) [SpringerLink]
24. Eessaar, E., Soobik, M. A Comparison of the Universal and the Regular Database Design. In: Databases and Information Systems V: Selected Papers from the Eighth International Baltic Conference, DB&IS 2008. Eds. H.-M. Haav, A. Kalja. Volume 187. IOS Press, (Frontiers in Artificial Intelligence and Applications). ISBN 978-1-58603-939-4, pp. 289-300 (2009) [IOS Press]

    2008

25. Eessaar, E. On Finding Suitable Designs for Whole-Part Relationships in Object-Relational Databases. In: Information Systems Development: Challenges in Practice, Theory, and Education Volume 2: 16th International Conference on Information Systems Development (ISD2007) Galway, Ireland August 29-31, 2007. Eds. C. Barry, K. Conboy, M. Lang, G. Wojtkowski, S. Wojtkowski. Springer US. ISBN 978-0-387-78578-3, pp. 351-362 (2008) [SpringerLink]
26. Zub, D., Eessaar, E. Pattern-Based Usability Evaluation of E-Learning Systems. In: Innovative Techniques in Instruction Technology, E-learning, E-assessment, and Education: International Conference on Engineering Education, Instructional Technology, Assessment, and E-learning (EIAE 07). Ed. I. Magued. Springer Netherlands. ISBN: 978-1-4020-8738-7, pp. 117-122 (2008) [SpringerLink]
27. Eessaar, E. On Translation-Based Design of UML Profiles. In: Innovative Techniques in Instruction Technology, E-learning, E-assessment, and Education: International Conference on Systems, Computing Sciences and Software Engineering, (SCS2 07). Ed. I. Magued. Springer Netherlands. ISBN: 978-1-4020-8738-7, pp. 144-149 (2008) [SpringerLink]
28. Eessaar, E. On Metamodel-Based Design of Software Metrics. In: Balancing Agility and Formalism in Software Engineering: 2nd IFIP Central and East European Conference on Software Engineering Techniques CEE-SET 2007 Poland, Poznan October 10-12, 2007. Eds. M. Bertrand, J.R. Nawrocki, W. Bartosz. Springer Berlin / Heidelberg. (LNCS) Vol. 5082/2008. ISBN 978-3-540-85278-0, pp. 40-54 (2008) [SpringerLink]
29. Eessaar, E. On Pattern-Based Database Design and Implementation. In: Proceedings of 6th International Conference on Software Engineering Research, Management & Applications (SERA 2008): 20-22 August 2008 Charles University, Prague, Czech Republic. Eds. W. Dosch, R. Lee, P. Tuma, T. Coupaye. Los Alamitos, California: IEEE Computer Society. ISBN 978-0-7695-3302-5, pp. 235 - 242 (2008) [IEEE Xplore]
30. Eessaar, E. Towards a Semiotic Quality Framework of Software Measures. In: Proceedings of the 10th International Conference on Enterprise Information Systems, Barcelona, Spain June 12 – 16, 2008 / Eds. J. Cordeiro, J. Filipe. ISBN: 978-989-8111-48-7. Volume DISI. pp. 41-48 (2008) [Conference homepage]
31. Eessaar, E., Soobik, M. On Universal Database Design. In: Proceedings of the 8th International Baltic Conference on Databases and Information Systems June 2-5, 2008, Tallinn, Estonia. Eds. H.-M. Haav, A. Kalja: Tallinn University of Technology Press. ISBN 978-9985-59-789-7, pp. 349-360 (2008) [Conference homepage] The article is indexed by ISI Proceedings.

    2007

32. Eessaar, E. Preserving Semantics of the Whole-Part Relationships in the Object-Relational Databases. In: Advances in Information Systems Development, New Methods and Practice for the Networked Society: 15th International Conference on Information Systems Development (ISD 2006), August 31 - September 2, 2006, Budapest, Hungary / Eds. W. Wojtkowski, W. G. Wojtkowski, J. Zupancic, G. Magyar, G. Knapp. Springer US. ISBN 978-0-387-70801-0, pp.1-11 (2007) [SpringerLink]
33. Eessaar, E. Metamodel-based Comparison of Data Models. In: Advances and Innovations in Systems, Computing Sciences and Software Engineering: International Conference on Systems, Computing Sciences and Software Engineering (SCSS 06) / Eds.K. Elleithy: Springer Netherlands. ISBN 978-1-4020-6263-6, pp. 109-114 (2007) [SpringerLink]
34. Eessaar, E. Using Metamodeling in order to Evaluate Data Models. In: Proceedings of the 6th WSEAS International Conference on Artificial Intelligence, Knowledge Engineering and Data Bases, Corfu Island, Greece, February 16-19, 2007 / Eds. C. A. Long, V. M. Mladenov, Z. Bojkovic, ISBN 9789608457591, ISSN 1790-5117, pp. 181 - 186 (2007)

    2006

35. Eessaar, E. Integrated System Analysis Environment for the Continuous Consistency and Completeness Checking. In:Knowledge-Based Software Engineering: 7th Joint Conference on Knowledge-Based Software Engineering: Joint Conference on Knowledge-Based Software Engineering 2006, Tallinn, Estonia, August 28-31, 2006 / Eds. E. Tyugu, T. Yamaguchi. Netherlands: IOS Press, (Frontiers in Artificial Intelligence and Applications). ISBN I-58603-640-8, ISSN 0922-6389, pp. 96 - 105 (2006) [IOS Press]
36. Eessaar, E. Whole-Part Relationships in the Object-Relational Databases. In: Proceedings of the 10th WSEAS International Conference on COMPUTERS, Vouliagmeni, Athens, Greece, July 10-15, 2006 / Eds. Z. S. Bojkovic. ISSN 1790-5117, ISBN 960-8457-47-5, pp. 1263-1268 (2006)
37. Eessaar, E. Using Relational Databases in the Engineering Repository Systems. In: Proceedings of the 8th International Conference on Enterprise Information Systems, Paphos, Cyprus, May 23 -27, 2006, Databases and Information Systems Integration / Eds. Y. Manolopoulos, J. Filipe, J Constantopoulos, J. Cordeiro. ISBN 972-8865-41-4, pp.30 - 37 (2006) [abstract] [Conference homepage]
38. Eessaar, E. Extended Principle of Orthogonal Database Design. In: Proceedings of the 5th WSEAS International Conference on Artificial Intelligence, Knowledge Engineering and Data Bases, Madrid, Spain, February 15-17, 2006 / Eds. P. L. L. Espi, J. M. Giron-Sierra, A. S. Drigas. ISBN 960-8457-41-6, pp. 360-365 (2006)

    2005

39. Eessaar, E. Architecture of Pattern Management Software System. In: Proceedings of the 9th East-European Conference, ADBIS 2005 Tallinn, September 12-15, 2005 / Eds. J. Eder, H.-M. Haav, A. Kalja, J. Penjam. Institute of Cybernetics at Tallinn University of Technology. ISBN 9985-59-545-9, pp. 189-207 (2005)
40. Eessaar, E. Truly Relational Databases as a Platform for the Artifact Management. In: Proceedings of the 14th International Conference on Information Systems Development: Pre-Conference 14-17 August 2005, Karlstad, Sweden / Eds. A. G. Nilsson, R. Gustas, W. Wojtkowski, W. G. Wojtkowski, S. Wrycza and J. Zupanèiè. ISSN 1403-8099, ISBN 91-85335-72-X, pp. 207-218 (2005)

    2004

41. Eessaar, E. Methods for Searching Patterns from the Database of Patterns. In: The 16th Conference on Advanced Information Systems Engineering Forum Proceedings, Riga, Latvia, June 7-11, 2004 / Eds. J. Grabis, A. Persson, J. Stirna. ISBN 9984-9767-0-X, pp. 103 – 111 (2004)
42. Eessaar, E. Towards Pattern Management System. In: Proceedings of the 6th International Conference on Enterprise Information Systems, Porto, Portugal, April 14 – 17, 2004, Vol. 3 / Eds. I. Seruca, J. Filipe, S. Hammoudi, J. Cordeiro. ISBN 972-8865-00-7, pp. 655 - 658 (2004) [Conference homepage]

    2002

43. Eessaar, E. Patterns as Reusable Fragments of Knowledge. In: Proceedings of the 5th International Baltic Conference, BalticDB&IS 2002, Tallinn, June 3-6, 2002, Vol.2 / Eds. H.-M. Haav, A. Kalja. Institute of Cybernetics at Tallinn Technical University. ISBN 9985-894-40-5, pp. 243 – 248 (2002)

Other Publications (in reverse chronological order)

1. Eessaar, E. Using The Third Manifesto Compliant DBMS in the Repository Systems. Info- ja kommunikatsioonitehnoloogia doktorikooli IKTDK esimese aastakonverentsi artiklite kogumik, 12. - 13. mai 2006 Jäneda Mõis, ISBN 9985-59-642-2, pp. 85-88 (2006)
2. Eessaar, E. Holistlik süsteemiarendus süsteemimaatriksi abil (Holistic system development by using system matrices), A&A, Vol. 2, 2005, pp.21-39 (in Estonian)
3. Eessaar, E. Mustrid ja nende kasutamist abistavad tarkvarasüsteemid (Patterns and software systems that assist their usage), A&A, Vol. 6, 2003, pp.17-32 (in Estonian)
4. Eessaar, E. Mustrite kasutamine infosüsteemide arendamiseks (Usage of patterns in order to develope informational systems), A&A, Vol. 3, 2002, pp.28-38 (in Estonian)
5. Eessaar, E. Veebirakenduste disaini modelleerimine UML-i abil (Modeling of design of web-applications by using UML), A&A, Vol. 4, 2000, pp.25-35 (in Estonian)
6. Eessaar, E. Veebirakenduste loomine - traditsioonilise tarkvaraarenduse ja loomingulise disaini ühendamine (Development of web-applications - unification of traditional software design methods with the creative design), A&A, Vol. 3, 2000, pp.27-37 (in Estonian)
7. Eessaar, E. Tarkvara omaduste parandamine kasutatavuse testimise kaudu (Improving quality of software by using usability testing), A&A, Vol. 2, 1999, pp.26-31 (in Estonian)

Co-authors (in Alphabetical Order)

• Erko Aaberg
• Ege Käosaar
• Elari Saal
• Rünno Sgirka
• Marek Soobik
• Dmitry Zub
• Janina Voronova

References to Publications

• DBLP
• Google Scholar
• SpringerLink
• Research Gate
• E-Catalogue of Estonian libraries (ESTER)

Back to the beginning

---

Awards

• I received an Honorable Mention "Lecturer of the Year 2009/2010" from the Tallinn University of Technology Student Union.
• I was named TUT lecturer of the year 2016 in the School of Information Technologies.

Back to the beginning

---

Environment

• My research about ozone layer (from 1995) (in Estonian)

Back to the beginning