US8782100B2 - Hybrid database table stored as both row and column store - Google Patents

Hybrid database table stored as both row and column store Download PDF

Info

Publication number
US8782100B2
US8782100B2 US13/334,777 US201113334777A US8782100B2 US 8782100 B2 US8782100 B2 US 8782100B2 US 201113334777 A US201113334777 A US 201113334777A US 8782100 B2 US8782100 B2 US 8782100B2
Authority
US
United States
Prior art keywords
row
store
column
data
records
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
US13/334,777
Other languages
English (en)
Other versions
US20130166554A1 (en
Inventor
Yongsik Yoon
Chanho Jeong
Juchang Lee
Chang Bin Song
Yong Sik Kwon
Sang Kyun Cha
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
SAP SE
Original Assignee
SAP SE
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by SAP SE filed Critical SAP SE
Priority to US13/334,777 priority Critical patent/US8782100B2/en
Assigned to SAP AG reassignment SAP AG ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS). Assignors: LEE, JUCHANG, CHA, SANG KYUN, JEONG, CHANHO, KWON, YONG SIK, SONG, CHANG BIN, YOON, YONGSIK
Priority to EP12006520.6A priority patent/EP2608072A1/fr
Priority to CN201210433383.2A priority patent/CN103177058B/zh
Publication of US20130166554A1 publication Critical patent/US20130166554A1/en
Priority to US14/299,843 priority patent/US9558258B2/en
Application granted granted Critical
Publication of US8782100B2 publication Critical patent/US8782100B2/en
Assigned to SAP SE reassignment SAP SE CHANGE OF NAME (SEE DOCUMENT FOR DETAILS). Assignors: SAP AG
Priority to US15/380,720 priority patent/US10664497B2/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • G06F17/245—
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28—Databases characterised by their database models, e.g. relational or object models
    • G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22—Indexing; Data structures therefor; Storage structures
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22—Indexing; Data structures therefor; Storage structures
    • G06F16/221—Column-oriented storage; Management thereof
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22—Indexing; Data structures therefor; Storage structures
    • G06F16/2228—Indexing structures
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • G06F16/278—Data partitioning, e.g. horizontal or vertical partitioning
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90—Details of database functions independent of the retrieved data types
    • G06F16/95—Retrieval from the web
    • G06F16/953—Querying, e.g. by the use of web search engines
    • G06F16/9535—Search customisation based on user profiles and personalisation
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23—Updating
    • G06F16/2379—Updates performed during online database operations; commit processing
    • G06F17/30321—
    • G06F17/30377—
US13/334,777 2011-12-22 2011-12-22 Hybrid database table stored as both row and column store Active US8782100B2 (en)

Priority Applications (5)

Application Number Priority Date Filing Date Title
US13/334,777 US8782100B2 (en) 2011-12-22 2011-12-22 Hybrid database table stored as both row and column store
EP12006520.6A EP2608072A1 (fr) 2011-12-22 2012-09-17 Table de base de données hybride stockée à la fois comme magasin de rangées et colonnes
CN201210433383.2A CN103177058B (zh) 2011-12-22 2012-09-28 存储为行存储和列存储二者的混合数据库表
US14/299,843 US9558258B2 (en) 2011-12-22 2014-06-09 Hybrid database table stored as both row and column store
US15/380,720 US10664497B2 (en) 2011-12-22 2016-12-15 Hybrid database table stored as both row and column store

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
US13/334,777 US8782100B2 (en) 2011-12-22 2011-12-22 Hybrid database table stored as both row and column store

Related Child Applications (1)

Application Number Title Priority Date Filing Date
US14/299,843 Continuation US9558258B2 (en) 2011-12-22 2014-06-09 Hybrid database table stored as both row and column store

Publications (2)

Publication Number Publication Date
US20130166554A1 US20130166554A1 (en) 2013-06-27
US8782100B2 true US8782100B2 (en) 2014-07-15

Family

ID=47178443

Family Applications (3)

