IN2014CN00740A - - Google Patents

Info

Publication number
IN2014CN00740A
IN2014CN00740A IN740CHN2014A IN2014CN00740A IN 2014CN00740 A IN2014CN00740 A IN 2014CN00740A IN 740CHN2014 A IN740CHN2014 A IN 740CHN2014A IN 2014CN00740 A IN2014CN00740 A IN 2014CN00740A
Authority
IN
India
Prior art keywords
query
distributed
explain plan
node
execution time
Prior art date
Application number
Other languages
English (en)
Inventor
Tom Beerbower
Robert H Lee
Original Assignee
Oracle Int Corp
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 Oracle Int Corp filed Critical Oracle Int Corp
Publication of IN2014CN00740A publication Critical patent/IN2014CN00740A/en

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/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2471—Distributed queries
    • 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/2452—Query translation
    • G06F16/24524—Access plan code generation and invalidation; Reuse of access plans
    • 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/24532—Query optimisation of parallel queries
    • 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/24542—Plan optimisation
    • 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/24549—Run-time optimisation
    • 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/284—Relational databases

Landscapes

  • Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Computational Linguistics (AREA)
  • Probability & Statistics with Applications (AREA)
  • Software Systems (AREA)
  • Mathematical Physics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Fuzzy Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Multi Processors (AREA)
IN740CHN2014 2011-09-15 2012-09-11 IN2014CN00740A (de)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US201161535227P 2011-09-15 2011-09-15
US13/420,324 US8868546B2 (en) 2011-09-15 2012-03-14 Query explain plan in a distributed data management system
PCT/US2012/054680 WO2013039921A1 (en) 2011-09-15 2012-09-11 Query explain plan in a distributed data management system

Publications (1)

Publication Number Publication Date
IN2014CN00740A true IN2014CN00740A (de) 2015-04-03

Family

ID=47881633

Family Applications (1)

Application Number Title Priority Date Filing Date
IN740CHN2014 IN2014CN00740A (de) 2011-09-15 2012-09-11

Country Status (6)

Country Link
US (1) US8868546B2 (de)
EP (1) EP2756431A1 (de)
JP (1) JP6096197B2 (de)
CN (1) CN103782295B (de)
IN (1) IN2014CN00740A (de)
WO (1) WO2013039921A1 (de)

Families Citing this family (17)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8868546B2 (en) * 2011-09-15 2014-10-21 Oracle International Corporation Query explain plan in a distributed data management system
US10176184B2 (en) * 2012-01-17 2019-01-08 Oracle International Corporation System and method for supporting persistent store versioning and integrity in a distributed data grid
US9251209B2 (en) 2012-03-15 2016-02-02 International Business Machines Corporation Autonomic caching for in memory data grid query processing
US11455287B1 (en) * 2012-08-01 2022-09-27 Tibco Software Inc. Systems and methods for analysis of data at disparate data sources
US9753980B1 (en) 2013-02-25 2017-09-05 EMC IP Holding Company LLC M X N dispatching in large scale distributed system
CN106716406A (zh) * 2014-09-26 2017-05-24 华为技术有限公司 优化查询执行的方法和查询处理服务器
US10430410B2 (en) * 2015-03-12 2019-10-01 International Business Machines Corporation Explain tool for optimizing SPARQL queries
US10169409B2 (en) * 2015-10-01 2019-01-01 International Business Machines Corporation System and method for transferring data between RDBMS and big data platform
US10210210B2 (en) 2015-10-21 2019-02-19 International Business Machines Corporation Adaptive multi-index access plan for database queries
US10783142B2 (en) * 2015-10-23 2020-09-22 Oracle International Corporation Efficient data retrieval in staged use of in-memory cursor duration temporary tables
US10678792B2 (en) 2015-10-23 2020-06-09 Oracle International Corporation Parallel execution of queries with a recursive clause
US10642831B2 (en) 2015-10-23 2020-05-05 Oracle International Corporation Static data caching for queries with a clause that requires multiple iterations to execute
US10452655B2 (en) 2015-10-23 2019-10-22 Oracle International Corporation In-memory cursor duration temp tables
WO2017166166A1 (en) * 2016-03-31 2017-10-05 Oracle International Corporation System and method for providing runtime tracing for web-based client accessing transactional middleware platform using extension interface
CN106445877B (zh) * 2016-11-03 2019-03-15 北京爱其科技有限公司 一种基于多个微处理器的集群运算方法
CN107885780A (zh) * 2017-10-12 2018-04-06 北京人大金仓信息技术股份有限公司 一种针对分布式查询执行的性能数据收集方法
CN112650915B (zh) * 2020-11-30 2023-03-10 中国科学院信息工程研究所 一种基于实时查询的数据交互方法及装置

