WO2006108753A1 - Relational query of a hierarchical database - Google Patents

Relational query of a hierarchical database Download PDF

Info

Publication number
WO2006108753A1
WO2006108753A1 PCT/EP2006/060823 EP2006060823W WO2006108753A1 WO 2006108753 A1 WO2006108753 A1 WO 2006108753A1 EP 2006060823 W EP2006060823 W EP 2006060823W WO 2006108753 A1 WO2006108753 A1 WO 2006108753A1
Authority
WO
WIPO (PCT)
Prior art keywords
many
query
bridging table
records
entities
Prior art date
Legal status (The legal status 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 status listed.)
Ceased
Application number
PCT/EP2006/060823
Other languages
English (en)
French (fr)
Inventor
Robert Aloise Hoth
John Williams Miller
Joaquin Ramirez
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
IBM United Kingdom Ltd
International Business Machines Corp
Original Assignee
IBM United Kingdom Ltd
International Business Machines Corp
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 IBM United Kingdom Ltd, International Business Machines Corp filed Critical IBM United Kingdom Ltd
Priority to JP2008505856A priority Critical patent/JP2008537827A/ja
Priority to EP06725125A priority patent/EP1872278A1/en
Publication of WO2006108753A1 publication Critical patent/WO2006108753A1/en
Anticipated expiration legal-status Critical
Ceased legal-status Critical Current

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/90—Details of database functions independent of the retrieved data types
    • G06F16/901—Indexing; Data structures therefor; Storage structures
    • G06F16/9027—Trees

Definitions

  • step 44 components for searching and retrieving data from the hierarchical database are created. This step is described below in connection with FIGS. 1, 3, and 4.

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Software Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
PCT/EP2006/060823 2005-04-14 2006-03-17 Relational query of a hierarchical database Ceased WO2006108753A1 (en)

Priority Applications (2)

Application Number Priority Date Filing Date Title
JP2008505856A JP2008537827A (ja) 2005-04-14 2006-03-17 階層データベースのリレーショナル・クエリ
EP06725125A EP1872278A1 (en) 2005-04-14 2006-03-17 Relational query of a hierarchical database

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US11/106,412 2005-04-14
US11/106,412 US20060235820A1 (en) 2005-04-14 2005-04-14 Relational query of a hierarchical database

Publications (1)

Publication Number Publication Date
WO2006108753A1 true WO2006108753A1 (en) 2006-10-19

Family

ID=36581672

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/EP2006/060823 Ceased WO2006108753A1 (en) 2005-04-14 2006-03-17 Relational query of a hierarchical database

Country Status (5)

Country Link
US (1) US20060235820A1 (enExample)
EP (1) EP1872278A1 (enExample)
JP (1) JP2008537827A (enExample)
CN (1) CN101160583A (enExample)
WO (1) WO2006108753A1 (enExample)

