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.

  • A

    autonomous transaction

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

  • C

    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.

  • 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

    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.

  • 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 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.

  • 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

    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.

  • 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.

  • 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.

  • V

    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.

SearchDataManagement
SearchBusinessAnalytics
SearchSAP
SearchSQLServer
TheServerSide.com
SearchDataCenter
SearchContentManagement
SearchHRSoftware
Close