Erki Eessaar

Associate Professor in Department of Software Science (old page), Tallinn University of Technology
A member of the TalTech Information Systems Group.
Postal address: Department of Software Science, Akadeemia tee 15A, EE-12618 Tallinn, Estonia.
Room: ICT-626
Phone: +372 6202306
e-mail: Erki.Eessaar@taltech.ee
CV in the Estonian Science Information System
Researcher ID
ORCID


Education Teaching Graduation Theses Research Publications
Awards Software Photography Environment


Education

Back to the beginning


Courses that I currently teach in Tallinn University of Technology (TalTech)

Previous courses

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.

Back to the beginning


Graduation Theses

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

Session Chair

Reviewer

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)

    2020

  1. 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].

    2018

  2. 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].

    2016

  3. 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].
  4. 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

  5. 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]
  6. 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

  7. 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]
  8. 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

  9. 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]
  10. 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

  11. 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]
  12. 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]
  13. 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

  14. 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

  15. 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]
  16. 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]
  17. 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]
  18. 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]
  19. 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

  20. 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]
  21. 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

  22. 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]
  23. 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]
  24. 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]
  25. 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]
  26. 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]
  27. 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]
  28. 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

  29. 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]
  30. 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]
  31. 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

  32. 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]
  33. 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)
  34. 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]
  35. 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

  36. 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)
  37. 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

  38. 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)
  39. 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

  40. 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)

References to Publications

Back to the beginning


Awards

Back to the beginning


Photography

Photos are a great way to capture moments that one thinks are worth of preserving. Making and organizing photos are a way to live these monents through more than once and keep these in memory. Some photos may turn into historic documents after a while.

Back to the beginning


Environment

Back to the beginning