JP2014530416A5 - - Google Patents

Download PDF

Info

Publication number
JP2014530416A5
JP2014530416A5 JP2014530739A JP2014530739A JP2014530416A5 JP 2014530416 A5 JP2014530416 A5 JP 2014530416A5 JP 2014530739 A JP2014530739 A JP 2014530739A JP 2014530739 A JP2014530739 A JP 2014530739A JP 2014530416 A5 JP2014530416 A5 JP 2014530416A5
Authority
JP
Japan
Prior art keywords
query
cluster
node
sql
information
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.)
Granted
Application number
JP2014530739A
Other languages
English (en)
Japanese (ja)
Other versions
JP2014530416A (ja
JP6096197B2 (ja
Filing date
Publication date
Priority claimed from US13/420,324 external-priority patent/US8868546B2/en
Application filed filed Critical
Publication of JP2014530416A publication Critical patent/JP2014530416A/ja
Publication of JP2014530416A5 publication Critical patent/JP2014530416A5/ja
Application granted granted Critical
Publication of JP6096197B2 publication Critical patent/JP6096197B2/ja
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

JP2014530739A 2011-09-15 2012-09-11 分散データ管理システムにおけるクエリ説明計画 Active JP6096197B2 (ja)

Applications Claiming Priority (5)

Application Number Priority Date Filing Date Title
US201161535227P 2011-09-15 2011-09-15
US61/535,227 2011-09-15
US13/420,324 2012-03-14
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 (3)

Publication Number Publication Date
JP2014530416A JP2014530416A (ja) 2014-11-17
JP2014530416A5 true JP2014530416A5 (enExample) 2015-08-13
JP6096197B2 JP6096197B2 (ja) 2017-03-15

Family

ID=47881633

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2014530739A Active JP6096197B2 (ja) 2011-09-15 2012-09-11 分散データ管理システムにおけるクエリ説明計画

Country Status (6)

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

Families Citing this family (19)

* 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
US9898475B1 (en) 2013-02-25 2018-02-20 EMC IP Holding Company LLC Tiering with pluggable storage system for parallel query engines
WO2016045397A1 (en) * 2014-09-26 2016-03-31 Huawei Technologies Co., Ltd. Method and query processing server for optimizing query execution
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
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
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
CN108496157B (zh) * 2016-03-31 2021-11-12 甲骨文国际公司 使用扩展接口提供运行时跟踪的系统和方法
CN106445877B (zh) * 2016-11-03 2019-03-15 北京爱其科技有限公司 一种基于多个微处理器的集群运算方法
CN107885780A (zh) * 2017-10-12 2018-04-06 北京人大金仓信息技术股份有限公司 一种针对分布式查询执行的性能数据收集方法
CN112650915B (zh) * 2020-11-30 2023-03-10 中国科学院信息工程研究所 一种基于实时查询的数据交互方法及装置
CN113722349B (zh) * 2021-08-18 2025-07-15 上海浦东发展银行股份有限公司 基于分布式数据库的sql审核方法、装置和计算机设备
CN114398426A (zh) * 2022-01-11 2022-04-26 山东浪潮科学研究院有限公司 一种sql语句全局变量属性查询方法及工具

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
US7747606B2 (en) * 2003-09-06 2010-06-29 Oracle International Corporation Automatic SQL tuning advisor
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 株式会社東芝 構造化文書検索システム、装置、及び方法
WO2010098034A1 (ja) * 2009-02-24 2010-09-02 日本電気株式会社 分散データベース管理システムおよび分散データベース管理方法
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
US9495427B2 (en) * 2010-06-04 2016-11-15 Yale University Processing of data using a database system in communication with a data processing framework
US8935232B2 (en) * 2010-06-04 2015-01-13 Yale University Query execution systems and methods
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

Similar Documents

Publication Publication Date Title
JP2014530416A5 (enExample)
US9846589B2 (en) Virtual machine placement optimization with generalized organizational scenarios
CN105550274B (zh) 双副本并行数据库的查询方法和装置
CN103927346B (zh) 基于数据量的查询连接方法
US8756217B2 (en) Speculative switch database
JP2014524608A5 (enExample)
JP2017530469A5 (enExample)
JP2014524078A5 (enExample)
US20120158453A1 (en) Workflow processing system for supporting multi-tenant, and method thereof
JP2018533090A5 (enExample)
JP2016539427A5 (enExample)
JP2015534674A5 (enExample)
CN103324534A (zh) 作业调度方法及其调度器
JP2006244499A5 (enExample)
JP2013528856A5 (enExample)
CN102360309A (zh) 片上多核异构系统的调度系统与调度执行方法
Zhang et al. MrHeter: improving MapReduce performance in heterogeneous environments
JP2014534532A5 (enExample)
CN105550268A (zh) 大数据流程建模分析引擎
CN105579999A (zh) 日志分析
CN102761602A (zh) 一种基于Hadoop的海量数据实时分析处理方法
WO2015062540A1 (zh) 基于行车用量模型事件的存储及索引方法及系统
CN103823846A (zh) 一种基于图论的大数据存储及查询方法
Lu et al. Parallel secondo: A practical system for large-scale processing of moving objects
WO2015143985A1 (zh) 一种确定结果向量的方法和装置