WO2003081464A3 - Database system comprising database access object with cache - Google Patents

Database system comprising database access object with cache Download PDF

Info

Publication number
WO2003081464A3
WO2003081464A3 PCT/GB2003/001233 GB0301233W WO03081464A3 WO 2003081464 A3 WO2003081464 A3 WO 2003081464A3 GB 0301233 W GB0301233 W GB 0301233W WO 03081464 A3 WO03081464 A3 WO 03081464A3
Authority
WO
WIPO (PCT)
Prior art keywords
database
client
data
response
database access
Prior art date
Application number
PCT/GB2003/001233
Other languages
French (fr)
Other versions
WO2003081464A2 (en
Inventor
Timothy Stephen Hoverd
Dean Alan Sheehan
Denis Ronald Howlett
Original Assignee
Isocra Ltd
Timothy Stephen Hoverd
Dean Alan Sheehan
Denis Ronald Howlett
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 Isocra Ltd, Timothy Stephen Hoverd, Dean Alan Sheehan, Denis Ronald Howlett filed Critical Isocra Ltd
Priority to AU2003216854A priority Critical patent/AU2003216854A1/en
Publication of WO2003081464A2 publication Critical patent/WO2003081464A2/en
Publication of WO2003081464A3 publication Critical patent/WO2003081464A3/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
    • G06F16/24534—Query rewriting; Transformation
    • G06F16/24539—Query rewriting; Transformation using cached or materialised query results

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The present invention relates to a database system. In particular, the invention relates to a system for accessing databases, and specifically, but not exclusively relational databases, over a computer network.The database access system comprises a database access object (20), which operates on a client computer that functions as an interface between a database client (10) and a database server (12). The database object receives database queries from the client and returns a response to the queries to the client. Each database access object maintains a cache of data and if the response data is available in the cache provides the response from the cached data. Otherwise, a query is passed to the database server to retrieve data to make a response. Upon a change in the data cached in the client, the client sends a message to other like database access objects to indicate to the other database access objects the extent to which the data in their caches is invalid.
PCT/GB2003/001233 2002-03-22 2003-03-21 Database system comprising database access object with cache WO2003081464A2 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
AU2003216854A AU2003216854A1 (en) 2002-03-22 2003-03-21 Database system comprising database access object with cache

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
GB0206810.4 2002-03-22
GBGB0206810.4A GB0206810D0 (en) 2002-03-22 2002-03-22 Database system

Publications (2)

Publication Number Publication Date
WO2003081464A2 WO2003081464A2 (en) 2003-10-02
WO2003081464A3 true WO2003081464A3 (en) 2004-06-03

Family

ID=9933528

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/GB2003/001233 WO2003081464A2 (en) 2002-03-22 2003-03-21 Database system comprising database access object with cache

Country Status (3)

Country Link
AU (1) AU2003216854A1 (en)
GB (1) GB0206810D0 (en)
WO (1) WO2003081464A2 (en)

Families Citing this family (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7500111B2 (en) * 2003-05-30 2009-03-03 International Business Machines Corporation Querying encrypted data in a relational database system
US7328222B2 (en) * 2004-08-26 2008-02-05 Oracle International Corporation Method and apparatus for preserving data coherency in a database by generating a command object that includes instructions for writing a data record to a local cache
WO2008038271A1 (en) * 2006-09-28 2008-04-03 Xeround Systems Ltd. An apparatus and method for a distributed storage global database
EP2146292B8 (en) * 2008-07-18 2019-03-20 QlikTech International AB Method and apparatus for extracting information from a database
US8898181B2 (en) * 2010-06-22 2014-11-25 Microsoft Corporation Subscription for integrating external data from external system
CN102841889A (en) * 2011-06-20 2012-12-26 中兴通讯股份有限公司 Method and device for achieving efficient database access based on ORM (object relational mapping) architecture
CA3038199A1 (en) * 2018-04-03 2019-10-03 Amadeus S.A.S. Updating cache data
CN111770182B (en) * 2020-06-30 2022-05-31 北京百度网讯科技有限公司 Data pushing method and device
CN114064684B (en) * 2021-10-13 2024-07-19 中国电子科技集团公司第十五研究所 Unified access method for heterogeneous data sources

Citations (1)

* 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

Patent Citations (1)

* 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

Non-Patent Citations (5)

* Cited by examiner, † Cited by third party
Title
FRANKLIN M ET AL: "Transactional client-server cache consistency: alternatives and performance", ACM TRANSACTIONS ON DATABASE SYSTEMS, ASSOCIATION FOR COMPUTING MACHINERY. NEW YORK, US, vol. 22, no. 3, September 1997 (1997-09-01), pages 315 - 363, XP002247935, ISSN: 0362-5915 *
INTERNATIONAL BUSINESS MACHINES CORPORATION: "Using consistency check value as optimistic locking value for staging host production data at client/server for access by IMS csobject client/server feature", RESEARCH DISCLOSURE, KENNETH MASON PUBLICATIONS, HAMPSHIRE, GB, vol. 442, no. 150, February 2001 (2001-02-01), XP007127709, ISSN: 0374-4353 *
KELLER A M ET AL: "A predicate-based caching scheme for client-server database architectures", PARALLEL AND DISTRIBUTED INFORMATION SYSTEMS, 1994., PROCEEDINGS OF THE THIRD INTERNATIONAL CONFERENCE ON AUSTIN, TX, USA 28-30 SEPT. 1994, LOS ALAMITOS, CA, USA,IEEE COMPUT. SOC, 28 September 1994 (1994-09-28), pages 229 - 238, XP010100051, ISBN: 0-8186-6400-2 *
U. HALICI, AND A. DOGAC: "An Optimistic Locking Technique For Concurrency Control in Distributed Databases", IEEE TRANSACTIONS ON SOFTWARE ENGINEERING, vol. 17, no. 7, July 1991 (1991-07-01), pages 712 - 724, XP002271650 *
YONGDONG WANG ET AL: "CACHE CONSISTENCY AND CONCURRENCY CONTROL IN A CLIENT/SERVER DBMS ARCHITECTURE", SIGMOD RECORD, ASSOCIATION FOR COMPUTING MACHINERY, NEW YORK, US, vol. 20, no. 2, 1 June 1991 (1991-06-01), pages 367 - 376, XP000364651 *

Also Published As

Publication number Publication date
AU2003216854A8 (en) 2003-10-08
AU2003216854A1 (en) 2003-10-08
WO2003081464A2 (en) 2003-10-02
GB0206810D0 (en) 2002-05-01

Similar Documents

Publication Publication Date Title
Scheuermann et al. A case for delay-conscious caching of Web documents
US7398271B1 (en) Using network traffic logs for search enhancement
WO2004104729A3 (en) System and method for query result caching
Xie et al. Locality in search engine queries and its implications for caching
JP4593793B2 (en) Web server with queryable dynamic cache
EP0843267A3 (en) Processing multiple database transactions in the same process to reduce process overhead and redundant retrieval from database servers
WO2003056466A1 (en) System and meth0d for adaptive result set caching
WO2001082031A3 (en) Portable internet services
US7487159B2 (en) Method implementing scrollable cursors in a distributed database system
WO2002025557A3 (en) Method, system, and computer program product for interfacing with information sources
JP2002374246A5 (en)
US7412496B2 (en) Management of the file-modification time attribute in a multi-processor file server system
WO2002003251A3 (en) Caching scheme for multi-dimensional data
Alonso et al. Dynamic hierarchical caching for large-scale distributed file systems
WO2002019114A3 (en) Multi-tier caching system
TWI663518B (en) Search cache update method and device
JPH1091638A (en) Retrieval system
US20040193574A1 (en) Application server, cache program, and application server system
US20100287156A1 (en) On-site search engine for the world wide web
WO2003081464A3 (en) Database system comprising database access object with cache
GB2398146A (en) Directory request caching in distributed computer systems
SE9803246D0 (en) An internet caching system and a method and an arrangement in such a system
Bahn et al. Replica-aware caching for web proxies
JPH05143435A (en) Data base system
Stanoi et al. Data warehousing alternatives for mobile environments

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A2

Designated state(s): AE AG AL AM AT AU AZ BA BB BG BR BY BZ CA CH CN CO CR CU CZ DE DK DM DZ EC EE ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX MZ NI NO NZ OM PH PL PT RO RU SC SD SE SG SK SL TJ TM TN TR TT TZ UA UG US UZ VC VN YU ZA ZM ZW

AL Designated countries for regional patents

Kind code of ref document: A2

Designated state(s): GH GM KE LS MW MZ SD SL SZ TZ UG ZM ZW AM AZ BY KG KZ MD RU TJ TM AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HU IE IT LU MC NL PT RO SE SI SK TR BF BJ CF CG CI CM GA GN GQ GW ML MR NE SN TD TG

121 Ep: the epo has been informed by wipo that ep was designated in this application
DFPE Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed before 20040101)
122 Ep: pct application non-entry in european phase
NENP Non-entry into the national phase

Ref country code: JP

WWW Wipo information: withdrawn in national office

Country of ref document: JP