Oracle Database / Applications Definitions

This glossary explains the meaning of key words and phrases that information technology (IT) and business professionals use when discussing Oracle and related software products. You can find additional definitions by visiting WhatIs.com or using the search box below.

  • #

    10g

    10g is Oracle's grid computing product group including (among other things) a database management system (DBMS) and an application server. In addition to supporting grid computing features such as resource sharing and automatic load balancing. (Continued...)

  • A

    AS2 (Applicability Statement 2)

    AS2 (Applicability Statement 2) is a specification for Electronic Data Interchange (EDI) between businesses using the Internet's Web page protocol, the Hypertext Transfer Protocol (HTTP).

  • autonomous transaction

    In Oracle's database products, an autonomous transaction is an independent transaction that is initiated by another transaction.

  • B

    bioinformatics

    Bioinformatics is the science of developing computer databases and algorithms for the purpose of speeding up and enhancing biological research.

  • C

    CFML (ColdFusion Markup Language)

    CFML (ColdFusion Markup Language) is a Web page markup language that allows a Web site developer to create pages with variable information (text or graphics) that is filled in dynamically (on the fly) in response to variables such as user input.

  • concurrent processing

    Concurrent processing is a computing model in which multiple processors execute instructions simultaneously for better performance.

  • correlated subquery

    A correlated subquery is a SQL query that depends on values executed by the outer query in order to complete.

  • D

    delimiter

    In computer programming, a delimiter is a character that identifies the beginning or the end of a character string (a contiguous sequence of characters).

  • distributed database

    A distributed database is a database that consists of two or more files located in different sites either on the same network or on entirely different networks.

  • DSML (Directory Services Markup Language)

    DSML (Directory Services Markup Language) is an application of the Extensible Markup Language (XML) that enables different computer network directory formats to be expressed in a common format and shared by different directory systems.

  • dynamic SQL (Dynamic Structured Query Language)

    Dynamic SQL is an enhanced form of Structured Query Language (SQL) that, unlike standard (or static) SQL, facilitates the automatic generation and execution of program statements.

  • E

    E. F. Codd (Edgar F. "Ted" Codd)

    E. F. Codd (Edgar F. "Ted" Codd) formed the concepts for organizing and accessing data that are embodied in the relational database, the predominant approach to data organization in today's business world.

  • Exadata

    Exadata (also called Oracle Exadata Database Machine) in-memory database appliance that supports OLTP (transactional) and OLAP (analytical) database systems.

  • Oracle extents

    Oracle extents are a set of contiguous blocks allocated in an Oracle database.

  • F

    field

    A field is an area in a fixed or known location in a unit of data such as a record, message header, or computer instruction that has a purpose and usually a fixed size.

  • flexfield

    In an Oracle environment, a flexfield is a database field that has flexibility built into it so that users can define reporting structures that are relevant to their specific organizations.

  • foreign key

    A foreign key is a column or columns of data in one table that connects to the primary key data in the original table.

  • G

    Good Automated Laboratory Practices (GALP)

    Good Automated Laboratory Practices (GALP) is a standardized set of best practices that are used to ensure data integrity for laboratory data that is gathered, processed, and archived by a laboratory information management system (LIMS).

  • J

    JD Edwards EnterpriseOne

    JD Edwards EnterpriseOne is a suite of enterprise resource planning (ERP) software that is developed and sold by Oracle Corp.

  • M

    metabase (metadatabase or metadata repository)

    A metabase (sometimes called a metadatabase or metadata repository) is a database for storing metadata (data that describes data) for a specific purpose.

  • metadata repository

    A metadata repository is a database of data about data (metadata).

  • metainformation

    Metainformation is information about information.

  • multidimensional database (MDB)

    A multidimensional database (MDB) is a type of database that is optimized for data warehouse and online analytical processing (OLAP) applications. Multidimensional databases are frequently created using input from existing relational databases.

  • MySQL

    MySQL is a relational database management system (RDBMS) based on SQL (Structured Query Language).

  • MySQL Connector/ODBC (Connector ODBC or MyODBC)

    MySQL Connector/ODBC (sometimes called just Connector ODBC or MyODBC) is a driver for connecting to a MySQL database server through the Open Database Connectivity (ODBC) application program interface (API), which is the standard means of connecting to any database. Users can connect from within common applications and programming environments, such as Microsoft Access or Excel or Borland Delphi.

  • N

    NetSuite

    NetSuite is a business technology vendor based in San Mateo, California.

  • O

    object-oriented database management system (OODBMS)

    An object-oriented database management system (OODBMS), sometimes shortened to ODBMS for object database management system, is a database management system (DBMS) that supports the modelling and creation of data as objects.

  • Open Database Connectivity (ODBC)

    Open Database Connectivity (ODBC) is an open standard application programming interface (API) for accessing a database.

  • operational data store (ODS)

    An operational data store (ODS) is a type of database that's often used as an interim logical area for a data warehouse.

  • Oracle

    Oracle is one of the largest vendors in the enterprise IT market and the shorthand name of its flagship product, a relational database management system (RDBMS) that's formally called Oracle Database.

  • Oracle Autonomous Database

    Oracle Autonomous Database is a cloud-based technology designed to automate many of the routine tasks required to manage Oracle databases, which Oracle says can free up database administrators (DBAs) to do higher-level and more strategic work.

  • Oracle Communications Network Charging and Control (OCNCC)

    Oracle Communications Network Charging and Control (OCNCC) is a product from the telecommunications industry used for real-time charging and session control.

  • Oracle Database 12c

    The Oracle Database 12c is a high-performance, enterprise-class database.

  • Oracle Database In-Memory

    Oracle Database In-Memory is an optional add-on to Oracle Database 12c that enables Oracle's flagship relational software to function as an in-memory database.

  • Oracle E-Business Suite

    Oracle E-Business Suite is a set of applications for managing business operations, including customer relationship management, enterprise resource planning and supply chain management processes.

  • Oracle Fusion Applications

    Oracle Fusion Applications is an all-encompassing suite of Oracle applications built for enterprise resource planning (ERP), customer relationship management (CRM), human capital management (HCM) and other business tasks.

  • Oracle Hyperion

    Hyperion is the business division of Oracle that's known for corporate performance management (CPM) and business intelligence systems. 

  • Oracle Mobile Security Suite (OMSS)

    Oracle Mobile Security Suite (OMSS) is a mobile security system intended to allow organizations to provide secure application access from mobile devices to enterprise applications.

  • Oracle NoSQL Database

    The Oracle NoSQL Database is a nonrelational, horizontally scalable key-value database, with multiple higher-level data abstractions that support data management as binary key-value pairs, JSON objects, and SQL-like tables.

  • Oracle TimesTen In-Memory Database

    The Oracle TimesTen In-Memory Database is an in-memory relational database in which all data is located in random access memory (RAM).

  • P

    PeopleSoft

    PeopleSoft is an e-business software product line owned by Oracle.

  • Pick

    Pick is a data base management system (DMS) based on a business model of data and its organization and traditionally associated with minicomputer systems for small- to medium-size businesses.

  • PL/SQL (procedural language extension to Structured Query Language)

    In Oracle database management, PL/SQL is a procedural language extension to Structured Query Language (SQL).

  • Q

    quad tree

    A quad tree is a method of placing and locating files (called records or keys) in a database.

  • Query by Example (QBE)

    Query by Example (QBE) is a method of query creation that allows the user to search for documents based on an example in the form of a selected text string or in the form of a document name or a list of documents.

  • R

    Real Application Cluster (RAC)

    Real Application Cluster (RAC) is a component of the Oracle 9i database product that allows a database to be installed across multiple servers... (Continued)

  • record

    In computer data processing, a record is a collection of data items arranged for processing by a program.

  • relational online analytical processing (ROLAP)

    Relational online analytical processing (ROLAP) is a form of online analytical processing (OLAP) that performs dynamic multidimensional analysis of data stored in a relational database rather than in a multidimensional database (which is usually considered the OLAP standard).

  • repository

    In information technology, a repository (pronounced ree-PAHZ-ih-tor-i) is a central place in which an aggregation of data is kept and maintained in an organized way, usually in computer storage.

  • responsibility

    In an Oracle environment, a responsibility is a defined user right, similar to the word privilege in some other settings.

  • row

    In a database, a row (sometimes called a record) is the set of fields within a table that are relevant to a specific entity.

  • S

    sharding

    Sharding is a type of database partitioning that is used to separate very large databases the into smaller, faster, more easily managed pieces called data shards.

  • Solaris

    Solaris is the computer operating system that Sun Microsystems provides for its family of Scalable Processor Architecture-based processors as well as for Intel-based processors.

  • splay tree

    A splay tree is a self-adjusting search algorithm for placing and locating files (called records or keys) in a database.

  • stored procedure

    A stored procedure is a group of statements with a specific name, which are stored inside a database, such as MySQL or Oracle.

  • T

    The Open Group

    The Open Group is a software standards organization that is sponsored by a number of major software vendors.

  • V

    Very Large Database (VLDB)

    While there is apparently no official or standard definition for the term Very Large Database (VLDB), it is sometimes used to describe databases occupying magnetic storage in the terabyte range and containing billions of table rows.

  • virtual (federated) database

    A virtual database, also called a federated database, is a system in which several databases appear to function as a single entity.

  • virtual private database (VPD)

    A Virtual Private Database (VPD) makes the database tables seem like they belong to one user when multiple users may actually be using that table.

  • Z

    Z39.50

    Z39.50 is a standard communications protocol for the search and retrieval of bibliographic data in online databases.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close