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