https://www.omnidex.com/docs/v51/ 2026-04-23T09:18:37+0000 https://www.omnidex.com/docs/v51/ https://www.omnidex.com/docs/v51/lib/tpl/simple/images/favicon.ico text/html 2012-10-26T14:46:10+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=glossary:a&rev=1351262770&do=diff Glossary A Index A B C D E F G H I J K L M N O P Q R S T U V W X Y Z $ Glossary Access method * The process of operating in a database to store or retrieve data * The movement of physical data to and from a computer and its storage devices text/html 2012-10-26T14:46:10+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=glossary:b&rev=1351262770&do=diff Glossary B Index A B C D E F G H I J K L M N O P Q R S T U V W X Y Z $ Glossary Back out feature * The ability to undo a QUAFLIFY keyword search and to restore the previous internal ID list. Bitmap index * An indexing option which stores index pointer as a bitmap, providing efficient indexing for text/html 2012-10-26T14:46:10+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=glossary:c&rev=1351262770&do=diff Glossary C Index A B C D E F G H I J K L M N O P Q R S T U V W X Y Z $ Glossary C String Omnidex Datatype * A legacy Omnidex datatype name that is now referred to “String”. A datatype in Omnidex that refers to a string terminated with a null just like strings in the C language. C Strings are used as a return data type from many Omnidex SQL Functions. C Strings are recommended over the Varchar datatype because of internal performance. text/html 2012-10-26T14:46:10+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=glossary:d&rev=1351262770&do=diff Glossary D Index A B C D E F G H I J K L M N O P Q R S T U V W X Y Z $ Glossary 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 text/html 2012-10-26T14:46:10+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=glossary:dollarsign&rev=1351262770&do=diff Glossary $ Index A B C D E F G H I J K L M N O P Q R S T U V W X Y Z $ Glossary $function - Omnidex Extended SQL Function * SQL Functions that are preceded with a $ are Omnidex Extended functions beyond the SQL Standard. * See also SQL Functions $omnidex * text/html 2012-10-26T14:46:11+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=glossary:e&rev=1351262771&do=diff Glossary E Index A B C D E F G H I J K L M N O P Q R S T U V W X Y Z $ Glossary Environment An Environment, also know as an Omnidex Environment is the combination of: * An Omnidex Environment File containing metadata * Connection to one or more databases or raw data files text/html 2012-10-26T14:46:11+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=glossary:f&rev=1351262771&do=diff Glossary F Index A B C D E F G H I J K L M N O P Q R S T U V W X Y Z $ Glossary Fact table * A single child table in a data warehouse containing potentially repetitive information, surrounded by parent tables (dimension tables) that are used to provide keyed retrievals of unique rows from the child table; text/html 2012-10-26T14:46:11+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=glossary:g&rev=1351262771&do=diff Glossary G Index A B C D E F G H I J K L M N O P Q R S T U V W X Y Z $ Glossary Gateway * As a network term, a protocol server; * As a Web term, an interface between an external source of information and a Web server. Geo Search General intrinsics text/html 2012-10-26T14:46:11+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=glossary:h&rev=1351262771&do=diff Glossary H Index A B C D E F G H I J K L M N O P Q R S T U V W X Y Z $ Glossary Hashed key * a database key facilitating direct access to data on a storage device. See key and direct access. Hashing * An indexing technique where an algorithm is used to calculate the location of a row or record, requiring a full key look-up and an exact match, including upper and lower case characters, spaces, and punctuation. text/html 2012-10-26T14:46:11+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=glossary:home&rev=1351262771&do=diff Glossary Index A B C D E F G H I J K L M N O P Q R S T U V W X Y Z $ Glossary text/html 2012-10-26T14:46:11+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=glossary:i&rev=1351262771&do=diff Glossary I Index A B C D E F G H I J K L M N O P Q R S T U V W X Y Z $ Glossary Internal ID list ID * a 4-byte integer that is most often sequentially-ascending and which starts at 1, except when the Search Item (SI) is a 4-byte integer. Ill-behaved row ID text/html 2012-10-26T14:46:11+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=glossary:j&rev=1351262771&do=diff Glossary J Index A B C D E F G H I J K L M N O P Q R S T U V W X Y Z $ Glossary Java * Programming language widely used for web programming developed by Sun Microsystems. JDBC * Java database connectivity standard defined by Sun Microsystems as an extension to the Java programming language. text/html 2012-10-26T14:46:11+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=glossary:k&rev=1351262771&do=diff Glossary K Index A B C D E F G H I J K L M N O P Q R S T U V W X Y Z $ Glossary Key * a field, or column, that is used to select records from a data set, providing fast access to rows. Keys are typically indexed, uniquely identify parent rows, and provide a correlation for joining tables and maintaining data integrity across tables. See also Native keys and OMNIDEX indexes. text/html 2012-10-26T14:46:11+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=glossary:l&rev=1351262771&do=diff Glossary L Index A B C D E F G H I J K L M N O P Q R S T U V W X Y Z $ Glossary Left outer join * An outer join in which all rows from the left table in the JOIN clause are included, only rows from the right table with matching rows in the left table are included, and left table rows with no matching right table rows are matched with nulls. text/html 2012-10-26T14:46:11+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=glossary:m&rev=1351262771&do=diff Glossary M Index A B C D E F G H I J K L M N O P Q R S T U V W X Y Z $ Glossary MDD * Multidimensional Database; a database architecture used to perform OLAP by summarizing data into a special database structure. See OLAP. MDK * Multi-Dimensional Keyword. MDK is used as an abbreviation in things like Explain Plans or OdxSQL Show Table prior to version 5.1 text/html 2012-10-26T14:46:11+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=glossary:n&rev=1351262771&do=diff Glossary N Index A B C D E F G H I J K L M N O P Q R S T U V W X Y Z $ Glossary Native key * A key (index) defined for a database or system of files before OMNIDEX was installed on it. OMNIDEX uses native keys when prejoining tables. Network transport text/html 2012-10-26T14:46:11+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=glossary:o&rev=1351262771&do=diff Glossary O Index A B C D E F G H I J K L M N O P Q R S T U V W X Y Z $ Glossary Object * an entity within the Environment that can be accessed and manipulated, a column definition, for example. ODBC * Open Database Connectivity; (1) a standard for accessing different databases from PCs or other small workstations, providing a common SQL-based method for translating requests into the database tool's native SQL (2) software developed by Microsoft that e… text/html 2012-10-26T14:46:11+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=glossary:p&rev=1351262771&do=diff Glossary P Index A B C D E F G H I J K L M N O P Q R S T U V W X Y Z $ Glossary Parent key * the column within a parent table that uniquely identifies rows or records containing the same values. * Also known as Primary Key. * See also: key text/html 2012-10-26T14:46:11+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=glossary:q&rev=1351262771&do=diff Glossary Q Index A B C D E F G H I J K L M N O P Q R S T U V W X Y Z $ Glossary Qualified subset * The list of rows established and refined by searches of keyword keys. You can either retrieve the rows represented in the qualified subset by calling oaselect and oafetch, or you can further qualify the rows by successive calls to oaqualify. text/html 2012-10-26T14:46:11+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=glossary:r&rev=1351262771&do=diff Glossary R Index A B C D E F G H I J K L M N O P Q R S T U V W X Y Z $ Glossary RC * Record Complex - a type of Omnidex Domain where child records are collectively indexed together with the parent record. RC child * A child table which is indexed with only primary keys (from parent table). See Record Complex. text/html 2012-10-26T14:46:12+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=glossary:s&rev=1351262772&do=diff Glossary S Index A B C D E F G H I J K L M N O P Q R S T U V W X Y Z $ Glossary Samelist * Refers to a previously qualified list of Omnidex ids. Used in multiple qualifies to refine queries. Samelist operators * AND, NOT, AND NOT (AND_NOT in oaqualify) text/html 2012-10-26T14:46:12+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=glossary:t&rev=1351262772&do=diff Glossary T Index A B C D E F G H I J K L M N O P Q R S T U V W X Y Z $ Glossary Table * A collection of data typically organized in two or more dimensions, usually by row and column (or field). Table cardinality * The number of rows in a table. See also: column cardinality, cardinality. text/html 2012-10-26T14:46:12+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=glossary:u&rev=1351262772&do=diff Glossary U Index A B C D E F G H I J K L M N O P Q R S T U V W X Y Z $ Glossary Unique key * any column (preferably indexed) that uniquely identifies individual rows in a parent table. Unlinked child tables * child tables that are not prejoined to a parent table during OMNIDEX installation. text/html 2012-10-26T14:46:12+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=glossary:v&rev=1351262772&do=diff Glossary V Index A B C D E F G H I J K L M N O P Q R S T U V W X Y Z $ Glossary text/html 2012-10-26T14:46:12+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=glossary:w&rev=1351262772&do=diff Glossary W Index A B C D E F G H I J K L M N O P Q R S T U V W X Y Z $ Glossary Wall time * Elapsed time as clock time or real time, as contrasted with CPU or system resource time. Well-behaved rowids * Unique record designations in a database table or set of data that are neatly sequential; for example, the first record is identified as row ID 1, the second record in the series is row ID 2, the third record is numbered 3, and so on. See record number… text/html 2012-10-26T14:46:12+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=glossary:x&rev=1351262772&do=diff Glossary X Index A B C D E F G H I J K L M N O P Q R S T U V W X Y Z $ Glossary text/html 2012-10-26T14:46:12+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=glossary:y&rev=1351262772&do=diff Glossary Y Index A B C D E F G H I J K L M N O P Q R S T U V W X Y Z $ Glossary text/html 2012-10-26T14:46:12+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=glossary:z&rev=1351262772&do=diff Glossary Z Index A B C D E F G H I J K L M N O P Q R S T U V W X Y Z $ Glossary