SG11201808828RA - Method and system of optimizing database system, electronic device and storage medium - Google Patents

Method and system of optimizing database system, electronic device and storage medium

Info

Publication number
SG11201808828RA
SG11201808828RA SG11201808828RA SG11201808828RA SG11201808828RA SG 11201808828R A SG11201808828R A SG 11201808828RA SG 11201808828R A SG11201808828R A SG 11201808828RA SG 11201808828R A SG11201808828R A SG 11201808828RA SG 11201808828R A SG11201808828R A SG 11201808828RA
Authority
SG
Singapore
Prior art keywords
database system
buffer gets
optimizing
electronic device
storage medium
Prior art date
Application number
SG11201808828RA
Other languages
English (en)
Inventor
Yeung Wong
Original Assignee
Ping An Technology Shenzhen Co Ltd
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 Ping An Technology Shenzhen Co Ltd filed Critical Ping An Technology Shenzhen Co Ltd
Publication of SG11201808828RA publication Critical patent/SG11201808828RA/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/2453—Query optimisation
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/30—Monitoring
    • G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
    • G06F11/3409—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment for performance assessment
    • 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/242—Query formulation
    • G06F16/2433—Query languages
    • 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/24539—Query rewriting; Transformation using cached or materialised query results
    • 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/2455—Query execution
    • G06F16/24564—Applying rules; Deductive queries
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
    • G06F2201/80—Database-specific techniques
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
    • G06F2201/84—Using snapshots, i.e. a logical point-in-time copy of the data

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • General Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Computer Hardware Design (AREA)
  • Quality & Reliability (AREA)
  • Mathematical Physics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Debugging And Monitoring (AREA)
