Actionable intelligence
Read more
Ad Hoc Reporting
Read more
Big Data
Read more
Business Intelligence
Read more
Cloud Computing
The cloud, or cloud computing, is a type of storage that uses a network of physical locations to store software, hardware and services that run on the internet rather than on your device. The cloud is an all-encompassing term that includes Read more
Cognitive Analytics
Cognitive Analytics is intelligent technology that covers multiple analytical techniques to analyze large data sets and give structure to the unstructured data. To put it simply, a cognitive analytics system searches through the data that exists in its knowledge base Read more
Collaboration
Read more
Dashboard
Read more
Data Aggregation
Read more
Data Exploration
Read more
Data Governance
Read more
Data Lake
Read more
Data Mashing
Read more
Data Mining
Read more
Data Modeling & Management
Build the Reports That You Need When You Need Them Data Modeling & Management Orbit’s data modeling functionality achieves highly-tuned queries by identifying the objects needed from multidimensional data relationships. You can build reports as per your business requirements to Read more
Data Scientist
Read more
Data Security
Read more
Data Visualization Dashboards
Simple, Intuitive, and Powerful Dashboards Data Visualization: Dashboards Orbit Reporting and Analytics brings all of your data together in real-time and interactive dashboards, so you can gain a clear view of your business – at a glance. View Data from Read more
Data Warehouse
Read more
Data Wrangling
Read more
Descriptive Analytics
Read more
Edge Analytics
Edge analytics is a method of data collection and analysis that uses an automated analytical data computation that is performed at a sensor or other device. This is performed before the data is sent to a centralized store. This process Read more
Financial Statements
Financial statements are reports on companies’ spending and fiscal positions. These statements can be audited by the government to prevent tax fraud and other illegal activities. Financial analysts use these statements to analyze a company’s performance, then use that information Read more
Hierarchies
These are the methods which use parent-child relationship to drill up/down the data. Hierarchies use parent-child relationships within the data, so that a user can go deeper in order to gain a better insight into the information they are responsible Read more
Hybrid Cloud
Hybrid cloud infrastructure is a combination of at least two cloud infrastructures, such as private, public or community, that remain individual but are connected by standardized technologies that allow data portability. On its most basic level, this means that hybrid Read more
JD Edwards
JD Edwards is a suite of enterprise resource planning (ERP) software from Oracle. Focused on a modern and simplified user experience, the purpose-built applications are aligned to create a seamless experience for end users that’s integrated with digital technologies. JD Read more
Key Performance Indicator (KPI)
A measure of key business objectives of an organization. A Key Performance Indicator (KPI) is a measure that determines how effectively, or ineffectively, organizations, projects or individuals achieve their key business objectives compared to their strategic objectives and targets. With Read more
Metadata
Metadata is data that contains information about other data. Metadata, in general, is used almost everywhere. The most common example is the use of meta tags in a web page. Search engines use these meta tags to identify a web Read more
Mobile BI
Mobile Business Intelligence (Mobile BI) is software that allows BI data to be viewed on a mobile device. Mobile BI has just recently become popular among BI users, and is helpful for remote workers that need information but do not Read more
Multi-tenant
Read more
OLAP
Read more
On-Premises
On-premises architecture is comprised of data, software and applications that are installed and operated from an in-house server and computing infrastructure. It utilizes the organization’s native computing resources. It is the traditional method for storing data and running enterprise applications, Read more
Pivot Table/Crosstab
Pivot tables and crosstabs are ways to display and analyze sets of data. Both are similar to each other, with pivot tables having just a few added features. Pivot tables and crosstabs present data in tabular format, with rows and Read more
Pixel Perfect (Printable Reports)
Pixel perfect describes reports where the user can manipulate the size and layout with precision. This includes allowing the user to change the size of the report, the size of the printed page, and the position of the different elements Read more
Predictive Analytics
A part of advanced analytics to make future forecasts. Predictive analytics are a part of advanced analytics that provide a probable picture of what might happen in the future. Considering the previous behaviors from the descriptive analytics, predictive analytics might Read more
Prescriptive Analytics
It provides a best course of action taking a clue from predictive and descriptive analytics. Prescriptive Analytics is the final stage of Business Analytics (BA) that takes insights from descriptive and predictive analytics to identify the best course action for Read more
Query
A database query is a means for extracting data from a database and formatting it in a readable form. When you’re searching for data from a database, you can submit a query to request specific information. However, a query needs Read more
SAP HANA
Read more
Scheduling
An automated process of refreshing the jobs or reports on a regular basis. Scheduling is a process of planning any event or a job at a required time. Similarly, on the technical front, scheduling helps in automating the required procedure Read more
Subject Area Modeling
An initial level of Enterprise Data Model (EDM), which provides a structure for organizing EDM by Subject Areas. A Subject Area Model, together with a Conceptual Model and a Conceptual Entity Model forms the complete structure of the Enterprise Data Read more
Tabular Data
The term “tabular” refers to data that is displayed in columns or tables, which can be created by most BI tools. These tools find relationships between data entries in one or more database, then use those relationships to display the Read more
Taleo
The Oracle Talent Acquisition Cloud (Taleo) is a data-enriched talent management software suite that helps organizations find, develop and retain prime talent. Taleo History Oracle acquired this cloud-based talent management software in 2012, though it was founded in 1999 by Read more
Home | Glossary

