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/SE0801708L/en
Priority to ES09164490T priority patent/ES2713097T3/en
Priority to EP09164490.6A priority patent/EP2146292B8/en
Priority to DK09164490.6T priority patent/DK2146292T3/en
Priority to CA2671650A priority patent/CA2671650C/en
Priority to JP2009168570A priority patent/JP5288129B2/en
Priority to US12/504,695 priority patent/US8244741B2/en
Priority to CN2009101613238A priority patent/CN101635001B/en
Publication of SE532252C2 publication Critical patent/SE532252C2/en
Publication of SE0801708L publication Critical patent/SE0801708L/en

Links

Classifications

    • 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/24553—Query execution of query operations
    • G06F16/24561—Intermediate data storage techniques for performance improvement
    • G06F17/30501—
    • 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/22—Indexing; Data structures therefor; Storage structures
    • G06F16/2228—Indexing structures
    • G06F16/2255—Hash tables
    • G06F17/3033—

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 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 SE0801708L (en)

Priority Applications (8)

Application Number Priority Date Filing Date Title
SE0801708A SE0801708L (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
EP09164490.6A EP2146292B8 (en) 2008-07-18 2009-07-03 Method and apparatus for extracting information from a database
DK09164490.6T DK2146292T3 (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
JP2009168570A JP5288129B2 (en) 2008-07-18 2009-07-17 Computer-implemented method, computer-readable medium 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
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 SE0801708L (en) 2008-07-18 2008-07-18 Method and apparatus for extracting information from a database

Publications (2)

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

Family

ID=41327598

Family Applications (1)

Application Number Title Priority Date Filing Date
SE0801708A SE0801708L (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) SE0801708L (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
CN101635001A (en) 2010-01-27
DK2146292T3 (en) 2019-05-06
SE532252C2 (en) 2009-11-24
ES2713097T3 (en) 2019-05-17
CN101635001B (en) 2013-09-11

Similar Documents

Publication Publication Date Title
Lu et al. Using interval information granules to improve forecasting in fuzzy time series
JP2008287744A5 (en)
Zou et al. GPUTENSOR: Efficient tensor factorization for context-aware recommendations
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
GB2529981A (en) System and method for generating a rhythmic accompaniment for a musical performance
AR107534A1 (en) MODELING OF TRENDS IN CROP PERFORMANCE
BR112014031390A2 (en) Method for updating precomputed database query results on a distributed database system, data caching platform, and computer readable storage medium.
GB2546912A (en) Emulating manual system of filing using electronic document and electronic file
IN2013CH05115A (en)
WO2013013171A8 (en) Content retrieval systems for distribution items
GB2517885A (en) Method and apparatus for processing database data in distributed database system
GB201209324D0 (en) Method and apparatus for assessing a translation
JP2013542501A5 (en)
WO2014188290A3 (en) Fast and secure retrieval of dna sequences
GB2504911A (en) Cache management of tracks in a first cache and a second cache for a storage
MY172251A (en) System generator module for electronic document and electronic filing
JP2016509281A5 (en)
TW201611877A (en) Computer-implemented method for determining game mechanics in business process gamification
BR112018007488A2 (en) method and system for determining time data with respect to a non-combustion output process of a combustible gas from a gas tank in a vehicle
IL241640B (en) Method for executing queries on streaming data using graphic processing units
IN2013CH05996A (en)
GB2534448A (en) Managing customs information
WO2014137893A3 (en) Interactive healthcare modeling
WO2011091354A3 (en) System and method for data storage
Sturfelt Skandinavien och första världskriget