Database Glossary – O
Useful Terms For Working With Data
ODBC (Open Database Connectivity)
A Microsoft-developed standard for database software from different manufacturers and on different computers that enables users to share data through ODBC drivers (or translators). ODBC is defined by an international (ISO) and a national (ANSI) standard. The most recent version is called SQL-92. (There are now at least 4 different ODBC “standards”, and not every software maker’s implementation is fully compatible with all the others.)
OLAP (Online Analytical Processing)
The OLAP Council defines online analytical processing as, “A category of software technology that enables analysis, managers and executives to gain insight into data through fast, consistent, interactive access to wide variety of possible views of information that have been transformed from raw data to reflect the real dimensionality of the enterprise as understood by the user.”
See: Relationship, One-to-One.
Online Analytical Processing
Open Database Connectivity
A defined process that modifies data, performs calculations using data, imports or exports data, or otherwise manipulates data in some way.
See also: Task.
Systems that run the day-to-day business for companies.
See: Join, Outer.