SE0801708L - Method and apparatus for extracting information from a database - Google Patents

Method and apparatus for extracting information from a database

Info

Publication number
SE0801708L
SE0801708L SE0801708A SE0801708A SE0801708L SE 0801708 L SE0801708 L SE 0801708L SE 0801708 A SE0801708 A SE 0801708A SE 0801708 A SE0801708 A SE 0801708A SE 0801708 L SE0801708 L SE 0801708L
Authority
SE
Sweden
Prior art keywords
result
selection
identifier value
database
information
Prior art date
Application number
SE0801708A
Other languages
Swedish (sv)
Other versions
SE532252C2 (en
Inventor
Haakan Wolge
Original Assignee
Qliktech Internat Ab
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 Qliktech Internat Ab filed Critical Qliktech Internat Ab
Priority to SE0801708A priority Critical patent/SE532252C2/en
Priority to ES09164490T priority patent/ES2713097T3/en
Priority to DK09164490.6T priority patent/DK2146292T3/en
Priority to EP09164490.6A priority patent/EP2146292B8/en
Priority to CA2671650A priority patent/CA2671650C/en
Priority to US12/504,695 priority patent/US8244741B2/en
Priority to JP2009168570A priority patent/JP5288129B2/en
Priority to CN2009101613238A priority patent/CN101635001B/en
Publication of SE0801708L publication Critical patent/SE0801708L/en
Publication of SE532252C2 publication Critical patent/SE532252C2/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/24553—Query execution of query operations
    • G06F16/24561—Intermediate data storage techniques for performance improvement
    • G06F17/30501—
    • 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/22—Indexing; Data structures therefor; Storage structures
    • G06F16/2228—Indexing structures
    • G06F16/2255—Hash tables
    • G06F17/3033—

Abstract

The present invention relates to a method and apparatus for extracting information from a database. Information is extracted from a database using a computer-implemented method that involves a sequential chain of main calculations, in which a first main calculation operates a first selection item on a data set to produce a first result, and a second main calculation operates a second selection item on the first result to produce a second result. The first and second results are cached in computer memory for re-use in subsequent iterations of the method, thereby reducing the need to execute the first and/or second main calculations for extracting the information. The caching involves calculating a first selection identifier value as a function of at least the first selection item, and a second selection identifier value as a function of at least the second selection item and the first result, and storing the first selection identifier value and the first result, and the second selection identifier value and the second result, respectively, as associated objects in a data structure.
SE0801708A 2008-07-18 2008-07-18 Method and apparatus for extracting information from a database SE532252C2 (en)

Priority Applications (8)

Application Number Priority Date Filing Date Title
SE0801708A SE532252C2 (en) 2008-07-18 2008-07-18 Method and apparatus for extracting information from a database
ES09164490T ES2713097T3 (en) 2008-07-18 2009-07-03 Method and apparatus to extract information from a database
DK09164490.6T DK2146292T3 (en) 2008-07-18 2009-07-03 Method and apparatus for extracting information from a database
EP09164490.6A EP2146292B8 (en) 2008-07-18 2009-07-03 Method and apparatus for extracting information from a database
CA2671650A CA2671650C (en) 2008-07-18 2009-07-10 Method and apparatus for extracting information from a database
US12/504,695 US8244741B2 (en) 2008-07-18 2009-07-17 Method and apparatus for extracting information from a database
JP2009168570A JP5288129B2 (en) 2008-07-18 2009-07-17 Computer-implemented method, computer-readable medium and apparatus for extracting information from a database
CN2009101613238A CN101635001B (en) 2008-07-18 2009-07-20 Method and apparatus for extracting information from a database

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
SE0801708A SE532252C2 (en) 2008-07-18 2008-07-18 Method and apparatus for extracting information from a database

Publications (2)

Publication Number Publication Date
SE0801708L true SE0801708L (en) 2009-11-24
SE532252C2 SE532252C2 (en) 2009-11-24

Family

ID=41327598

Family Applications (1)

Application Number Title Priority Date Filing Date
SE0801708A SE532252C2 (en) 2008-07-18 2008-07-18 Method and apparatus for extracting information from a database

Country Status (4)

Country Link
CN (1) CN101635001B (en)
DK (1) DK2146292T3 (en)
ES (1) ES2713097T3 (en)
SE (1) SE532252C2 (en)

Families Citing this family (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101840430B (en) * 2010-04-28 2012-02-29 北京握奇数据系统有限公司 Intelligent card database multi-list operation method and device
US9563658B2 (en) * 2012-08-20 2017-02-07 Oracle International Corporation Hardware implementation of the aggregation/group by operation: hash-table method
CN104268136A (en) * 2013-07-30 2015-01-07 深圳市华傲数据技术有限公司 Record grouping method and device
CN107239484A (en) * 2017-04-17 2017-10-10 腾讯科技（深圳）有限公司 Database operation method, device and computer equipment
CN109117435B (en) * 2017-06-22 2021-07-27 索意互动（北京）信息技术有限公司 Client, server, retrieval method and system thereof
CN112015758B (en) * 2020-08-27 2023-07-28 中国平安财产保险股份有限公司 Product code-fetching method, device, computer equipment and storage medium

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
IES20010724A2 (en) * 2001-07-30 2003-02-05 Univ Dublin Data processing system and method

Also Published As

Publication number Publication date
CN101635001B (en) 2013-09-11
CN101635001A (en) 2010-01-27
SE532252C2 (en) 2009-11-24
ES2713097T3 (en) 2019-05-17
DK2146292T3 (en) 2019-05-06

Similar Documents

Publication Publication Date Title
SE0801708L (en) Method and apparatus for extracting information from a database
JP2008287744A5 (en)
DE602007004587D1 (en) Obscuring execution tracks of a computer program code
EA201490172A1 (en) SYSTEM AND METHOD FOR FORMING A GEOSTATISTICAL MODEL OF AN INTERESTING GEOLOGICAL VOLUME LIMITED TO A PROCESS ORIENTED MODEL OF AN INTERESTING GEOLOGICAL VOLUME
AR107534A1 (en) MODELING OF TRENDS IN CROP PERFORMANCE
GB2529981A (en) System and method for generating a rhythmic accompaniment for a musical performance
BR112014031390A2 (en) Method for updating precomputed database query results on a distributed database system, data caching platform, and computer readable storage medium.
IN2013CH05115A (en)
GB2546912A (en) Emulating manual system of filing using electronic document and electronic file
WO2013013171A8 (en) Content retrieval systems for distribution items
WO2013062622A3 (en) Methods and apparatus for constructing and analyzing component-based models of engineering systems
WO2008146807A1 (en) Ontology processing device, ontology processing method, and ontology processing program
FR2868848B1 (en) METHOD, DEVICE AND PROGRAM PRODUCT FOR STOCHASTIC SIMULATION OF PALEO CHENAUX OR PALEO GEOLOGICAL STRUCTURES
TW201611877A (en) Computer-implemented method for determining game mechanics in business process gamification
GB2536123A (en) Integrated oilfield asset modeling using multiple resolutions of reservoir detail
MY172251A (en) System generator module for electronic document and electronic filing
JP2016509281A5 (en)
IL241640B (en) Method for executing queries on streaming data using graphic processing units
CL2009000842A1 (en) Method implemented in a computer to adapt and use a computer environment, computer program product and computer system.
IN2013MU01495A (en)
WO2014137893A3 (en) Interactive healthcare modeling
GB2534448A (en) Managing customs information
Winchenbach et al. Multi-level-memory structures for adaptive SPH simulations
Sturfelt Skandinavien och första världskriget
Schwalm et al. Attributing Changes in Gross Primary Productivity from 1901 to 2010