Family Cites Families (38)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH03108036A (ja) * 1989-09-20 1991-05-08 Fujitsu Ltd データベース管理システムの性能見積もり方法
FR2696852B1 (fr) * 1992-10-12 1994-12-23 Bull Sa Procédé d'aide à l'optimisation d'une requête d'un système de gestion de base de données relationnel.
JP3266351B2 (ja) * 1993-01-20 2002-03-18 株式会社日立製作所 データベース管理システムおよび問合せの処理方法
US5495604A (en) * 1993-08-25 1996-02-27 Asymetrix Corporation Method and apparatus for the modeling and query of database structures using natural language-like constructs
US6195653B1 (en) 1997-10-14 2001-02-27 International Business Machines Corporation System and method for selectively preparing customized reports of query explain data
US7069264B2 (en) * 1999-12-08 2006-06-27 Ncr Corp. Stratified sampling of data in a database system
JP2001331485A (ja) * 2000-05-22 2001-11-30 Mitsubishi Electric Corp 分散データベース演算処理装置
US7185000B1 (en) 2000-06-30 2007-02-27 Ncr Corp. Method and apparatus for presenting query plans
US6980985B1 (en) * 2000-08-30 2005-12-27 At&T Corp. Distributed evalulation of directory queries using a topology cache
JP3819694B2 (ja) * 2000-10-10 2006-09-13 株式会社日立製作所 データベース管理システムおよび問合せの処理方法
US6725212B2 (en) * 2001-08-31 2004-04-20 International Business Machines Corporation Platform-independent method and system for graphically presenting the evaluation of a query in a database management system
JP4031947B2 (ja) * 2002-04-22 2008-01-09 株式会社リコー 異種データベース統合システムにおける問い合わせ最適化処理装置、問い合わせ最適化処理方法、その方法をコンピュータに実行させるプログラムおよびプログラムを記録した記録媒体
US7370064B2 (en) 2002-08-06 2008-05-06 Yousefi Zadeh Homayoun Database remote replication for back-end tier of multi-tier computer systems
US8825629B2 (en) * 2003-09-06 2014-09-02 Oracle International Corporation Method for index tuning of a SQL statement, and index merging for a multi-statement SQL workload, using a cost-based relational query optimizer
JP2007172516A (ja) * 2005-12-26 2007-07-05 Hitachi Software Eng Co Ltd Ｓｑｌ文によるデータベースの検索所要時間の予測方法及びプログラム
US7801912B2 (en) * 2005-12-29 2010-09-21 Amazon Technologies, Inc. Method and apparatus for a searchable data service
JP2007193381A (ja) * 2006-01-16 2007-08-02 Sony Computer Entertainment Inc 分散検索システム、分散検索方法、検索装置、検索装置の制御方法及びプログラム
US9015146B2 (en) * 2006-12-01 2015-04-21 Teradata Us, Inc. Managing access to data in a multi-temperature database
US7680779B2 (en) * 2007-01-26 2010-03-16 Sap Ag Managing queries in a distributed database system
US7991763B2 (en) * 2007-04-13 2011-08-02 International Business Machines Corporation Database query optimization utilizing remote statistics collection
US7984043B1 (en) * 2007-07-24 2011-07-19 Amazon Technologies, Inc. System and method for distributed query processing using configuration-independent query plans
US7865502B2 (en) * 2008-04-10 2011-01-04 International Business Machines Corporation Optimization of extensible markup language path language (XPATH) expressions in a database management system configured to accept extensible markup language (XML) queries
US9418107B2 (en) * 2008-07-30 2016-08-16 At&T Intellectual Property I, L.P. Method and apparatus for performing query aware partitioning
JP5072871B2 (ja) * 2009-01-28 2012-11-14 株式会社東芝 構造化文書検索システム、装置、及び方法
JPWO2010098034A1 (ja) * 2009-02-24 2012-08-30 日本電気株式会社 分散データベース管理システムおよび分散データベース管理方法
US9934261B2 (en) * 2009-03-10 2018-04-03 Hewlett Packard Enterprise Development Lp Progress analyzer for database queries
US8380738B2 (en) * 2009-03-17 2013-02-19 Nec Laboratories America, Inc. System and methods for database distribution and querying over key-based scalable storage
CN101567006B (zh) * 2009-05-25 2012-07-04 中兴通讯股份有限公司 一种数据库系统及分布式sql语句执行计划重用方法
US8620903B2 (en) * 2009-11-04 2013-12-31 Nec Laboratories America, Inc. Database distribution system and methods for scale-out applications
US8433701B2 (en) * 2009-11-19 2013-04-30 21Ct, Inc. System and method for optimizing pattern query searches on a graph database
CN102163195B (zh) * 2010-02-22 2013-04-24 北京东方通科技股份有限公司 一种基于分布式、异构数据库统一视图的查询优化方法
US8874961B2 (en) * 2010-03-22 2014-10-28 Infosys Limited Method and system for automatic failover of distributed query processing using distributed shared memory
US8935232B2 (en) * 2010-06-04 2015-01-13 Yale University Query execution systems and methods
US9495427B2 (en) * 2010-06-04 2016-11-15 Yale University Processing of data using a database system in communication with a data processing framework
CN101908075A (zh) * 2010-08-17 2010-12-08 上海云数信息科技有限公司 基于sql的并行计算系统及方法
US20120036146A1 (en) * 2010-10-26 2012-02-09 ParElastic Corporation Apparatus for elastic database processing with heterogeneous data
US8631279B2 (en) * 2011-06-07 2014-01-14 Microsoft Corporation Propagating unobserved exceptions in distributed execution environments
US8868546B2 (en) * 2011-09-15 2014-10-21 Oracle International Corporation Query explain plan in a distributed data management system

