JP2004303211A - データベース結果および導出オブジェクトをキャッシュし、無効にするためのシステムおよび方法 - Google Patents

データベース結果および導出オブジェクトをキャッシュし、無効にするためのシステムおよび方法 Download PDF

Info

Publication number
JP2004303211A
JP2004303211A JP2004058206A JP2004058206A JP2004303211A JP 2004303211 A JP2004303211 A JP 2004303211A JP 2004058206 A JP2004058206 A JP 2004058206A JP 2004058206 A JP2004058206 A JP 2004058206A JP 2004303211 A JP2004303211 A JP 2004303211A
Authority
JP
Japan
Prior art keywords
results
memory
query
database
invalidation
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.)
Pending
Application number
JP2004058206A
Other languages
English (en)
Japanese (ja)
Other versions
JP2004303211A5 (enExample
Inventor
Michael J Pizzo
ジェイ．ピゾ マイケル
Robert M Howard
エム．ハワード ロバート
Christian Kleinerman
クレイナーマン クリスチャン
Ng Patrick Yu-Kwan
ユ−クァン ング パトリック
John F Noss
エフ．ノス ジョン
Adam W Smith
ダブリュ．スミス アダム
Oren Trutner
トラトナー オレン
Florian M Waas
エム．ワース フロリアン
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Microsoft Corp
Original Assignee
Microsoft Corp
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 Microsoft Corp filed Critical Microsoft Corp
Publication of JP2004303211A publication Critical patent/JP2004303211A/ja
Publication of JP2004303211A5 publication Critical patent/JP2004303211A5/ja
Pending legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F17/00—Digital computing or data processing equipment or methods, specially adapted for specific functions
    • G06F17/40—Data acquisition and logging
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90—Details of database functions independent of the retrieved data types
    • G06F16/95—Retrieval from the web
    • G06F16/957—Browsing optimisation, e.g. caching or content distillation
    • G06F16/9574—Browsing optimisation, e.g. caching or content distillation of access to content, e.g. by caching

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Computer Hardware Design (AREA)
  • Mathematical Physics (AREA)
  • Software Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
JP2004058206A 2003-03-28 2004-03-02 データベース結果および導出オブジェクトをキャッシュし、無効にするためのシステムおよび方法 Pending JP2004303211A (ja)

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
US10/402,031 US20040193656A1 (en) 2003-03-28 2003-03-28 Systems and methods for caching and invalidating database results and derived objects

Publications (2)

Publication Number Publication Date
JP2004303211A true JP2004303211A (ja) 2004-10-28
JP2004303211A5 JP2004303211A5 (enExample) 2007-04-12

Family

ID=32825036

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2004058206A Pending JP2004303211A (ja) 2003-03-28 2004-03-02 データベース結果および導出オブジェクトをキャッシュし、無効にするためのシステムおよび方法

Country Status (5)

Country Link
US (1) US20040193656A1 (enExample)
EP (1) EP1462959A3 (enExample)
JP (1) JP2004303211A (enExample)
KR (1) KR20040085057A (enExample)
CN (1) CN1534520A (enExample)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2006178983A (ja) * 2004-12-21 2006-07-06 Samsung Electronics Co Ltd バッファメモリに貯蔵されたデータを無効化させるスキームを有する貯蔵システム及びそれを含んだコンピューティングシステム
JP2008287660A (ja) * 2007-05-21 2008-11-27 Hitachi Ltd キャッシュサーバ、キャッシュ管理方法、およびキャッシュ管理プログラム
JP2015170076A (ja) * 2014-03-06 2015-09-28 株式会社東芝 データベースシステム

Families Citing this family (52)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7568229B1 (en) 2003-07-01 2009-07-28 Symantec Corporation Real-time training for a computer code intrusion detection system
US7406714B1 (en) 2003-07-01 2008-07-29 Symantec Corporation Computer code intrusion detection system based on acceptable retrievals
US8266177B1 (en) 2004-03-16 2012-09-11 Symantec Corporation Empirical database access adjustment
US7610373B2 (en) * 2004-05-27 2009-10-27 International Business Machines Corporation Voting mechanism for session invalidation processing in an application server cluster
US7529753B1 (en) 2004-09-03 2009-05-05 Crossroads Systems, Inc. Providing application-layer functionality between one or more database clients and one or more database servers
US7509330B2 (en) * 2004-09-03 2009-03-24 Crossroads Systems, Inc. Application-layer monitoring of communication between one or more database clients and one or more database servers
US7444331B1 (en) 2005-03-02 2008-10-28 Symantec Corporation Detecting code injection attacks against databases
US8046374B1 (en) 2005-05-06 2011-10-25 Symantec Corporation Automatic training of a database intrusion detection system
US7558796B1 (en) 2005-05-19 2009-07-07 Symantec Corporation Determining origins of queries for a database intrusion detection system
WO2006128062A2 (en) * 2005-05-25 2006-11-30 Terracotta, Inc. Database caching of queries and stored procedures using database provided facilities for dependency analysis and detected database updates for invalidation
US8239535B2 (en) * 2005-06-06 2012-08-07 Adobe Systems Incorporated Network architecture with load balancing, fault tolerance and distributed querying
US8301751B2 (en) * 2005-06-30 2012-10-30 International Business Machines Corporation Generation of a master schedule for a resource from a plurality of user created schedules for the resource
GB0513375D0 (en) * 2005-06-30 2005-08-03 Retento Ltd Computer security
US7774361B1 (en) 2005-07-08 2010-08-10 Symantec Corporation Effective aggregation and presentation of database intrusion incidents
US7690037B1 (en) 2005-07-13 2010-03-30 Symantec Corporation Filtering training data for machine learning
CN100407199C (zh) * 2005-09-30 2008-07-30 南京大学 基于关系数据库信息技术产品保护轮廓的一致性检查方法
US7966315B2 (en) * 2005-11-15 2011-06-21 Vmware, Inc. Multi-query optimization
US8069153B2 (en) * 2005-12-02 2011-11-29 Salesforce.Com, Inc. Systems and methods for securing customer data in a multi-tenant environment
US7540766B2 (en) * 2006-06-14 2009-06-02 Itron, Inc. Printed circuit board connector for utility meters
US8285707B2 (en) 2006-11-08 2012-10-09 International Business Machines Corporation Method of querying relational database management systems
KR100893222B1 (ko) * 2007-01-16 2009-04-16 엔에이치엔(주) 입력되는 검색 쿼리 패턴을 고려한 무효 쿼리 검출 장치 및그 방법
US20090083336A1 (en) * 2007-09-26 2009-03-26 Microsoft Corporation Search based data management
CN101430687B (zh) 2007-11-09 2015-11-25 阿里巴巴集团控股有限公司 基于oltp环境的统计表应用方法及系统
CN101572598B (zh) * 2008-04-28 2013-03-06 国际商业机器公司 用于可靠的快速集成的方法和装置
US20110078166A1 (en) * 2009-09-29 2011-03-31 Nokia Corporation Method and apparatus for creating and utilizing information representation of queries
CN102541884B (zh) * 2010-12-10 2014-07-02 中国移动通信集团贵州有限公司 数据库优化方法和装置
EP2791819B1 (en) 2011-12-14 2017-11-01 Level 3 Communications, LLC Content delivery network
CN102624583B (zh) * 2012-02-29 2016-06-01 武汉虹信通信技术有限责任公司 一种海量设备并发实时参数获取的分层设计方法
US9836513B2 (en) 2012-03-12 2017-12-05 Entit Software Llc Page feed for efficient dataflow between distributed query engines
US9298764B2 (en) * 2012-05-23 2016-03-29 Oracle International Corporation Partial source verification of EDC data
US9342411B2 (en) * 2012-10-22 2016-05-17 International Business Machines Corporation Reducing memory overhead of highly available, distributed, in-memory key-value caches
US10791050B2 (en) 2012-12-13 2020-09-29 Level 3 Communications, Llc Geographic location determination in a content delivery framework
US9634918B2 (en) 2012-12-13 2017-04-25 Level 3 Communications, Llc Invalidation sequencing in a content delivery framework
US10652087B2 (en) 2012-12-13 2020-05-12 Level 3 Communications, Llc Content delivery framework having fill services
US10701149B2 (en) 2012-12-13 2020-06-30 Level 3 Communications, Llc Content delivery framework having origin services
US20140337472A1 (en) 2012-12-13 2014-11-13 Level 3 Communications, Llc Beacon Services in a Content Delivery Framework
US10701148B2 (en) 2012-12-13 2020-06-30 Level 3 Communications, Llc Content delivery framework having storage services
US9705754B2 (en) 2012-12-13 2017-07-11 Level 3 Communications, Llc Devices and methods supporting content delivery with rendezvous services
CN103077204B (zh) * 2012-12-27 2016-01-20 北京地拓科技发展有限公司 一种栅格数据的统计查询方法和系统
US9813515B2 (en) 2013-10-04 2017-11-07 Akamai Technologies, Inc. Systems and methods for caching content with notification-based invalidation with extension to clients
US9641640B2 (en) 2013-10-04 2017-05-02 Akamai Technologies, Inc. Systems and methods for controlling cacheability and privacy of objects
US9648125B2 (en) 2013-10-04 2017-05-09 Akamai Technologies, Inc. Systems and methods for caching content with notification-based invalidation
US9870425B2 (en) * 2014-02-27 2018-01-16 Excalibur Ip, Llc Localized selectable location and/or time for search queries and/or search query results
US9613096B2 (en) 2014-03-04 2017-04-04 International Business Machines Corporation Dynamic result set caching with a database accelerator
US10242075B2 (en) 2014-09-25 2019-03-26 Lg Cns Co., Ltd. Database apparatus, database management method performed in database apparatus and storing the same
US9591047B1 (en) 2016-04-11 2017-03-07 Level 3 Communications, Llc Invalidation in a content delivery network (CDN)
CN107368500B (zh) * 2016-05-13 2020-03-03 北京京东尚科信息技术有限公司 数据抽取方法及系统
US11138236B1 (en) * 2017-05-17 2021-10-05 Palantir Technologies Inc. Systems and methods for packaging information into data objects
US10719539B2 (en) * 2017-06-06 2020-07-21 Mastercard International Incorporated Method and system for automatic reporting of analytics and distribution of advice using a conversational interface
CN109313642B (zh) * 2018-09-07 2022-07-12 威富通科技有限公司 账单信息缓存方法、账单信息查询方法和终端设备
CN111459978A (zh) * 2020-03-20 2020-07-28 平安国际智慧城市科技股份有限公司 查询方法、装置、计算机设备和存储介质
EP4550168A1 (en) * 2023-11-06 2025-05-07 Amadeus S.A.S. Search request processing

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH05143435A (ja) * 1991-11-22 1993-06-11 Fuji Xerox Co Ltd データベースシステム

Family Cites Families (19)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5897634A (en) * 1997-05-09 1999-04-27 International Business Machines Corporation Optimized caching of SQL data in an object server system
JP3228182B2 (ja) * 1997-05-29 2001-11-12 株式会社日立製作所 記憶システム及び記憶システムへのアクセス方法
US6061677A (en) * 1997-06-09 2000-05-09 Microsoft Corporation Database query system and method
US6026413A (en) * 1997-08-01 2000-02-15 International Business Machines Corporation Determining how changes to underlying data affect cached objects
US6493720B1 (en) * 1998-01-26 2002-12-10 International Business Machines Corporation Method and system for synchronization of metadata in an information catalog
EP0959416A3 (en) * 1998-05-08 2005-08-10 International Business Machines Corporation Using database query technology for message subscriptions in messaging systems
US6389414B1 (en) * 1998-09-21 2002-05-14 Microsoft Corporation Internal database validation
CA2249096C (en) * 1998-09-30 2001-12-04 Ibm Canada Limited-Ibm Canada Limitee Method for determining optimal database materializations using a query optimizer
US6347312B1 (en) * 1998-11-05 2002-02-12 International Business Machines Corporation Lightweight directory access protocol (LDAP) directory server cache mechanism and method
US6725333B1 (en) * 1999-04-22 2004-04-20 International Business Machines Corporation System and method for managing cachable entities
US6502088B1 (en) * 1999-07-08 2002-12-31 International Business Machines Corporation Method and system for improved access to non-relational databases
US6405191B1 (en) * 1999-07-21 2002-06-11 Oracle Corporation Content based publish-and-subscribe system integrated in a relational database system
US6507891B1 (en) * 1999-07-22 2003-01-14 International Business Machines Corporation Method and apparatus for managing internal caches and external caches in a data processing system
US6584548B1 (en) * 1999-07-22 2003-06-24 International Business Machines Corporation Method and apparatus for invalidating data in a cache
US6873997B1 (en) * 1999-08-04 2005-03-29 Agile Software Corporation Data management system and method for automatically propagating information to disparate information systems from a central location
US6615317B2 (en) * 2000-07-07 2003-09-02 Fitech Laboratories, Inc. Methods and systems for providing a highly scalable synchronous data cache
US6748386B1 (en) * 2001-04-24 2004-06-08 Nec Corporation System and method for automated construction of URL, cookie, and database query mapping
US7089228B2 (en) * 2002-04-18 2006-08-08 International Business Machines Corporation Computer apparatus and method for caching results of a database query
US6996584B2 (en) * 2002-05-14 2006-02-07 Pervasive Software, Inc. System and method of maintaining functional client side data cache coherence

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH05143435A (ja) * 1991-11-22 1993-06-11 Fuji Xerox Co Ltd データベースシステム

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2006178983A (ja) * 2004-12-21 2006-07-06 Samsung Electronics Co Ltd バッファメモリに貯蔵されたデータを無効化させるスキームを有する貯蔵システム及びそれを含んだコンピューティングシステム
US8051258B2 (en) 2004-12-21 2011-11-01 Samsung Electronics Co., Ltd. Apparatus and methods using invalidity indicators for buffered memory
JP2008287660A (ja) * 2007-05-21 2008-11-27 Hitachi Ltd キャッシュサーバ、キャッシュ管理方法、およびキャッシュ管理プログラム
JP2015170076A (ja) * 2014-03-06 2015-09-28 株式会社東芝 データベースシステム

Also Published As

Publication number Publication date
EP1462959A2 (en) 2004-09-29
EP1462959A3 (en) 2004-11-17
CN1534520A (zh) 2004-10-06
KR20040085057A (ko) 2004-10-07
US20040193656A1 (en) 2004-09-30

Similar Documents

Publication Publication Date Title
JP2004303211A (ja) データベース結果および導出オブジェクトをキャッシュし、無効にするためのシステムおよび方法
JP4578160B2 (ja) キャッシュエントリを無効化するために使用できるデータベーステーブル変更情報の登録および取り出し
JP5006348B2 (ja) 応答出力キャッシュに対するマルチキャッシュ協調
US10063615B2 (en) Systems and methods for caching and serving dynamic content
US6507891B1 (en) Method and apparatus for managing internal caches and external caches in a data processing system
US6981105B2 (en) Method and apparatus for invalidating data in a cache
US8725793B2 (en) Architectural pattern for persistent web application design
US6557076B1 (en) Method and apparatus for aggressively rendering data in a data processing system
US20080183721A1 (en) Method of and system for providing performance information in a uddi system
JP2004303214A (ja) データベース変更通知を要求および受信するためのシステムおよび方法
US20080208806A1 (en) Techniques for a web services data access layer
US20110035553A1 (en) Method and system for cache management
US20050091226A1 (en) Persistent caching directory level support
US20100325363A1 (en) Hierarchical object caching based on object version
JP5193056B2 (ja) 無線装置の最新データを維持するための方法及びシステム
US9940243B1 (en) System and method for managing an object cache
US9792166B2 (en) System and method for managing an object cache

Legal Events

Date Code Title Description
A521 Written amendment

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20070226

A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20070226

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20091020

A02 Decision of refusal

Free format text: JAPANESE INTERMEDIATE CODE: A02

Effective date: 20100402