SG11201808828RA 2017-02-20 2017-06-30 Method and system of optimizing database system, electronic device and storage medium SG11201808828RA (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201710088152.5A CN107688589B (zh) 2017-02-20 2017-02-20 数据库系统优化的方法及装置
PCT/CN2017/091375 WO2018149085A1 (zh) 2017-02-20 2017-06-30 数据库系统优化的方法、系统、电子装置及存储介质

Publications (1)

Publication Number Publication Date
SG11201808828RA true SG11201808828RA (en) 2018-11-29

Family

ID=61152404

Family Applications (1)

Application Number Title Priority Date Filing Date
SG11201808828RA SG11201808828RA (en) 2017-02-20 2017-06-30 Method and system of optimizing database system, electronic device and storage medium

Country Status (8)

Country Link
US (1) US11132362B2 (ja)
EP (1) EP3388957B1 (ja)
JP (1) JP6570156B2 (ja)
KR (1) KR102141083B1 (ja)
CN (1) CN107688589B (ja)
AU (1) AU2017399399B2 (ja)
SG (1) SG11201808828RA (ja)
WO (1) WO2018149085A1 (ja)

Families Citing this family (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110888909B (zh) * 2018-09-07 2022-09-23 大唐移动通信设备有限公司 一种评估内容的数据统计处理方法及装置
CN109299132B (zh) * 2018-11-29 2021-08-06 中国人民财产保险股份有限公司 Sql数据处理方法、系统以及电子设备
CN110148011B (zh) * 2019-04-15 2024-03-22 平安科技（深圳）有限公司 基于大数据的活跃量下降分析方法、装置、设备及介质
CN115037798B (zh) * 2022-08-11 2022-12-27 成都金诺信高科技有限公司 一种时统报文数据包分发方法
CN115858399B (zh) * 2023-02-09 2023-05-05 创智和宇信息技术股份有限公司 一种利用线程栈快照进行代码级性能分析的方法和系统

Family Cites Families (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2001175678A (ja) * 1999-12-20 2001-06-29 Toshiba Corp データベース・チューニング装置、データベース・チューニング方法、および記録媒体
US7805411B2 (en) * 2003-09-06 2010-09-28 Oracle International Corporation Auto-tuning SQL statements
JP2007122405A (ja) * 2005-10-28 2007-05-17 Hitachi Ltd データベース管理システムの性能チューニングシステム
US8301636B2 (en) * 2005-12-15 2012-10-30 Microsoft Corporation Providing schedulable calendars electronically
US8903801B2 (en) * 2007-09-14 2014-12-02 Oracle International Corporation Fully automated SQL tuning
CN102541884B (zh) * 2010-12-10 2014-07-02 中国移动通信集团贵州有限公司 数据库优化方法和装置
CN103176974B (zh) * 2011-12-20 2016-01-13 国际商业机器公司 优化数据库中访问路径的方法和装置
CN103390066B (zh) * 2013-08-08 2016-02-17 上海新炬网络信息技术有限公司 一种数据库全局性自动化优化预警装置及其处理方法
KR102160251B1 (ko) * 2013-10-23 2020-09-25 삼성전자주식회사 복수의 프로세서들을 병렬적으로 이용하여 시뮬레이션을 수행하는 방법 및 장치
CN105243068A (zh) * 2014-07-09 2016-01-13 华为技术有限公司 数据库系统的查询方法、服务器和能耗测试系统
CN105989137B (zh) * 2015-02-27 2019-12-10 中国移动通信集团河北有限公司 一种结构化查询语言性能优化方法及系统
CN105302858B (zh) * 2015-09-18 2019-02-05 北京国电通网络技术有限公司 一种分布式数据库系统的跨节点查询优化方法及系统
CN106372135A (zh) * 2016-08-26 2017-02-01 深圳市卓讯信息技术有限公司 一种结构化查询语言sql执行效率跟踪方法及装置
US11232102B2 (en) * 2016-10-17 2022-01-25 Salesforce.Com, Inc. Background processing to provide automated database query tuning

Also Published As

Publication number Publication date
JP2019508774A (ja) 2019-03-28
EP3388957B1 (en) 2020-10-14
EP3388957A4 (en) 2018-11-07
EP3388957A1 (en) 2018-10-17
AU2017399399B2 (en) 2020-01-23
CN107688589B (zh) 2019-02-26
US11132362B2 (en) 2021-09-28
KR20190022434A (ko) 2019-03-06
KR102141083B1 (ko) 2020-08-05
US20190065548A1 (en) 2019-02-28
WO2018149085A1 (zh) 2018-08-23
AU2017399399A1 (en) 2018-10-11
JP6570156B2 (ja) 2019-09-04
CN107688589A (zh) 2018-02-13

Similar Documents

Publication Publication Date Title
SG11201808828RA (en) Method and system of optimizing database system, electronic device and storage medium
SG11201900414WA (en) Signature verification system, signature verification method, and storage medium
US9916354B2 (en) Generating multiple query access plans for multiple computing environments
WO2014143208A8 (en) Systems, methods and apparatuses for implementing data upload, processing, and predictive query api exposure
US20200285642A1 (en) Machine learning model-based dynamic prediction of estimated query execution time taking into account other, concurrently executing queries
WO2014113263A1 (en) Variable duration non-event pattern matching
GB2520878A (en) System and method for matching data using probabilistic modeling techniques
US10929397B2 (en) Forecasting query access plan obsolescence
JP2013517574A5 (ja)
CN104899295A (zh) 一种异构数据源数据关联分析方法
GB2517885A (en) Method and apparatus for processing database data in distributed database system
US20180268079A1 (en) Graph database query classification
US20160292223A1 (en) Generating multiple query access plans for multiple computing environments
US9672214B2 (en) Incrementally updating a large key-value store
AU2021244852B2 (en) Offloading statistics collection
CN104102701A (zh) 一种基于hive的历史数据存档与查询方法
EP4300324A3 (en) Selecting backing stores based on data request
GB2565482A (en) Attribute matching
IN2013CH05996A (ja)
GB2541614A (en) Method and system for micro-accumulation of funds
US9626397B2 (en) Discounted future value operations on a massively parallel processing system and methods thereof
GB2534481A (en) Data analytics for oilfield data repositories
Zhao et al. STOC: extending oracle to support spatiotemporal data management
IN2013CH05008A (ja)
PH22021050178Y1 (en) Data processing for deduplication