JP4351530B2 - リレーショナルデータベースシステム内の階層型データにアクセスするための効率的な索引構造 - Google Patents

リレーショナルデータベースシステム内の階層型データにアクセスするための効率的な索引構造 Download PDF

Info

Publication number
JP4351530B2
JP4351530B2 JP2003533164A JP2003533164A JP4351530B2 JP 4351530 B2 JP4351530 B2 JP 4351530B2 JP 2003533164 A JP2003533164 A JP 2003533164A JP 2003533164 A JP2003533164 A JP 2003533164A JP 4351530 B2 JP4351530 B2 JP 4351530B2
Authority
JP
Japan
Prior art keywords
index
access
node
path
user
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.)
Expired - Lifetime
Application number
JP2003533164A
Other languages
English (en)
Japanese (ja)
Other versions
JP2005505059A5 (https=
JP2005505059A (ja
Inventor
ジャラリ，ニーマ
セドラー，エリック
アガーウォル，ニプン
マーシー，ラビ
Original Assignee
オラクル・インターナショナル・コーポレイション
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
Priority claimed from US10/171,728 external-priority patent/US6571231B2/en
Application filed by オラクル・インターナショナル・コーポレイション filed Critical オラクル・インターナショナル・コーポレイション
Publication of JP2005505059A publication Critical patent/JP2005505059A/ja
Publication of JP2005505059A5 publication Critical patent/JP2005505059A5/ja
Application granted granted Critical
Publication of JP4351530B2 publication Critical patent/JP4351530B2/ja
Anticipated expiration legal-status Critical
Expired - Lifetime legal-status Critical Current

Links

Images

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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28—Databases characterised by their database models, e.g. relational or object models
    • G06F16/284—Relational databases

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)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
JP2003533164A 2001-09-28 2002-09-26 リレーショナルデータベースシステム内の階層型データにアクセスするための効率的な索引構造 Expired - Lifetime JP4351530B2 (ja)

Applications Claiming Priority (4)

Application Number Priority Date Filing Date Title
US32605201P 2001-09-28 2001-09-28
US37880002P 2002-05-07 2002-05-07
US10/171,728 US6571231B2 (en) 1999-02-18 2002-05-28 Maintenance of hierarchical index in relational system
PCT/US2002/030875 WO2003030032A2 (en) 2001-09-28 2002-09-26 An index structure to access hierarchical data in a relational database system

Publications (3)

Publication Number Publication Date
JP2005505059A JP2005505059A (ja) 2005-02-17
JP2005505059A5 JP2005505059A5 (https=) 2006-01-05
JP4351530B2 true JP4351530B2 (ja) 2009-10-28

Family

ID=27390012

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2003533164A Expired - Lifetime JP4351530B2 (ja) 2001-09-28 2002-09-26 リレーショナルデータベースシステム内の階層型データにアクセスするための効率的な索引構造

Country Status (5)

Country Link
EP (1) EP1446737B1 (https=)
JP (1) JP4351530B2 (https=)
CN (1) CN1295636C (https=)
CA (1) CA2461871C (https=)
WO (1) WO2003030032A2 (https=)

Families Citing this family (24)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP1569132B1 (en) 2004-02-23 2012-07-04 Sap Ag Computer system and method of performing a database access
CN100498792C (zh) * 2007-06-08 2009-06-10 北京神舟航天软件技术有限公司 数据库表行级数据的自主访问控制方法
US7809751B2 (en) 2007-08-27 2010-10-05 Sap Ag Authorization controlled searching
JP5303935B2 (ja) * 2008-01-08 2013-10-02 日本電気株式会社 データ多重化システムおよびデータ多重化方法
CN101299216B (zh) * 2008-05-28 2010-10-06 华为技术有限公司 权限管理方法、装置及系统
CN101727465B (zh) * 2008-11-03 2011-12-21 中国移动通信集团公司 分布式列存储数据库索引建立、查询方法及装置与系统
CN101751406B (zh) * 2008-12-18 2012-01-04 赵伟 一种实现基于列存储的关系型数据库的方法及装置
CN101706808B (zh) * 2009-11-17 2012-07-04 中国科学院软件研究所 基于索引树的海量数据库访问控制方法
CN101739523B (zh) * 2009-11-25 2013-02-27 金蝶软件（中国）有限公司 一种数据权限的控制方法及装置
US8655894B2 (en) * 2010-04-26 2014-02-18 Nokia Corporation Method and apparatus for index generation and use
US8584047B2 (en) * 2010-05-18 2013-11-12 Microsoft Corporation Orbital representation of hierarchical navigation
CN102063500A (zh) * 2011-01-04 2011-05-18 北京凯铭风尚网络技术有限公司 一种数据迁移的方法及装置
CN103635886B (zh) 2011-05-24 2017-02-15 日本电气株式会社 信息处理系统、数据管理方法、信息处理设备及其控制方法
KR101440475B1 (ko) * 2012-10-17 2014-09-17 주식회사 리얼타임테크 혼합 질의 처리를 위한 색인 생성 방법, 혼합 질의 처리 방법 및 색인 자료구조를 기록한 기록 매체
CN103853773A (zh) * 2012-12-04 2014-06-11 厦门亿联网络技术股份有限公司 一种Ｍysql数据库下树形数据结构的检索方法
US9367449B2 (en) * 2013-09-11 2016-06-14 Owtware Holdings Limited, BVI Hierarchical garbage collection in an object relational database system
US10635645B1 (en) 2014-05-04 2020-04-28 Veritas Technologies Llc Systems and methods for maintaining aggregate tables in databases
CN109726579B (zh) * 2017-10-27 2023-04-28 阿里巴巴集团控股有限公司 资源访问权限分组方法及设备
US11106698B2 (en) * 2019-06-11 2021-08-31 Sap Se Multi-master with ownership transfer
US10997178B2 (en) * 2019-06-11 2021-05-04 Sap Se Implicit partitioning
US11640380B2 (en) * 2021-03-10 2023-05-02 Oracle International Corporation Technique of comprehensively supporting multi-value, multi-field, multilevel, multi-position functional index over stored aggregately stored data in RDBMS
CN113204564B (zh) * 2021-05-20 2023-02-28 山东英信计算机技术有限公司 一种数据库高频sql查询方法、系统和存储介质
US11516307B1 (en) * 2021-08-09 2022-11-29 Servicenow, Inc. Support for multi-type users in a single-type computing system
CN114116716B (zh) * 2021-11-19 2025-06-06 天翼数字生活科技有限公司 一种层次数据检索方法、装置和设备

Family Cites Families (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5751949A (en) * 1995-05-23 1998-05-12 Mci Corporation Data security system and method
US5893104A (en) * 1996-07-09 1999-04-06 Oracle Corporation Method and system for processing queries in a database system using index structures that are not native to the database system
US5903888A (en) * 1997-02-28 1999-05-11 Oracle Corporation Method and apparatus for using incompatible types of indexes to process a single query
GB2329044B (en) * 1997-09-05 2002-10-09 Ibm Data retrieval system
US6279007B1 (en) * 1998-11-30 2001-08-21 Microsoft Corporation Architecture for managing query friendly hierarchical values
US6427123B1 (en) * 1999-02-18 2002-07-30 Oracle Corporation Hierarchical indexing for accessing hierarchically organized information in a relational system

Also Published As

Publication number Publication date
EP1446737A2 (en) 2004-08-18
WO2003030032A2 (en) 2003-04-10
CA2461871A1 (en) 2003-04-10
CA2461871C (en) 2012-12-18
CN1295636C (zh) 2007-01-17
CN1561496A (zh) 2005-01-05
WO2003030032A3 (en) 2004-04-29
EP1446737B1 (en) 2016-04-27
JP2005505059A (ja) 2005-02-17

Similar Documents

Publication Publication Date Title
US7366708B2 (en) Mechanism to efficiently index structured data that provides hierarchical access in a relational database system
JP4351530B2 (ja) リレーショナルデータベースシステム内の階層型データにアクセスするための効率的な索引構造
AU2002334721B2 (en) An index structure to access hierarchical data in a relational database system
US7051039B1 (en) Mechanism for uniform access control in a database system
AU2002334721A1 (en) An index structure to access hierarchical data in a relational database system
US9898545B2 (en) Path-caching mechanism to improve performance of path-related operations in a repository
US6965903B1 (en) Techniques for managing hierarchical data with link attributes in a relational database
US8176007B2 (en) Performing an action in response to a file system event
US7047253B1 (en) Mechanisms for storing content and properties of hierarchically organized resources
JP5320438B2 (ja) Ｘｍｌデータ記憶、クエリー再書込、ビジュアライゼーション、マッピング、および参照のための方法および装置
AU2002334747A1 (en) Providing a consistent hierarchical abstraction of relational data
KR20070121664A (ko) 데이터 저장 시스템에서 데이터를 조작하는 시스템 및 방법
US7472140B2 (en) Label-aware index for efficient queries in a versioning system
US7627547B2 (en) Processing path-based database operations
US7849106B1 (en) Efficient mechanism to support user defined resource metadata in a database repository
US7028037B1 (en) Operators for accessing hierarchical data in a relational system
EP4170516A1 (en) Metadata elements with persistent identifiers
JP4724177B2 (ja) Ｘｍｌデータにアクセスするためのインデックス
US20080147615A1 (en) Xpath based evaluation for content stored in a hierarchical database repository using xmlindex

Legal Events

Date Code Title Description
A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20050809

A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20050809

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20080722

A601 Written request for extension of time

Free format text: JAPANESE INTERMEDIATE CODE: A601

Effective date: 20081021

A602 Written permission of extension of time

Free format text: JAPANESE INTERMEDIATE CODE: A602

Effective date: 20081028

A601 Written request for extension of time

Free format text: JAPANESE INTERMEDIATE CODE: A601

Effective date: 20081121

A602 Written permission of extension of time

Free format text: JAPANESE INTERMEDIATE CODE: A602

Effective date: 20081201

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20081217

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20090127

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20090427

TRDD Decision of grant or rejection written
A01 Written decision to grant a patent or to grant a registration (utility model)

Free format text: JAPANESE INTERMEDIATE CODE: A01

Effective date: 20090714

A01 Written decision to grant a patent or to grant a registration (utility model)

Free format text: JAPANESE INTERMEDIATE CODE: A01

A61 First payment of annual fees (during grant procedure)

Free format text: JAPANESE INTERMEDIATE CODE: A61

Effective date: 20090724

FPAY Renewal fee payment (event date is renewal date of database)

Free format text: PAYMENT UNTIL: 20120731

Year of fee payment: 3

R150 Certificate of patent or registration of utility model

Ref document number: 4351530

Country of ref document: JP

Free format text: JAPANESE INTERMEDIATE CODE: R150

Free format text: JAPANESE INTERMEDIATE CODE: R150

FPAY Renewal fee payment (event date is renewal date of database)

Free format text: PAYMENT UNTIL: 20120731

Year of fee payment: 3

FPAY Renewal fee payment (event date is renewal date of database)

Free format text: PAYMENT UNTIL: 20130731

Year of fee payment: 4

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

EXPY Cancellation because of completion of term