Families Citing this family (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7877369B2 (en) 2007-11-02 2011-01-25 Paglo Labs, Inc. Hosted searching of private local area network information
US7877368B2 (en) * 2007-11-02 2011-01-25 Paglo Labs, Inc. Hosted searching of private local area network information with support for add-on applications
US8046353B2 (en) * 2007-11-02 2011-10-25 Citrix Online Llc Method and apparatus for searching a hierarchical database and an unstructured database with a single search query
CN101237449B (zh) * 2008-02-01 2012-08-22 中国建设银行股份有限公司 一种访问ims数据库的方法及系统
US8140565B2 (en) * 2009-01-20 2012-03-20 International Business Machines Corporation Autonomic information management system (IMS) mainframe database pointer error diagnostic data extraction
US20110154221A1 (en) * 2009-12-22 2011-06-23 International Business Machines Corporation Subject suggestion based on e-mail recipients
US9087138B2 (en) 2013-01-15 2015-07-21 Xiaofan Zhou Method for representing and storing hierarchical data in a columnar format
US9639568B2 (en) * 2014-05-01 2017-05-02 Aktiebolaget Skf Systems and methods for improved data structure storage
US9881036B2 (en) 2014-12-01 2018-01-30 International Business Machines Corporation Avoid double counting of mapped database data
US10853364B2 (en) * 2016-09-28 2020-12-01 Microsoft Technology Licensing, Llc Direct table association in in-memory databases

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO1995003586A1 (en) * 1993-07-21 1995-02-02 Persistence Software, Inc. Method and apparatus for generation of code for mapping relational data to objects
US20040030716A1 (en) * 2002-08-08 2004-02-12 International Business Machines Corporation Hierarchical environments supporting relational schemas

Family Cites Families (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5675545A (en) * 1995-09-08 1997-10-07 Ambit Design Systems, Inc. Method of forming a database that defines an integrated circuit memory with built in test circuitry
US5907844A (en) * 1997-03-20 1999-05-25 Oracle Corporation Dynamic external control of rule-based decision making through user rule inheritance for database performance optimization
US6016497A (en) * 1997-12-24 2000-01-18 Microsoft Corporation Methods and system for storing and accessing embedded information in object-relational databases
US6421658B1 (en) * 1999-07-30 2002-07-16 International Business Machines Corporation Efficient implementation of typed view hierarchies for ORDBMS
US6597366B1 (en) * 2000-01-14 2003-07-22 International Business Machines Corporation Transparent general purpose object isolation for multi-tier distributed object environments
US6665654B2 (en) * 2001-07-03 2003-12-16 International Business Machines Corporation Changing table records in a database management system
US20040024720A1 (en) * 2002-02-01 2004-02-05 John Fairweather System and method for managing knowledge
US20040133581A1 (en) * 2002-05-21 2004-07-08 High-Speed Engineering Laboratory, Inc. Database management system, data structure generating method for database management system, and storage medium therefor
JP4138462B2 (ja) * 2002-11-22 2008-08-27 株式会社東芝 階層構造表示装置および階層構造表示方法
US20050278308A1 (en) * 2004-06-01 2005-12-15 Barstow James F Methods and systems for data integration

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO1995003586A1 (en) * 1993-07-21 1995-02-02 Persistence Software, Inc. Method and apparatus for generation of code for mapping relational data to objects
US20040030716A1 (en) * 2002-08-08 2004-02-12 International Business Machines Corporation Hierarchical environments supporting relational schemas

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
CHEN P P-S: "THE ENTITY-RELATIONSHIP MODEL-TOWARD A UNIFIED VIEW OF DATA", ACM TRANSACTIONS ON DATABASE SYSTEMS, ACM, NEW YORK, NY, US, vol. 1, no. 1, March 1976 (1976-03-01), pages 9 - 36, XP001012200, ISSN: 0362-5915 *
JOHNSON J.L.: "DATABASE : MODELS, LANGUAGES, DESIGN", 1997, OXFORD UNIVERSITY PRESS, USA, XP002386368 *

Also Published As

Publication number Publication date
US20060235820A1 (en) 2006-10-19
CN101160583A (zh) 2008-04-09
JP2008537827A (ja) 2008-09-25
EP1872278A1 (en) 2008-01-02

Similar Documents

Publication Publication Date Title
US12222944B2 (en) Processing database queries using format conversion
US6931408B2 (en) Method of storing, maintaining and distributing computer intelligible electronic data
US7756861B2 (en) Optimizing a computer database query that fetches N rows
US7895226B2 (en) System and method for translating and executing update requests
US7617235B2 (en) Method and system for creating a domain index
US7856462B2 (en) System and computer program product for performing an inexact query transformation in a heterogeneous environment
US8145668B2 (en) Associating information related to components in structured documents stored in their native format in a database
US8924373B2 (en) Query plans with parameter markers in place of object identifiers
EP3751426A1 (en) System and method for migration of a legacy datastore
CN105760418B (zh) 用于对关系数据库表进行交叉列搜索的方法和系统
US8825621B2 (en) Transformation of complex data source result sets to normalized sets for manipulation and presentation
US20100100556A1 (en) System and methods for facilitating a linear grid database with data organization by dimension
US20040148293A1 (en) Method, system, and program for managing database operations with respect to a database table
US11907251B2 (en) Method and system for implementing distributed lobs
US20070239673A1 (en) Removing nodes from a query tree based on a result set
US8639717B2 (en) Providing access to data with user defined table functions
US20060235820A1 (en) Relational query of a hierarchical database
US7213014B2 (en) Apparatus and method for using a predefined database operation as a data source for a different database operation
US7765219B2 (en) Sort digits as number collation in server
US20090012948A1 (en) System and method for translating and executing queries
CN100538700C (zh) 用于数据处理的方法和系统
US6839716B1 (en) Method and system for building a dataset
JP2004265421A (ja) 選択されたオブジェクトに関する情報の要求を生成するためのシステムおよび方法
WO2024108638A1 (zh) 一种基于分片索引的自适应查询方法和装置
US20070299837A1 (en) Data Processing Method and System Based on Networked Relational Dimension

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application
WWE Wipo information: entry into national phase

Ref document number: 2008505856

Country of ref document: JP

Ref document number: 200680012050.5

Country of ref document: CN

NENP Non-entry into the national phase

Ref country code: DE

WWW Wipo information: withdrawn in national office

Country of ref document: DE

WWE Wipo information: entry into national phase

Ref document number: 2006725125

Country of ref document: EP

NENP Non-entry into the national phase

Ref country code: RU

WWW Wipo information: withdrawn in national office

Country of ref document: RU

WWP Wipo information: published in national office

Ref document number: 2006725125

Country of ref document: EP