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 (pt-BR
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

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR 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

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 (pt-BR) 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 (pt-BR)
EP (1) EP1872278A1 (pt-BR)
JP (1) JP2008537827A (pt-BR)
CN (1) CN101160583A (pt-BR)
WO (1) WO2006108753A1 (pt-BR)

Families Citing this family (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
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
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
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
US7240330B2 (en) * 2002-02-01 2007-07-03 John Fairweather Use of ontologies for auto-generating and handling applications, their persistent storage, and user interfaces
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
WO2006108753A1 (en) 2006-10-19
US20060235820A1 (en) 2006-10-19
CN101160583A (zh) 2008-04-09
EP1872278A1 (en) 2008-01-02

Similar Documents

Publication Publication Date Title
US11755575B2 (en) Processing database queries using format conversion
JP2008537827A (ja) 階層データベースのリレーショナル・クエリ
TWI710919B (zh) 資料儲存裝置、轉譯裝置及資料庫存取方法
US9672272B2 (en) Method, apparatus, and computer-readable medium for efficiently performing operations on distinct data values
US7895226B2 (en) System and method for translating and executing update requests
US8782075B2 (en) Query handling in databases with replicated data
US9418101B2 (en) Query optimization
US8713041B2 (en) Peer to peer (P2P) missing fields and field valuation feedback
US8924373B2 (en) Query plans with parameter markers in place of object identifiers
US20080104089A1 (en) System and method for distributing queries to a group of databases and expediting data access
CN1987861A (zh) 处理数据库查询的系统和方法
US11907251B2 (en) Method and system for implementing distributed lobs
CN105760418B (zh) 用于对关系数据库表进行交叉列搜索的方法和系统
CN116450890A (zh) 图数据处理方法、装置、系统、电子设备及存储介质
US20140310262A1 (en) Multiple schema repository and modular database procedures
US20090012948A1 (en) System and method for translating and executing queries
US9069816B2 (en) Distributed multi-step abstract queries
US7536398B2 (en) On-line organization of data sets
CN100445989C (zh) 用于生成对关于选择对象的信息的请求的系统和方法
JP2022018435A (ja) データ管理装置及びデータ管理方法
JP2001067369A (ja) 情報検索システム、情報検索方法および情報検索用プログラムを記録した記録媒体
US7707138B2 (en) Identifying columns for row based operations
US20050188334A1 (en) Circuit design interface
JP2002259384A (ja) 仮想レコード使用データベース統合装置
JP2004046906A (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