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

Table (database)

Index Table (database)

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

27 relations: Check constraint, Column (database), Computer file, Data type, Database, Flat file database, Hierarchical database model, IBM Informix, Logical data model, Metadata, Multiset, Oracle Database, Order by, Primary key, Relation (database), Relational database, Relational model, Row (database), Select (SQL), Set (abstract data type), Spreadsheet, SQL, SQLite, Table (information), Tuple, View (SQL), Virtual column.

Check constraint

A check constraint is a type of integrity constraint in SQL which specifies a requirement that must be met by each row in a database table.

New!!: Table (database) and Check constraint · 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!!: Table (database) and Column (database) · See more »

Computer file

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

New!!: Table (database) and Computer file · See more »

Data type

In computer science and computer programming, a data type or simply type is a classification of data which tells the compiler or interpreter how the programmer intends to use the data.

New!!: Table (database) and Data type · See more »

Database

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

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

Flat file database

A flat file database is a database stored as an ordinary unstructured file called a "flat file".

New!!: Table (database) and Flat file database · See more »

Hierarchical database model

A hierarchical database model is a data model in which the data is organized into a tree-like structure.

New!!: Table (database) and Hierarchical database model · See more »

IBM Informix

IBM Informix is a product family within IBM's Information Management division that is centered on several relational database management system (RDBMS) offerings.

New!!: Table (database) and IBM Informix · See more »

Logical data model

A logical data model or logical schema is a data model of a specific problem domain expressed independently of a particular database management product or storage technology (physical data model) but in terms of data structures such as relational tables and columns, object-oriented classes, or XML tags.

New!!: Table (database) and Logical data model · See more »

Metadata

Metadata is "data that provides information about other data".

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

Multiset

In mathematics, a multiset (aka bag or mset) is a modification of the concept of a set that, unlike a set, allows for multiple instances for each of its elements.

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

Oracle Database

Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is a multi-model database management system produced and marketed by Oracle Corporation.

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

Order by

An ORDER BY clause in SQL specifies that a SQL SELECT statement returns a result set with the rows being sorted by the values of one or more columns.

New!!: Table (database) and Order by · See more »

Primary key

In the relational model of databases, a primary key is a specific choice of a minimal set of attributes (columns) that uniquely specify a tuple (row) in a relation (table).

New!!: Table (database) and Primary key · See more »

Relation (database)

In relational database theory, a relation, as originally defined by E. F. Codd, is a set of tuples (d1, d2,..., dn), where each element dj is a member of Dj, a data domain.

New!!: Table (database) and Relation (database) · 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!!: Table (database) and Relational database · See more »

Relational model

The relational model (RM) for database management is an approach to managing data using a structure and language consistent with first-order predicate logic, first described in 1969 by Edgar F. Codd, where all data is represented in terms of tuples, grouped into relations.

New!!: Table (database) and Relational model · See more »

Row (database)

In the context of a relational database, a row—also called a tuple—represents a single, implicitly structured data item in a table.

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

Select (SQL)

The SQL SELECT statement returns a result set of records from one or more tables.

New!!: Table (database) and Select (SQL) · See more »

Set (abstract data type)

In computer science, a set is an abstract data type that can store unique values, without any particular order.

New!!: Table (database) and Set (abstract data type) · See more »

Spreadsheet

A spreadsheet is an interactive computer application for organization, analysis and storage of data in tabular form.

New!!: Table (database) and Spreadsheet · 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!!: Table (database) and SQL · See more »

SQLite

SQLite is a relational database management system contained in a C programming library.

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

Table (information)

A table is an arrangement of data in rows and columns, or possibly in a more complex structure.

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

Tuple

In mathematics, a tuple is a finite ordered list (sequence) of elements.

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

View (SQL)

In a database, a view is the result set of a stored query on the data, which the database users can query just as they would in a persistent database collection object.

New!!: Table (database) and View (SQL) · See more »

Virtual column

In relational databases a virtual column is a table column whose value is automatically computed using other columns values, or another deterministic expression.

New!!: Table (database) and Virtual column · See more »

Redirects here:

Database Tables, Database table.

References

[1] https://en.wikipedia.org/wiki/Table_(database)

OutgoingIncoming
Hey! We are on Facebook now! »