DK173451B1 - Fremgangsmåde, apparat og databærer til behandling af forespørgsler til en database - Google Patents

Fremgangsmåde, apparat og databærer til behandling af forespørgsler til en database Download PDF

Info

Publication number
DK173451B1
DK173451B1 DK199900517A DKPA199900517A DK173451B1 DK 173451 B1 DK173451 B1 DK 173451B1 DK 199900517 A DK199900517 A DK 199900517A DK PA199900517 A DKPA199900517 A DK PA199900517A DK 173451 B1 DK173451 B1 DK 173451B1
Authority
DK
Denmark
Prior art keywords
tables
query
queries
selecting
database
Prior art date
Application number
DK199900517A
Other languages
Danish (da)
English (en)
Inventor
Morten Middelfart
Original Assignee
Targit As
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 Targit As filed Critical Targit As
Priority to DK199900517A priority Critical patent/DK173451B1/da
Priority to US09/869,316 priority patent/US6732091B1/en
Priority to AT00918716T priority patent/ATE274208T1/de
Priority to AU39571/00A priority patent/AU3957100A/en
Priority to DE60013138T priority patent/DE60013138T2/de
Priority to EP00918716A priority patent/EP1196867B1/fr
Priority to PCT/DK2000/000181 priority patent/WO2000063798A1/fr
Application granted granted Critical
Publication of DK173451B1 publication Critical patent/DK173451B1/da

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/21—Design, administration or maintenance of databases
    • G06F16/217—Database tuning
    • 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/24542—Plan optimisation
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/953—Organization of data
    • Y10S707/954—Relational
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99931—Database or file accessing
    • Y10S707/99932—Access augmentation or optimizing
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99931—Database or file accessing
    • Y10S707/99933—Query processing, i.e. searching
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99931—Database or file accessing
    • Y10S707/99933—Query processing, i.e. searching
    • Y10S707/99934—Query formulation, input preparation, or translation
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99931—Database or file accessing
    • Y10S707/99933—Query processing, i.e. searching
    • Y10S707/99935—Query augmenting and refining, e.g. inexact access

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Operations Research (AREA)
  • Computational Linguistics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Electrically Operated Instructional Devices (AREA)
DK199900517A 1999-04-16 1999-04-16 Fremgangsmåde, apparat og databærer til behandling af forespørgsler til en database DK173451B1 (da)

Priority Applications (7)

Application Number Priority Date Filing Date Title
DK199900517A DK173451B1 (da) 1999-04-16 1999-04-16 Fremgangsmåde, apparat og databærer til behandling af forespørgsler til en database
US09/869,316 US6732091B1 (en) 1999-04-16 2000-04-13 Method and an apparatus for the processing of queries to a database
AT00918716T ATE274208T1 (de) 1999-04-16 2000-04-13 Ein verfahren und ein gerät für die verarbeitung von abfragen einer datenbank
AU39571/00A AU3957100A (en) 1999-04-16 2000-04-13 A method and an apparatus for the processing of queries to database
DE60013138T DE60013138T2 (de) 1999-04-16 2000-04-13 Ein verfahren und ein gerät für die verarbeitung von abfragen einer datenbank
EP00918716A EP1196867B1 (fr) 1999-04-16 2000-04-13 Procede et appareil de traitement des demandes vers une base de donnees
PCT/DK2000/000181 WO2000063798A1 (fr) 1999-04-16 2000-04-13 Procede et appareil de traitement des demandes vers une base de donnees

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
DK51799 1999-04-16
DK199900517A DK173451B1 (da) 1999-04-16 1999-04-16 Fremgangsmåde, apparat og databærer til behandling af forespørgsler til en database

Publications (1)

Publication Number Publication Date
DK173451B1 true DK173451B1 (da) 2000-11-20

Family

ID=59053839

Family Applications (1)

Application Number Title Priority Date Filing Date
DK199900517A DK173451B1 (da) 1999-04-16 1999-04-16 Fremgangsmåde, apparat og databærer til behandling af forespørgsler til en database

Country Status (7)

Country Link
US (1) US6732091B1 (fr)
EP (1) EP1196867B1 (fr)
AT (1) ATE274208T1 (fr)
AU (1) AU3957100A (fr)
DE (1) DE60013138T2 (fr)
DK (1) DK173451B1 (fr)
WO (1) WO2000063798A1 (fr)

