CN1295636C - 用于访问关系型数据库系统中的分层数据的高效索引结构 - Google Patents

用于访问关系型数据库系统中的分层数据的高效索引结构 Download PDF

Info

Publication number
CN1295636C
CN1295636C CNB028191684A CN02819168A CN1295636C CN 1295636 C CN1295636 C CN 1295636C CN B028191684 A CNB028191684 A CN B028191684A CN 02819168 A CN02819168 A CN 02819168A CN 1295636 C CN1295636 C CN 1295636C
Authority
CN
China
Prior art keywords
node
index
item
hierarchical
database
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
CNB028191684A
Other languages
English (en)
Chinese (zh)
Other versions
CN1561496A (zh
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.)
Oracle International Corp
Original Assignee
Oracle International 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
Priority claimed from US10/171,728 external-priority patent/US6571231B2/en
Application filed by Oracle International Corp filed Critical Oracle International Corp
Publication of CN1561496A publication Critical patent/CN1561496A/zh
Application granted granted Critical
Publication of CN1295636C publication Critical patent/CN1295636C/zh
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)
CNB028191684A 2001-09-28 2002-09-26 用于访问关系型数据库系统中的分层数据的高效索引结构 Expired - Lifetime CN1295636C (zh)

Applications Claiming Priority (6)

Application Number Priority Date Filing Date Title
US32605201P 2001-09-28 2001-09-28
US60/326,052 2001-09-28
US37880002P 2002-05-07 2002-05-07
US60/378,800 2002-05-07
US10/171,728 US6571231B2 (en) 1999-02-18 2002-05-28 Maintenance of hierarchical index in relational system
US10/171,728 2002-05-28

Publications (2)

Publication Number Publication Date
CN1561496A CN1561496A (zh) 2005-01-05
CN1295636C true CN1295636C (zh) 2007-01-17

Family

ID=27390012

Family Applications (1)

Application Number Title Priority Date Filing Date
CNB028191684A Expired - Lifetime CN1295636C (zh) 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=)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2010048789A1 (zh) * 2008-11-03 2010-05-06 中国移动通信集团公司 用于分布式列存储数据库索引建立、查询的方法、装置及系统

Families Citing this family (23)

* 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 华为技术有限公司 权限管理方法、装置及系统
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 天翼数字生活科技有限公司 一种层次数据检索方法、装置和设备

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2000049533A2 (en) * 1999-02-18 2000-08-24 Oracle Corporation Hierarchical indexing for accessing hierarchically organized information in a relational system
US6236988B1 (en) * 1997-09-05 2001-05-22 International Business Machines Corp. Data retrieval system

Family Cites Families (4)

* 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
US6279007B1 (en) * 1998-11-30 2001-08-21 Microsoft Corporation Architecture for managing query friendly hierarchical values

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6236988B1 (en) * 1997-09-05 2001-05-22 International Business Machines Corp. Data retrieval system
WO2000049533A2 (en) * 1999-02-18 2000-08-24 Oracle Corporation Hierarchical indexing for accessing hierarchically organized information in a relational system

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2010048789A1 (zh) * 2008-11-03 2010-05-06 中国移动通信集团公司 用于分布式列存储数据库索引建立、查询的方法、装置及系统

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
CN1561496A (zh) 2005-01-05
WO2003030032A3 (en) 2004-04-29
EP1446737B1 (en) 2016-04-27
JP2005505059A (ja) 2005-02-17
JP4351530B2 (ja) 2009-10-28

Similar Documents

Publication Publication Date Title
CN1295636C (zh) 用于访问关系型数据库系统中的分层数据的高效索引结构
AU2002334721B2 (en) An index structure to access hierarchical data in a relational database system
US7366708B2 (en) Mechanism to efficiently index structured data that provides hierarchical access in a relational database system
US9898545B2 (en) Path-caching mechanism to improve performance of path-related operations in a repository
US6427123B1 (en) Hierarchical indexing for accessing hierarchically organized information in a relational system
AU2002334721A1 (en) An index structure to access hierarchical data in a relational database system
US7047253B1 (en) Mechanisms for storing content and properties of hierarchically organized resources
US7051039B1 (en) Mechanism for uniform access control in a database system
KR101022929B1 (ko) 데이터에 대한 함수 적용의 결과에 대한 구조화된 인덱스
CN100557605C (zh) 类型路径索引
AU2002334747A1 (en) Providing a consistent hierarchical abstraction of relational data
US7627547B2 (en) Processing path-based database operations
US9229967B2 (en) Efficient processing of path related operations on data organized hierarchically in an RDBMS
US7028037B1 (en) Operators for accessing hierarchical data in a relational system
CN115994139A (zh) 具有持久性标识符的元数据元素

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C14 Grant of patent or utility model
GR01 Patent grant
CX01 Expiry of patent term
CX01 Expiry of patent term

Granted publication date: 20070117