CN104854587B - 用于维护主动查询的方法、系统和计算机可读存储介质 - Google Patents

用于维护主动查询的方法、系统和计算机可读存储介质 Download PDF

Info

Publication number
CN104854587B
CN104854587B CN201380065875.3A CN201380065875A CN104854587B CN 104854587 B CN104854587 B CN 104854587B CN 201380065875 A CN201380065875 A CN 201380065875A CN 104854587 B CN104854587 B CN 104854587B
Authority
CN
China
Prior art keywords
control information
inquiry
data item
query result
affairs
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
CN201380065875.3A
Other languages
English (en)
Chinese (zh)
Other versions
CN104854587A (zh
Inventor
托德·L·费尔德赫伊曾
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.)
Enfu Retail Holding Co
Enfu Usa Co
Enfu Usa Co ltd
Logich Brooks Proditix Acquisition Co
Logichbrocks Proditix Mico Co ltd
Rocky Brooks Co ltd
Original Assignee
Luo Jiqibuluo Ces Co Ltd
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 Luo Jiqibuluo Ces Co Ltd filed Critical Luo Jiqibuluo Ces Co Ltd
Publication of CN104854587A publication Critical patent/CN104854587A/zh
Application granted granted Critical
Publication of CN104854587B publication Critical patent/CN104854587B/zh
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/24—Querying
    • G06F16/245—Query processing
    • G06F16/2453—Query optimisation
    • G06F16/24534—Query rewriting; Transformation
    • G06F16/24539—Query rewriting; Transformation using cached or materialised query results
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/2308—Concurrency control
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/24—Querying
    • G06F16/245—Query processing
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/24—Querying
    • G06F16/245—Query processing
    • G06F16/2453—Query optimisation
    • G06F16/24534—Query rewriting; Transformation
    • G06F16/24537—Query rewriting; Transformation of operators

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
CN201380065875.3A 2012-12-20 2013-12-19 用于维护主动查询的方法、系统和计算机可读存储介质 Active CN104854587B (zh)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US13/722,067 US9424304B2 (en) 2012-12-20 2012-12-20 Maintenance of active database queries
US13/722,067 2012-12-20
PCT/US2013/076483 WO2014100383A1 (en) 2012-12-20 2013-12-19 Maintenance of active database queries

Publications (2)

Publication Number Publication Date
CN104854587A CN104854587A (zh) 2015-08-19
CN104854587B true CN104854587B (zh) 2018-11-02

Family

ID=50975892

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201380065875.3A Active CN104854587B (zh) 2012-12-20 2013-12-19 用于维护主动查询的方法、系统和计算机可读存储介质

Country Status (8)

Country Link
US (2) US9424304B2 (enExample)
EP (1) EP2936351B1 (enExample)
JP (1) JP6198845B2 (enExample)
KR (1) KR20150098660A (enExample)
CN (1) CN104854587B (enExample)
CA (1) CA2895231C (enExample)
IL (1) IL239173B (enExample)
WO (1) WO2014100383A1 (enExample)

