Logo
Unionpedia
Communication
Get it on Google Play
New! Download Unionpedia on your Android™ device!
Install
Faster access than browser!
 

Database index

Index Database index

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 space to maintain the index data structure. [1]

38 relations: B+ tree, B-tree, Big O notation, Bit array, Bitwise operation, Block (data storage), Column (database), Composite index (database), Computer file, Concurrency control, Data structure, Database, Expression (computer science), Foreign key, Full table scan, Hash table, Héctor García-Molina, Index locking, Inverted index, Jeffrey Ullman, Jennifer Widom, Linear search, Lookup table, Microsoft SQL Server, Partial index, Pointer (computer programming), Record (computer science), Relational database, Search engine indexing, Self-balancing binary search tree, SQL, Table (database), Time complexity, Tree (data structure), Unique key, User-defined function, Wildcard character, Wrox Press.

B+ tree

A B+ tree is an N-ary tree with a variable but often large number of children per node.

New!!: Database index and B+ tree · See more »

B-tree

In computer science, a B-tree is a self-balancing tree data structure that keeps data sorted and allows searches, sequential access, insertions, and deletions in logarithmic time.

New!!: Database index and B-tree · See more »

Big O notation

Big O notation is a mathematical notation that describes the limiting behaviour of a function when the argument tends towards a particular value or infinity.

New!!: Database index and Big O notation · See more »

Bit array

A bit array (also known as bit map, bit set, bit string, or bit vector) is an array data structure that compactly stores bits.

New!!: Database index and Bit array · See more »

Bitwise operation

In digital computer programming, a bitwise operation operates on one or more bit patterns or binary numerals at the level of their individual bits.

New!!: Database index and Bitwise operation · See more »

Block (data storage)

In computing (specifically data transmission and data storage), a block, sometimes called a physical record, is a sequence of bytes or bits, usually containing some whole number of records, having a maximum length, a block size.

New!!: Database index and Block (data storage) · See more »

Column (database)

In a relational database, a column is a set of data values of a particular simple type, one value for each row of the database.

New!!: Database index and Column (database) · See more »

Composite index (database)

A database composite index or multi-column index is an index that is based on several columns.

New!!: Database index and Composite index (database) · See more »

Computer file

A computer file is a computer resource for recording data discretely in a computer storage device.

New!!: Database index and Computer file · See more »

Concurrency control

In information technology and computer science, especially in the fields of computer programming, operating systems, multiprocessors, and databases, concurrency control ensures that correct results for concurrent operations are generated, while getting those results as quickly as possible.

New!!: Database index and Concurrency control · See more »

Data structure

In computer science, a data structure is a data organization and storage format that enables efficient access and modification.

New!!: Database index and Data structure · See more »

Database

A database is an organized collection of data, stored and accessed electronically.

New!!: Database index and Database · See more »

Expression (computer science)

An expression in a programming language is a combination of one or more constants, variables, operators, and functions that the programming language interprets (according to its particular rules of precedence and of association) and computes to produce ("to return", in a stateful environment) another value.

New!!: Database index and Expression (computer science) · See more »

Foreign key

In the context of relational databases, a foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table or the same table.

New!!: Database index and Foreign key · See more »

Full table scan

Full Table Scan (also known as Sequential Scan) is a scan made on a database where each row of the table under scan is read in a sequential (serial) order and the columns encountered are checked for the validity of a condition.

New!!: Database index and Full table scan · See more »

Hash table

In computing, a hash table (hash map) is a data structure that implements an associative array abstract data type, a structure that can map keys to values.

New!!: Database index and Hash table · See more »

Héctor García-Molina

Héctor García-Molina (born 1954) is a Mexican/American computer scientist and Professor in the Departments of Computer Science and Electrical Engineering at Stanford University.

New!!: Database index and Héctor García-Molina · See more »

Index locking

In databases an index is a data structure, part of the database, used by a database system to effectively navigate access to user data.

