Designing the user interface: strategies for effective human-computer interaction
Designing the user interface: strategies for effective human-computer interaction
A logical design methodology for relational databases using the extended entity-relationship model
ACM Computing Surveys (CSUR)
A guide to the SQL standard
A methodology for creating user views in database design
ACM Transactions on Database Systems (TODS)
Fundamentals of database systems
Fundamentals of database systems
The effects of relational and entity-relationship data models on query performance of end users
International Journal of Man-Machine Studies
Comparing representations with relational and EER models
Communications of the ACM
An introduction to database systems: vol. 1 (5th ed.)
An introduction to database systems: vol. 1 (5th ed.)
Database modeling and design: the entity-relationship approach
Database modeling and design: the entity-relationship approach
Data models, database languages and database management systems
Data models, database languages and database management systems
Relational database design: an introduction
Relational database design: an introduction
Towards a semantic view of an extended entity-relationship model
ACM Transactions on Database Systems (TODS)
Formal semantics of SQL queries
ACM Transactions on Database Systems (TODS)
Conceptual database design: an Entity-relationship approach
Conceptual database design: an Entity-relationship approach
Object-oriented databases: a semantic data model approach
Object-oriented databases: a semantic data model approach
Object-oriented databases
Human factors comparison of a procedural and a nonprocedural query language
ACM Transactions on Database Systems (TODS)
The entity-relationship model—toward a unified view of data
ACM Transactions on Database Systems (TODS) - Special issue: papers from the international conference on very large data bases: September 22–24, 1975, Framingham, MA
Human Factors Studies of Database Query Languages: A Survey and Assessment
ACM Computing Surveys (CSUR)
Communications of the ACM
User performance considerations in DBMS selection
SIGMOD '77 Proceedings of the 1977 ACM SIGMOD international conference on Management of data
Database
An Introduction to Database Systems
An Introduction to Database Systems
An Algebra for a Directional Binary Entity-Relationship Model
Proceedings of the First International Conference on Data Engineering
An Entity-Relationship Algebra
Proceedings of the First International Conference on Data Engineering
An Entity-Relationship Enhanced Logic System
Proceedings of the Second International Symposium on Database Systems for Advanced Applications
Completeness of Query Languages for the Entity-Relationship Model
ER '81 Proceedings of the Second International Conference on the Entity-Relationship Approach to Information Modeling and Analysis
SESPATH: An ER Manipulation Language
Proceedings of the Fourth International Conference on Entity-Relationship Approach
Lambda: An Entity-Relationship Based Query Language for the Retrieval of Structured Documents
Proceedings of the Fourth International Conference on Entity-Relationship Approach
A Normal Form For Entity-Relationship Diagrams
Proceedings of the Fourth International Conference on Entity-Relationship Approach
An ER Calculus for the Entity-Relationship Complex Model
Proceedings of the Eight International Conference on Enity-Relationship Approach to Database Design and Querying
Automatic Transformation of an Entity-Relationship Query Language into SQL
Proceedings of the Eight International Conference on Enity-Relationship Approach to Database Design and Querying
SEQUEL: A structured English query language
SIGFIDET '74 Proceedings of the 1974 ACM SIGFIDET (now SIGMOD) workshop on Data description, access and control
A knowledge level user interface using the entity-relationship model
A knowledge level user interface using the entity-relationship model
A psychological study of query by example
AFIPS '75 Proceedings of the May 19-22, 1975, national computer conference and exposition
Human factors evaluation of two data base query languages: square and sequel
AFIPS '75 Proceedings of the May 19-22, 1975, national computer conference and exposition
Information and Software Technology
A comparison of database fault detection capabilities using mutation testing
Proceedings of the ACM-IEEE international symposium on Empirical software engineering and measurement
Conceptual modeling for systems integration
ER'12 Proceedings of the 31st international conference on Conceptual Modeling
Hi-index | 0.00 |
A common classification of data models is based on their abstraction levels: physical, logical and conceptual. The user-database interaction can be similarly classified. For the conceptual-level interaction, the user and the database exchange information on the user's world, e.g., information of entities, relationships, and attributes. For the logical-level interaction, the user and the database communicate based on concepts in the database system, e.g., relations and join operations. We expect users to be familiar with concepts in their world but not the concepts in the database system. This is especially so for infrequent or naive database users. The conceptual level should therefore be easier because it is semantically closer to the user. This deduction was tested in an experiment using the entity-relationship (ER) model for the conceptual-level model and the relational model for the logical-level model. The results were affirmative. The users at the conceptual level had 38 percent higher accuracy and 16 percent higher confidence than users at the logical level. The conceptual-level users took 65 percent less time than the logical-level users, and it took 33 percent less time to train them. The differences were statistically significant with p