CN105740312B - 使数据库查询形成聚类以用于运行时间预测 - Google Patents

使数据库查询形成聚类以用于运行时间预测 Download PDF

Info

Publication number
CN105740312B
CN105740312B CN201510993945.2A CN201510993945A CN105740312B CN 105740312 B CN105740312 B CN 105740312B CN 201510993945 A CN201510993945 A CN 201510993945A CN 105740312 B CN105740312 B CN 105740312B
Authority
CN
China
Prior art keywords
query
index
database
values
cluster
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
CN201510993945.2A
Other languages
English (en)
Chinese (zh)
Other versions
CN105740312A (zh
Inventor
I·贝勒吉提
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.)
Dassault Systemes SE
Original Assignee
Dassault Systemes SE
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 Dassault Systemes SE filed Critical Dassault Systemes SE
Publication of CN105740312A publication Critical patent/CN105740312A/zh
Application granted granted Critical
Publication of CN105740312B publication Critical patent/CN105740312B/zh
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

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/24542—Plan optimisation
    • 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/22—Indexing; Data structures therefor; Storage structures
    • G06F16/2228—Indexing structures
    • G06F16/2272—Management thereof
    • 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/24542—Plan optimisation
    • G06F16/24545—Selectivity estimation or determination
    • 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/24547—Optimisations to support specific applications; Extensibility of optimisers
    • 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/28—Databases characterised by their database models, e.g. relational or object models
    • G06F16/284—Relational databases
    • G06F16/285—Clustering or classification
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F18/00—Pattern recognition
    • G06F18/20—Analysing
    • G06F18/23—Clustering techniques
    • G06F18/232—Non-hierarchical techniques
    • G06F18/2321—Non-hierarchical techniques using statistics or function optimisation, e.g. modelling of probability density functions
    • G06F18/23213—Non-hierarchical techniques using statistics or function optimisation, e.g. modelling of probability density functions with fixed number of clusters, e.g. K-means clustering

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Operations Research (AREA)
  • Probability & Statistics with Applications (AREA)
  • Life Sciences & Earth Sciences (AREA)
  • Artificial Intelligence (AREA)
  • Bioinformatics & Cheminformatics (AREA)
  • Bioinformatics & Computational Biology (AREA)
  • Computer Vision & Pattern Recognition (AREA)
  • Evolutionary Biology (AREA)
  • Evolutionary Computation (AREA)
  • Software Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
CN201510993945.2A 2014-12-27 2015-12-25 使数据库查询形成聚类以用于运行时间预测 Active CN105740312B (zh)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
EP14307192.6 2014-12-27
EP14307192.6A EP3038018A1 (en) 2014-12-27 2014-12-27 Clustering database queries for runtime prediction

Publications (2)

Publication Number Publication Date
CN105740312A CN105740312A (zh) 2016-07-06
CN105740312B true CN105740312B (zh) 2020-10-23

Family

ID=52396394

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201510993945.2A Active CN105740312B (zh) 2014-12-27 2015-12-25 使数据库查询形成聚类以用于运行时间预测

Country Status (4)

Country Link
US (1) US10191967B2 (enExample)
EP (1) EP3038018A1 (enExample)
JP (1) JP6673683B2 (enExample)
CN (1) CN105740312B (enExample)

Families Citing this family (22)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9959354B2 (en) * 2015-06-23 2018-05-01 Google Llc Utilizing user co-search behavior to identify search queries seeking inappropriate content
US11249995B2 (en) * 2016-12-30 2022-02-15 Salesforce.Com, Inc. Techniques and architectures for providing and operating an application-aware database environment with predictive execution of queries and query flows
US11120021B2 (en) * 2017-01-11 2021-09-14 Facebook, Inc. Systems and methods for optimizing queries
CN106991006B (zh) * 2017-03-30 2018-05-15 浙江天正信息科技有限公司 支持依赖和时间平衡的云工作流任务聚类方法
US11372858B2 (en) * 2017-05-18 2022-06-28 Oracle International Corporation Estimated query performance
CN107491508B (zh) * 2017-08-01 2020-05-26 浙江大学 一种基于循环神经网络的数据库查询时间预测方法
CN108052614B (zh) * 2017-12-14 2021-12-03 太原理工大学 一种数据库系统负载的调度方法
US11100555B1 (en) * 2018-05-04 2021-08-24 Coupa Software Incorporated Anticipatory and responsive federated database search
US12013856B2 (en) 2018-08-13 2024-06-18 Amazon Technologies, Inc. Burst performance of database queries according to query size
US11586939B2 (en) * 2019-02-28 2023-02-21 Entigenlogic Llc Generating comparison information
US11327970B1 (en) * 2019-03-25 2022-05-10 Amazon Technologies, Inc. Context dependent execution time prediction for redirecting queries
US11308100B2 (en) 2019-06-25 2022-04-19 Amazon Technologies, Inc. Dynamically assigning queries to secondary query processing resources
CN110825894B (zh) * 2019-09-18 2024-10-11 平安科技（深圳）有限公司 数据索引建立、数据检索方法、装置、设备和存储介质
US11314561B2 (en) 2020-03-11 2022-04-26 UiPath, Inc. Bottleneck detection for processes
US11416270B2 (en) * 2020-03-11 2022-08-16 Td Ameritrade Ip Company, Inc. Systems and methods for dynamic server control based on estimated script complexity
US11537616B1 (en) 2020-06-29 2022-12-27 Amazon Technologies, Inc. Predicting query performance for prioritizing query execution
CN112256725B (zh) * 2020-11-06 2024-10-15 山东伏羲智库互联网研究院 一种基于gpu和cpu的相似数据查询方法及系统
CN112397146B (zh) * 2020-12-02 2021-08-24 广东美格基因科技有限公司 一种基于云平台的微生物组学数据交互分析系统
US11741101B2 (en) 2020-12-15 2023-08-29 International Business Machines Corporation Estimating execution time for batch queries
US20250086202A1 (en) * 2023-09-13 2025-03-13 Microsoft Technology Licensing, Llc Robust tuner for database cluster configuration tuning in production
CN119003326B (zh) * 2023-11-22 2025-08-22 北京字跳网络技术有限公司 应用调试的方法、信息查询的方法、应用评测的方法
US12248473B1 (en) * 2023-12-14 2025-03-11 Amazon Technologies, Inc. Query performance prediction using multiple experts

