• Online transaction processing (OLTP) is a type of database system used in transaction-oriented applications, such as many operational systems. "Online"...
    10 KB (1,124 words) - 13:26, 16 June 2024
  • provide the scalability of NoSQL systems for online transaction processing (OLTP) workloads while maintaining the ACID guarantees of a traditional database...
    7 KB (655 words) - 13:44, 9 June 2024
  • Thumbnail for Data warehouse
    transaction processing (OLTP) is characterized by a large number of short on-line transactions (INSERT, UPDATE, DELETE). OLTP systems emphasize very fast...
    38 KB (4,883 words) - 18:54, 10 May 2024
  • commonly used for running online transaction processing (OLTP), data warehousing (DW) and mixed (OLTP & DW) database workloads. Oracle Database is available...
    25 KB (1,462 words) - 08:46, 17 July 2024
  • row-oriented formats are more commonly used in Online transaction processing (OLTP) and column-oriented formats are more commonly used in Online analytical...
    7 KB (803 words) - 14:05, 12 July 2024
  • Thumbnail for SAP HANA
    column-oriented search engine), P*TIME (in-memory online transaction processing (OLTP) Platform acquired by SAP in 2005), and MaxDB with its in-memory liveCache...
    31 KB (3,002 words) - 16:41, 5 July 2024
  • instantaneous data processing, or online transaction processing (OLTP), led to widespread OLTP use in government and business-sector information systems. Online...
    8 KB (882 words) - 16:01, 5 July 2024
  • Thumbnail for Oracle Exadata
    Service. Exadata is designed to run all Oracle Database workloads, such as OLTP, Data Warehousing, Analytics, and AI vector processing, often with multiple...
    9 KB (466 words) - 18:15, 11 July 2024
  • Hekaton (also known as SQL Server In-Memory OLTP) is an in-memory database for OLTP workloads built into Microsoft SQL Server. Hekaton was designed in...
    5 KB (329 words) - 15:58, 5 July 2024
  • Operational database management systems (also referred to as OLTP databases or online transaction processing databases), are used to update data in real-time...
    8 KB (627 words) - 11:50, 24 June 2024
  • Thumbnail for TPC-C
    benchmark used to compare the performance of online transaction processing (OLTP) systems. This industry standard was published in August 1992, and eventually...
    16 KB (2,284 words) - 01:03, 28 December 2023
  • Oracle PL/SQL Microsoft Transact-SQL (T-SQL) Online transaction processing (OLTP) Online analytical processing (OLAP) Data warehouse Relational data stream...
    39 KB (3,754 words) - 05:02, 11 May 2024
  • databases (for example, SQLite) DuckDB is not focusing on transactional (OLTP) applications and instead is specialized for online analytical processing...
    6 KB (538 words) - 15:39, 17 June 2024
  • modification of the traditional database term online transaction processing (OLTP). OLAP tools enable users to analyse multidimensional data interactively...
    37 KB (4,469 words) - 16:22, 18 July 2024
  • workloads, commonly referred to as HTAP workloads, as well as more traditional OLTP and OLAP use cases. For queries, it compiles Structured Query Language (SQL)...
    17 KB (1,684 words) - 15:55, 18 June 2024
  • Thumbnail for Greenplum
    in OLTP performance. Greenplum 6 was reviewed in the media by several sources and mentioned for its Postgres open source alignment and for its OLTP performance...
    13 KB (1,270 words) - 15:57, 5 July 2024
  • Apache TinkerPop of the Apache Software Foundation. Gremlin works for both OLTP-based graph databases as well as OLAP-based graph processors. Gremlin's automata...
    14 KB (1,478 words) - 16:27, 18 January 2024
  • Thumbnail for Extract, transform, load
    discovery Online analytical processing (OLAP) Online transaction processing (OLTP) Spatial ETL Ralph., Kimball (2004). The data warehouse ETL toolkit : practical...
    27 KB (3,832 words) - 15:00, 4 June 2024
  • in September 2020. TiDB can support both online transaction processing (OLTP) and online analytical processing (OLAP) workloads. TiDB has two storage...
    13 KB (1,058 words) - 12:08, 11 March 2024
  • Michael (June 16, 2011). "NewSQL: An Alternative to NoSQL and Old SQL for New OLTP Apps". Communications of the ACM Blog. Retrieved February 22, 2020. Hoff...
    19 KB (1,876 words) - 13:32, 14 June 2024
  • Thumbnail for Solid-state drive
    such as write caching, I/O acceleration, and online transaction processing (OLTP). The PX02SS series uses 12 Gbit/s SAS interface, featuring MLC NAND flash...
    192 KB (16,528 words) - 23:13, 8 July 2024
  • modeling; Gremlin is an Apache Software Foundation graph traversal language for OLTP and OLAP graph systems. GraphQL is a data query language developed by Facebook...
    8 KB (928 words) - 15:56, 29 May 2024
  • Thumbnail for Informix
    functionality. The Informix database has been used in many high transaction rate OLTP applications in the retail, finance, energy and utilities, manufacturing...
    14 KB (1,428 words) - 17:22, 18 March 2024
  • implementation. Tests conducted by Red Hat showed a doubling in performance for OLTP benchmarks. Extended Page Tables (EPT) is an Intel second-generation x86...
    17 KB (1,793 words) - 16:42, 5 July 2024
  • shared-nothing architecture, and is derived from work done by Stonebraker on OLTP system performance and optimization. It is available in both enterprise and...
    12 KB (1,184 words) - 05:55, 1 May 2024
  • workloads as well as hyper-scale big data and streaming workloads including OLTP, data warehousing, Spark, machine learning, text search, image analytics...
    17 KB (1,697 words) - 20:45, 13 May 2024
  • callback Claim check SOA Data architecture Transaction data stores (TDS/OLTP) Master data store Operational data store Big data Data mart Data warehouse...
    12 KB (964 words) - 16:41, 12 June 2024
  • index."1 For database query optimizers, sargable is an important property in OLTP workloads because it suggests a good query plan can be obtained by a simple...
    6 KB (756 words) - 14:13, 29 February 2024
  • processing, as contrasted to interactive online transaction processing (OLTP) applications. The extract, transform, load (ETL) step in populating data...
    17 KB (1,951 words) - 14:35, 29 March 2024
  • Computerworld withdrew the paper. In contrast to "on-line transaction processing" (OLTP), OLAP defines a database technology optimized for processing human queries...
    22 KB (2,493 words) - 06:03, 19 May 2024