New!!: Database index and Index locking · See more »

Inverted index

In computer science, an inverted index (also referred to as postings file or inverted file) is an index data structure storing a mapping from content, such as words or numbers, to its locations in a database file, or in a document or a set of documents (named in contrast to a forward index, which maps from documents to content).

New!!: Database index and Inverted index · See more »

Jeffrey Ullman

Jeffrey David "Jeff" Ullman (born November 22, 1942) is an American computer scientist and professor at Stanford University.

New!!: Database index and Jeffrey Ullman · See more »

Jennifer Widom

Jennifer Widom is the Frederick Emmons Terman Dean of the Stanford School of Engineering and the Fletcher Jones Professor of Computer Science and Electrical Engineering at Stanford University.

New!!: Database index and Jennifer Widom · See more »

Linear search

In computer science, linear search or sequential search is a method for finding a target value within a list.

New!!: Database index and Linear search · See more »

Lookup table

In computer science, a lookup table is an array that replaces runtime computation with a simpler array indexing operation.

New!!: Database index and Lookup table · See more »

Microsoft SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft.

New!!: Database index and Microsoft SQL Server · See more »

Partial index

In databases, a partial index, also known as filtered index is an index which has some condition applied to it so that it includes a subset of rows in the table.

New!!: Database index and Partial index · See more »

Pointer (computer programming)

In computer science, a pointer is a programming language object that stores the memory address of another value located in computer memory.

New!!: Database index and Pointer (computer programming) · See more »

Record (computer science)

In computer science, a record (also called a structure, struct, or compound data) is a basic data structure.

New!!: Database index and Record (computer science) · See more »

Relational database

A relational database is a digital database based on the relational model of data, as proposed by E. F. Codd in 1970.

New!!: Database index and Relational database · See more »

Search engine indexing

Search engine indexing collects, parses, and stores data to facilitate fast and accurate information retrieval.

New!!: Database index and Search engine indexing · See more »

Self-balancing binary search tree

In computer science, a self-balancing (or height-balanced) binary search tree is any node-based binary search tree that automatically keeps its height (maximal number of levels below the root) small in the face of arbitrary item insertions and deletions.

New!!: Database index and Self-balancing binary search tree · See more »

SQL

SQL (S-Q-L, "sequel"; Structured Query Language) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).

New!!: Database index and SQL · See more »

Table (database)

A table is a collection of related data held in a structured format within a database.

New!!: Database index and Table (database) · See more »

Time complexity

In computer science, the time complexity is the computational complexity that describes the amount of time it takes to run an algorithm.

New!!: Database index and Time complexity · See more »

Tree (data structure)

In computer science, a tree is a widely used abstract data type (ADT)—or data structure implementing this ADT—that simulates a hierarchical tree structure, with a root value and subtrees of children with a parent node, represented as a set of linked nodes.

New!!: Database index and Tree (data structure) · See more »

Unique key

In database relational modeling and implementation, a unique key (also known as a candidate key) of a relation is a minimal superkey for that relation; that is, a set of attributes such that.

New!!: Database index and Unique key · See more »

User-defined function

A user-defined function (UDF) is a function provided by the user of a program or environment, in a context where the usual assumption is that functions are built into the program or environment.

New!!: Database index and User-defined function · See more »

Wildcard character

In software, a wildcard character is a kind of placeholder represented by a single character, such as an asterisk, which can be interpreted as a number of literal characters or an empty string.

New!!: Database index and Wildcard character · See more »

Wrox Press

Wrox Press (established in 1992) is a computer book publisher, originally based in Birmingham, England.

New!!: Database index and Wrox Press · See more »

Redirects here:

Clustered index, Dense index, IDX (file format), Index (database), Index file, Key (computing), Non-clustered Index, Nonclustered index, Sparse index, Table index.

References

[1] https://en.wikipedia.org/wiki/Database_index

OutgoingIncoming
Hey! We are on Facebook now! »