ATE543137T1 - Mehrkernplanung für parallele abfragen - Google Patents

Mehrkernplanung für parallele abfragen

Info

Publication number
ATE543137T1
ATE543137T1 AT10005824T AT10005824T ATE543137T1 AT E543137 T1 ATE543137 T1 AT E543137T1 AT 10005824 T AT10005824 T AT 10005824T AT 10005824 T AT10005824 T AT 10005824T AT E543137 T1 ATE543137 T1 AT E543137T1
Authority
AT
Austria
Prior art keywords
critical path
operators
running
operator
query
Prior art date
Application number
AT10005824T
Other languages
English (en)
Inventor
Jianfeng Yan
Jian Xu
Wen-Syan Li
Original Assignee
Sap Ag
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 Ag filed Critical Sap Ag
Application granted granted Critical
Publication of ATE543137T1 publication Critical patent/ATE543137T1/de

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00—Arrangements for program control, e.g. control units
    • G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/46—Multiprogramming arrangements
    • G06F9/50—Allocation of resources, e.g. of the central processing unit [CPU]
    • G06F9/5005—Allocation of resources, e.g. of the central processing unit [CPU] to service a request
    • G06F9/5027—Allocation of resources, e.g. of the central processing unit [CPU] to service a request the resource being a machine, e.g. CPUs, Servers, Terminals
    • G06F9/505—Allocation of resources, e.g. of the central processing unit [CPU] to service a request the resource being a machine, e.g. CPUs, Servers, Terminals considering the load
    • 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/24532—Query optimisation of parallel queries

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Software Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Hardware Redundancy (AREA)
  • Game Rules And Presentations Of Slot Machines (AREA)
  • Devices For Executing Special Programs (AREA)
AT10005824T 2009-06-05 2010-06-04 Mehrkernplanung für parallele abfragen ATE543137T1 (de)

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN200910159572.3A CN101908003B (zh) 2009-06-05 2009-06-05 并行化查询的多核调度

Publications (1)

Publication Number Publication Date
ATE543137T1 true ATE543137T1 (de) 2012-02-15

Family

ID=42790862

Family Applications (1)

Application Number Title Priority Date Filing Date
AT10005824T ATE543137T1 (de) 2009-06-05 2010-06-04 Mehrkernplanung für parallele abfragen

Country Status (4)

Country Link
US (1) US8219546B2 (de)
EP (1) EP2259184B1 (de)
CN (1) CN101908003B (de)
AT (1) ATE543137T1 (de)

