Personal information

databases, database design, metamodeling, design patterns, automating design
Estonia

Activities

Employment (1)

Tallinn University of Technology: Tallinn, EE

2007-09-01 to present | Associate Professor (Department of Software Science)
Employment
Source: Self-asserted source
Erki Eessaar

Education and qualifications (1)

Tallinn University of Technology: Tallinn, EE

2001-09-01 to 2006-12-18 | Doctor of Philosophy in Engineering (Informatics) (Department of Informatics)
Education
Source: Self-asserted source
Erki Eessaar

Works (42)

On the Naming of Database Objects in the SQL Databases of Some Existing Software

2023 | Book chapter
Contributors: Erki Eessaar
Source: check_circle
Crossref

On the Design of Base Tables in the SQL Databases of Some Existing Software

2022 | Book chapter
Contributors: Erki Eessaar
Source: check_circle
Crossref

The Usage of Declarative Integrity Constraints in the SQL Databases of Some Existing Software

2021 | Book chapter
Contributors: Erki Eessaar
Source: check_circle
Crossref

Automating Detection of Occurrences of PostgreSQL Database Design Problems

2020 | Book chapter
Contributors: Erki Eessaar
Source: check_circle
Crossref

On Finding Model Smells Based on Code Smells

2019 | Book chapter
Contributors: Erki Eessaar; Ege Käosaar
Source: check_circle
Crossref

A data-centric algorithm for identifying use cases

Advances in Intelligent Systems and Computing
2016 | Book
EID:

2-s2.0-84964700313

Contributors: Eessaar, E.
Source: Self-asserted source
Erki Eessaar via Scopus - Elsevier

On Query-Based Search Of Possible Design Flaws Of SQL Databases

Lecture Notes in Electrical Engineering
2015 | Book
EID:

2-s2.0-84921881697

Contributors: Eessaar, E.
Source: Self-asserted source
Erki Eessaar via Scopus - Elsevier

Using SQL queries to evaluate the design of SQL databases

Lecture Notes in Electrical Engineering
2015 | Book
EID:

2-s2.0-84919346410

Contributors: Eessaar, E.; Voronova, J.
Source: Self-asserted source
Erki Eessaar via Scopus - Elsevier

A Set of Practices for the Development of Data-Centric Information Systems

Information System Development
2014 | Other
Part of ISBN: 9783319072142
Contributors: Erki Eessaar
Source: Self-asserted source
Erki Eessaar via Crossref Metadata Search

A quality model of metamodeling systems

Lecture Notes in Electrical Engineering
2013 | Book
EID:

2-s2.0-84865959817

Contributors: Sgirka, R.; Eessaar, E.
Source: Self-asserted source
Erki Eessaar via Scopus - Elsevier

An Ontological Analysis of Metamodeling Languages

Information Systems Development
2013 | Other
Part of ISBN: 9781461449508
Contributors: Erki Eessaar; Rünno Sgirka
Source: Self-asserted source
Erki Eessaar via Crossref Metadata Search

Evaluation of different designs to represent missing information in SQL databases

Lecture Notes in Electrical Engineering
2013 | Book
EID:

2-s2.0-84866623778

Contributors: Eessaar, E.; Saal, E.
Source: Self-asserted source
Erki Eessaar via Scopus - Elsevier

On using a semiotic quality framework to evaluate the quality of conceptual database schemas

Lecture Notes in Electrical Engineering
2013 | Book
EID:

2-s2.0-84865977954

Contributors: Eessaar, E.
Source: Self-asserted source
Erki Eessaar via Scopus - Elsevier

A decision support method for evaluating database designs

Computer Science and Information Systems
2012 | Journal article
EID:

2-s2.0-84858693995

Contributors: Eessaar, E.; Soobik, M.
Source: Self-asserted source
Erki Eessaar via Scopus - Elsevier
grade
Preferred source (of 2)‎

Extending UML profiles to model integrity constraints in SQL databases

Frontiers in Artificial Intelligence and Applications
2012 | Book
EID:

2-s2.0-84865703429

