Database Interfaces
Defining and Describing Database Interfaces
- A database interface is the boundary that lets people inspect, query, modify, and administer stored data without requiring the same level of knowledge as the underlying database system.
- Database interfaces translate human actions—such as filling in forms, selecting icons, navigating relationships, or writing queries—into database operations. Early research emphasized that interfaces had to serve nontechnical users, while later systems expanded toward graphical browsing, multimodal interaction, and natural-language access. [1] [2] [3]
- The concept applies wherever users need to work with structured data: business applications, engineering systems, personal databases, research tools, and administrative software. Its central design problem is balancing expressive power with learnability, accuracy, and protection against invalid or unintended operations. [4] [1] [3]
Uses in Context
- Business applications: Forms and tables let staff create, maintain, and manipulate relational data without directly writing formal queries. [4]
- Exploratory search: Browsing interfaces help users investigate vague information needs when a precise query is difficult to formulate. [2]
- Engineering design: Interfaces can combine constraints, examples, pointing at graphical parts, and query language in a multimodal workstation environment. [3]
History of Use
Origins
- The modern research agenda emerged from human-factors work on database interaction. Ben Shneiderman’s 1978 paper argued that the spread of information systems to nontechnically trained users required “a new approach” to database-interface design and proposed controlled experiments comparing natural and artificial query languages. [1]
- Earlier relational-interface research explored ways to make databases usable through browsing rather than formal query specification. The 1986 BAROQUE system presented a relational database as a semantic-network-like environment and supported exploratory retrieval with few formal skills. [2]
- The concept was also shaped by entity-relationship and graphical interaction research. The 1984 Living in a Database system used a bit-mapped display and mouse interaction for an entity-relationship database, while noting the implementation difficulty of dynamic displays and the challenge of operating on sets of instances. [9]
Evolution
- 1986–1990 — Browsing, icons, and graphical query construction: Systems such as BAROQUE and IconicBrowser made exploratory retrieval and object selection central interaction modes; IconicBrowser used icons for classes and objects and interpreted combinations of overlapping icons as database operations. [2] [5]
- Late 1980s onward — Domain-specific and multimodal interfaces: Database interfaces expanded beyond business-style text interaction to engineering environments combining graphics, constraints, examples, and specialized query languages, while form-based systems mapped familiar screen layouts onto normalized relational structures. [3] [4]
Best Real-World Examples
- IconicBrowser — an icon-based object-oriented database retrieval system that translated visual combinations into database operations. [5]
- Living in a Database — an early graphical entity-relationship interface using a bit-mapped display and mouse pointer. [9]
- A user interface for database creation, use and maintenance — a form-and-table interface that allowed users to manipulate relational data through screen images rather than direct relational operations. [4]
- A graphical database interface for casual, naive users — research focused explicitly on making database access practical for casual and inexperienced users. [8]
- A Graphical Interface to a Complex-Object Database Management System — a graphical system that displayed schemas, formulated queries visually, and presented results as navigable complex-object graphs. [6]
- A practical natural language interface to databases — an early applied treatment of translating ordinary-language requests into database access. [7]
Case Studies
Sources
[1] 2026, Nov 11. dl.acm.org . Improving the human factors aspect of database interactions | ACM Transactions on Database Systems . Updated: 2026, Nov 14. Generated: 2026, Nov 16. Perplexity API response.
[2] 2026, Nov 12. dl.acm.org . BAROQUE: a browser for relational databases | ACM Transactions on Information Systems . Updated: 2026, Nov 15. Generated: 2026, Nov 16. Perplexity API response.
[3] 2026, Nov 11. dl.acm.org . User interfaces for structural engineering relational data base | Engineering with Computers . Updated: 2026, Nov 14. Generated: 2026, Nov 16. Perplexity API response.
[4] 2026, Nov 08. dl.acm.org . A user interface for database creation use and maintenance | Proceedings of the 1988 ACM SIGSMALL/PC symposium on ACTES . Updated: 2026, Nov 11. Generated: 2026, Nov 16. Perplexity API response.
[5] 2026, Nov 11. dl.acm.org . IconicBrowser: An iconic retrieval system for object-oriented databases: Journal of Visual Languages and Computing: Vol 1, No 1 . Updated: 2026, Nov 14. Generated: 2026, Nov 16. Perplexity API response.
[6] 2026, May 03. link.springer.com . A Graphical Interface to a Complex-Object Database Management ... . Updated: 2026, Nov 13. Generated: 2026, Nov 16. Perplexity API response.
[7] 2026, Nov 09. dl.acm.org . A practical natural language interface to databases | Perspectives in artificial intelligence vol. 2: machine translation, NLP, databases and computer-aided instruction . Updated: 2026, Nov 13. Generated: 2026, Nov 16. Perplexity API response.
[8] 2026, Nov 08. dl.acm.org . A graphical database interface for casual, naive users | Information Processing and Management: an International Journal . Updated: 2026, Nov 11. Generated: 2026, Nov 16. Perplexity API response.
[9] 2026, Oct 20. dl.acm.org . Lessons from a "living in a database" graphical query interface . Updated: 2026, Oct 23. Generated: 2026, Nov 16. Perplexity API response.
[10] 2026, Nov 11. dl.acm.org . The proteus bibliography: Representation and interactive display in databases | ACM SIGMOD Record . Updated: 2026, Nov 14. Generated: 2026, Nov 16. Perplexity API response.