JP2008537827A - 階層データベースのリレーショナル・クエリ - Google Patents

階層データベースのリレーショナル・クエリ Download PDF

Info

Publication number
JP2008537827A
JP2008537827A JP2008505856A JP2008505856A JP2008537827A JP 2008537827 A JP2008537827 A JP 2008537827A JP 2008505856 A JP2008505856 A JP 2008505856A JP 2008505856 A JP2008505856 A JP 2008505856A JP 2008537827 A JP2008537827 A JP 2008537827A
Authority
JP
Japan
Prior art keywords
many
entities
bridging table
record
query
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.)
Pending
Application number
JP2008505856A
Other languages
English (en)
Japanese (ja)
Other versions
JP2008537827A5 (enExample
Inventor
ホス、ロバート、アロイズ
ミラー、ジョン、ウィリアムズ
ラミレツ、ジャックイーン
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.)
International Business Machines Corp
Original Assignee
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 International Business Machines Corp filed Critical International Business Machines Corp
Publication of JP2008537827A publication Critical patent/JP2008537827A/ja
Publication of JP2008537827A5 publication Critical patent/JP2008537827A5/ja
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/901Indexing; Data structures therefor; Storage structures
    • G06F16/9027Trees

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)
JP2008505856A 2005-04-14 2006-03-17 階層データベースのリレーショナル・クエリ Pending JP2008537827A (ja)

Applications Claiming Priority (2)

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

Publications (2)

Publication Number Publication Date
JP2008537827A true JP2008537827A (ja) 2008-09-25
JP2008537827A5 JP2008537827A5 (enExample) 2009-02-26

Family

ID=36581672

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2008505856A Pending JP2008537827A (ja) 2005-04-14 2006-03-17 階層データベースのリレーショナル・クエリ

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 (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20040030716A1 (en) * 2002-08-08 2004-02-12 International Business Machines Corporation Hierarchical environments supporting relational schemas

Family Cites Families (11)

* 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
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 (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20040030716A1 (en) * 2002-08-08 2004-02-12 International Business Machines Corporation Hierarchical environments supporting relational schemas

Also Published As

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

Similar Documents

Publication Publication Date Title
US12222944B2 (en) Processing database queries using format conversion
TWI710919B (zh) 資料儲存裝置、轉譯裝置及資料庫存取方法
US7895226B2 (en) System and method for translating and executing update requests
CA2906669C (en) Efficiently performing operations on distinct data values
US20140074771A1 (en) Query optimization
US8713041B2 (en) Peer to peer (P2P) missing fields and field valuation feedback
US20140046928A1 (en) Query plans with parameter markers in place of object identifiers
US11907251B2 (en) Method and system for implementing distributed lobs
JP2022018435A (ja) データ管理装置及びデータ管理方法
JP2008537827A (ja) 階層データベースのリレーショナル・クエリ
US9069816B2 (en) Distributed multi-step abstract queries
CN116450890B (zh) 图数据处理方法、装置、系统、电子设备及存储介质
US20140310262A1 (en) Multiple schema repository and modular database procedures
US20090012948A1 (en) System and method for translating and executing queries
WO2023197865A1 (zh) 一种信息存储方法及装置
US8005844B2 (en) On-line organization of data sets
CN100445989C (zh) 用于生成对关于选择对象的信息的请求的系统和方法
WO2024108638A1 (zh) 一种基于分片索引的自适应查询方法和装置
CN117435591A (zh) 数据管理方法、装置及存储介质
JP2001067369A (ja) 情報検索システム、情報検索方法および情報検索用プログラムを記録した記録媒体
US7707138B2 (en) Identifying columns for row based operations
US20050188334A1 (en) Circuit design interface
JP2002259384A (ja) 仮想レコード使用データベース統合装置

Legal Events

Date Code Title Description
A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20081219

A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20081219

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20110614

A02 Decision of refusal

Free format text: JAPANESE INTERMEDIATE CODE: A02

Effective date: 20111122