Application Number Title Priority Date Filing Date
US13/334,777 Active US8782100B2 (en) 2011-12-22 2011-12-22 Hybrid database table stored as both row and column store
US14/299,843 Active 2032-02-18 US9558258B2 (en) 2011-12-22 2014-06-09 Hybrid database table stored as both row and column store
US15/380,720 Active 2033-07-20 US10664497B2 (en) 2011-12-22 2016-12-15 Hybrid database table stored as both row and column store

Family Applications After (2)

Application Number Title Priority Date Filing Date
US14/299,843 Active 2032-02-18 US9558258B2 (en) 2011-12-22 2014-06-09 Hybrid database table stored as both row and column store
US15/380,720 Active 2033-07-20 US10664497B2 (en) 2011-12-22 2016-12-15 Hybrid database table stored as both row and column store

Country Status (3)

Country Link
US (3) US8782100B2 (fr)
EP (1) EP2608072A1 (fr)
CN (1) CN103177058B (fr)

Cited By (20)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9569481B1 (en) * 2013-12-10 2017-02-14 Google Inc. Efficient locking of large data collections
US9852184B2 (en) 2014-11-03 2017-12-26 Sap Se Partition-aware distributed execution of window operator
US9904705B2 (en) 2015-06-08 2018-02-27 International Business Machines Corporation Data table performance optimization
US10095764B2 (en) 2015-06-19 2018-10-09 Sap Se Multi-replica asynchronous table replication
US10235440B2 (en) 2015-12-21 2019-03-19 Sap Se Decentralized transaction commit protocol
US10268743B2 (en) 2015-06-19 2019-04-23 Sap Se Distributed database transaction protocol
US10298702B2 (en) 2016-07-05 2019-05-21 Sap Se Parallelized replay of captured database workload
US10387395B2 (en) 2014-11-03 2019-08-20 Sap Se Parallelized execution of window operator
US10552413B2 (en) 2016-05-09 2020-02-04 Sap Se Database workload capture and replay
US10572510B2 (en) 2015-12-21 2020-02-25 Sap Se Distributed database transaction protocol
US10585873B2 (en) 2017-05-08 2020-03-10 Sap Se Atomic processing of compound database transactions that modify a metadata entity
US10592528B2 (en) 2017-02-27 2020-03-17 Sap Se Workload capture and replay for replicated database systems
US10698892B2 (en) 2018-04-10 2020-06-30 Sap Se Order-independent multi-record hash generation and data filtering
US10795881B2 (en) 2015-12-18 2020-10-06 Sap Se Table replication in a database environment
US10936578B2 (en) 2017-06-01 2021-03-02 Sap Se Client-driven commit of distributed write transactions in a database environment
US10977227B2 (en) 2017-06-06 2021-04-13 Sap Se Dynamic snapshot isolation protocol selection
US11347705B2 (en) 2019-04-02 2022-05-31 Sap Se Supporting scalable distributed secondary index using replication engine for high-performance distributed database systems
US11573947B2 (en) 2017-05-08 2023-02-07 Sap Se Adaptive query routing in a replicated database environment
US11615012B2 (en) 2020-04-03 2023-03-28 Sap Se Preprocessing in database system workload capture and replay
US11709752B2 (en) 2020-04-02 2023-07-25 Sap Se Pause and resume in database system workload capture and replay