Family Cites Families (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US1543036A (en) 1924-10-10 1925-06-23 Lawrence H Taylor Domestic press
US5694591A (en) 1995-05-02 1997-12-02 Hewlett Packard Company Reducing query response time using tree balancing
US7356526B2 (en) 2003-09-30 2008-04-08 International Business Machines Corporation Estimating the compilation time of a query optimizer
US20050192937A1 (en) 2004-02-26 2005-09-01 International Business Machines Corporation Dynamic query optimization
US8346761B2 (en) 2004-08-05 2013-01-01 International Business Machines Corporation Method and system for data mining for automatic query optimization
US7831594B2 (en) 2007-04-30 2010-11-09 Hewlett-Packard Development Company, L.L.P. Estimating the static execution time of a database query
US7895192B2 (en) 2007-07-19 2011-02-22 Hewlett-Packard Development Company, L.P. Estimating the loaded execution runtime of a database query
US8352480B2 (en) * 2010-12-20 2013-01-08 Nokia Corporation Methods, apparatuses and computer program products for converting a geographical database into a map tile database
EP2909743B1 (en) * 2012-10-19 2018-06-27 Telefonaktiebolaget LM Ericsson (publ) A federated database system

Also Published As

Publication number Publication date
EP3038018A1 (en) 2016-06-29
JP2016126770A (ja) 2016-07-11
CN105740312A (zh) 2016-07-06
JP6673683B2 (ja) 2020-03-25
US10191967B2 (en) 2019-01-29
US20160188696A1 (en) 2016-06-30

Similar Documents

Publication Publication Date Title
CN105740312B (zh) 使数据库查询形成聚类以用于运行时间预测
US10657229B2 (en) Building resilient models to address dynamic customer data use rights
Hopfensitz et al. Multiscale binarization of gene expression data for reconstructing Boolean networks
CN104573130B (zh) 基于群体计算的实体解析方法及装置
US20220382622A1 (en) Point Anomaly Detection
US20190354839A1 (en) Systems and Methods for Slate Optimization with Recurrent Neural Networks
JP2020522055A5 (enExample)
Raza et al. Performance prediction and adaptation for database management system workload using case-based reasoning approach
WO2018004829A1 (en) Methods and apparatus for subgraph matching in big data analysis
CN107480694B (zh) 基于Spark平台采用两次评价的加权选择集成三支聚类方法
CN114202123A (zh) 业务数据预测方法、装置、电子设备及存储介质
Seidl et al. Indexing density models for incremental learning and anytime classification on data streams
US20150294052A1 (en) Anomaly detection using tripoint arbitration
US20250005436A1 (en) Automatic generation of attributes based on semantic categorization of large datasets in artificial intelligence models and applications
Zhang et al. Efficient missing data imputation for supervised learning
Milicevic et al. A systematic review of deep learning applications in database query execution
Li et al. Gaussml: An end-to-end in-database machine learning system
CN115472257A (zh) 一种招募用户的方法、装置、电子设备及存储介质
KR20230170679A (ko) 심층 학습을 위한 효율적인 복셀화
Elayidom et al. A generalized data mining framework for placement chance prediction problems
US9158815B2 (en) Estimating a number of unique values in a list
Quader et al. LearnedWMP: Workload Memory Prediction Using Distribution of Query Templates
KR20230171930A (ko) 3차원(3d) 단백질 구조들을 사용하여 변이체 병원성을 예측하기 위한 심층 콘볼루션 신경망들
CN114723084A (zh) 新颖性物品召回模型的生成方法、召回方法及装置和系统
Thiyagarajan Platfora Method for High Data Delivery in Large Datasets

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant