CN107145549B - 一种数据库缓存控制方法以及*** - Google Patents
一种数据库缓存控制方法以及*** Download PDFInfo
- Publication number
- CN107145549B CN107145549B CN201710284987.8A CN201710284987A CN107145549B CN 107145549 B CN107145549 B CN 107145549B CN 201710284987 A CN201710284987 A CN 201710284987A CN 107145549 B CN107145549 B CN 107145549B
- Authority
- CN
- China
- Prior art keywords
- query
- mapping table
- statement
- updating
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 17
- 238000013507 mapping Methods 0.000 claims abstract description 221
- 230000009191 jumping Effects 0.000 claims description 6
- 230000001960 triggered effect Effects 0.000 claims description 6
- 230000003190 augmentative effect Effects 0.000 description 3
- 239000012141 concentrate Substances 0.000 description 2
- 239000000470 constituent Substances 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
Images
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/2455—Query execution
- G06F16/24564—Applying rules; Deductive queries
-
- 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/24552—Database cache management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (4)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710284987.8A CN107145549B (zh) | 2017-04-27 | 2017-04-27 | 一种数据库缓存控制方法以及*** |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710284987.8A CN107145549B (zh) | 2017-04-27 | 2017-04-27 | 一种数据库缓存控制方法以及*** |
Publications (2)
Publication Number | Publication Date |
---|---|
CN107145549A CN107145549A (zh) | 2017-09-08 |
CN107145549B true CN107145549B (zh) | 2020-01-14 |
Family
ID=59775008
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710284987.8A Active CN107145549B (zh) | 2017-04-27 | 2017-04-27 | 一种数据库缓存控制方法以及*** |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN107145549B (zh) |
Families Citing this family (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107832336A (zh) * | 2017-10-10 | 2018-03-23 | 北京京东尚科信息技术有限公司 | 数据处理方法及其*** |
CN108305625B (zh) * | 2018-01-29 | 2020-12-18 | 深圳春沐源控股有限公司 | 语音控制方法及装置、电子设备和计算机可读存储介质 |
CN110046170B (zh) * | 2019-04-22 | 2021-07-27 | 深圳乐信软件技术有限公司 | 基于多文件管理的语句执行方法、装置、设备和介质 |
CN110288264A (zh) * | 2019-07-03 | 2019-09-27 | 深圳智高点知识产权运营有限公司 | 一种企业商标监控分析***和方法 |
CN110321355A (zh) * | 2019-07-12 | 2019-10-11 | 杭州美巴科技有限公司 | 一种自适应部分查询字段***及执行方法 |
Citations (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101021875A (zh) * | 2007-03-22 | 2007-08-22 | 金蝶软件(中国)有限公司 | 面向对象的数据库访问方法及*** |
CN101706781A (zh) * | 2009-09-29 | 2010-05-12 | 北京星网锐捷网络技术有限公司 | 一种数据库缓存集中管理方法和*** |
CN101860449A (zh) * | 2009-04-09 | 2010-10-13 | 华为技术有限公司 | 一种数据查询方法、装置及*** |
CN102542034A (zh) * | 2011-12-23 | 2012-07-04 | 北京人大金仓信息技术股份有限公司 | 一种数据库接口的结果集缓存方法 |
CN102915380A (zh) * | 2012-11-19 | 2013-02-06 | 北京奇虎科技有限公司 | 用于对数据进行搜索的方法和*** |
CN102937980A (zh) * | 2012-10-18 | 2013-02-20 | 亿赞普(北京)科技有限公司 | 一种集群数据库数据查询方法 |
CN103268343A (zh) * | 2013-05-24 | 2013-08-28 | 北京京东尚科信息技术有限公司 | 将关系数据库和缓存透明结合的***和方法 |
CN104182405A (zh) * | 2013-05-22 | 2014-12-03 | 阿里巴巴集团控股有限公司 | 一种连接查询方法及装置 |
CN105512222A (zh) * | 2015-11-30 | 2016-04-20 | 中国建设银行股份有限公司 | 数据查询方法及***和数据读取方法及*** |
CN105740383A (zh) * | 2016-01-27 | 2016-07-06 | 中国科学院计算技术研究所 | 一种大数据平台下数据库与缓存的数据一致性方法及*** |
CN106294565A (zh) * | 2016-07-27 | 2017-01-04 | 中国农业银行股份有限公司 | 一种数据库访问方法及*** |
CN106599199A (zh) * | 2016-12-14 | 2017-04-26 | 国云科技股份有限公司 | 一种数据缓存与同步方法 |
-
2017
- 2017-04-27 CN CN201710284987.8A patent/CN107145549B/zh active Active
Patent Citations (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101021875A (zh) * | 2007-03-22 | 2007-08-22 | 金蝶软件(中国)有限公司 | 面向对象的数据库访问方法及*** |
CN101860449A (zh) * | 2009-04-09 | 2010-10-13 | 华为技术有限公司 | 一种数据查询方法、装置及*** |
CN101706781A (zh) * | 2009-09-29 | 2010-05-12 | 北京星网锐捷网络技术有限公司 | 一种数据库缓存集中管理方法和*** |
CN102542034A (zh) * | 2011-12-23 | 2012-07-04 | 北京人大金仓信息技术股份有限公司 | 一种数据库接口的结果集缓存方法 |
CN102937980A (zh) * | 2012-10-18 | 2013-02-20 | 亿赞普(北京)科技有限公司 | 一种集群数据库数据查询方法 |
CN102915380A (zh) * | 2012-11-19 | 2013-02-06 | 北京奇虎科技有限公司 | 用于对数据进行搜索的方法和*** |
CN104182405A (zh) * | 2013-05-22 | 2014-12-03 | 阿里巴巴集团控股有限公司 | 一种连接查询方法及装置 |
CN103268343A (zh) * | 2013-05-24 | 2013-08-28 | 北京京东尚科信息技术有限公司 | 将关系数据库和缓存透明结合的***和方法 |
CN105512222A (zh) * | 2015-11-30 | 2016-04-20 | 中国建设银行股份有限公司 | 数据查询方法及***和数据读取方法及*** |
CN105740383A (zh) * | 2016-01-27 | 2016-07-06 | 中国科学院计算技术研究所 | 一种大数据平台下数据库与缓存的数据一致性方法及*** |
CN106294565A (zh) * | 2016-07-27 | 2017-01-04 | 中国农业银行股份有限公司 | 一种数据库访问方法及*** |
CN106599199A (zh) * | 2016-12-14 | 2017-04-26 | 国云科技股份有限公司 | 一种数据缓存与同步方法 |
Also Published As
Publication number | Publication date |
---|---|
CN107145549A (zh) | 2017-09-08 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107145549B (zh) | 一种数据库缓存控制方法以及*** | |
CN107247808B (zh) | 一种分布式NewSQL数据库***及图片数据查询方法 | |
CN106934062B (zh) | 一种查询elasticsearch的实现方法及*** | |
CN100550019C (zh) | 面向对象的数据库访问方法及*** | |
KR102407510B1 (ko) | 데이터 저장 및 조회 방법, 장치, 기기 및 매체 | |
US8601474B2 (en) | Resuming execution of an execution plan in a virtual machine | |
CN107526777B (zh) | 一种基于版本号对文件进行处理的方法及设备 | |
US7676453B2 (en) | Partial query caching | |
US8396852B2 (en) | Evaluating execution plan changes after a wakeup threshold time | |
US20060200438A1 (en) | System and method for retrieving data from a relational database management system | |
US20120278305A1 (en) | Dynamic merging of executable structures in a database system | |
US20020049756A1 (en) | System and method for searching multiple disparate search engines | |
US20140046928A1 (en) | Query plans with parameter markers in place of object identifiers | |
CN104765731A (zh) | 数据库查询优化方法和设备 | |
CN105718593A (zh) | 一种数据库查询优化方法及*** | |
US20060010112A1 (en) | Using a rowset as a query parameter | |
CN105630881A (zh) | 一种rdf的数据存储方法和查询方法 | |
US9218394B2 (en) | Reading rows from memory prior to reading rows from secondary storage | |
US20160103858A1 (en) | Data management system comprising a trie data structure, integrated circuits and methods therefor | |
CN112231321B (zh) | 一种Oracle二级索引及索引实时同步方法 | |
CN111159215B (zh) | Java类与关系型数据库的映射方法、装置及计算设备 | |
CN110046170A (zh) | 基于多文件管理的语句执行方法、装置、设备和介质 | |
US20120179669A1 (en) | Systems and methods for searching a search space of a query | |
US20140067853A1 (en) | Data search method, information system, and recording medium storing data search program | |
CN111125216A (zh) | 数据导入Phoenix的方法及装置 |
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 | ||
CP01 | Change in the name or title of a patent holder | ||
CP01 | Change in the name or title of a patent holder |
Address after: 518000 Room 201, building A, No. 1, Qian Wan Road, Qianhai Shenzhen Hong Kong cooperation zone, Shenzhen, Guangdong (Shenzhen Qianhai business secretary Co., Ltd.) Patentee after: Zhigaogao Intellectual Property Group Co.,Ltd. Address before: 518000 Room 201, building A, No. 1, Qian Wan Road, Qianhai Shenzhen Hong Kong cooperation zone, Shenzhen, Guangdong (Shenzhen Qianhai business secretary Co., Ltd.) Patentee before: SHENZHEN ZHIGAODIAN INTELLECTUAL PROPERTY OPERATION Co.,Ltd. |
|
TR01 | Transfer of patent right |
Effective date of registration: 20230110 Address after: 518064 109, Building 15, Block B, Building 5, No. 54, Xingnan Road, Nanyou Community, Yuehai Street, Nanshan District, Shenzhen, Guangdong Province Patentee after: Guozhi Digital Economy (Shenzhen) Co.,Ltd. Address before: 518000 Room 201, building A, No. 1, Qian Wan Road, Qianhai Shenzhen Hong Kong cooperation zone, Shenzhen, Guangdong (Shenzhen Qianhai business secretary Co., Ltd.) Patentee before: Zhigaogao Intellectual Property Group Co.,Ltd. |
|
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20230428 Address after: Room D504-507, Zhejiang University Science and Technology Park, No. 698 Jingdong Avenue, Nanchang High tech Industrial Development Zone, Nanchang City, Jiangxi Province, 330096 Patentee after: Jiangxi Zhichan Big Data Co.,Ltd. Address before: 518064 109, Building 15, Block B, Building 5, No. 54, Xingnan Road, Nanyou Community, Yuehai Street, Nanshan District, Shenzhen, Guangdong Province Patentee before: Guozhi Digital Economy (Shenzhen) Co.,Ltd. |
|
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20231227 Address after: 518000 Room 109, Building 15, Nanyou District B, Building 5, No. 54, Xingnan Road, Nanyou Community, Yuehai Street, Nanshan District, Shenzhen, Guangdong Patentee after: Guozhi Digital Economy (Shenzhen) Co.,Ltd. Address before: Room D504-507, Zhejiang University Science and Technology Park, No. 698 Jingdong Avenue, Nanchang High tech Industrial Development Zone, Nanchang City, Jiangxi Province, 330096 Patentee before: Jiangxi Zhichan Big Data Co.,Ltd. |
|
TR01 | Transfer of patent right |