WO2004104729A3 - System and method for query result caching - Google Patents

System and method for query result caching Download PDF

Info

Publication number
WO2004104729A3
WO2004104729A3 PCT/US2004/013741 US2004013741W WO2004104729A3 WO 2004104729 A3 WO2004104729 A3 WO 2004104729A3 US 2004013741 W US2004013741 W US 2004013741W WO 2004104729 A3 WO2004104729 A3 WO 2004104729A3
Authority
WO
WIPO (PCT)
Prior art keywords
query
query result
request
record
database
Prior art date
Application number
PCT/US2004/013741
Other languages
French (fr)
Other versions
WO2004104729A2 (en
Inventor
David B Ewing
Kevin R Banks
Rick A Martindale
Original Assignee
Crossroads Sys Inc
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 Crossroads Sys Inc filed Critical Crossroads Sys Inc
Publication of WO2004104729A2 publication Critical patent/WO2004104729A2/en
Publication of WO2004104729A3 publication Critical patent/WO2004104729A3/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/2455—Query execution
    • G06F16/24552—Database cache management

Abstract

A method, performed in a result caching system (102), for query result caching comprises providing a query result database (208) comprising at least one query result record (500), each query result record (500) associated with a query, receiving (902) from a requestor a query request intended for a server, and determining (916) if the query request is represented by a query result record (500) in the query result database (208). The method further comprises, responsive to determining that the query result record (500) representing the query request is found in the query result database (208), retrieving and transmitting (918) to the requestor a query response to the query request, wherein the query response is retrieved from the query result database (208), and responsive to determining that the query result record (500) representing the query request is not found in the query result database (208), creating (924) a new query result record (500) representing the query request in the query result database (208) and transmitting the query request to the server.
PCT/US2004/013741 2003-05-19 2004-04-28 System and method for query result caching WO2004104729A2 (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US10/441,714 US20040236726A1 (en) 2003-05-19 2003-05-19 System and method for query result caching
US10/441,714 2003-05-19

Publications (2)

Publication Number Publication Date
WO2004104729A2 WO2004104729A2 (en) 2004-12-02
WO2004104729A3 true WO2004104729A3 (en) 2006-04-06

Family

ID=33450059

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US2004/013741 WO2004104729A2 (en) 2003-05-19 2004-04-28 System and method for query result caching

Country Status (2)

Country Link
US (1) US20040236726A1 (en)
WO (1) WO2004104729A2 (en)

Families Citing this family (43)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8407777B1 (en) 2003-11-26 2013-03-26 Rockstar Consortium Us Lp SOCKS tunneling for firewall traversal
US8019735B2 (en) * 2004-05-21 2011-09-13 Oracle International Corporation Systems and methods for query caching
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
US7571188B1 (en) * 2004-09-23 2009-08-04 Sun Microsystems, Inc. Cache abstraction for modeling database performance
US8131736B1 (en) * 2005-03-01 2012-03-06 Google Inc. System and method for navigating documents
GB2431742A (en) * 2005-10-27 2007-05-02 Hewlett Packard Development Co A method of retrieving data from a data repository
US8239383B2 (en) * 2006-06-15 2012-08-07 International Business Machines Corporation System and method for managing execution of queries against database samples
US20090319489A1 (en) * 2008-04-17 2009-12-24 Nokia Corporation System and Method for Improving Operations on a Media Server
US8295298B2 (en) * 2008-05-07 2012-10-23 Hid Global Gmbh Device with ethernet switch function and single ethernet connector
US9535967B2 (en) * 2008-09-10 2017-01-03 Salesforce.Com, Inc. Method and system for providing efficient and complex database functionality to a mobile device
US8868831B2 (en) * 2009-09-14 2014-10-21 Oracle International Corporation Caching data between a database server and a storage system
GB2465773A (en) 2008-11-27 2010-06-02 Symbian Software Ltd Data Storage and Access
KR101083563B1 (en) * 2009-04-24 2011-11-14 엔에이치엔비즈니스플랫폼 주식회사 Method and System for Managing Database
WO2011020102A2 (en) * 2009-08-14 2011-02-17 Akamai Technologies, Inc. Method and apparatus for correlating nameserver ipv6 and ipv4 addresses
US9355139B2 (en) * 2011-05-17 2016-05-31 Speedtrack, Inc. Pre-caching
US8930347B2 (en) 2011-12-14 2015-01-06 International Business Machines Corporation Intermediate result set caching for a database system
US9632944B2 (en) * 2013-04-22 2017-04-25 Sap Se Enhanced transactional cache
US9477609B2 (en) * 2013-04-22 2016-10-25 Sap Se Enhanced transactional cache with bulk operation
US9870415B2 (en) * 2013-09-18 2018-01-16 Quintiles Ims Incorporated System and method for fast query response
US10114874B2 (en) * 2014-02-24 2018-10-30 Red Hat, Inc. Source query caching as fault prevention for federated queries
US10515151B2 (en) * 2014-08-18 2019-12-24 Nuance Communications, Inc. Concept identification and capture
US20160103914A1 (en) * 2014-10-10 2016-04-14 Salesforce.Com, Inc. Offloading search processing against analytic data stores
US9449188B2 (en) 2014-10-10 2016-09-20 Salesforce.Com, Inc. Integration user for analytical access to read only data stores generated from transactional systems
US10101889B2 (en) 2014-10-10 2018-10-16 Salesforce.Com, Inc. Dashboard builder with live data updating without exiting an edit mode
US9600548B2 (en) 2014-10-10 2017-03-21 Salesforce.Com Row level security integration of analytical data store with cloud architecture
US10049141B2 (en) 2014-10-10 2018-08-14 salesforce.com,inc. Declarative specification of visualization queries, display formats and bindings
US9940360B2 (en) * 2015-05-19 2018-04-10 Sybase, Inc. Streaming optimized data processing
US10191963B2 (en) * 2015-05-29 2019-01-29 Oracle International Corporation Prefetching analytic results across multiple levels of data
US10115213B2 (en) 2015-09-15 2018-10-30 Salesforce, Inc. Recursive cell-based hierarchy for data visualizations
US10089368B2 (en) 2015-09-18 2018-10-02 Salesforce, Inc. Systems and methods for making visual data representations actionable
CN106649304A (en) * 2015-10-28 2017-05-10 北京国双科技有限公司 Method, device and system for data query
US10311047B2 (en) 2016-10-19 2019-06-04 Salesforce.Com, Inc. Streamlined creation and updating of OLAP analytic databases
CN110851474A (en) * 2018-07-26 2020-02-28 深圳市优必选科技有限公司 Data query method, database middleware, data query device and storage medium
US11914590B1 (en) * 2018-10-31 2024-02-27 Amazon Technologies, Inc. Database request router improving server cache utilization
US11206207B1 (en) 2019-01-29 2021-12-21 Amazon Technologies, Inc. Managed multicast communications across isolated networks
US11372927B2 (en) * 2019-04-04 2022-06-28 Sap Se Evaluation of duplicated filter predicates
CN110032567B (en) * 2019-04-24 2022-09-06 江苏满运软件科技有限公司 Report query method, device, server and storage medium
CN110399389B (en) * 2019-06-17 2023-11-28 平安科技（深圳）有限公司 Data paging query method, device, equipment and storage medium
CN113515541A (en) * 2020-04-09 2021-10-19 奇安信安全技术(珠海)有限公司 Data query method, device and system of database
CN113032392B (en) * 2021-02-26 2023-06-23 广东核电合营有限公司 Label data acquisition method, apparatus, computer device and storage medium
US20230267102A1 (en) * 2022-02-22 2023-08-24 Accenture Global Solutions Limited On-demand virtual storage access method analytics
CN115525686B (en) * 2022-10-10 2023-06-13 中电金信软件有限公司 Caching method and device for mapping configuration data

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6009271A (en) * 1996-10-28 1999-12-28 Bmc Software, Inc. Method of retrieving data from a relational database
US20040030682A1 (en) * 2000-11-21 2004-02-12 Porter Charles A. System and process for searching a network
US20040059719A1 (en) * 2002-09-23 2004-03-25 Rajeev Gupta Methods, computer programs and apparatus for caching directory queries

Family Cites Families (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6006214A (en) * 1996-12-04 1999-12-21 International Business Machines Corporation Database management system, method, and program for providing query rewrite transformations for nested set elimination in database views
US6026391A (en) * 1997-10-31 2000-02-15 Oracle Corporation Systems and methods for estimating query response times in a computer system
US6389460B1 (en) * 1998-05-13 2002-05-14 Compaq Computer Corporation Method and apparatus for efficient storage and retrieval of objects in and from an object storage device
US6304867B1 (en) * 1999-02-25 2001-10-16 Electronic Data Systems Corporation System and method for enhanced performance of a relational database management system through the use of application-specific memory-resident data
US6275819B1 (en) * 1999-03-16 2001-08-14 Novell, Inc. Method and apparatus for characterizing and retrieving query results
US6457020B1 (en) * 2000-03-20 2002-09-24 International Business Machines Corporation Query optimization using a multi-layered object cache
US6832218B1 (en) * 2000-09-22 2004-12-14 International Business Machines Corporation System and method for associating search results
JP4255624B2 (en) * 2001-02-22 2009-04-15 株式会社日立製作所 Database management system, query method in database management system, and query execution program in database management system
CA2390954C (en) * 2001-06-19 2010-05-18 Foedero Technologies, Inc. Dynamic multi-level cache manager
US6950823B2 (en) * 2002-12-23 2005-09-27 International Business Machines Corporation Transparent edge-of-network data cache

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6009271A (en) * 1996-10-28 1999-12-28 Bmc Software, Inc. Method of retrieving data from a relational database
US20040030682A1 (en) * 2000-11-21 2004-02-12 Porter Charles A. System and process for searching a network
US20040059719A1 (en) * 2002-09-23 2004-03-25 Rajeev Gupta Methods, computer programs and apparatus for caching directory queries

Also Published As

Publication number Publication date
US20040236726A1 (en) 2004-11-25
WO2004104729A2 (en) 2004-12-02

Similar Documents

Publication Publication Date Title
WO2004104729A3 (en) System and method for query result caching
MXPA05009733A (en) System and method to acquire information from a database.
EP1008944A3 (en) Document retrieval mediating apparatus, document retrieval system amd recording medium storing document retrieval mediating program
EP1213667A3 (en) Video information retrieval
WO2007014274A3 (en) Caching and modifying portions of a multi-dimensional database on a user device
EP0856803A3 (en) File system interface to a database
WO2006120446A3 (en) Method and apparatus for searching data in a plurality of heterogeneous databases
WO2002091232A3 (en) Method, system, and program for querying data in a personal information manager database
WO2002067146A3 (en) Query resolution system
WO2001075640A3 (en) Method and system for gathering, organizing, and displaying information from data searches
EP1507245A4 (en) Vehicle operation information management evaluation system
JP2007525726A5 (en)
WO2005062210A8 (en) Methods and systems for personalized network searching
EP0889420A3 (en) Media manager for access to multiple media types
WO2000062264A3 (en) Method and system for retrieving data from multiple data sources using a search routing database
WO2004051555A3 (en) Method and apparatus for improved information transactions
WO2002003251A3 (en) Caching scheme for multi-dimensional data
CA2589365A1 (en) Predictive information retrieval
WO1999036864A3 (en) Method for finding and retrieving electronic information in a network using interest agents
CA2308107A1 (en) Ordering of database search results based on user feedback
WO2003075633A3 (en) Method and system for managing software licenses
WO2005084265A3 (en) System and method for registration of valuable items
CA2180906A1 (en) Information Management Apparatus Providing Efficient Management of Multimedia Titles in a Client-Server Network
FR2887385B1 (en) METHOD AND SYSTEM FOR REPORTING AND FILTERING MULTIMEDIA INFORMATION ON A NETWORK
EP1552425A4 (en) A link generation system

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 BW BY BZ CA CH CN CO CR CU CZ DE DK DM DZ EC EE EG 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 NA NI NO NZ OM PG PH PL PT RO RU SC SD SE SG SK SL SY 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): GM KE LS MW MZ NA 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 PL 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
32PN Ep: public notification in the ep bulletin as address of the adressee cannot be established

Free format text: NOTING OF LOSS OF RIGHTS PURSUANT TO RULE 69(1) EPC (COMMUNICATION DATED 29-05-2006, EPO FORM 1205A)

122 Ep: pct application non-entry in european phase