WO2012126177A3 - 从数据库中读取数据的方法及装置 - Google Patents

从数据库中读取数据的方法及装置 Download PDF

Info

Publication number
WO2012126177A3
WO2012126177A3 PCT/CN2011/072035 CN2011072035W WO2012126177A3 WO 2012126177 A3 WO2012126177 A3 WO 2012126177A3 CN 2011072035 W CN2011072035 W CN 2011072035W WO 2012126177 A3 WO2012126177 A3 WO 2012126177A3
Authority
WO
WIPO (PCT)
Prior art keywords
data
cache node
database
cache
cached
Prior art date
Application number
PCT/CN2011/072035
Other languages
English (en)
French (fr)
Other versions
WO2012126177A2 (zh
Inventor
王震
Original Assignee
青岛海信传媒网络技术有限公司
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 青岛海信传媒网络技术有限公司 filed Critical 青岛海信传媒网络技术有限公司
Priority to PCT/CN2011/072035 priority Critical patent/WO2012126177A2/zh
Priority to CN201180004080.2A priority patent/CN102741843B/zh
Publication of WO2012126177A2 publication Critical patent/WO2012126177A2/zh
Publication of WO2012126177A3 publication Critical patent/WO2012126177A3/zh

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/2455—Query execution
    • G06F16/24552—Database cache management

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (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

本发明实施例公开了一种从数据库中读取数据的方法及装置，涉及数据库，实现了緩存的实时更新，并且降低了整个应用系统开发的复杂性。本发明的方法包括：根据緩存节点需要緩存的数据内容，为所述需要緩存的数据内容建立数据读取控制表和创建消息队列；当应用程序更新数据库中的数据时，更新数据的数据表对应的触发器，将所述数据表的更新数据信息和所述数据表需要緩存的緩存节点标识，写入到所述数据表对应的消息队列中；緩存节点根据所述緩存节点标识读取所述緩存节点对应的消息队列，并根据所述更新数据信息更新所述緩存节点中的数据。本发明的实施例主要用于緩存系统从数据库读取数据并更新緩存的过程中。
PCT/CN2011/072035 2011-03-22 2011-03-22 从数据库中读取数据的方法及装置 WO2012126177A2 (zh)

Priority Applications (2)

Application Number Priority Date Filing Date Title
PCT/CN2011/072035 WO2012126177A2 (zh) 2011-03-22 2011-03-22 从数据库中读取数据的方法及装置
CN201180004080.2A CN102741843B (zh) 2011-03-22 2011-03-22 从数据库中读取数据的方法及装置

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
PCT/CN2011/072035 WO2012126177A2 (zh) 2011-03-22 2011-03-22 从数据库中读取数据的方法及装置

Publications (2)

Publication Number Publication Date
WO2012126177A2 WO2012126177A2 (zh) 2012-09-27
WO2012126177A3 true WO2012126177A3 (zh) 2012-11-22

Family

ID=46879775

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2011/072035 WO2012126177A2 (zh) 2011-03-22 2011-03-22 从数据库中读取数据的方法及装置

Country Status (2)

Country Link
CN (1) CN102741843B (zh)
WO (1) WO2012126177A2 (zh)

Families Citing this family (26)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103440285B (zh) * 2013-08-14 2016-09-07 北京乐动卓越科技有限公司 大型手机游戏系统及其数据库更新方法
CN105094756B (zh) * 2014-04-28 2018-07-03 阿里巴巴集团控股有限公司 数据读写方法和装置
CN105786882B (zh) * 2014-12-24 2019-04-12 阿里巴巴集团控股有限公司 一种数据表标识生成、数据写入方法及装置
CN106980625B (zh) 2016-01-18 2020-08-04 阿里巴巴集团控股有限公司 一种数据同步方法、装置及系统
US10809998B2 (en) 2016-02-12 2020-10-20 Nutanix, Inc. Virtualized file server splitting and merging
CN106033474A (zh) * 2016-04-21 2016-10-19 苏州奖多多科技有限公司 一种数据同步更新方法、装置及电子设备
US11218418B2 (en) 2016-05-20 2022-01-04 Nutanix, Inc. Scalable leadership election in a multi-processing computing environment
US11568073B2 (en) 2016-12-02 2023-01-31 Nutanix, Inc. Handling permissions for virtualized file servers
US11562034B2 (en) 2016-12-02 2023-01-24 Nutanix, Inc. Transparent referrals for distributed file servers
US11294777B2 (en) 2016-12-05 2022-04-05 Nutanix, Inc. Disaster recovery for distributed file servers, including metadata fixers
US11288239B2 (en) 2016-12-06 2022-03-29 Nutanix, Inc. Cloning virtualized file servers
US11281484B2 (en) 2016-12-06 2022-03-22 Nutanix, Inc. Virtualized server systems and methods including scaling of file system virtual machines
CN106815329A (zh) * 2016-12-29 2017-06-09 网易无尾熊（杭州）科技有限公司 一种缓存数据的更新方法及装置
CN107678856B (zh) * 2017-09-20 2022-04-05 苏宁易购集团股份有限公司 一种处理业务实体中增量信息的方法及装置
CN110019340A (zh) * 2017-12-08 2019-07-16 北京新媒传信科技有限公司 数据存储/读取方法、装置及系统
CN108897868A (zh) * 2018-06-29 2018-11-27 北京奇虎科技有限公司 基于触发器的缓存同步方法及装置、计算设备及存储介质
US11770447B2 (en) 2018-10-31 2023-09-26 Nutanix, Inc. Managing high-availability file servers
CN109597818A (zh) * 2018-11-28 2019-04-09 优刻得科技股份有限公司 数据更新方法、装置、存储介质和设备
CN111563102A (zh) * 2020-04-10 2020-08-21 中国联合网络通信集团有限公司 缓存更新方法、服务器、系统及存储介质
CN111522818B (zh) * 2020-04-23 2023-09-26 北京思特奇信息技术股份有限公司 一种基于内存数据库的多主机间消息交互方法
US11768809B2 (en) * 2020-05-08 2023-09-26 Nutanix, Inc. Managing incremental snapshots for fast leader node bring-up
CN113742617A (zh) * 2020-08-28 2021-12-03 北京沃东天骏信息技术有限公司 一种缓存更新的方法和装置
CN112286973B (zh) * 2020-11-19 2022-09-30 每日互动股份有限公司 数据消息的存储方法、装置、计算机设备及存储介质
CN113377289B (zh) * 2021-06-01 2024-08-13 北京齐尔布莱特科技有限公司 一种缓存管理方法、系统、计算设备及可读存储介质
US12117972B2 (en) 2021-08-19 2024-10-15 Nutanix, Inc. File server managers and systems for managing virtualized file servers
US12072770B2 (en) 2021-08-19 2024-08-27 Nutanix, Inc. Share-based file server replication for disaster recovery

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP4326464B2 (ja) * 2004-12-09 2009-09-09 株式会社野村総合研究所 アプリケーションシステム及び分散データを同期させる方法
CN101770484A (zh) * 2008-12-31 2010-07-07 北大方正集团有限公司 一种网站更新实时发布的方法及系统

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7624126B2 (en) * 2003-06-25 2009-11-24 Microsoft Corporation Registering for and retrieving database table change information that can be used to invalidate cache entries
US7395258B2 (en) * 2004-07-30 2008-07-01 International Business Machines Corporation System and method for adaptive database caching
CN101127041A (zh) * 2007-08-28 2008-02-20 激动集团股份有限公司 一种业务规则基础数据的缓冲方法
CN101188566B (zh) * 2007-12-13 2010-06-02 东软集团股份有限公司 一种集群环境下数据缓存同步的方法及系统
US7917502B2 (en) * 2008-02-27 2011-03-29 International Business Machines Corporation Optimized collection of just-in-time statistics for database query optimization

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP4326464B2 (ja) * 2004-12-09 2009-09-09 株式会社野村総合研究所 アプリケーションシステム及び分散データを同期させる方法
CN101770484A (zh) * 2008-12-31 2010-07-07 北大方正集团有限公司 一种网站更新实时发布的方法及系统

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
WANG DONG ET AL.: "Large Database System Synchronization Scheme Based on MQSeries.", COMPUTER APPLICATIONS., vol. 21, no. 8, August 2001 (2001-08-01), pages 138 - 139 *
ZHANG PU.: "Cache Consistency Technology Based on Oracle DCN.", COMPUTER ENGINEERING, vol. 34, no. 22, November 2008 (2008-11-01), pages 46 - 48 *

Also Published As

Publication number Publication date
WO2012126177A2 (zh) 2012-09-27
CN102741843B (zh) 2014-03-26
CN102741843A (zh) 2012-10-17

Similar Documents

Publication Publication Date Title
WO2012126177A3 (zh) 从数据库中读取数据的方法及装置
MY185258A (en) Method, device, and system for data system for data synchronization
MX2016010421A (es) Sistema para la sincronizacion de cambios en sitios web editados y aplicaciones interactivas.
WO2012138700A3 (en) Methods and apparatus for updating data in passive variable resistive memory
WO2014139466A3 (en) Data cache system and method
TW200723252A (en) Information processing device, information recording medium manufacturing device, information recording medium, methods thereof, and computer program
WO2014031416A3 (en) Hardware implementation of the aggregation/group by operation: hash-table method
WO2014176587A3 (en) Systems and methods for mobile applications
GB201015879D0 (en) Automated development of computer-specific software updates
IN2012DN00378A (zh)
WO2012121968A3 (en) Logical address translation
MX2011009754A (es) Aparato de transmision de datos, aparato de recepcion de datos, metodo de transmision de datos y metodo de recepcion de datos.
WO2013090594A3 (en) Infrastructure support for gpu memory paging without operating system integration
WO2011051849A3 (en) Method and system for processing information of a stream of information
ATE512386T1 (de) Umskalierung des sollastigmatismus für andere additionen
JP2013542501A5 (zh)
AR079707A1 (es) Celula aislada de ovario de hamster chino util para la produccion de anticuerpos terapeuticos
GB2509390A (en) Managing a message subscription in a publish/subscribe messaging system
GB2513082A (en) Implementing updates to source code executing on a plurality of compute nodes
GB2521326A (en) Managing updates and copying data in a point-in-time copy relationship expressed as source logical addresses and target logical addresses
DE602006008980D1 (de) System und Verfahren zur Steuerung der Weitergabe von Inhalten von einem Ursprungsserver an einen Browser eines mobilen Geräts über einen Proxy-Server
EP2624576A3 (en) Stream messaging for program stream automation
WO2013028009A3 (ko) 스마트 오피스 시스템 및 운용을 위한 서버 및 운용 방법
DE602007013292D1 (de) System und verfahren zum implementieren eines erweiterten hover-zustands mit aktiven prefetches
JP2011146823A5 (zh)

Legal Events

Date Code Title Description
WWE Wipo information: entry into national phase

Ref document number: 201180004080.2

Country of ref document: CN

121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 11861557

Country of ref document: EP

Kind code of ref document: A2

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 11861557

Country of ref document: EP

Kind code of ref document: A2