Supercharge Your Innovation With Domain-Expert AI Agents!

Method and apparatus for extracting information from a database

A database and equipment technology, applied in digital data information retrieval, database indexing, electronic digital data processing, etc., can solve problems such as long computing time

Active Publication Date: 2013-09-11
QLIK TECH INTERNATIONAL AB
View PDF1 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Although state of the art algorithms are efficient, however, particularly if a large amount of data is to be analyzed, a large number of calculations may still need to be performed to create the multidimensional cube
In this case, the algorithm may place undesirably high demands on the processing hardware and / or cause undesirably long computation times

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and apparatus for extracting information from a database
  • Method and apparatus for extracting information from a database
  • Method and apparatus for extracting information from a database

Examples

Experimental program
Comparison scheme
Effect test

specific Embodiment

[0057] Specific embodiments, implementations and examples

[0058] In the following, embodiments of the present invention will be described and illustrated in more detail.

[0059] In an embodiment of the invention, previous calculations and results are used in the processing of subsequent requests for new data and new calculations. To this end, fetch processing is designed to cache results during processing of data requests. When processing subsequent requests, the fetch process determines whether appropriate previous results have been generated and cached. If yes, the previous result is used when processing subsequent requests. Subsequent request processing times can be significantly reduced since previous calculations do not need to be regenerated.

[0060] In an embodiment of the invention, a digital identifier (digital fingerprint) is used to identify cached information and in this way, cached results can also be reused when obtained differently compared to previous ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

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.

Description

technical field [0001] The present invention relates to techniques for extracting information from databases, and more particularly to techniques relating to a series of main calculations comprising a first main calculation and a second main calculation, wherein the first main calculation runs a first selection on a data set representing a database to produce A first result, and a second primary calculation runs a second option on the first result to produce a second result. Background technique [0002] It is often desirable to extract specific information from a database, and in particular, to summarize large amounts of data in a database and present the summarized data to a user in an understandable manner. Such data processing is typically performed by computers and may require significant memory performance and processing capabilities of the computers. This data processing may aim, for example, by visualizing selected data graphically in pivot tables or in 2D and 3D ch...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30G06F16/22G06F16/2455
CPCG06F16/2255G06F16/24561
Inventor 哈坎·沃尔格
Owner QLIK TECH INTERNATIONAL AB
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More