Actionable intelligence
Actionable intelligence is information that can give a company a strategic advantage over its competitors when acted upon. The term “actionable” indicates that actions can, and should, be made to take advantage of the information. Actionable intelligence comes into picture Read more
Ad Hoc Reporting
Data discovery made easy Most business reporting needs are ad hoc. Orbit makes it easy for users to create ad hoc reports with data from on premise and cloud applications like Oracle EBS, Salesforce and NetSuite – even Excel files. Read more
Big Data
Big data is a general term for larger and less structured data sets coming from a wide variety of modern data sources such as social media and the Internet of Things. Its size and complexity creates challenges for traditional data Read more
Business Intelligence
Business Intelligence is a process that performs data analysis and presents the information to the end users in such a way that they can make informed business decisions. Business Intelligence analyzes past and current data and provides organizations an insight 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
Collaboration is the action of working with others to achieve a certain goal. With analytics, this can refer to two or more people using the same data set, working on the same report, or creating separate reports that relate to Read more
Dashboard
A Visualization Tool to Monitor KPIs and Metrics A dashboard is a visualization tool that tracks, analyzes and exhibits the status of key performance indicators (KPIs). Dashboards are a one-stop location that combines and displays various performance metrics and numbers Read more
Data Aggregation
Data aggregation is the process where data is collected and presented in a summarized format for statistical analysis and to effectively achieve business objectives. Data aggregation is vital to data warehousing as it helps to make decisions based on vast Read more
Data Exploration
Data exploration is the process of describing the main characteristics of a set of data. This is often the first step people take when performing data analysis. During this process, the analyst decides which questions the data is going to Read more
Data Governance
In today’s fast-paced and highly competitive business environment, data governance is more important than ever. Businesses have the chance to capture large amounts of data from various sources, but they also need a way to maximize the value, manage the Read more
Data Lake
A data lake is a centralized repository that offers storage for both structured and unstructured data, regardless of scale, and allows multiple types of analytics to guide business processes. Data lakes contain raw-form data from all data sources, and they Read more
Data Mashing
A process of combining heterogeneous data from multiple sources. Data Mashing is the process of integrating business-related heterogeneous and application data from numerous sources to give a more unified view from a “big picture” perspective. Usually, mashing is a process Read more
Data Mining
Data Mining is the process of uncovering hidden information or patterns from large data sets. Data is extracted from large databases using statistics, artificial intelligence, decision trees, machine learning, etc. The primary goal of the data mining process is to 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
Data science uses scientific methods, algorithms, processes and systems to gain insights from data. The end result of their methods are usually charts or other visualizations that reveal trends and produce insights to inform the decision-making process and thus help Read more
Data Security
Data security means protecting data in a database, personal computer or network from unauthorized users. In general, data can range from personal files to any corporate analytics information. Though some information is intended for general use, there might be some 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
A data warehouse is loaded with data from numerous heterogeneous sources into a central repository for analytics. Data warehouses store multidimensional information in a way that allows analytics to be efficiently performed. Data warehousing helps organizations in effective decision-making, and Read more
Data Wrangling
Data wrangling is a method of gathering, choosing and transforming data to answer an analytical question. Often referred to as “munging” or data cleaning, data wrangling makes up approximately 80 percent of a data scientist’s time, with the rest devoted Read more
Descriptive Analytics
An initial stage of business analytics to summarize historic data. Descriptive Analytics, a preliminary stage of data processing, exemplifies retrospective analysis that drills through the past behaviors and provides an insight into the future outcomes. Descriptive Analytics, famously known as 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
Multi-tenant architecture uses a single instance of a software application to serve multiple customer organizations, called tenants. Tenants are a group of users who share a common access point to the software. The systems that operate this way share the Read more
OLAP
Online Analytical Processing, also known as OLAP, is an approach to view and analyze multidimensional data from multiple perspectives. Unlike OLTP (online transaction processing), which is useful in transaction processing (involving less complex querying), OLAP deals with business intelligence and 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
SAP HANA (short for “high-performance analytic appliance”) is an in-memory relational database management system that allows the rapid processing of large sets of data in real time. Having computational power in-memory gives HANA the ability to process the data stored 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

    Exploring Orbit Analytics Add-Ons and Plugins for Excel

    Sep 12, 2024

    Excel is an excellent tool for working with data, and with add-ons and plugins, Excel becomes an extra powerful tool that automates tasks, saves time and enhances efficiency. Orbit Analytics offers powerful add-ons and plugins for Excel that magnify its capabilities,...

    read more