Families Citing this family (44)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8918436B2 (en) * 2011-12-22 2014-12-23 Sap Ag Hybrid database table stored as both row and column store
US9305044B2 (en) * 2013-07-18 2016-04-05 Bank Of America, N.A. System and method for modelling data
CN104424287B (zh) * 2013-08-30 2019-06-07 深圳市腾讯计算机系统有限公司 数据查询方法和装置
US10311154B2 (en) * 2013-09-21 2019-06-04 Oracle International Corporation Combined row and columnar storage for in-memory databases for OLTP and analytics workloads
US9489409B2 (en) 2013-10-17 2016-11-08 Sybase, Inc. Rollover strategies in a N-bit dictionary compressed column store
US9442913B2 (en) 2014-01-30 2016-09-13 International Business Machines Corporation Using parallel insert sub-ranges to insert into a column store
CN105408893B (zh) * 2014-02-10 2019-04-26 华为技术有限公司 一种数据处理和写入方法及相关装置
US10055440B2 (en) 2014-02-24 2018-08-21 Sap Se Database table re-partitioning using trigger-based capture and replay
US10558571B2 (en) * 2014-03-20 2020-02-11 Sybase, Inc. Second level database file cache for row instantiation
US9870382B2 (en) 2014-03-25 2018-01-16 Sap Se Data encoding and corresponding data structure
US9454574B2 (en) 2014-03-28 2016-09-27 Sybase, Inc. Bloom filter costing estimation
US9009171B1 (en) * 2014-05-02 2015-04-14 Palantir Technologies Inc. Systems and methods for active column filtering
KR101679011B1 (ko) * 2014-06-26 2016-11-24 주식회사 알티베이스 데이터베이스에서 데이터 이동을 처리하는 방법 및 장치
US9836507B2 (en) * 2014-09-17 2017-12-05 Futurewei Technologies, Inc. Method and system for adaptively building a column store database from a temporal row store database based on query demands
US10671594B2 (en) 2014-09-17 2020-06-02 Futurewei Technologies, Inc. Statement based migration for adaptively building and updating a column store database from a row store database based on query demands using disparate database systems
US9785660B2 (en) * 2014-09-25 2017-10-10 Sap Se Detection and quantifying of data redundancy in column-oriented in-memory databases
JP6398632B2 (ja) * 2014-11-12 2018-10-03 日本電気株式会社 制御装置、分散データベースシステム、方法およびプログラム
CN104537030B (zh) * 2014-12-22 2018-03-02 华为技术有限公司 一种业务数据查询方法及装置、数据库系统
US20160253382A1 (en) * 2015-02-26 2016-09-01 Ori Software Development Ltd. System and method for improving a query response rate by managing a column-based store in a row-based database
WO2016149552A1 (fr) 2015-03-17 2016-09-22 Cloudera, Inc. Politique de compactage
US20160328429A1 (en) * 2015-03-17 2016-11-10 Cloudera, Inc. Mutations in a column store
EP3271840B1 (fr) * 2015-05-07 2019-02-27 Cloudera, Inc. Mutations dans une mémoire organisée en colonnes
US10346434B1 (en) * 2015-08-21 2019-07-09 Amazon Technologies, Inc. Partitioned data materialization in journal-based storage systems
US11403318B2 (en) * 2015-10-01 2022-08-02 Futurewei Technologies, Inc. Apparatus and method for managing storage of a primary database and a replica database
US10127266B2 (en) * 2015-11-03 2018-11-13 International Business Machines Corporation Scalable virtual namespace and semantic policy management for object storage
US10761946B2 (en) 2017-02-10 2020-09-01 Sap Se Transaction commit protocol with recoverable commit identifier
CN110537174B (zh) * 2017-04-21 2022-09-09 华为技术有限公司 一种基于交替行锁和列锁的数据锁定方法
US10747814B2 (en) * 2017-09-29 2020-08-18 Oracle International Corporation Handling semi-structured and unstructured data in a sharded database environment
US10769114B2 (en) * 2017-12-14 2020-09-08 Google Llc Database syncing
US20190034427A1 (en) * 2017-12-28 2019-01-31 Intel Corporation Data management system employing a hash-based and tree-based key-value data structure
CN110413966A (zh) * 2018-04-27 2019-11-05 富士施乐株式会社 文档管理设备和非暂时性计算机可读介质
US11379433B2 (en) * 2018-05-25 2022-07-05 Microsoft Technology Licensing, Llc Persistent version storage for relational database management system
US11449499B1 (en) * 2018-08-16 2022-09-20 Yellowbrick Data, Inc. System and method for retrieving data
US11157478B2 (en) 2018-12-28 2021-10-26 Oracle International Corporation Technique of comprehensively support autonomous JSON document object (AJD) cloud service
CN112148691B (zh) * 2019-06-27 2024-03-26 金世超 数据存储方法和数据存储引擎
US11068454B2 (en) * 2019-09-23 2021-07-20 Singlestore, Inc. Method of performing transactional and analytical data processing using a data structure
KR102102307B1 (ko) * 2019-11-25 2020-04-20 주식회사 리얼타임테크 다수의 스토리지를 갖는 데이터베이스 관리시스템에서 블룸필터를 이용한 벡터화 기반의 스토리지 탐색 방법
US20210224856A1 (en) * 2020-01-16 2021-07-22 Walmart Apollo, Llc Methods and apparatuses for determining the effectiveness of an advertisement campaign
JP7452031B2 (ja) 2020-01-27 2024-03-19 富士通株式会社 情報処理装置，情報処理システム及びプログラム
CN114356226A (zh) * 2021-12-17 2022-04-15 广州文远知行科技有限公司 一种传感器数据存储方法、装置、设备及存储介质
US11941029B2 (en) 2022-02-03 2024-03-26 Bank Of America Corporation Automatic extension of database partitions
US11853239B2 (en) * 2022-04-11 2023-12-26 Western Digital Technologies, Inc. Hardware accelerator circuits for near storage compute systems
CN115599790B (zh) * 2022-11-10 2024-03-15 星环信息科技(上海)股份有限公司 一种数据存储系统、数据处理方法、电子设备和存储介质
CN117216068A (zh) * 2023-11-07 2023-12-12 本原数据(北京)信息技术有限公司 支持数据库混合负载的数据存储方法、装置及存储介质

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6523040B1 (en) * 1999-06-24 2003-02-18 Ibm Corporation Method and apparatus for dynamic and flexible table summarization
US7076508B2 (en) * 2002-08-12 2006-07-11 International Business Machines Corporation Method, system, and program for merging log entries from multiple recovery log files
US20070185657A1 (en) * 1998-10-19 2007-08-09 Symyx Technologies, Inc. Graphic design of combinatorial material libraries
US20090037365A1 (en) * 2007-07-30 2009-02-05 Paul Sinclair Product join dynamic partition elimination for multilevel partitioning
US7702843B1 (en) * 2006-04-27 2010-04-20 Vmware, Inc. Determining memory conditions in a virtual machine
US7792822B2 (en) * 2007-03-02 2010-09-07 Microsoft Corporation Systems and methods for modeling partitioned tables as logical indexes
US7987192B2 (en) * 2008-06-25 2011-07-26 International Business Machines Corporation Hybrid data model and user interaction for data sets in a user interface

