Database query
A database query requests data under defined conditions. Selection, result scope and ordering should fit the work being done.
A database query requests data from a database under defined conditions. In a relational database, an SQL statement such as SELECT can be used. It describes, among other things, which columns and records are needed.
An order list example
A hypothetical portal requests open orders belonging to a particular customer company. Company association, status and required fields belong in the selection. Any desired sorting must also be specified; otherwise the order is not reliably guaranteed.
Not every view needs all available data. Appropriate limits support a traceable workflow. The query must also stay within the permitted data scope. Technical availability does not mean the requesting person may see the data.
Sources
Related terms
- Database indexA database index supports suitable lookups. It does not accelerate every query and adds storage and data-change overhead.
- N+1 queryIn an N+1 pattern, a list query is followed by another fetch for each result. The structure matters, not merely a high call count.
- Object-relational mappingConnecting program objects to data in a relational database.
- PostgreSQLAn open-source object-relational database system for structured storage and querying of data.
- NoSQLAn umbrella term for database systems with different, not primarily relational data models.
- SQLA language for defining, querying and changing data.
Articles on this topic
Your project with ASES
Describe your project to us. We will get back to you with an initial assessment.