-
1 database object
"A database component (for example, a table, index, trigger, view, key, constraint, default, rule, user-defined data type, or stored procedure in a database)." -
2 table
"A database object that stores data in records (rows) and fields (columns). The data is usually about a particular category of things, such as employees or orders." -
3 external database
"The source of the table that is to be linked or imported to the current database, or the destination of a table that is to be exported." -
4 base table
"A table stored permanently in a database. Base tables are referenced by views, cursors, SQL statements, and stored procedures." -
5 temporary table
"A table placed in the temporary database, tempdb, and erased at the end of the session." -
6 external table
A table outside the open database or project. -
7 normalization
"The process of taking a single-table database and breaking it into a set of smaller, related tables, with each table focused on a single topic or grouping of information." -
8 FK
"A key in a database table that comes from another table (also know as the ""referenced table"") and whose values match the primary key (PK) or unique key in the referenced table."FK -
9 foreign key
"A key in a database table that comes from another table (also know as the ""referenced table"") and whose values match the primary key (PK) or unique key in the referenced table." -
10 referencing key
"A key in a database table that comes from another table (also know as the ""referenced table"") and whose values match the primary key (PK) or unique key in the referenced table." -
11 nest
"To embed one construct inside another. For example, a database may contain a nested table (a table within a table), a program may contain a nested procedure (a procedure declared within a procedure), and a data structure may include a nested record (a record containing a field that is itself a record)." -
12 column
The area in each row of a database table that stores the data value for some attribute of the object modeled by the table. -
13 self-join
"A join in which records from a table are combined with other records from the same table when there are matching values in the joined fields. A self-join can be an inner join or an outer join. In database diagrams, a self-join is called a reflexive relationship." -
14 aggregation
A table or structure containing pre-calculated data for an online analytical processing (OLAP) cube. Aggregations support the rapid and efficient querying of a multidimensional database. -
15 system object
"A database object that is defined by the system, such as the table MSysIndexes, or by the user." -
16 view
"In relational database management systems, a logical table created through the specification of one or more relational operations on one or more tables. A view is equivalent to a divided relation in the relational model." -
17 normalize
To minimize the duplication of information in a relational database through effective table design. -
18 ar-sa DTMF
"A discrete packet of binary data that has an exceptionally large size, such as pictures or audio tracks stored as digital data, or any variable or table column large enough to hold such values. The designation ""binary large object"" typically refers to a packet of data that is stored in a database and is treated as a sequence of uninterpreted bytes." -
19 BLOB
"A discrete packet of binary data that has an exceptionally large size, such as pictures or audio tracks stored as digital data, or any variable or table column large enough to hold such values. The designation ""binary large object"" typically refers to a packet of data that is stored in a database and is treated as a sequence of uninterpreted bytes." -
20 blob
"A discrete packet of binary data that has an exceptionally large size, such as pictures or audio tracks stored as digital data, or any variable or table column large enough to hold such values. The designation ""binary large object"" typically refers to a packet of data that is stored in a database and is treated as a sequence of uninterpreted bytes."
- 1
- 2
См. также в других словарях:
Table (database) — In relational databases and flat file databases, a table is a set of data elements (values) that is organized using a model of vertical columns (which are identified by their name) and horizontal rows. A table has a specified number of columns,… … Wikipedia
Table (database) — Таблица (англ. table) (в реляционной модели данных) структура хранения данных, состоящая из строк и столбцов и обладающая следующими свойствами: значения, находящиеся в одном столбце таблицы имеют один тип данных; атомарность: ячейки не содержат… … Википедия
Table (information) — Tabular redirects here. For the typewriter key, see tab key. For sortable tables in Wikipedia, see Help:Sorting An example table rendered in a web browser using HTML. A table is a means of arranging data in rows an … Wikipedia
Table — NOTOC Table may refer to:* Table (furniture) * Deliberative procedures: ** Table (parliamentary), deferral of consideration ** Table (verb), contrasting usages * Tables (board game), a class of board games * The Table, a volcanic tuya in British… … Wikipedia
Database design — is the process of producing a detailed data model of a database. This logical data model contains all the needed logical and physical design choices and physical storage parameters needed to generate a design in a Data Definition Language, which… … Wikipedia
Database Deployment Manager — Developer(s) The Unauthorized Frog project Stable release 0.1e Operating system Windows 2000, XP and Vista, Linux License … Wikipedia
Database storage structures — Database tables/indexes are typically stored on hard disk in one of many forms, ordered/unordered Flat files, ISAM, Heaps, Hash buckets or B+ Trees. These have various advantages and disadvantages discussed in this topic. The most commonly used… … Wikipedia
Database security — concerns the use of a broad range of information security controls to protect databases (potentially including the data, the database applications or stored functions, the database systems, the database servers and the associated network links)… … Wikipedia
Database tuning — describes a group of activities used to optimize and homogenize the performance of a database. It usually overlaps with query tuning, but refers to design of the database files, selection of the database management system (DBMS), operating system … Wikipedia
Database-centric architecture — or data centric architecture has several distinct meanings, generally relating to software architectures in which databases play a crucial role. Often this description is meant to contrast the design to an alternative approach. For example, the… … Wikipedia
Table de mortalite — Table de mortalité Une table de mortalité (aussi appelée table de survie) est une construction qui permet de suivre minutieusement le destin d une population. Cet outil est surtout utilisé en démographie et en actuariat afin d étudier le nombre… … Wikipédia en Français