Family Cites Families (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7024414B2 (en) * 2001-08-06 2006-04-04 Sensage, Inc. Storage of row-column data
US7356523B2 (en) * 2002-05-23 2008-04-08 International Business Machines Corporation Dynamic optimization of prepared statements in a statement pool
US7421446B1 (en) * 2004-08-25 2008-09-02 Unisys Corporation Allocation of storage for a database
US8671091B2 (en) * 2006-08-02 2014-03-11 Hewlett-Packard Development Company, L.P. Optimizing snowflake schema queries
US8099440B2 (en) * 2008-08-15 2012-01-17 International Business Machines Corporation Method for laying out fields in a database in a hybrid of row-wise and column-wise ordering
CN101751406B (zh) * 2008-12-18 2012-01-04 赵伟 一种实现基于列存储的关系型数据库的方法及装置
US9336263B2 (en) * 2010-06-04 2016-05-10 Yale University Data loading systems and methods
US8170981B1 (en) * 2010-12-08 2012-05-01 Dassault Systemes Enovia Corporation Computer method and system for combining OLTP database and OLAP database environments
US20120166402A1 (en) * 2010-12-28 2012-06-28 Teradata Us, Inc. Techniques for extending horizontal partitioning to column partitioning

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20070185657A1 (en) * 1998-10-19 2007-08-09 Symyx Technologies, Inc. Graphic design of combinatorial material libraries
US6523040B1 (en) * 1999-06-24 2003-02-18 Ibm Corporation Method and apparatus for dynamic and flexible table summarization
US7076508B2 (en) * 2002-08-12 2006-07-11 International Business Machines Corporation Method, system, and program for merging log entries from multiple recovery log files
US7702843B1 (en) * 2006-04-27 2010-04-20 Vmware, Inc. Determining memory conditions in a virtual machine
US7792822B2 (en) * 2007-03-02 2010-09-07 Microsoft Corporation Systems and methods for modeling partitioned tables as logical indexes
US20090037365A1 (en) * 2007-07-30 2009-02-05 Paul Sinclair Product join dynamic partition elimination for multilevel partitioning
US7987192B2 (en) * 2008-06-25 2011-07-26 International Business Machines Corporation Hybrid data model and user interaction for data sets in a user interface

Non-Patent Citations (3)

* Cited by examiner, † Cited by third party
Title
Extended European Search Report (from a corresponding foreign application), EP 12006520.6, mailed Apr. 13, 2013.
Jens Dittrich et al., "Towards a One Size Fits All Databases Architecture," Proceedings of the 5th Biennial Conference on Innovative Data Systems Research (CIDR 2011), Jan. 6, 2011.
Ravishankar Ramamurthy et al., "A Case for Fractured Mirrors," Proceedings of the International Conference on Very Large Data Bases, VLDB Conference, Rome, Italy, Sep. 11-14, 2001.

Cited By (36)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9569481B1 (en) * 2013-12-10 2017-02-14 Google Inc. Efficient locking of large data collections
US10509772B1 (en) 2013-12-10 2019-12-17 Google Llc Efficient locking of large data collections
US9852184B2 (en) 2014-11-03 2017-12-26 Sap Se Partition-aware distributed execution of window operator
US10387395B2 (en) 2014-11-03 2019-08-20 Sap Se Parallelized execution of window operator
US10303685B2 (en) 2015-06-08 2019-05-28 International Business Machines Corporation Data table performance optimization
US9904705B2 (en) 2015-06-08 2018-02-27 International Business Machines Corporation Data table performance optimization
US10095764B2 (en) 2015-06-19 2018-10-09 Sap Se Multi-replica asynchronous table replication
US10296632B2 (en) 2015-06-19 2019-05-21 Sap Se Synchronization on reactivation of asynchronous table replication
US10990610B2 (en) 2015-06-19 2021-04-27 Sap Se Synchronization on reactivation of asynchronous table replication
US10268743B2 (en) 2015-06-19 2019-04-23 Sap Se Distributed database transaction protocol
US11003689B2 (en) 2015-06-19 2021-05-11 Sap Se Distributed database transaction protocol
US10169439B2 (en) 2015-06-19 2019-01-01 Sap Se Multi-source asynchronous table replication
US10866967B2 (en) 2015-06-19 2020-12-15 Sap Se Multi-replica asynchronous table replication
US10795881B2 (en) 2015-12-18 2020-10-06 Sap Se Table replication in a database environment
US11327958B2 (en) 2015-12-18 2022-05-10 Sap Se Table replication in a database environment
US10235440B2 (en) 2015-12-21 2019-03-19 Sap Se Decentralized transaction commit protocol
US11372890B2 (en) 2015-12-21 2022-06-28 Sap Se Distributed database transaction protocol
US10572510B2 (en) 2015-12-21 2020-02-25 Sap Se Distributed database transaction protocol
US11829360B2 (en) 2016-05-09 2023-11-28 Sap Se Database workload capture and replay
US10552413B2 (en) 2016-05-09 2020-02-04 Sap Se Database workload capture and replay
US11294897B2 (en) 2016-05-09 2022-04-05 Sap Se Database workload capture and replay
US10554771B2 (en) 2016-07-05 2020-02-04 Sap Se Parallelized replay of captured database workload
US10298702B2 (en) 2016-07-05 2019-05-21 Sap Se Parallelized replay of captured database workload
US10592528B2 (en) 2017-02-27 2020-03-17 Sap Se Workload capture and replay for replicated database systems
US11314716B2 (en) 2017-05-08 2022-04-26 Sap Se Atomic processing of compound database transactions that modify a metadata entity
US11573947B2 (en) 2017-05-08 2023-02-07 Sap Se Adaptive query routing in a replicated database environment
US10585873B2 (en) 2017-05-08 2020-03-10 Sap Se Atomic processing of compound database transactions that modify a metadata entity
US11914572B2 (en) 2017-05-08 2024-02-27 Sap Se Adaptive query routing in a replicated database environment
US10936578B2 (en) 2017-06-01 2021-03-02 Sap Se Client-driven commit of distributed write transactions in a database environment
US11681684B2 (en) 2017-06-01 2023-06-20 Sap Se Client-driven commit of distributed write transactions in a database environment
US10977227B2 (en) 2017-06-06 2021-04-13 Sap Se Dynamic snapshot isolation protocol selection
US10698892B2 (en) 2018-04-10 2020-06-30 Sap Se Order-independent multi-record hash generation and data filtering
US11468062B2 (en) 2018-04-10 2022-10-11 Sap Se Order-independent multi-record hash generation and data filtering
US11347705B2 (en) 2019-04-02 2022-05-31 Sap Se Supporting scalable distributed secondary index using replication engine for high-performance distributed database systems
US11709752B2 (en) 2020-04-02 2023-07-25 Sap Se Pause and resume in database system workload capture and replay
US11615012B2 (en) 2020-04-03 2023-03-28 Sap Se Preprocessing in database system workload capture and replay

Also Published As

Publication number Publication date
US20140304219A1 (en) 2014-10-09
EP2608072A1 (fr) 2013-06-26
CN103177058A (zh) 2013-06-26
US20130166554A1 (en) 2013-06-27
US20170097977A1 (en) 2017-04-06
CN103177058B (zh) 2017-11-21
US9558258B2 (en) 2017-01-31
US10664497B2 (en) 2020-05-26

Similar Documents

Publication Publication Date Title
US10664497B2 (en) Hybrid database table stored as both row and column store
US10346383B2 (en) Hybrid database table stored as both row and column store
US8768927B2 (en) Hybrid database table stored as both row and column store
US11238039B2 (en) Materializing internal computations in-memory to improve query performance
US9830109B2 (en) Materializing data from an in-memory array to an on-disk page structure
US10204135B2 (en) Materializing expressions within in-memory virtual column units to accelerate analytic queries
EP3026578B1 (fr) Réseau de données de colonne à version compressée n bits pour stockage colonnaire en mémoire
US10474648B2 (en) Migration of unified table metadata graph nodes
EP2605158B1 (fr) Jointure mixte de tables de base de données à rangées et colonnes dans une orientation native
US8924373B2 (en) Query plans with parameter markers in place of object identifiers
EP2811792A1 (fr) Procédé pour faire fonctionner un dispositif de télécommunication mobile
US9218394B2 (en) Reading rows from memory prior to reading rows from secondary storage
US20110202497A1 (en) Systems and Methods for Performing Direct Reporting Access to Transaction Databases
CN113704300A (zh) 供数据检索方法使用的数据印记技术
Dwivedi et al. Performance analysis of column oriented database vs row oriented database
KR20230096107A (ko) 빅 메타데이터 관리를 위한 열 기반 기법들
US20200264786A1 (en) Locking based on categorical memory allocation
US11556540B1 (en) Transmission format cache for database reads

Legal Events

Date Code Title Description
AS Assignment

Owner name: SAP AG, GERMANY

Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:YOON, YONGSIK;JEONG, CHANHO;LEE, JUCHANG;AND OTHERS;SIGNING DATES FROM 20111220 TO 20111221;REEL/FRAME:027437/0840

FEPP Fee payment procedure

Free format text: PAYOR NUMBER ASSIGNED (ORIGINAL EVENT CODE: ASPN); ENTITY STATUS OF PATENT OWNER: LARGE ENTITY

STCF Information on status: patent grant

Free format text: PATENTED CASE

AS Assignment

Owner name: SAP SE, GERMANY

Free format text: CHANGE OF NAME;ASSIGNOR:SAP AG;REEL/FRAME:033625/0334

Effective date: 20140707

MAFP Maintenance fee payment

Free format text: PAYMENT OF MAINTENANCE FEE, 4TH YEAR, LARGE ENTITY (ORIGINAL EVENT CODE: M1551)

Year of fee payment: 4

MAFP Maintenance fee payment

Free format text: PAYMENT OF MAINTENANCE FEE, 8TH YEAR, LARGE ENTITY (ORIGINAL EVENT CODE: M1552); ENTITY STATUS OF PATENT OWNER: LARGE ENTITY

Year of fee payment: 8