OLTP

OLTP is an initialism for Online Transaction Processing. This is a type of software program that is designed to support transaction-oriented application processing.

Online transaction processing systems are used in business for handling processes like financial transactions, order entries, customer relationship management, and retail sales. OLTP is characterized by numerous short online transactions that involve inserting, updating, and deleting data belonging to individual records in a database.

Online transaction processing is mainly used in industries that rely on the efficient processing of a large number of client transactions, such as airlines, banks, and retailers. Other examples of OLTP transactions include:

  • Online banking
  • Online purchases
  • Order entry
  • Telemarketing
  • Call centers

In terms of databases, a transaction is a sequence of operations that are performed as a single logical unit of work. A transaction will only be successful if the entire sequence is successful. If any aspect of the transaction fails, the whole transaction will fail. This property, called atomicity, requires that an OLTP system be able to fully rollback a transaction if it does not complete successfully.

For example, if a customer books a seat on a flight, atomicity allows both the reservation of the seat and the sale of the seat, which must happen simultaneously. Database systems that use OLTP are typically decentralized to avoid single points of failure, which spreads the query volume among several servers.

OLTP databases need to be ACID-compliant as well. ACID refers to a standardized set of properties that guarantee database transactions are processed reliably, accurately, and consistently. Other examples of OLTP application characteristics include:

  • Transactions that involve small amounts of data
  • Indexed data access
  • Multiple users
  • Frequent updates and queries
  • Fast response times

OLTP differs from OLAP (Online Analytic Processing), which is analytical and used to provide input data to data warehouses. OLAP analytics are often derived from data capture via an OLTP application. Because of this, OLTP and OLAP may work with the same data sets, but for different purposes.
OLTP can provide a snapshot of current business processes, whereas OLAP offers multi-dimensional views of business metrics over time. Because OLAP involves querying tens of thousands or millions of database records for analytical use, OLAP databases and systems are designed to optimize queries, not transactions.

Turn Your Data Challenges Into Opportunities. Get Started TODAY.


    Featured Resources / Insights

    Fact Sheet

    GLSense: Integrated Financial Reporting for Excel Users

    Download now

    Whitepaper

    Your Guide to Choosing the Right GL Reporting Solution for Oracle Fusion Cloud ERP

    Download now

    Webinar

    Unified Reporting from Oracle EBS, Oracle Cloud and Beyond

    Access now

    Blogs