This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
glossary:s [2009/12/04 20:03] tdo |
glossary:s [2012/10/26 14:24] (current) |
||
|---|---|---|---|
| Line 22: | Line 22: | ||
| * The process of cleaning data to make it consistent in preparation for data warehouse retrieval. | * The process of cleaning data to make it consistent in preparation for data warehouse retrieval. | ||
| - | **search item** | + | ==== Search item ==== |
| + | * Primary key - SI | ||
| + | * A field within a table that is used for calculated access in parent tables, and chained access in child tables | ||
| - | * Primary key - SI | + | ==== Select item ==== |
| - | * A field within a table that is used for calculated access in parent tables, and chained access in child tables | + | * An item in a SQL SELECT statement's select-list. See the SQL Reference for details on valid select-list items. |
| - | **select item** | + | ==== Select-list ==== |
| - | * An item in a SQL SELECT statement's select-list. See the SQL Reference for details on valid select-list items. | + | * A comma separated list of items to be returned to the application in a SQL SELECT statement. See the SQL Reference for details on valid select-list items. |
| - | **select-list** | + | ==== Sequential read ==== |
| + | * A search of a file or database performed by comparing successive records with search criteria. | ||
| - | * A comma separated list of items to be returned to the application in a SQL SELECT statement. See the SQL Reference for details on valid select-list items. | + | ==== Serial read ==== |
| + | * A sequential read of records in a data set that is performed one block of records at a time. | ||
| - | **sequential read** | + | ==== Server ==== |
| + | * A hardware component dedicated to a specific purpose. | ||
| + | * The part of the client/server architecture which refers to the host CPU where the database and other corporate information is stored. | ||
| - | * A search of a file or database performed by comparing successive records with search criteria. | + | ==== SI domain ==== |
| + | * An affiliation of one parent table, and one or more child tables, linked at installation, whose keyword values are all indexed in the same indexes. See also: search item. | ||
| - | **serial read** | + | ==== Snowflake schema ==== |
| + | * A type of database design used in data warehousing involving multiple tables in a hierarchy within a given dimension i.e., data is organized into parent tables with branches to child tables and so-called grandparent tables (snow flakes). | ||
| + | * When the schema is displayed graphically, it has the appearance of a snow flake. | ||
| - | * A sequential read of records in a data set that is performed one block of records at a time. | + | ==== Soundex ==== |
| + | * ;SX | ||
| + | * an indexing option which allows data retrieval based on phonetic arguments, useful for location of data with keys that are difficult to spell or that can be spelled in several ways. | ||
| - | **server** | + | ==== Source ==== |
| + | * In Multifind usage, refers to the item, set, or database that is supplying the data values used as search arguments. | ||
| + | * Textual, uncompiled version of an Omnidex Environment Catalog. | ||
| + | * Textual, uncompiled version of a computer program. | ||
| - | * A hardware component dedicated to a specific purpose. | + | ==== Special characters ==== |
| - | * The part of the client/server architecture which refers to the host CPU where the database and other corporate information is stored. | + | * A character that is parsed by Omnidex before being indexed |
| + | * A character that is interpreted by Omnidex to have special meaning | ||
| + | ==== SQL ==== | ||
| + | * Structured Query Language | ||
| + | * A standardized computer language used to add, modify, delete, and retrieve information from a database | ||
| - | **SI domain** | + | ==== SQL Interfaces ==== |
| + | * Interface to ata bases and data stores. | ||
| + | * Omnidex supports both ODBC and JDBC interfaces using both standard SQL and specific Omnidex SQL extensions. | ||
| - | * An affiliation of one parent table, and one or more child tables, linked at installation, whose keyword values are all indexed in the same indexes. See also: search item. | + | ==== Star schema ==== |
| + | * A type of database design used in data warehousing composed of a large sized fact table combined with numerous dimension tables, i.e., parent tables branched to child tables. | ||
| - | **snowflake schema** | + | ==== Summary table ==== |
| - | * A type of database design used in data warehousing involving multiple tables in a hierarchy within a given dimension i.e., data is organized into parent tables with branches to child tables and so-called grandparent tables (snow flakes). | + | * A table containing pre-summarized data, typically used in ROLAP data warehousing, used to perform fast look-ups against specific, predictable combinations of criteria. |
| - | * When the schema is displayed graphically, it has the appearance of a snow flake. | + | * Omnidex aggregation indexes eliminate the need for summary tables. |
| - | **soundex** | + | ==== Superview ==== |
| + | * The technique of flatening out multiple tables into a single table to facilitate very high-speed Omnidex access. | ||
| - | * ;SX | + | ==== Synchronous ==== |
| - | * an indexing option which allows data retrieval based on phonetic arguments, useful for location of data with keys that are difficult to spell or that can be spelled in several ways. | + | * A process that is executed in conjunction with another process |
| - | + | * In Omnidex, index updates that are update at the same time that the data updates occur. | |
| - | **source** | + | |
| - | + | ||
| - | * In Multifind usage, refers to the item, set, or database that is supplying the data values used as search arguments. | + | |
| - | * Textual, uncompiled version of an Omnidex Environment Catalog. | + | |
| - | * Textual, uncompiled version of a computer program. | + | |
| - | + | ||
| - | **special characters** | + | |
| - | + | ||
| - | * A character that is parsed by Omnidex before being indexed | + | |
| - | * A character that is interpreted by Omnidex to have special meaning | + | |
| - | + | ||
| - | **SQL** | + | |
| - | * Structured Query Language | + | |
| - | * A standardized computer language used to add, modify, delete, and retrieve information from a database | + | |
| - | + | ||
| - | **star schema** | + | |
| - | + | ||
| - | * A type of database design used in data warehousing composed of a large sized fact table combined with numerous dimension tables, i.e., parent tables branched to child tables. | + | |
| - | + | ||
| - | **summary table** | + | |
| - | + | ||
| - | * A table containing pre-summarized data, typically used in ROLAP data warehousing, used to perform fast look-ups against specific, predictable combinations of criteria. | + | |
| - | * Omnidex aggregation indexes eliminate the need for summary tables. | + | |
| - | + | ||
| - | **superview** | + | |
| - | + | ||
| - | * The technique of flatening out multiple tables into a single table to facilitate very high-speed Omnidex access. | + | |
| - | + | ||
| - | **synchronous** | + | |
| - | + | ||
| - | * A process that is executed in conjunction with another process | + | |
| - | * In Omnidex, index updates that are update at the same time that the data updates occur. | + | |
| - | + | ||
| - | **System Data Source** | + | |
| - | + | ||
| - | * Windows only. An ODBC data source that is stored in the System's registry. An Omnidex data source can be a System Data Source. | + | |
| + | ==== System Data Source ==== | ||
| + | * Windows only. An ODBC data source that is stored in the System's registry. An Omnidex data source can be a System Data Source. | ||
| {{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} | ||