Also Published As

Publication number Publication date
US8868546B2 (en) 2014-10-21
JP6096197B2 (ja) 2017-03-15
WO2013039921A1 (en) 2013-03-21
CN103782295B (zh) 2017-03-22
CN103782295A (zh) 2014-05-07
JP2014530416A (ja) 2014-11-17
US20130073538A1 (en) 2013-03-21
EP2756431A1 (de) 2014-07-23

Similar Documents

Publication Publication Date Title
IN2014CN00740A (de)
AU2016219677A1 (en) Methods and apparatus to monitor media presentations
WO2015188183A3 (en) Methods and system for incremental exploration of design changes in large computer-aided design models
WO2014177522A3 (en) Device and method for wave-field reconstruction
WO2015195676A3 (en) Computer-implemented tools and methods for extracting information about the structure of a large computer software system, exploring its structure, discovering problems in its design, and enabling refactoring
GB2510279A (en) Monitoring application program resource consumption
IN2014DN11110A (de)
IN2015DN01406A (de)
GB2519900A (en) Image instance mapping
WO2012099643A3 (en) Integrated environment for execution monitoring and profiling of applications running on multi-processor system-on-chip
MX2014002726A (es) Navegacion jerarquica con objetos relacionados.
IN2013MU02339A (de)
WO2014134076A3 (en) Quality management system and problem solving learning environments and design for 21st century skills
BR112015026753A2 (pt) método e dispositivo para a gestão de memória de dispositivo de usuário
EA201690256A1 (ru) Система и способ планирования площадки для транспортных средств
GB2491715B (en) Prospect assessment and play chance mapping tools
BR112014017652A8 (pt) Método para estimar um tempo de irrupção do fluido injetado em um poço de produção, e, dispositivos portador não transitório e portador de programa
IN2013CH04496A (de)
GB2519790A8 (en) Configuration of network devices
MX2015015041A (es) Compilacion de datos de situaciones hipoteticas de perforacion a partir de fuentes de datos dispares.
MX2014003132A (es) Metodo y sistema de asignacion de horizontes de subsuelo.
WO2013181151A3 (en) System and method for automated analysis comparing a wireless device location with another geographic location
MX2013002348A (es) Monitoreo de aplicacion.
NZ601872A (en) Meter access management system
Chompunth et al. Evaluating public participation process in development projects in Thailand: A case study of the Hin Krut power plant project