Families Citing this family (40)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102043673B (zh) * 2009-10-21 2015-06-03 Sap欧洲公司 并行处理中执行任务的节点数量的优化选择系统及方法
US8612989B1 (en) * 2010-10-04 2013-12-17 Teradata Us, Inc. Assigning resources among multiple groups of workloads in a database system
US9307048B2 (en) 2010-12-28 2016-04-05 Microsoft Technology Licensing, Llc System and method for proactive task scheduling of a copy of outlier task in a computing environment
JP5678691B2 (ja) * 2011-01-28 2015-03-04 富士通株式会社 検索制御装置、検索制御プログラムおよび検索制御方法
US8645958B2 (en) * 2011-06-16 2014-02-04 uCIRRUS Software virtual machine for content delivery
US9208197B2 (en) 2011-10-21 2015-12-08 International Business Machines Corporation Dynamic SMT in parallel database systems
US9262216B2 (en) * 2012-02-14 2016-02-16 Microsoft Technologies Licensing, LLC Computing cluster with latency control
US9639575B2 (en) * 2012-03-30 2017-05-02 Khalifa University Of Science, Technology And Research Method and system for processing data queries
US8954419B2 (en) * 2012-05-22 2015-02-10 Oracle International Corporation Method for serial and condition-based execution of operators by parallel processes
US9753778B2 (en) * 2012-07-20 2017-09-05 Microsoft Technology Licensing, Llc Domain-agnostic resource allocation framework
US20140067601A1 (en) * 2012-09-06 2014-03-06 Sap Ag Supply chain finance planning
US9811938B2 (en) * 2013-03-14 2017-11-07 Business Objects Software Ltd. Methods, apparatus and system for analytics replay utilizing random sampling
US9329899B2 (en) 2013-06-24 2016-05-03 Sap Se Parallel execution of parsed query based on a concurrency level corresponding to an average number of available worker threads
US9606840B2 (en) 2013-06-27 2017-03-28 Sap Se Enterprise data-driven system for predictive resource provisioning in cloud environments
CN104376013A (zh) * 2013-08-12 2015-02-25 北京千橡网景科技发展有限公司 用于检索与用户相关联的数据的方法和设备
CN104516635B (zh) 2013-09-26 2022-03-08 Sap欧洲公司 一种管理内容显示的方法、系统及存储介质
CN104516910B (zh) 2013-09-26 2018-01-12 Sap欧洲公司 在客户端服务器环境中推荐内容
TWI533211B (zh) * 2013-11-14 2016-05-11 財團法人資訊工業策進會 用於任務排程之電腦系統，方法及電腦可讀取記錄媒體
US9767151B2 (en) * 2013-11-18 2017-09-19 Sap Se Optimizing database queries having hierarchy filters
CN103729417B (zh) * 2013-12-17 2017-11-03 华为技术有限公司 一种数据扫描的方法及装置
US10909117B2 (en) 2013-12-20 2021-02-02 Micro Focus Llc Multiple measurements aggregated at multiple levels of execution of a workload
US10489266B2 (en) 2013-12-20 2019-11-26 Micro Focus Llc Generating a visualization of a metric at one or multiple levels of execution of a database workload
US9953074B2 (en) 2014-01-31 2018-04-24 Sap Se Safe synchronization of parallel data operator trees
WO2015147853A1 (en) * 2014-03-28 2015-10-01 Hewlett-Packard Development Company, L.P. Real-time monitoring and analysis of query execution
US10410150B2 (en) 2014-11-04 2019-09-10 Sap Se Efficient computerized calculation of resource reallocation scheduling schemes
CN107193813B (zh) 2016-03-14 2021-05-14 阿里巴巴集团控股有限公司 数据表连接方式处理方法及装置
CN107479963A (zh) * 2016-06-08 2017-12-15 国家计算机网络与信息安全管理中心 一种任务分配方法及系统
US10637964B2 (en) 2016-11-23 2020-04-28 Sap Se Mutual reinforcement of edge devices with dynamic triggering conditions
CN108197255B (zh) * 2017-12-29 2021-01-15 上海瑞家信息技术有限公司 一种设置查询树的方法、设备及计算机可读存储介质
CN108108473B (zh) * 2018-01-02 2023-06-27 联想(北京)有限公司 数据查询方法以及服务器
US10841020B2 (en) 2018-01-31 2020-11-17 Sap Se Online self-correction on multiple data streams in sensor networks
US10891271B2 (en) * 2018-05-25 2021-01-12 Oracle International Corporation Optimized execution of queries involving early terminable database operators
US11176129B2 (en) * 2018-09-30 2021-11-16 Microsoft Technology Licensing, Llc Methods for automatic selection of degrees of parallelism for efficient execution of queries in a database system
US11620510B2 (en) * 2019-01-23 2023-04-04 Samsung Electronics Co., Ltd. Platform for concurrent execution of GPU operations
US11561886B2 (en) * 2019-09-19 2023-01-24 Sap Se Open data protocol performance test automation intelligence (OPT-AI)
US11609911B2 (en) * 2019-12-19 2023-03-21 Ocient Holdings LLC Selecting a normalized form for conversion of a query expression
US11269879B2 (en) * 2020-01-13 2022-03-08 Google Llc Optimal query scheduling according to data freshness requirements
US12511292B2 (en) 2023-05-22 2025-12-30 Microsoft Technology Licensing, Llc Cluster views for compute scale and cache preservation
WO2024243105A1 (en) * 2023-05-22 2024-11-28 Microsoft Technology Licensing, Llc Cluster views for compute scale and cache preservation
CN116881299B (zh) * 2023-07-13 2025-11-21 北京火山引擎科技有限公司 一种查询任务执行方法、装置、计算机设备及存储介质

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7426522B2 (en) * 2003-09-23 2008-09-16 International Business Machines Corporation Object oriented query path expression to relational outer join translator method, system, article of manufacture, and computer program product
US7509646B1 (en) * 2003-09-23 2009-03-24 Unisys Corporation Method of managing workloads in a distributed processing system
US20080010642A1 (en) * 2006-06-30 2008-01-10 Maclellan Scot Method, system and computer program for scheduling execution of work units with monitoring of progress thereof
US7769938B2 (en) * 2007-09-06 2010-08-03 Intel Corporation Processor selection for an interrupt identifying a processor cluster
US8161035B2 (en) * 2009-06-04 2012-04-17 Oracle International Corporation Query optimization by specifying path-based predicate evaluation in a path-based query operator

