Glossary of Terms

Methods of database interaction

Keyword Definition
Data Manipulation The process of using SQL commands to modify data within a database, including operations like update, insert, and delete.
Database Schema The structure that defines the organization of data, including the tables, fields, and relationships within a database.
Drag-And-Drop Interface A user-friendly method that enables users to select objects and manipulate them within a graphical environment for query creation.
Graphical User Interface An interface that allows users to interact with software through visual indicators and elements.
Natural Language Interfaces Tools that enable users to communicate with databases using everyday language instead of programming languages.
Non-Technical Users Individuals who may lack specialized knowledge in programming or database languages.
QBE A query method that allows users to build queries by filling in templates or grids.
Query A request for data or information from a database that specifies the criteria for data retrieval.
Relational Database A type of database that organizes data into tables, which can be linked by relationships through the use of keys.
SQL A standard programming language used to communicate with relational databases and perform operations such as data retrieval, insertion, updating, and deletion.
Visual Query Systems Tools that allow users to build queries using graphical elements rather than text-based commands.