CN104854587B - 用于维护主动查询的方法、系统和计算机可读存储介质 - Google Patents
用于维护主动查询的方法、系统和计算机可读存储介质 Download PDFInfo
- 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
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/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; 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/2308—Concurrency control
-
- 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
-
- 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/24—Querying
- G06F16/245—Query processing
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
- G06F16/24534—Query rewriting; Transformation
- G06F16/24537—Query rewriting; Transformation of operators
Abstract
Description
Claims (19)
Applications Claiming Priority (3)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US13/722,067 | 2012-12-20 | ||
US13/722,067 US9424304B2 (en) | 2012-12-20 | 2012-12-20 | Maintenance of active database queries |
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 (zh) |
EP (1) | EP2936351B1 (zh) |
JP (1) | JP6198845B2 (zh) |
KR (1) | KR20150098660A (zh) |
CN (1) | CN104854587B (zh) |
CA (1) | CA2895231C (zh) |
IL (1) | IL239173B (zh) |
WO (1) | WO2014100383A1 (zh) |
Families Citing this family (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US9619210B2 (en) | 2015-05-14 | 2017-04-11 | Walleye Software, LLC | Parsing and compiling data system queries |
CN106021326A (zh) * | 2016-05-03 | 2016-10-12 | 无锡雅座在线科技发展有限公司 | 基于流计算的事件处理方法和装置 |
US10198469B1 (en) | 2017-08-24 | 2019-02-05 | Deephaven Data Labs Llc | Computer data system data source refreshing using an update propagation graph having a merged join listener |
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 |
US11126622B1 (en) * | 2021-03-02 | 2021-09-21 | Chaossearch, Inc. | Methods and apparatus for efficiently scaling result caching |
Family Cites Families (63)
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 | 株式会社日立製作所 | B木インデクスの管理方法およびシステム |
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 |
US6356890B1 (en) * | 2000-04-20 | 2002-03-12 | Microsoft Corporation | Merging materialized view pairs for database workload materialized view selection |
US6366903B1 (en) | 2000-04-20 | 2002-04-02 | Microsoft Corporation | Index and materialized view selection for a given workload |
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 |
US7146366B2 (en) | 2002-09-13 | 2006-12-05 | Netezza Corporation | Distributed concurrency control using serialization ordering |
CA2414983A1 (en) | 2002-12-23 | 2004-06-23 | Ibm Canada Limited-Ibm Canada Limitee | Independent deferred incremental refresh of materialized views |
US7139783B2 (en) | 2003-02-10 | 2006-11-21 | 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 |
-
2012
- 2012-12-20 US US13/722,067 patent/US9424304B2/en active Active
-
2013
- 2013-12-19 WO PCT/US2013/076483 patent/WO2014100383A1/en active Application Filing
- 2013-12-19 JP JP2015549688A patent/JP6198845B2/ja active Active
- 2013-12-19 CA CA2895231A patent/CA2895231C/en active Active
- 2013-12-19 EP EP13863961.2A patent/EP2936351B1/en active Active
- 2013-12-19 CN CN201380065875.3A patent/CN104854587B/zh active Active
- 2013-12-19 KR KR1020157019642A patent/KR20150098660A/ko not_active Application Discontinuation
-
2015
- 2015-06-03 IL IL239173A patent/IL239173B/en active IP Right Grant
-
2016
- 2016-04-11 US US15/095,826 patent/US10430409B2/en active Active
Also Published As
Publication number | Publication date |
---|---|
JP6198845B2 (ja) | 2017-09-20 |
CA2895231A1 (en) | 2014-06-26 |
EP2936351B1 (en) | 2019-05-15 |
CA2895231C (en) | 2021-01-26 |
IL239173A0 (en) | 2015-07-30 |
US20140181081A1 (en) | 2014-06-26 |
EP2936351A4 (en) | 2016-08-17 |
EP2936351A1 (en) | 2015-10-28 |
IL239173B (en) | 2018-02-28 |
US20160259823A1 (en) | 2016-09-08 |
US10430409B2 (en) | 2019-10-01 |
JP2016509281A (ja) | 2016-03-24 |
US9424304B2 (en) | 2016-08-23 |
WO2014100383A1 (en) | 2014-06-26 |
KR20150098660A (ko) | 2015-08-28 |
CN104854587A (zh) | 2015-08-19 |
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 | |
CN105786955B (zh) | 数据库管理系统中的数据复制 | |
CN104050223B (zh) | 用于文本挖掘和搜索的数据透视面 | |
US20140337373A1 (en) | System for managing graph queries on relationships among entities using graph index | |
US20120136839A1 (en) | User-Driven Conflict Resolution Of Concurrent Updates In Snapshot Isolation | |
KR101213798B1 (ko) | 복합 데이터 액세스 | |
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 | |
Zhang et al. | Skeena: Efficient and consistent cross-engine transactions | |
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 | |
US8103677B1 (en) | Searching using object linked enterprise system | |
Xu et al. | Efficiently answer top-k queries on typed intervals | |
Al-Harbi et al. | PHD-Store: an adaptive SPARQL engine with dynamic partitioning for distributed RDF repositories | |
US20110282911A1 (en) | Method and apparatus for providing a relational document-based datastore | |
Jeevangekar et al. | Design and Implementation of a NoSQL Database for Decision Support in R&D Management | |
Antognini et al. | Execution Plans | |
RU2546058C1 (ru) | Способ формирования реляционного описания синтаксиса команды | |
Fernandez et al. | SQL and PL/SQL by Example | |
Morton et al. | SQL Execution Plans | |
Kumariβ et al. | Uncertainty in the Last Mile |
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 | ||
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. |