Also Published As

Publication number Publication date
CN101908003B (zh) 2014-10-22
EP2259184B1 (de) 2012-01-25
US20100312762A1 (en) 2010-12-09
EP2259184A3 (de) 2010-12-29
US8219546B2 (en) 2012-07-10
EP2259184A2 (de) 2010-12-08
CN101908003A (zh) 2010-12-08

Similar Documents

Publication Publication Date Title
ATE543137T1 (de) Mehrkernplanung für parallele abfragen
AR086994A1 (es) Metodo y aparato para estimar los datos relacionados con las celdas
WO2009100124A3 (en) Performance management system for multi-machine worksite
CL2011003283A1 (es) Metodo y aparato para realizar el control automatico de una maquina minera movil por una ruta de retorno de una ruta de conduccion guia que elimina o añade datos de control adicionales asociados con uno o mas puntos de ruta de la ruta de conduccion.
ATE556555T1 (de) Messungskontrolle für den wechsel von einer funkzugangstechnologie zu einer anderen
GB201317330D0 (en) Derrick apparatus
PH12017500869A1 (en) MULTI-CHAT MONITORING and AUDITING SYSTEM
GB2485683A (en) Thread shift: Allocating threads to cores
GB2476181A (en) Bottom hole assembly configuration management
UA109441C2 (uk) Система контролю і діагностики системи енергетичних машин для текучих середовищ, а також система енергетичних машин для текучих середовищ
FI20106239A7 (fi) Menetelmä puunkorjuun seuraamiseen ja järjestelmä
ES2650595T3 (es) Ingeniería de tráfico de red
MX2015009092A (es) Cuerda que tiene una trenza de baja friccion.
WO2012098129A3 (en) Method of managing trace sessions in a network and trace session management system
ITMI20071845A1 (it) Apparecchiatura per la cernita delle fibre o la selezione delle fibre di un nastro di fibre comprendente fibre tessili, specialmente per la pettinatura
EA201300513A1 (ru) Волокна для контролируемого разложения
EP2629465A4 (de) Dienststeuerungsverfahren und -vorrichtung an einem zugangsknoten
CL2014000451A1 (es) Metodo para sedar, anestesiar o someter a eutanasia un organismo acuático que comprende poner en contacto dicho organismo con linalol; composición que comprende linalol y al menos un solvente o surfactante.
BR102012023812B8 (pt) Método para a fabricação de um material absorvente fibroso
FR3033280B1 (fr) Procede d'inspection de fibres drapees par une machine de placement de fibres
EP3945506C0 (de) Verwaltungssystem für casino-artikel
ATE454770T1 (de) Nachrichtensequenzer für korrelierte unternehmensereignisse
GB201209660D0 (en) Data lifecycle management
CO6670516A2 (es) Cortacircuito de operación múltiple
MY184612A (en) A system and method for ranking recommendations