Families Citing this family (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9805084B2 (en) 2015-05-14 2017-10-31 Walleye Software, LLC Computer data system data source refreshing using an update propagation graph
CN106021326A (zh) * 2016-05-03 2016-10-12 无锡雅座在线科技发展有限公司 基于流计算的事件处理方法和装置
US10002154B1 (en) 2017-08-24 2018-06-19 Illumon Llc Computer data system data source having an update propagation graph with feedback cyclicality
US11151111B2 (en) * 2017-11-30 2021-10-19 Futurewei Technologies, Inc. Redistributing table data in a database cluster
JP6850720B2 (ja) * 2017-12-11 2021-03-31 Kddi株式会社 問合せ文実行装置、問合せ文実行方法及び問合せ文実行プログラム
US20190294713A1 (en) * 2018-03-22 2019-09-26 Accenture Global Solutions Limited Database impact analysis
US10789242B2 (en) * 2018-04-25 2020-09-29 Microsoft Technology Licensing, Llc Managing materialized views in eventually consistent distributed data stores
US12059889B2 (en) 2018-04-30 2024-08-13 Kimberly-Clark Inc. Air dryer utilizing low temperature, high velocity air
US11126622B1 (en) * 2021-03-02 2021-09-21 Chaossearch, Inc. Methods and apparatus for efficiently scaling result caching
US11194808B1 (en) * 2021-03-18 2021-12-07 Snowflake Inc. Multidimensional and multi-relation sampling for implementing multidimensional two-sided interval joins

Family Cites Families (63)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5325525A (en) * 1991-04-04 1994-06-28 Hewlett-Packard Company Method of automatically controlling the allocation of resources of a parallel processor computer system by calculating a minimum execution time of a task and scheduling subtasks against resources to execute the task in the minimum time
US5276872A (en) 1991-06-25 1994-01-04 Digital Equipment Corporation Concurrency and recovery for index trees with nodal updates using multiple atomic actions by which the trees integrity is preserved during undesired system interruptions
US5280612A (en) 1991-11-26 1994-01-18 International Business Machines Corporation Multiple version database concurrency control system
JP3441807B2 (ja) 1994-09-19 2003-09-02 株式会社日立製作所 Ｂ木インデクスの管理方法およびシステム
US6889358B1 (en) 1998-01-08 2005-05-03 Lucent Technologies Inc. Concurrency control in materialized views of a database
US6272502B1 (en) * 1998-05-11 2001-08-07 Lucent Technologies Inc. Refreshing materialized views of a database to maintain consistency with underlying data
US6205451B1 (en) * 1998-05-22 2001-03-20 Oracle Corporation Method and apparatus for incremental refresh of summary tables in a database system
US6134543A (en) 1998-07-02 2000-10-17 Oracle Corporation Incremental maintenance of materialized views containing one-to-one lossless joins
US6353835B1 (en) 1998-08-03 2002-03-05 Lucent Technologies Inc. Technique for effectively maintaining materialized views in a data warehouse
US6363387B1 (en) * 1998-10-20 2002-03-26 Sybase, Inc. Database system providing methodology for enhancing concurrency using row update bit and deferred locking
US6360219B1 (en) 1998-12-16 2002-03-19 Gemstone Systems, Inc. Object queues with concurrent updating
US6353828B1 (en) * 1999-05-14 2002-03-05 Oracle Corp. Concurrency control for transactions that update base tables of a materialized view using different types of locks
US6484159B1 (en) 1999-05-20 2002-11-19 At&T Corp. Method and system for incremental database maintenance
US6763352B2 (en) * 1999-05-21 2004-07-13 International Business Machines Corporation Incremental maintenance of summary tables with complex grouping expressions
US6983291B1 (en) 1999-05-21 2006-01-03 International Business Machines Corporation Incremental maintenance of aggregated and join summary tables
US6484172B1 (en) 1999-12-24 2002-11-19 Electronics And Telecommunications Research Institute Concurrency control method for high-dimensional index structure using latch and lock
US6366903B1 (en) 2000-04-20 2002-04-02 Microsoft Corporation Index and materialized view selection for a given workload
US6356890B1 (en) * 2000-04-20 2002-03-12 Microsoft Corporation Merging materialized view pairs for database workload materialized view selection
US6356891B1 (en) 2000-04-20 2002-03-12 Microsoft Corporation Identifying indexes on materialized views for database workload
US6510422B1 (en) * 2000-09-27 2003-01-21 Microsoft Corporation Cost based materialized view selection for query optimization
US6868414B2 (en) 2001-01-03 2005-03-15 International Business Machines Corporation Technique for serializing data structure updates and retrievals without requiring searchers to use locks
US7293028B2 (en) 2001-06-08 2007-11-06 Sap Ag Cache-conscious concurrency control scheme for database systems
CA2365692A1 (en) 2001-06-21 2002-12-21 International Business Machines Corporation Method for recommending indexes and materialized views for a database workload
US7181453B2 (en) 2001-06-28 2007-02-20 Mysql Ab Method for concurrency control for a secondary index
US6708179B1 (en) 2001-09-28 2004-03-16 Oracle International Corporation Incremental refresh of materialized views for many-to-many relationships
US20030101183A1 (en) 2001-11-26 2003-05-29 Navin Kabra Information retrieval index allowing updating while in use
US6882993B1 (en) * 2002-01-28 2005-04-19 Oracle International Corporation Incremental refresh of materialized views with joins and aggregates after arbitrary DML operations to multiple tables
US7426559B2 (en) * 2002-05-09 2008-09-16 International Business Machines Corporation Method for sequential coordination of external database application events with asynchronous internal database events
US7089253B2 (en) 2002-09-13 2006-08-08 Netezza Corporation Computer method and system for concurrency control using dynamic serialization ordering
CA2414983A1 (en) 2002-12-23 2004-06-23 Ibm Canada Limited-Ibm Canada Limitee Independent deferred incremental refresh of materialized views
WO2004072810A2 (en) 2003-02-10 2004-08-26 Netezza Corporation Materialized view system and method
US7523462B1 (en) 2003-05-27 2009-04-21 International Business Machines Corporation Method for providing a real time view of heterogeneous enterprise data
US20050091180A1 (en) * 2003-10-22 2005-04-28 Nitzan Peleg Method and apparatus for refreshing materialized views
US8359325B1 (en) * 2004-02-25 2013-01-22 Teradata Us, Inc. Determining materialized view coverage for join transactions
US7739262B2 (en) * 2004-03-19 2010-06-15 Microsoft Corporation Enforcing currency and consistency constraints in database query processing
US7890497B2 (en) * 2004-04-14 2011-02-15 Oracle International Corporation Using estimated cost to schedule an order for refreshing a set of materialized views (MVS)
US7769770B2 (en) 2004-07-14 2010-08-03 Microsoft Corporation Secondary index and indexed view maintenance for updates to complex types
US7720845B2 (en) * 2004-08-13 2010-05-18 Yahoo! Inc. Systems and methods for updating query results based on query deltas
US7490084B2 (en) 2004-09-24 2009-02-10 Oracle Corporation Deferred incorporation of updates for spatial indexes
US7930297B2 (en) 2004-12-03 2011-04-19 Oracle International Corporation Materialized view maintenance and change tracking
US7792839B2 (en) 2005-01-13 2010-09-07 International Business Machines Corporation Incremental indexing of a database table in a database
US8126870B2 (en) * 2005-03-28 2012-02-28 Sybase, Inc. System and methodology for parallel query optimization using semantic-based partitioning
US7895186B2 (en) * 2005-03-31 2011-02-22 Oracle International Corp. Method and mechanism of materialized view mix incremental refresh
US7677441B2 (en) 2005-04-01 2010-03-16 Microsoft Corporation Relaxed currency constraints
US20060294156A1 (en) 2005-06-24 2006-12-28 Nec Laboratories, Inc Incremental maintenance of path-expression views
US8468152B2 (en) * 2005-08-04 2013-06-18 International Business Machines Corporation Autonomic refresh of a materialized query table in a computer database
US7680767B2 (en) * 2006-03-23 2010-03-16 Microsoft Corporation Mapping architecture with incremental view maintenance
US7647298B2 (en) * 2006-03-23 2010-01-12 Microsoft Corporation Generation of query and update views for object relational mapping
US7577658B2 (en) 2006-10-06 2009-08-18 Microsoft Corporation Hierarchical locking in B-tree indexes
US8260761B2 (en) * 2006-10-20 2012-09-04 Ianywhere Solutions, Inc. Detecting performance degrading design and algorithm issues in database applications
US7805420B2 (en) 2006-11-20 2010-09-28 Microsoft Corporation Versioning and concurrency control for multiple client access of data
US7797356B2 (en) * 2007-02-02 2010-09-14 Microsoft Corporation Dynamically detecting exceptions based on data changes
US9483525B2 (en) 2007-04-30 2016-11-01 Microsoft Technology Licensing, Llc Reducing update conflicts when maintaining views
US7853604B2 (en) 2007-07-12 2010-12-14 Oracle International Corporation Inline view query rewrite using a materialized view
US20090083238A1 (en) * 2007-09-21 2009-03-26 Microsoft Corporation Stop-and-restart style execution for long running decision support queries
US20090210429A1 (en) 2008-02-19 2009-08-20 Yahoo! Inc. System and method for asynchronous update of indexes in a distributed database
US20090213269A1 (en) 2008-02-21 2009-08-27 David Dozoretz Content Slider
US8065269B2 (en) 2008-12-19 2011-11-22 Ianywhere Solutions, Inc. Immediate maintenance of materialized views
US9177023B2 (en) * 2009-02-02 2015-11-03 Hewlett-Packard Development Company, L.P. Evaluation of database query plan robustness landmarks using operator maps or query maps
US20110137875A1 (en) * 2009-12-09 2011-06-09 Oracle International Corporation Incremental materialized view refresh with enhanced dml compression
US8306959B2 (en) 2010-08-06 2012-11-06 Ianywhere Solutions, Inc. Incremental maintenance of immediate materialized views with outerjoins
US8775426B2 (en) 2010-09-14 2014-07-08 Microsoft Corporation Interface to navigate and search a concept hierarchy
US20130166523A1 (en) * 2011-12-21 2013-06-27 Sybase, Inc. Parallel Execution In A Transaction Using Independent Queries

Also Published As

Publication number Publication date
KR20150098660A (ko) 2015-08-28
EP2936351B1 (en) 2019-05-15
WO2014100383A1 (en) 2014-06-26
CN104854587A (zh) 2015-08-19
JP2016509281A (ja) 2016-03-24
US10430409B2 (en) 2019-10-01
US20140181081A1 (en) 2014-06-26
US20160259823A1 (en) 2016-09-08
IL239173A0 (en) 2015-07-30
CA2895231A1 (en) 2014-06-26
IL239173B (en) 2018-02-28
EP2936351A1 (en) 2015-10-28
CA2895231C (en) 2021-01-26
US9424304B2 (en) 2016-08-23
JP6198845B2 (ja) 2017-09-20
EP2936351A4 (en) 2016-08-17

Similar Documents

Publication Publication Date Title
CN104854587B (zh) 用于维护主动查询的方法、系统和计算机可读存储介质
Psallidas et al. Smoke: Fine-grained lineage at interactive speed
US11841835B2 (en) Data revision control in large-scale data analytic systems
JP7273045B2 (ja) Ｓｑｌクエリプランを最適化するための次元コンテキスト伝搬技術
CN105786955B (zh) 数据库管理系统中的数据复制
CN104050223B (zh) 用于文本挖掘和搜索的数据透视面
US20120136839A1 (en) User-Driven Conflict Resolution Of Concurrent Updates In Snapshot Isolation
US20130013590A1 (en) Searching and Displaying Data Objects Residing in Data Management Systems
US11281668B1 (en) Optimizing complex database queries using query fusion
US11947567B2 (en) System and method for computing and managing datasets using hierarchical analytics
Lu et al. UDBMS: road to unification for multi-model data management
KR101213798B1 (ko) 복합 데이터 액세스
Ge et al. LSShare: an efficient multiple query optimization system in the cloud
US20160379148A1 (en) System and Methods for Interest-Driven Business Intelligence Systems with Enhanced Data Pipelines
US11216457B1 (en) Selectively assigning join operations for remote data processing
CN116821156A (zh) 一种网络资产数据存储、查询和可视化方法、装置及介质
Mulder et al. Optimizing navigational graph queries
Stiemer et al. PolyMigrate: Dynamic Schema Evolution and Data Migration in a Distributed
Antognini Execution Plans
RU2546058C1 (ru) Способ формирования реляционного описания синтаксиса команды
Jeevangekar et al. Design and Implementation of a NoSQL Database for Decision Support in R&D Management
Agterdenbos et al. Structural indexing for accelerated join-processing in relational databases
Fernandez SQL and PL/SQL by Example
Dewson Creating Indexes and Database Diagramming
Morton et al. SQL Execution Plans

Legal Events

Date Code Title Description
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant
TR01 Transfer of patent right

Effective date of registration: 20210722

Address after: New York, USA

Patentee after: Logich Brooks proditix acquisition Co.

Address before: Georgia, USA

Patentee before: LOGICBLOX, Inc.

Effective date of registration: 20210722

Address after: New York, USA

Patentee after: Enfu retail holding Co.

Address before: New York, USA

Patentee before: Logichbrocks proditix mico Co.,Ltd.

Effective date of registration: 20210722

Address after: New York, USA

Patentee after: Enfu (USA) Co.,Ltd.

Address before: New York, USA

Patentee before: Enfu (USA) Co.

Effective date of registration: 20210722

Address after: New York, USA

Patentee after: Enfu (USA) Co.

Address before: New York, USA

Patentee before: Rocky Brooks Co.,Ltd.

Effective date of registration: 20210722

Address after: New York, USA

Patentee after: Rocky Brooks Co.,Ltd.

Address before: New York, USA

Patentee before: Enfu retail holding Co.

Effective date of registration: 20210722

Address after: New York, USA

Patentee after: Logichbrocks proditix mico Co.,Ltd.

Address before: New York, USA

Patentee before: Logich Brooks proditix acquisition Co.

TR01 Transfer of patent right