Contributors: Eessaar, E.; Aaberg, E.
Source: Self-asserted source
Erki Eessaar via Scopus - Elsevier

A database-based and web-based meta-CASE system

Advanced Techniques in Computing Sciences and Software Engineering
2010 | Conference paper
EID:

2-s2.0-84865990819

Contributors: Eessaar, E.; Sgirka, R.
Source: Self-asserted source
Erki Eessaar via Scopus - Elsevier

A SQL-database based meta-CASE system and its query subsystem

Innovations in Computing Sciences and Software Engineering
2010 | Conference paper
EID:

2-s2.0-84865966028

Contributors: Eessaar, E.; Sgirka, R.
Source: Self-asserted source
Erki Eessaar via Scopus - Elsevier

A SQL-Database Based Meta-CASE System and its Query Subsystem

Innovations in Computing Sciences and Software Engineering
2010 | Other
Part of ISBN: 9789048191116
Contributors: Erki Eessaar; Rünno Sgirka
Source: Self-asserted source
Erki Eessaar via Crossref Metadata Search

A UML profile for developing databases that conform to the Third Manifesto

Innovations in Computing Sciences and Software Engineering
2010 | Conference paper
EID:

2-s2.0-84878941903

Contributors: Eessaar, E.
Source: Self-asserted source
Erki Eessaar via Scopus - Elsevier

A UML Profile for Developing Databases that Conform to the Third Manifesto

Innovations in Computing Sciences and Software Engineering
2010 | Other
Part of ISBN: 9789048191116
Contributors: Erki Eessaar
Source: Self-asserted source
Erki Eessaar via Crossref Metadata Search

Pattern-based usability analysis: Comparison with a case-study

Technological Developments in Education and Automation
2010 | Conference paper
EID:

2-s2.0-84878182891

Contributors: Zub, D.; Eessaar, E.
Source: Self-asserted source
Erki Eessaar via Scopus - Elsevier

Selecting patterns for the evaluation of systems

Technological Developments in Networking, Education and Automation
2010 | Conference paper
EID:

2-s2.0-84878955025

Contributors: Zub, D.; Eessaar, E.
Source: Self-asserted source
Erki Eessaar via Scopus - Elsevier

Selecting Patterns for the Evaluation of Systems

Technological Developments in Networking, Education and Automation
2010 | Other
Part of ISBN: 9789048191505
Contributors: Dmitry Zub; Erki Eessaar
Source: Self-asserted source
Erki Eessaar via Crossref Metadata Search

A comparison of the universal and the regular database design

Frontiers in Artificial Intelligence and Applications
2009 | Book
EID:

2-s2.0-72749102751

Contributors: Eessaar, E.; Soobik, M.
Source: Self-asserted source
Erki Eessaar via Scopus - Elsevier

A Database-Based and Web-Based Meta-CASE System

Advanced Techniques in Computing Sciences and Software Engineering
2009 | Other
Part of ISBN: 9789048136599
Contributors: Erki Eessaar; Rünno Sgirka
Source: Self-asserted source
Erki Eessaar via Crossref Metadata Search

A semiotic approach to quality in specifications of software measures

Lecture Notes in Business Information Processing
2009 | Book
EID:

2-s2.0-64549119121

Contributors: Eessaar, E.
Source: Self-asserted source
Erki Eessaar via Scopus - Elsevier

On metamodel-based design of software metrics

Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
2008 | Book
EID:

2-s2.0-50949118949

Contributors: Eessaar, E.
Source: Self-asserted source
Erki Eessaar via Scopus - Elsevier

On pattern-based database design and implementation

Proceedings - 6th ACIS International Conference on Software Engineering Research, Management and Applications, SERA 2008
2008 | Conference paper
EID:

2-s2.0-53149085921

Contributors: Eessaar, E.
Source: Self-asserted source
Erki Eessaar via Scopus - Elsevier
grade
Preferred source (of 2)‎

On translation-based design of UML profiles

Innovative Techniques in Instruction Technology, E-Learning, E-Assessment, and Education
2008 | Conference paper
EID:

