CN108052614A - 一种数据库系统负载的调度方法 - Google Patents
一种数据库系统负载的调度方法 Download PDFInfo
- Publication number
- CN108052614A CN108052614A CN201711343745.8A CN201711343745A CN108052614A CN 108052614 A CN108052614 A CN 108052614A CN 201711343745 A CN201711343745 A CN 201711343745A CN 108052614 A CN108052614 A CN 108052614A
- Authority
- CN
- China
- Prior art keywords
- inquiry
- response time
- combination
- query
- database
- 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
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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- 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/2462—Approximate or statistical queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Probability & Statistics with Applications (AREA)
- Data Mining & Analysis (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Fuzzy Systems (AREA)
- Computing Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (2)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201711343745.8A CN108052614B (zh) | 2017-12-14 | 2017-12-14 | 一种数据库系统负载的调度方法 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201711343745.8A CN108052614B (zh) | 2017-12-14 | 2017-12-14 | 一种数据库系统负载的调度方法 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN108052614A true CN108052614A (zh) | 2018-05-18 |
CN108052614B CN108052614B (zh) | 2021-12-03 |
Family
ID=62132198
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201711343745.8A Active CN108052614B (zh) | 2017-12-14 | 2017-12-14 | 一种数据库系统负载的调度方法 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN108052614B (zh) |
Citations (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103136045A (zh) * | 2011-11-24 | 2013-06-05 | 中兴通讯股份有限公司 | 虚拟化操作系统中的调度方法和装置 |
US20130173632A1 (en) * | 2009-06-25 | 2013-07-04 | University Of Tennessee Research Foundation | Method and apparatus for predicting object properties and events using similarity-based information retrieval and modeling |
US20130226903A1 (en) * | 2012-02-27 | 2013-08-29 | Nec Laboratories America, Inc. | Predicting query execution time |
CN103488673A (zh) * | 2012-06-11 | 2014-01-01 | 富士通株式会社 | 用于执行调和处理的方法、控制器、程序及数据存储系统 |
CN104731973A (zh) * | 2015-04-13 | 2015-06-24 | 成都汇智远景科技有限公司 | 一种查询数据的方法 |
CN104794186A (zh) * | 2015-04-13 | 2015-07-22 | 太原理工大学 | 数据库负载响应时间预测模型训练样本的采集方法 |
CN105373428A (zh) * | 2015-12-09 | 2016-03-02 | 北京奇虎科技有限公司 | 一种任务调度方法和系统 |
CN105740312A (zh) * | 2014-12-27 | 2016-07-06 | 达索系统公司 | 使数据库查询形成聚类以用于运行时间预测 |
CN106156939A (zh) * | 2015-04-27 | 2016-11-23 | 上海宝信软件股份有限公司 | 基于作业流的分布式调度系统及应用方法 |
-
2017
- 2017-12-14 CN CN201711343745.8A patent/CN108052614B/zh active Active
Patent Citations (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20130173632A1 (en) * | 2009-06-25 | 2013-07-04 | University Of Tennessee Research Foundation | Method and apparatus for predicting object properties and events using similarity-based information retrieval and modeling |
CN103136045A (zh) * | 2011-11-24 | 2013-06-05 | 中兴通讯股份有限公司 | 虚拟化操作系统中的调度方法和装置 |
US20130226903A1 (en) * | 2012-02-27 | 2013-08-29 | Nec Laboratories America, Inc. | Predicting query execution time |
CN103488673A (zh) * | 2012-06-11 | 2014-01-01 | 富士通株式会社 | 用于执行调和处理的方法、控制器、程序及数据存储系统 |
CN105740312A (zh) * | 2014-12-27 | 2016-07-06 | 达索系统公司 | 使数据库查询形成聚类以用于运行时间预测 |
CN104731973A (zh) * | 2015-04-13 | 2015-06-24 | 成都汇智远景科技有限公司 | 一种查询数据的方法 |
CN104794186A (zh) * | 2015-04-13 | 2015-07-22 | 太原理工大学 | 数据库负载响应时间预测模型训练样本的采集方法 |
CN106156939A (zh) * | 2015-04-27 | 2016-11-23 | 上海宝信软件股份有限公司 | 基于作业流的分布式调度系统及应用方法 |
CN105373428A (zh) * | 2015-12-09 | 2016-03-02 | 北京奇虎科技有限公司 | 一种任务调度方法和系统 |
Non-Patent Citations (2)
Title |
---|
SHIGERU MASUYAMA等: ""Minimum Delay Semijoin Schedules For Local Area Dstributed Database Systems"", 《数理解析研究所講究錄》 * |
罗伟良等: ""面向异构计算平台的列数据库调度方法研究与实现"", 《2012年全国高性能计算学术年会论文集》 * |
Also Published As
Publication number | Publication date |
---|---|
CN108052614B (zh) | 2021-12-03 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US9152669B2 (en) | System and method for distributed SQL join processing in shared-nothing relational database clusters using stationary tables | |
CN106527381B (zh) | 一种面向并行批处理机动态调度的快速评估方法 | |
CN103927346B (zh) | 基于数据量的查询连接方法 | |
CN103870507B (zh) | 一种基于类目的搜索方法和装置 | |
CN107391713A (zh) | 一种解决协同过滤推荐技术中冷启动问题的方法及系统 | |
CN105843189B (zh) | 一种用于半导体生产线基于简化仿真模型的高效调度规则选择方法 | |
CN106897374B (zh) | 一种基于轨迹大数据最近邻查询的个性化推荐方法 | |
CN108469988A (zh) | 一种基于异构Hadoop集群的任务调度方法 | |
CN105302858B (zh) | 一种分布式数据库系统的跨节点查询优化方法及系统 | |
US9442949B2 (en) | System and method for compressing data in a database | |
CN103942375A (zh) | 基于区间的高速压力机滑块尺寸稳健设计方法 | |
CN115118602B (zh) | 一种基于使用量预测的容器资源动态调度方法及系统 | |
CN105512264A (zh) | 分布式数据库中并发工作负载的性能预测方法 | |
CN106127229A (zh) | 一种基于时间序列类别的计算机数据分类方法 | |
CN108681849A (zh) | 一种货物运输自动定价的方法及装置 | |
US7890705B2 (en) | Shared-memory multiprocessor system and information processing method | |
CN114615304B (zh) | 前分平台式工业物联网控制方法及系统 | |
CN110059261A (zh) | 内容推荐方法及装置 | |
CN109409848A (zh) | 开放式流程的节点智能推荐方法、终端设备及存储介质 | |
CN109215097A (zh) | 一种基于端到端联合学习的单个图像文本条件嵌入方法 | |
Wijayanto et al. | Implementation of multi-criteria collaborative filtering on cluster using Apache Spark | |
CN108829846B (zh) | 一种基于用户特征的业务推荐平台数据聚类优化系统及方法 | |
CN109086381A (zh) | 模糊概念格的一种更新生成方法 | |
CN106204094A (zh) | 一种基于b2b平台的需求信息推送方法、装置 | |
CN104573331B (zh) | 一种基于MapReduce的K近邻数据预测方法 |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | 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 | ||
TR01 | Transfer of patent right |
Effective date of registration: 20221228 Address after: Room 02A-084, Building C (Second Floor), No. 28, Xinxi Road, Haidian District, Beijing 100085 Patentee after: Jingchuang United (Beijing) Intellectual Property Service Co.,Ltd. Address before: 030024 No. 79 West Main Street, Taiyuan, Shanxi, Yingze Patentee before: Taiyuan University of Technology Effective date of registration: 20221228 Address after: Room 606-609, Compound Office Complex Building, No. 757, Dongfeng East Road, Yuexiu District, Guangzhou, Guangdong Province, 510699 Patentee after: China Southern Power Grid Internet Service Co.,Ltd. Address before: Room 02A-084, Building C (Second Floor), No. 28, Xinxi Road, Haidian District, Beijing 100085 Patentee before: Jingchuang United (Beijing) Intellectual Property Service Co.,Ltd. |
|
TR01 | Transfer of patent right |