DE602004024293D1 - System und Verfahren zur Datenverarbeitung - Google Patents

System und Verfahren zur Datenverarbeitung

Info

Publication number
DE602004024293D1
DE602004024293D1 DE602004024293T DE602004024293T DE602004024293D1 DE 602004024293 D1 DE602004024293 D1 DE 602004024293D1 DE 602004024293 T DE602004024293 T DE 602004024293T DE 602004024293 T DE602004024293 T DE 602004024293T DE 602004024293 D1 DE602004024293 D1 DE 602004024293D1
Authority
DE
Germany
Prior art keywords
database
olap
data
oltp
data processing
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
DE602004024293T
Other languages
English (en)
Inventor
Winfried Schmitt
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
Publication of DE602004024293D1 publication Critical patent/DE602004024293D1/de
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • 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
DE602004024293T 2004-06-23 2004-06-23 System und Verfahren zur Datenverarbeitung Active DE602004024293D1 (de)

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
EP04014696A EP1610235B1 (de) 2004-06-23 2004-06-23 System und Verfahren zur Datenverarbeitung

Publications (1)

Publication Number Publication Date
DE602004024293D1 true DE602004024293D1 (de) 2010-01-07

Family

ID=34925451

Family Applications (1)

Application Number Title Priority Date Filing Date
DE602004024293T Active DE602004024293D1 (de) 2004-06-23 2004-06-23 System und Verfahren zur Datenverarbeitung

Country Status (4)

Country Link
US (1) US7743015B2 (de)
EP (1) EP1610235B1 (de)
AT (1) ATE450011T1 (de)
DE (1) DE602004024293D1 (de)

Families Citing this family (39)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20070074112A1 (en) * 2005-09-23 2007-03-29 Business Objects Apparatus and method for consolidating reporting formulas
US8121975B2 (en) * 2008-02-20 2012-02-21 Panorama Software Inc. Creating pivot tables from tabular data
US8959050B2 (en) 2009-06-15 2015-02-17 Oracle International Corporation Mechanism for synchronizing OLAP system structure and OLTP system structure
GB2480599A (en) * 2010-05-17 2011-11-30 Tech Universit T Muenchen Hybrid OLTP and OLAP database
US9258363B2 (en) 2010-11-15 2016-02-09 Microsoft Technology Licensing, Llc Data cube high availability
US8170981B1 (en) * 2010-12-08 2012-05-01 Dassault Systemes Enovia Corporation Computer method and system for combining OLTP database and OLAP database environments
US8650150B2 (en) * 2011-03-14 2014-02-11 Sap Ag System and method of relating data and generating reports
US20120291014A1 (en) * 2011-05-09 2012-11-15 Sridhar Shrinivasan System and method for testing the development and updates in a test system using production/live data
US8838524B2 (en) * 2011-08-30 2014-09-16 Gnet Group, Llc Automated system for preparing and presenting control charts
IL216056B (en) 2011-10-31 2018-04-30 Verint Systems Ltd A system and method for integrating databases
US9098312B2 (en) 2011-11-16 2015-08-04 Ptc Inc. Methods for dynamically generating an application interface for a modeled entity and devices thereof
US8909641B2 (en) 2011-11-16 2014-12-09 Ptc Inc. Method for analyzing time series activity streams and devices thereof
US9576046B2 (en) 2011-11-16 2017-02-21 Ptc Inc. Methods for integrating semantic search, query, and analysis across heterogeneous data types and devices thereof
US8768927B2 (en) * 2011-12-22 2014-07-01 Sap Ag Hybrid database table stored as both row and column store
US8918436B2 (en) * 2011-12-22 2014-12-23 Sap Ag Hybrid database table stored as both row and column store
WO2014145084A1 (en) 2013-03-15 2014-09-18 Ptc Inc. Methods for managing applications using semantic modeling and tagging and devices thereof
US20150006466A1 (en) * 2013-06-27 2015-01-01 Andreas Tonder Multiversion concurrency control for columnar database and mixed OLTP/OLAP workload
WO2015030767A1 (en) * 2013-08-29 2015-03-05 Hewlett-Packard Development Company, L.P. Queries involving multiple databases and execution engines
CN103488695A (zh) * 2013-09-02 2014-01-01 用友软件股份有限公司 数据同步装置和数据同步方法
JP6336090B2 (ja) 2014-01-02 2018-06-06 ホアウェイ・テクノロジーズ・カンパニー・リミテッド データベースシステムにおけるオンライン分析処理のためのデータを維持する方法および装置
US9529865B2 (en) 2014-02-12 2016-12-27 Sap Se Interval based fuzzy database search
US10025942B2 (en) 2014-03-21 2018-07-17 Ptc Inc. System and method of establishing permission for multi-tenancy storage using organization matrices
US9467533B2 (en) 2014-03-21 2016-10-11 Ptc Inc. System and method for developing real-time web-service objects
US9762637B2 (en) 2014-03-21 2017-09-12 Ptc Inc. System and method of using binary dynamic rest messages
US9961058B2 (en) 2014-03-21 2018-05-01 Ptc Inc. System and method of message routing via connection servers in a distributed computing environment
WO2015143416A1 (en) 2014-03-21 2015-09-24 Ptc Inc. Systems and methods for developing and using real-time data applications
US10313410B2 (en) 2014-03-21 2019-06-04 Ptc Inc. Systems and methods using binary dynamic rest messages
US9350791B2 (en) 2014-03-21 2016-05-24 Ptc Inc. System and method of injecting states into message routing in a distributed computing environment
US9350812B2 (en) 2014-03-21 2016-05-24 Ptc Inc. System and method of message routing using name-based identifier in a distributed computing environment
US9462085B2 (en) 2014-03-21 2016-10-04 Ptc Inc. Chunk-based communication of binary dynamic rest messages
US9560170B2 (en) 2014-03-21 2017-01-31 Ptc Inc. System and method of abstracting communication protocol using self-describing messages
GB2531537A (en) * 2014-10-21 2016-04-27 Ibm Database Management system and method of operation
US20170329836A1 (en) * 2014-11-26 2017-11-16 Hewlett Packard Enterprise Development Lp Database transfer of changes
CA3048659A1 (en) * 2016-12-30 2018-07-05 Walmart Apollo, Llc System and method for database queries
CN110019541B (zh) * 2017-07-21 2022-04-05 杭州海康威视数字技术股份有限公司 数据查询方法、装置及计算机可读存储介质
US10789274B2 (en) 2018-02-27 2020-09-29 Sap Se Replicating data in a multi-cloud environment
US10740356B2 (en) * 2018-06-27 2020-08-11 International Business Machines Corporation Dynamic incremental updating of data cubes
US11675806B2 (en) * 2020-12-14 2023-06-13 Snowflake Inc. Aggregate and transactional networked database query processing
US20240004902A1 (en) * 2022-06-29 2024-01-04 International Business Machines Corporation Performance of row table to columnar table replication

Family Cites Families (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5742806A (en) * 1994-01-31 1998-04-21 Sun Microsystems, Inc. Apparatus and method for decomposing database queries for database management system including multiprocessor digital data processing system
US5799300A (en) * 1996-12-12 1998-08-25 International Business Machines Corporations Method and system for performing range-sum queries on a data cube
US5890151A (en) * 1997-05-09 1999-03-30 International Business Machines Corporation Method and system for performing partial-sum queries on a data cube
US6003036A (en) * 1998-02-12 1999-12-14 Martin; Michael W. Interval-partitioning method for multidimensional data
US6480842B1 (en) * 1998-03-26 2002-11-12 Sap Portals, Inc. Dimension to domain server
JP2000011005A (ja) * 1998-06-17 2000-01-14 Hitachi Ltd データ分析方法及び装置及びデータ分析プログラムを記録したコンピュータ読み取り可能な記録媒体
US6408292B1 (en) * 1999-08-04 2002-06-18 Hyperroll, Israel, Ltd. Method of and system for managing multi-dimensional databases using modular-arithmetic based address data mapping processes on integer-encoded business dimensions
US20020165724A1 (en) * 2001-02-07 2002-11-07 Blankesteijn Bartus C. Method and system for propagating data changes through data objects
US6983286B1 (en) * 2002-05-10 2006-01-03 Oracle International Corporation Method and apparatus for accessing data as it existed at a previous point in time
US7249118B2 (en) * 2002-05-17 2007-07-24 Aleri, Inc. Database system and methods
US7647354B2 (en) 2002-05-24 2010-01-12 Oracle International Corporation High-performance change capture for data warehousing
US7225302B2 (en) * 2002-11-27 2007-05-29 Sap Ag Method and software application for avoiding data loss
US20040199618A1 (en) * 2003-02-06 2004-10-07 Knight Gregory John Data replication solution
US7149736B2 (en) * 2003-09-26 2006-12-12 Microsoft Corporation Maintaining time-sorted aggregation records representing aggregations of values from multiple database records using multiple partitions

Also Published As

Publication number Publication date
ATE450011T1 (de) 2009-12-15
US20050289129A1 (en) 2005-12-29
EP1610235B1 (de) 2009-11-25
EP1610235A1 (de) 2005-12-28
US7743015B2 (en) 2010-06-22

Similar Documents

Publication Publication Date Title
ATE450011T1 (de) System und verfahren zur datenverarbeitung
ATE463014T1 (de) Verfahren und gerät zur speicherung von änderungsdaten in einer datenbank
Hoogeveen et al. CQADupStack: A benchmark data set for community question-answering research
EP1473640A3 (de) Automatische Generierung eines dimensionalen Modells für Online Analytische Datenverarbeitung (OLAP) aus einem Objektmodell für Online-Transaktionsverarbeitung (OLTP)
US7051020B2 (en) Intelligent query re-execution
WO2006128062A3 (en) Database caching of queries and stored procedures using database provided facilities for dependency analysis and detected database updates for invalidation
WO2005111611A3 (en) Methods and apparatus for facilitating analysis of large data sets
ATE444531T1 (de) Registrierung und abruf von datenbankänderungsinformationen zur invalidierung von cache einträgen
BRPI0506673A (pt) sistemas, métodos, interfaces e software para coleta automatizada e integração de dados de entidade em bancos de dados online e diretórios profissionais
EP1691211A3 (de) System und Verfahren zur Bereitstellung von ortsabhängigen Informationen für Reisende
MXPA05009369A (es) Busqueda simplificada de servicios de medios con el uso de un dispositivo de control.
WO2008055120A3 (en) System and method for summarizing search results
BRPI0713385A2 (pt) método de armazenamento de dados, de coleta de dados e de telemonitorização, e, sistema de telemonitoração
GB2453486A (en) Geographical information display system and method
WO2005029280A3 (en) Performing sequence analysis as a multipart plan storing intermediate results as a relation
EP1755054A3 (de) Verfahren für intelligentes Durchsuchen, Speichern, Abrufen und Indexieren von Dateistrukturen technischer Messdaten
DE602004022517D1 (de) Datenverarbeitungssystem und -verfahren, um Datenbankreplikationen zu überwachen
WO2007064896A3 (en) Data exchange system and method
CN105095436B (zh) 数据源数据自动建模方法
WO2004090674A3 (en) Content bridge for associating host content and guest content wherein guest content is determined by search
TW200511048A (en) Patent family analysis system and method
WO2008156044A1 (ja) データ管理装置およびデータ管理方法、データ管理プログラム、データ管理プログラム記憶媒体
CN104731908A (zh) 一种基于etl的数据清洗方法
GB2449385A (en) Systems and methods for predicting if a query is a name
Döhmen et al. Gitschemas: A dataset for automating relational data preparation tasks

Legal Events

Date Code Title Description
8364 No opposition during term of opposition