2-s2.0-84879614631

Contributors: Eessaar, E.
Source: Self-asserted source
Erki Eessaar via Scopus - Elsevier

Pattern-based usability evaluation of e-learning systems

Innovative Techniques in Instruction Technology, E-Learning, E-Assessment, and Education
2008 | Conference paper
EID:

2-s2.0-84879639877

Contributors: Zub, D.; Eessaar, E.
Source: Self-asserted source
Erki Eessaar via Scopus - Elsevier

Towards a semiotic quality framework of software measures

ICEIS 2008 - Proceedings of the 10th International Conference on Enterprise Information Systems
2008 | Conference paper
EID:

2-s2.0-55849131847

Contributors: Eessaar, E.
Source: Self-asserted source
Erki Eessaar via Scopus - Elsevier

On Finding Suitable Designs for Whole-Part Relationships in Object-Relational Databases

Information Systems Development
2008-09 | Other
Part of ISBN: 9780387785776
Contributors: Erki Eessaar
Source: Self-asserted source
Erki Eessaar via Crossref Metadata Search

Metamodel-based comparison of data models

Advances and Innovations in Systems, Computing Sciences and Software Engineering
2007 | Conference paper
EID:

2-s2.0-84878226904

Contributors: Eessaar, E.
Source: Self-asserted source
Erki Eessaar via Scopus - Elsevier

Preserving semantics of the whole-part relationships in the object-relational databases

Advances in Information Systems Development: New Methods and Practice for the Networked Society
2007 | Conference paper
EID:

2-s2.0-84889010270

Contributors: Eessaar, E.
Source: Self-asserted source
Erki Eessaar via Scopus - Elsevier

Preserving Semantics of the Whole-Part Relationships in the Object-Relational Databases

Advances in Information Systems Development
2007 | Other
Part of ISBN: 9780387708010
Contributors: Erki Eessaar
Source: Self-asserted source
Erki Eessaar via Crossref Metadata Search

Guidelines about usage of the complex data types in a database

WSEAS Transactions on Information Science and Applications
2006 | Journal article
EID:

2-s2.0-33645164976

Contributors: Eessaar, E.
Source: Self-asserted source
Erki Eessaar via Scopus - Elsevier

SQL or third manifesto compliant object-relational database management systems as the platforms for maintaining the whole-part relationships in a database

WSEAS Transactions on Computers
2006 | Journal article
EID:

2-s2.0-33746940288

Contributors: Eessaar, E.
Source: Self-asserted source
Erki Eessaar via Scopus - Elsevier

Using relational databases in the engineering repository systems

ICEIS 2006 - 8th International Conference on Enterprise Information Systems, Proceedings
2006 | Conference paper
EID:

2-s2.0-53149143905

Contributors: Eessaar, E.
Source: Self-asserted source
Erki Eessaar via Scopus - Elsevier

Architecture of pattern management software system

CEUR Workshop Proceedings
2005 | Conference paper
EID:

2-s2.0-84884360528

Contributors: Eessaar, E.
Source: Self-asserted source
Erki Eessaar via Scopus - Elsevier

Towards pattern management system

ICEIS 2004 - Proceedings of the Sixth International Conference on Enterprise Information Systems
2004 | Conference paper
EID:

2-s2.0-8444250619

Contributors: Eessaar, E.
Source: Self-asserted source
Erki Eessaar via Scopus - Elsevier

On Translation-Based Design of UML Profiles

Innovative Techniques in Instruction Technology, E-learning, E-assessment, and Education
Other
Part of ISBN: 9781402087387
Contributors: Erki Eessaar
Source: Self-asserted source
Erki Eessaar via Crossref Metadata Search

Pattern-Based Usability Evaluation of E-Learning Systems

Innovative Techniques in Instruction Technology, E-learning, E-assessment, and Education
Other
Part of ISBN: 9781402087387
Contributors: Dmitry Zub; Erki Eessaar
Source: Self-asserted source
Erki Eessaar via Crossref Metadata Search