A range query is a common database operation that retrieves all records where some value is between an upper and lower boundary. For example, list all...
1 KB (135 words) - 10:06, 11 October 2023
writing and querying data. In the 2000s, non-relational databases became popular, collectively referred to as NoSQL, because they use different query languages...
78 KB (9,882 words) - 16:36, 29 June 2025
A graph database (GDB) is a database that uses graph structures for semantic queries with nodes, edges, and properties to represent and store data. A key...
53 KB (4,714 words) - 05:29, 3 July 2025
partitions. While this effectively prevents hot spots, it sacrifices range query efficiency as adjacent keys scatter across partitions. Common implementations...
9 KB (1,101 words) - 06:31, 20 February 2025
areas, the foundations of query languages, computational complexity and expressive power of queries, finite model theory, database design theory, dependency...
3 KB (372 words) - 10:09, 30 June 2025
Vector databases typically implement one or more approximate nearest neighbor algorithms, so that one can search the database with a query vector to...
23 KB (1,648 words) - 12:44, 2 July 2025
WHOIS (redirect from Whois database)
WHOIS (pronounced as the phrase "who is") is a query and response protocol that is used for querying databases that store an Internet resource's registered...
53 KB (5,533 words) - 07:58, 25 June 2025
science, the range searching problem consists of processing a set S of objects, in order to determine which objects from S intersect with a query object, called...
11 KB (1,415 words) - 03:23, 26 January 2025
times. A uni-temporal database has one axis of time, either the validity range or the system time range. A bi-temporal database has two axes of time:...
32 KB (3,397 words) - 12:25, 6 September 2024
Relational model (redirect from Relational model of database management)
and retrieval procedures for answering queries. Most relational databases use the SQL data definition and query language; these systems implement what...
30 KB (4,196 words) - 15:00, 15 March 2025
Microsoft SQL Server (redirect from Pubs (database))
relational database management system developed by Microsoft using Structured Query Language (SQL, often pronounced "sequel"). As a database server, it...
61 KB (7,167 words) - 05:20, 24 May 2025
Select (SQL) (redirect from SQL query)
language, SELECT queries specify a result set, but do not specify how to calculate it. The database translates the query into a "query plan" which may...
33 KB (3,100 words) - 20:59, 25 January 2025
enumerable classes, XML documents, relational databases, and third-party data sources. Other uses, which utilize query expressions as a general framework for...
28 KB (3,366 words) - 06:11, 3 February 2025
and Wong, and Willard. The range tree is an alternative to the k-d tree. Compared to k-d trees, range trees offer faster query times of (in Big O notation)...
10 KB (1,250 words) - 19:18, 9 August 2024
Tuple relational calculus (section Queries)
provide a declarative database-query language for data manipulation in this data model. It formed the inspiration for the database-query languages QUEL and...
15 KB (2,303 words) - 13:44, 25 May 2025
NoSQL (redirect from Non-relational database)
query languages or work alongside SQL databases in polyglot-persistent setups, where multiple database types are combined. Non-relational databases date...
30 KB (2,437 words) - 06:52, 9 May 2025
availability, BigQuery found success among a broad range of customers, including airlines, insurance, and retail organizations. BigQuery requires all requests...
5 KB (403 words) - 07:16, 30 May 2025
Sargable (category Database management systems)
In relational databases, a condition (or predicate) in a query is said to be sargable if the DBMS engine can take advantage of an index to speed up the...
6 KB (757 words) - 21:42, 24 June 2025
A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of additional writes and storage...
17 KB (2,464 words) - 18:58, 7 June 2025
ArangoDB (redirect from AQL (ArangoDB Query Language))
(graphs, JSON documents, key/value) with one database core and a unified query language AQL (ArangoDB Query Language). AQL is mainly a declarative language...
18 KB (1,109 words) - 02:15, 14 June 2025
Log-structured merge-tree (category Database index techniques)
alternatively as a collection of files with non-overlapping key ranges. To perform a query on a particular key to get its associated value, one must search...
14 KB (1,936 words) - 08:24, 10 January 2025
MySQL (redirect from My Structured Query Language)
Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A relational database organizes data into one or more data tables in which data...
69 KB (6,514 words) - 09:07, 22 May 2025
P-Grid (section Range queries in P-Grid)
key distributions (and hence support lexicographic key ordering and range queries), still providing storage load-balancing and efficient search by using...
5 KB (643 words) - 16:13, 6 July 2024
Online analytical processing (redirect from Multidimensional database)
multi-dimensional analytical (MDA) queries. The term OLAP was created as a slight modification of the traditional database term online transaction processing...
37 KB (4,439 words) - 21:45, 6 June 2025
Domain Name System (redirect from DNS query)
server responds with answers to queries against its database. The most common types of records stored in the DNS database are for start of authority (SOA)...
69 KB (9,812 words) - 15:54, 2 July 2025
Data stream management system (redirect from Continuous query)
to a database management system (DBMS), which is, however, designed for static data in conventional databases. A DBMS also offers a flexible query processing...
13 KB (1,565 words) - 01:00, 22 December 2024
PostgreSQL (category Client-server database management systems)
system, another relational database management system (RDBMS), or a web service. This means that regular database queries can use these data sources like...
103 KB (8,668 words) - 19:59, 15 June 2025
IMDb (redirect from The Internet Movie Database)
integrated with the list data, and a centralized email interface for querying the database had been created by Alan Jay. Later, on August 5, 1993, it moved...
50 KB (4,642 words) - 00:22, 25 June 2025
of range queries (e.g., show all records where a particular column is between X and Y, or less than X.) In all these cases, however, the database designer...
37 KB (2,918 words) - 20:54, 14 May 2025
Bx-tree (section Range query)
querying ideas in The iDistance Technique. The range query and K Nearest Neighbor query algorithms can be easily extended to support interval queries...
11 KB (1,542 words) - 11:13, 31 March 2025