This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
glossary:d [2009/07/23 13:40] admin |
glossary:d [2012/10/26 14:24] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== Glossary: D ====== | + | {{page>:top_add&nofooter&noeditbtn}} |
| + | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
| + | ====== Glossary ====== | ||
| - | ===== Data dictionary ===== | + | ===== D ===== |
| - | An information structure that defines the organization of a database including the list and description of each element of the database such as columns, data types, memory allocations for data storage, etc... | + | {{page>:glossary_bar&nofooter&noeditbtn}} |
| - | + | ||
| - | ===== Data files ===== | + | |
| - | Files that contain actual data, rather than meta-data or other data descriptions. See meta-data and data. | + | ==== Data dictionary ==== |
| + | * An information structure that defines the organization of a database including the list and description of each element of the database such as columns, data types, memory allocations for data storage, etc... | ||
| - | ===== Data mart ===== | + | ==== Data files ==== |
| + | * Files that contain actual data, rather than meta-data or other data descriptions. See meta-data and data. | ||
| - | A departmental or subject-specific subset of data of a data warehouse. See data warehouse. | + | ==== Data mart ==== |
| - | + | * A departmental or subject-specific subset of data of a data warehouse. See data warehouse. | |
| - | ===== Data mining ===== | + | |
| - | + | ||
| - | The process of finding patterns or trends in a collection of data. | + | |
| + | ==== Data mining ==== | ||
| + | * The process of finding patterns or trends in a collection of data. | ||
| - | ===== Data modeling ===== | + | ==== Data modeling ==== |
| + | * The development of rules that cover data entities (objects such as relationships, tables, columns, data integrity, etc.) of a database management system. | ||
| - | The development of rules that cover data entities (objects such as relationships, tables, columns, data integrity, etc.) of a database management system. | + | ==== Data set ==== |
| + | * A collection of data entries where each entry contains a group of data items. Also called a table. | ||
| - | ===== Data set ===== | + | ==== Data source file ==== |
| + | * An initialization file that stores the location of data on a server and the transport method used to access the data. | ||
| - | A collection of data entries where each entry contains a group of data items. Also called a table. | + | ==== Data source name (DSN) ==== |
| - | + | * DSN; in ODBC, the name of the origin (e.g., of a file, database, document, etc.) of transmitted data. | |
| - | ===== Data source file ===== | + | |
| - | + | ||
| - | An initialization file that stores the location of data on a server and the transport method used to access the data. | + | |
| - | + | ||
| - | ===== Data source name (DSN) ===== | + | |
| - | + | ||
| - | DSN; in ODBC, the name of the origin (e.g., of a file, database, document, etc.) of transmitted data. | + | |
| - | **data type** | + | ==== Data type ==== |
| - | The characteristic description of data, be it alphabetic, numeric, integer, decimal, character, string, etc. | + | * The characteristic description of data, be it alphabetic, numeric, integer, decimal, character, string, etc. |
| - | **data type discrepancy** | + | ==== Data type discrepancy ==== |
| - | Condition in which data stored in a particular field does not match the DBMS data type defined for that field. | + | * Condition in which data stored in a particular field does not match the DBMS data type defined for that field. |
| - | **data warehouse** | + | ==== Data warehouse ==== |
| - | A voluminous collection of summarized consistent data, usually historical in nature, used for only data analysis rather than data processing | + | * A voluminous collection of summarized consistent data, usually historical in nature, used for only data analysis rather than data processing |
| - | A database designed and optimized for OLAP. | + | * A database designed and optimized for OLAP. |
| - | **database** | + | ==== Data-only option ==== |
| - | A collection of data files stored in a specific structure, whose organization is centrally defined in a root file or data dictionary. | + | * An option supported by the OmniAccess update routines (oainsert, oadelete, and oaupdate) that disables the real-time updating of OMNIDEX indexes. This option is useful when updating a high volume of records. Data-only updates must be followed by a DBINSTAL B or INDEX operation to update the OMNIDEX indexes. |
| - | **database key** | + | ==== DataSource ==== |
| - | A field or column that uniquely identifies a row in a table. | + | * A collection of information used by the ODBC software to connect to a database, required before accessing databases from a container application such as Microsoft Word. |
| + | ==== Decompile ==== | ||
| + | * in OMNIDEX, the process of reverting a compiled Environment Catalog file to an Environment source file using the utility OADECOMP. | ||
| + | ==== Denormalization ==== | ||
| + | * The process of introducing duplication of data within a relational database (which is typically normalized), used in data warehouse applications to avoid the inefficiencies of cross-table join operations. See normalization. | ||
| - | **database tuning** | ||
| - | A process effected on a database by the database administrator (DBA) in an effort to improve the speed and efficiency of data retrievals and data throughput. | ||
| - | ===== Data-only option ===== | + | ==== Detail data set ==== |
| + | * Child table. | ||
| - | An option supported by the OmniAccess update routines (oainsert, oadelete, and oaupdate) that disables the real-time updating of OMNIDEX indexes. This option is useful when updating a high volume of records. Data-only updates must be followed by a DBINSTAL B or INDEX operation to update the OMNIDEX indexes. | + | ==== Detail Record ==== |
| + | * A record in a child table. See DR Domain. | ||
| - | ===== DataSource ===== | + | ==== DI keys ==== |
| - | + | * Distributed Index key. See distributed index. | |
| - | a collection of information used by the ODBC software to connect to a database, required before accessing databases from a container application such as Microsoft Word. | + | ==== Dimension table** ==== |
| - | + | * A parent table with a unique key that provides keyed access into a child (fact) table; | |
| - | ===== Decompile ===== | + | * Tables that contain descriptions for codes in fact tables. |
| - | + | ||
| - | in OMNIDEX, the process of reverting a compiled Environment Catalog file to an Environment source file using the utility OADECOMP. | + | |
| - | denormalization | + | |
| - | the process of introducing duplication of data within a relational database (which is typically normalized), used in data warehouse applications to avoid the inefficiencies of cross-table join operations. See normalization. | + | |
| - | + | ||
| - | detail data set | + | |
| - | Child table. | + | |
| - | + | ||
| - | ===== Detail Record ===== | + | |
| - | + | ||
| - | A record in a child table. See DR Domain. | + | |
| - | + | ||
| - | ===== DI keys ===== | + | |
| - | + | ||
| - | distributed index key. See distributed index. | + | |
| - | + | ||
| - | ===== **dimension table** ===== | + | |
| - | + | ||
| - | A parent table with a unique key that provides keyed access into a child (fact) table; | + | |
| - | tables that contain descriptions for codes in fact tables. | + | |
| ==== Direct access ==== | ==== Direct access ==== | ||
| + | * The process of locating a record or row based on its location on a storage device, which is fast but requires an exact key match. See hashed access and hashed key. | ||
| - | The process of locating a record or row based on its location on a storage device, which is fast but requires an exact key match. See hashed access and hashed key. | + | ==== Disconnect ==== |
| - | + | * The process of disconnect from an Omnidex Environment or from a network connection. | |
| - | ===== **disconnect** ===== | + | ==== Distributed index ==== |
| - | + | * An indexing option for Omnidex, or MDK indexes, in which the index is stored as a separate file, essentially creating an IMSAM, or ASK key; | |
| - | the process of terminating a network connection. | + | * An ASK Index installed through an MDK Index process with ;DI option which can be used essentially as an MDK Index, including on-line index maintenance and optimization like an MDK Index, and also aggregation as on an ASK Index. |
| - | + | ||
| - | ===== **distributed index** ===== | + | |
| - | + | ||
| - | An indexing option for Omnidex, or MDK indexes, in which the index is stored as a separate file, essentially creating an IMSAM, or ASK key; | + | |
| - | An ASK Index installed through an MDK Index process with ;DI option which can be used essentially as an MDK Index, including on-line index maintenance and optimization like an MDK Index, and also aggregation as on an ASK Index. | + | |
| - | + | ||
| - | ===== **domain** ===== | + | |
| - | + | ||
| - | A parent table and any child tables that were linked (prejoined) to it during Omnidex installation; | + | |
| - | A single, unjoined table with Omnidex indexes installed on it; | + | |
| - | A a single data set installed with multiple keys; | + | |
| - | An association of several data sets installed with multiple keys and linked during installation. Also called an Omnidex domain. See SI domain and DR domain. | + | |
| - | + | ||
| - | ===== **DR** ===== | + | |
| - | + | ||
| - | See Detail Record. | + | |
| - | + | ||
| - | ===== **DR domain** ===== | + | |
| - | + | ||
| - | an OMNIDEX domain that consists of one detail data set, or child table, that has not been linked to a master data set, or parent table. A DR domain child table can also be part of RS (Record Specific) domain. See Hybrid-DR domain and domain. | + | |
| - | + | ||
| - | ===== **drill down** ===== | + | |
| - | + | ||
| - | In data analysis, the process of narrowing data to retrieve specific underlying detail; | + | |
| - | In OMNIDEX, successive iterations of adding criteria to a query, refining a search to the exact subset of required data. | + | |
| - | ===== **Driver Manager** ===== | + | ==== Domain ==== |
| + | * A parent table and any child tables that were linked (prejoined) to it during Omnidex installation; | ||
| + | * A single, unjoined table with Omnidex indexes installed on it; | ||
| + | * A a single data set installed with multiple keys; | ||
| + | * An association of several data sets installed with multiple keys and linked during installation. Also called an Omnidex domain. See SI domain and DR domain. | ||
| - | Software written by Microsoft and installed when installing ODBC applications; | + | ==== DR ==== |
| - | Software accessed by container applications such as Excel which initiates the appropriate ODBC driver such as the OMNIDEX ODBC Driver. | + | * See Detail Record. |
| - | ===== **DSN** ===== | + | ==== DR domain ==== |
| + | * An OMNIDEX domain that consists of one detail data set, or child table, that has not been linked to a master data set, or parent table. A DR domain child table can also be part of RS (Record Specific) domain. See Hybrid-DR domain and domain. | ||
| + | ==== Drill down ==== | ||
| + | * In data analysis, the process of narrowing data to retrieve specific underlying detail; | ||
| + | * In OMNIDEX, successive iterations of adding criteria to a query, refining a search to the exact subset of required data. | ||
| - | DataSource Name; see data source name | + | ==== Driver Manager ==== |
| + | * Software written by Microsoft and installed when installing ODBC applications; | ||
| + | * Software accessed by container applications such as Excel which initiates the appropriate ODBC driver such as the OMNIDEX ODBC Driver. | ||
| + | ==== DSN ==== | ||
| + | * DataSource Name; see data source name | ||
| - | ====== Quick Links ====== | + | {{page>:bottom_add&nofooter&noeditbtn}} |
| - | {{page>:quicklinks&nofooter&noeditbtn}} | + | |