Families Citing this family (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8452722B2 (en) * 2002-01-11 2013-05-28 Sap Ag Method and system for searching multiple data sources
US7499910B2 (en) * 2002-06-27 2009-03-03 Siebel Systems, Inc. Detecting and processing cache hits for queries with aggregates
US7765178B1 (en) * 2004-10-06 2010-07-27 Shopzilla, Inc. Search ranking estimation
US20060085386A1 (en) * 2004-10-19 2006-04-20 Microsoft Corporation Two pass calculation to optimize formula calculations for a spreadsheet
CA2519015A1 (fr) * 2005-09-13 2007-03-13 Cognos Incorporated Systeme et methode permettant d'executer des operations sur des ensembles relationnels pour des sources de donnees olap
US8117187B2 (en) * 2005-10-28 2012-02-14 Mediareif Moestl & Reif Kommunikations-Und Informationstechnologien Oeg Method for controlling a relational database system
ES2350243T3 (es) * 2005-10-28 2011-01-20 MEDIAREIF MÖSTL & REIF KOMMUNIKATIONS- UND INFORMATIONSTECHNOLOGIEN OEG Procedimiento para el control de un sistema de datos relacional.
US7937390B2 (en) * 2006-06-01 2011-05-03 Mediareif Moestl & Reif Kommunikations-Und Informationstechnologien Oeg Method for controlling a relational database system
US7774337B2 (en) * 2006-07-11 2010-08-10 Mediareif Moestl & Reif Kommunikations-Und Informationstechnologien Oeg Method for controlling a relational database system
US8918755B2 (en) * 2006-10-17 2014-12-23 International Business Machines Corporation Enterprise performance management software system having dynamic code generation
US7779031B2 (en) * 2007-02-15 2010-08-17 International Business Machines Corporation Multidimensional query simplification using data access service having local calculation engine
WO2008131465A1 (fr) * 2007-04-27 2008-11-06 Mediareif Möstl & Reif Kommunikations- Und Informationstechnologien Oeg Procédé de commande d'un système de banque de données relationnelle
US11550833B2 (en) * 2017-10-24 2023-01-10 University Of Louisiana At Lafayette Architecture for semantic search over encrypted data in the cloud
US11204923B2 (en) * 2018-10-24 2021-12-21 International Business Machines Corporation Performance for query execution

Family Cites Families (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5544355A (en) 1993-06-14 1996-08-06 Hewlett-Packard Company Method and apparatus for query optimization in a relational database system having foreign functions
US5600829A (en) 1994-09-02 1997-02-04 Wisconsin Alumni Research Foundation Computer database matching a user query to queries indicating the contents of individual database tables
CA2168287C (fr) * 1995-03-31 2000-05-23 Guy M. Lohman Methode de detection et d'optimisation de requetes relationnelles au moyen de tables de codage-decodage
US5822747A (en) * 1996-08-23 1998-10-13 Tandem Computers, Inc. System and method for optimizing database queries
US5884299A (en) 1997-02-06 1999-03-16 Ncr Corporation Optimization of SQL queries involving aggregate expressions using a plurality of local and global aggregation operations
US5940818A (en) * 1997-06-30 1999-08-17 International Business Machines Corporation Attribute-based access for multi-dimensional databases
US6073140A (en) * 1997-07-29 2000-06-06 Acxiom Corporation Method and system for the creation, enhancement and update of remote data using persistent keys
GB2330221B (en) * 1997-10-09 2002-07-03 Ibm Optimisation of relational database queries
AU761900B2 (en) * 1998-03-27 2003-06-12 International Business Machines Corporation Processing precomputed views
US6385604B1 (en) * 1999-08-04 2002-05-07 Hyperroll, Israel Limited Relational database management system having integrated non-relational multi-dimensional data store of aggregated data elements
EP1217541A1 (fr) * 2000-11-29 2002-06-26 Lafayette Software Inc. Procédé de traitement de demandes dans une base de données, base de données et produit logiciel pour mise en oeuvre de ce procédé

Also Published As

Publication number Publication date
EP1196867A1 (fr) 2002-04-17
US6732091B1 (en) 2004-05-04
AU3957100A (en) 2000-11-02
DE60013138D1 (de) 2004-09-23
ATE274208T1 (de) 2004-09-15
WO2000063798A1 (fr) 2000-10-26
EP1196867B1 (fr) 2004-08-18
DE60013138T2 (de) 2005-11-17

Similar Documents

Publication Publication Date Title
DK173451B1 (da) Fremgangsmåde, apparat og databærer til behandling af forespørgsler til en database
US5893090A (en) Method and apparatus for performing an aggregate query in a database system
US5778353A (en) Computer program product for optimizing data retrieval using index scanning
DK177142B1 (da) Fremgangsmåde til præsentation af et datasæt ved brug af søgning, computerlæsbart medium og computer
US7987200B2 (en) Method and apparatus for predicting selectivity of database query join conditions using hypothetical query predicates having skewed value constants
US5600829A (en) Computer database matching a user query to queries indicating the contents of individual database tables
JP5633944B1 (ja) 評価方法、評価装置、およびプログラム
TWI556180B (zh) 用以遞迴檢閱網際網路及其他來源以識別、收集、管理、判定及鑑定商業身分與相關資料之系統及方法
US6154739A (en) Method for discovering groups of objects having a selectable property from a population of objects
US7584178B2 (en) Query condition building using predefined query objects
US20050256848A1 (en) System and method for user rank search
JP2015099586A (ja) データ集約のためのシステム、装置、プログラム、及び方法
JP2007141247A (ja) 電子ビジネス通信におけるデータ要素の使用の追跡
US20170116307A1 (en) Automated Refinement and Validation of Data Warehouse Star Schemas
US11423036B2 (en) Systems and methods for selecting datasets
US20080120286A1 (en) Method and system for performing a clean operation on a query result
US8688612B2 (en) Method and device for saving triple for verifying reason and incremental reasoning, and method and device for reason-dependent indexing appropriate for same
US20190114325A1 (en) Method of facet-based searching of databases
US20170116306A1 (en) Automated Definition of Data Warehouse Star Schemas
US7827153B2 (en) System and method to perform bulk operation database cleanup
CN106603742B (zh) 一种ip地址与域名对应关系的更新方法及装置
US20230205750A1 (en) Multi-database subsetting
KR20040042065A (ko) 사례기반추론기법과 연관규칙탐사기법을 이용한 지능형정보검색방법
Abdel-Moneim et al. Quality Driven Approach for Data Integration Systems
EP3652669A1 (fr) Systèmes et procédés d'e compilation de base de données

Legal Events

Date Code Title Description
B1 Patent granted (law 1993)
PUP Patent expired

Expiry date: 20190416