CN104834675B - 一种基于用户行为分析的查询性能优化方法 - Google Patents
一种基于用户行为分析的查询性能优化方法 Download PDFInfo
- Publication number
- CN104834675B CN104834675B CN201510153663.1A CN201510153663A CN104834675B CN 104834675 B CN104834675 B CN 104834675B CN 201510153663 A CN201510153663 A CN 201510153663A CN 104834675 B CN104834675 B CN 104834675B
- Authority
- CN
- China
- Prior art keywords
- data
- user
- behavior
- inquiry
- access
- 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
Links
- 238000004458 analytical method Methods 0.000 title claims abstract description 45
- 238000000034 method Methods 0.000 title claims abstract description 31
- 238000005457 optimization Methods 0.000 title claims abstract description 23
- 238000003860 storage Methods 0.000 claims abstract description 41
- 230000003542 behavioural effect Effects 0.000 claims abstract description 19
- 230000008569 process Effects 0.000 claims abstract description 10
- 230000000694 effects Effects 0.000 claims abstract description 8
- 230000006978 adaptation Effects 0.000 claims abstract description 6
- 238000004321 preservation Methods 0.000 claims abstract description 6
- 238000004364 calculation method Methods 0.000 claims description 10
- 230000004044 response Effects 0.000 claims description 8
- 238000004590 computer program Methods 0.000 claims description 3
- 230000002123 temporal effect Effects 0.000 claims description 3
- 230000014759 maintenance of location Effects 0.000 claims 1
- 230000006399 behavior Effects 0.000 abstract description 56
- 230000006872 improvement Effects 0.000 abstract description 3
- 238000010801 machine learning Methods 0.000 abstract 1
- 238000005516 engineering process Methods 0.000 description 7
- 230000006870 function Effects 0.000 description 5
- 238000004422 calculation algorithm Methods 0.000 description 4
- 230000003111 delayed effect Effects 0.000 description 2
- 230000003139 buffering effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 230000007423 decrease Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 230000009467 reduction Effects 0.000 description 1
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
- 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/40—Information retrieval; Database structures therefor; File system structures therefor of multimedia data, e.g. slideshows comprising image and additional audio data
- G06F16/43—Querying
Abstract
Description
Claims (4)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510153663.1A CN104834675B (zh) | 2015-04-02 | 2015-04-02 | 一种基于用户行为分析的查询性能优化方法 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510153663.1A CN104834675B (zh) | 2015-04-02 | 2015-04-02 | 一种基于用户行为分析的查询性能优化方法 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN104834675A CN104834675A (zh) | 2015-08-12 |
CN104834675B true CN104834675B (zh) | 2018-02-23 |
Family
ID=53812563
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201510153663.1A Active CN104834675B (zh) | 2015-04-02 | 2015-04-02 | 一种基于用户行为分析的查询性能优化方法 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN104834675B (zh) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20220398244A1 (en) * | 2021-09-23 | 2022-12-15 | Beijing Baidu Netcom Science Technology Co., Ltd. | Query method and device and storage medium |
Families Citing this family (21)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107239572A (zh) * | 2017-06-28 | 2017-10-10 | 郑州云海信息技术有限公司 | 一种存储管理软件的数据缓存方法及装置 |
CN107943534B (zh) * | 2017-11-14 | 2021-02-02 | Oppo广东移动通信有限公司 | 后台应用程序的关闭方法、装置、存储介质及电子设备 |
CN110019394A (zh) * | 2017-11-28 | 2019-07-16 | 阿里巴巴集团控股有限公司 | 数据查询方法及设备 |
CN108280502B (zh) * | 2018-01-18 | 2020-10-27 | 福建工程学院 | 一种qr码容量提升方法及终端 |
CN110209687B (zh) * | 2018-02-23 | 2021-06-22 | 北京国双科技有限公司 | 多维度归因的查询方法和装置 |
CN110189153B (zh) * | 2018-02-23 | 2021-09-07 | 北京国双科技有限公司 | 归因方法和装置 |
CN108509501B (zh) * | 2018-02-28 | 2022-07-26 | 成都国恒空间技术工程股份有限公司 | 一种查询处理方法、服务器及计算机可读存储介质 |
CN110381375B (zh) * | 2018-04-13 | 2022-06-21 | 武汉斗鱼网络科技有限公司 | 一种确定盗刷数据的方法、客户端及服务器 |
CN108664579B (zh) * | 2018-05-03 | 2021-07-02 | 杭州美登科技股份有限公司 | 海量数据实时筛选分析方法、系统及存储介质 |
CN108763443A (zh) * | 2018-05-25 | 2018-11-06 | 众安信息技术服务有限公司 | 区块链账户处理方法与装置 |
CN109101346A (zh) * | 2018-07-12 | 2018-12-28 | 北京猫眼文化传媒有限公司 | 一种数据服务提供方法及装置 |
CN109656959A (zh) * | 2018-12-24 | 2019-04-19 | 拉扎斯网络科技(上海)有限公司 | 一种数据查询方法、装置、电子设备和存储介质 |
CN109976905B (zh) * | 2019-03-01 | 2021-10-22 | 联想(北京)有限公司 | 内存管理方法、装置和电子设备 |
CN110032578B (zh) * | 2019-04-22 | 2023-04-11 | 浪潮通用软件有限公司 | 一种海量数据查询缓存的方法及装置 |
CN110275677B (zh) * | 2019-05-22 | 2022-04-12 | 华为技术有限公司 | 硬盘格式转换方法、装置及存储设备 |
CN110363897B (zh) * | 2019-07-25 | 2021-04-27 | 新奥(中国)燃气投资有限公司 | 一种客户热度图生成方法及装置 |
CN112035766A (zh) * | 2020-08-05 | 2020-12-04 | 北京三快在线科技有限公司 | 网页访问方法、装置、存储介质及电子设备 |
CN112069211B (zh) * | 2020-08-21 | 2022-11-22 | 苏州浪潮智能科技有限公司 | 一种基于Solr的缓存预热优化方法及装置 |
CN112948289B (zh) * | 2021-03-03 | 2022-09-30 | 上海天旦网络科技发展有限公司 | 一种基于机器学习的缓存预测调度方法、系统及介质 |
CN114860770B (zh) * | 2022-04-15 | 2022-12-16 | 北京科杰科技有限公司 | 基于数据服务的优化方法、系统、计算机设备及介质 |
CN114564667B (zh) * | 2022-04-28 | 2022-07-19 | 深圳市艾德网络科技发展有限公司 | 分析大规模数据的低延时缓存数据处理方法 |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1885823A (zh) * | 2006-06-06 | 2006-12-27 | 北京北大方正电子有限公司 | 一种基于预测搜索的网络文件传输方法 |
CN101216825A (zh) * | 2007-12-29 | 2008-07-09 | 朱廷劭 | 标引关键词提取/预测方法、在线广告推荐方法和装置 |
CN101246495A (zh) * | 2008-03-21 | 2008-08-20 | 深圳国人通信有限公司 | 一种构造查询方案及使用其进行数据查询和统计的方法 |
Family Cites Families (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20030097263A1 (en) * | 2001-11-16 | 2003-05-22 | Lee Hang Shun | Decision tree based speech recognition |
-
2015
- 2015-04-02 CN CN201510153663.1A patent/CN104834675B/zh active Active
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1885823A (zh) * | 2006-06-06 | 2006-12-27 | 北京北大方正电子有限公司 | 一种基于预测搜索的网络文件传输方法 |
CN101216825A (zh) * | 2007-12-29 | 2008-07-09 | 朱廷劭 | 标引关键词提取/预测方法、在线广告推荐方法和装置 |
CN101246495A (zh) * | 2008-03-21 | 2008-08-20 | 深圳国人通信有限公司 | 一种构造查询方案及使用其进行数据查询和统计的方法 |
Non-Patent Citations (2)
Title |
---|
《垂直搜索引擎在团购网站中的研究与应用》;林印华;《中国优秀硕士论文全文数据库 信息科技辑》;20140315;论文第1、4、5章 * |
《基于百度百科的查询意图分类》;王井丰;《中国优秀硕士论文全文数据库 信息科技辑》;20130815;论文第2-4章 * |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20220398244A1 (en) * | 2021-09-23 | 2022-12-15 | Beijing Baidu Netcom Science Technology Co., Ltd. | Query method and device and storage medium |
Also Published As
Publication number | Publication date |
---|---|
CN104834675A (zh) | 2015-08-12 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN104834675B (zh) | 一种基于用户行为分析的查询性能优化方法 | |
US9892150B2 (en) | Unified data management for database systems | |
CN105426411B (zh) | 基于访问趋势预测的时间序列数据库缓存管理方法 | |
US9195693B2 (en) | Transaction prediction modeling method | |
US7331038B1 (en) | Predictive prefetching to improve parallelization of document generation subtasks | |
US9146956B2 (en) | Statistical applications in OLTP environment | |
US7523094B1 (en) | Asynchronous task for energy cost aware database query optimization | |
Gounaris et al. | Adaptive query processing: A survey | |
US8185546B2 (en) | Enhanced control to users to populate a cache in a database system | |
EP2113848B1 (en) | Adaptive caching for high volume extract transform load process | |
US11461332B2 (en) | Methods and apparatus to search datasets | |
CN109240946A (zh) | 数据的多级缓存方法及终端设备 | |
AU2005322096A1 (en) | System and method for adaptive query identification and acceleration | |
WO2007068667A1 (en) | Method and apparatus for analyzing the effect of different execution parameters on the performance of a database query | |
CN110442616B (zh) | 一种针对大数据量的页面访问路径分析方法与系统 | |
KR102415155B1 (ko) | 데이터 검색 장치 및 방법 | |
US10013353B2 (en) | Adaptive optimization of second level cache | |
CN101052944B (zh) | 用于关系数据库中存储数据的细化访问控制的系统和方法 | |
US11520767B2 (en) | Automated database cache resizing | |
Lin et al. | Dealing with query contention issue in real-time data warehouses by dynamic multi-level caches | |
US20240143593A1 (en) | Dynamic cache manager | |
CN117234745B (zh) | 一种面向异构计算平台的数据库负载均衡方法及装置 | |
US20230244666A1 (en) | Determining dimension tables for star schema joins | |
CN116361265A (zh) | 数据库存储优化方法、系统、电子设备及存储介质 | |
Fritchey et al. | SQL Query Performance Tuning |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
EXSB | Decision made by sipo to initiate substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20180808 Address after: 250100 S06 tower, 1036, Chao Lu Road, hi tech Zone, Ji'nan, Shandong. Patentee after: Shandong wave cloud Mdt InfoTech Ltd Address before: No. 1036, Shandong high tech Zone wave road, Ji'nan, Shandong Patentee before: Inspur Group Co., Ltd. |
|
CP03 | Change of name, title or address | ||
CP03 | Change of name, title or address |
Address after: 250100 No. 1036 Tidal Road, Jinan High-tech Zone, Shandong Province, S01 Building, Tidal Science Park Patentee after: Inspur cloud Information Technology Co., Ltd Address before: 250100 Ji'nan science and technology zone, Shandong high tide Road, No. 1036 wave of science and Technology Park, building S06 Patentee before: SHANDONG LANGCHAO YUNTOU INFORMATION TECHNOLOGY Co.,Ltd. |