CN1299223C - 提供关系数据的一致性层次抽象化 - Google Patents
提供关系数据的一致性层次抽象化 Download PDFInfo
- Publication number
- CN1299223C CN1299223C CNB028191692A CN02819169A CN1299223C CN 1299223 C CN1299223 C CN 1299223C CN B028191692 A CNB028191692 A CN B028191692A CN 02819169 A CN02819169 A CN 02819169A CN 1299223 C CN1299223 C CN 1299223C
- Authority
- CN
- China
- Prior art keywords
- level
- node
- information
- row
- data
- 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
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/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
- G06F16/84—Mapping; Conversion
- G06F16/86—Mapping to a database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR 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
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99931—Database or file accessing
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99931—Database or file accessing
- Y10S707/99933—Query processing, i.e. searching
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99941—Database schema or data structure
- Y10S707/99942—Manipulating data structure, e.g. compression, compaction, compilation
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99941—Database schema or data structure
- Y10S707/99943—Generating database or data structure, e.g. via user interface
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99941—Database schema or data structure
- Y10S707/99944—Object-oriented database structure
- Y10S707/99945—Object-oriented database structure processing
Abstract
本发明提供了数据的一致性层次抽象化。层次可以在层次结构之外维持的现有数据中明显或隐含地反映。这样的层次称之为“先前存在的层次”。此处描述的技术用于在分层结构中捕捉先前存在的层次。在先前存在的层次已经被捕捉后,存在两组反映该层次的独立数据:外部层次定义和内部层次定义。改变每个层次定义都会改变层次。因此,为了维持层次的一致性反映,响应于对外部层次定义做出的改变,必须更改内部层次定义,响应于对内部层次定义做出的改变,必须更改外部层次定义。所描述的各种技术用于维持两个层次定义之间的一致性。
Description
相关申请
本发明要求以下美国临时专利申请的优先权,其全部内容结合于此作为参考:
2001年9月28日由Eric Sedlar及Viswanathan Krishnamurthy提交的美国临时专利申请No.60/326,052,名称为:“设置有数据库系统的基于文件的访问(File Based Access Provided With a DatabaseSystem)”;
2002年5月7日由Nipun Agarwal、Ravi Murthy、Eric Sedlar、Sivasankaran Chandrasekar、Fei Ge、Syam Pannala、Neema Jalali、以及Muralidhar Krishnaprasad提交的美国临时专利申请No.60/378,800,名称为:“对提供文件系统抽象化的数据的SQL访问(SQL Access to Data that Provides a File System Abstraction)”。
本发明还涉及以下美国专利申请,其全部内容也结合于此作为参考:
同本申请同日由Nipun Agarwal、Ravi Murthy、Eric Sedlar、Sivasankaran Chandrasekar、以及Fei Ge提交的美国专利申请,序列号为:___________,名称为:“用于在关系系统中存取分层数据的操作器(OPERATORS FOR ACCESSINGHIERARCHICAL DATA IN A RELATIONAL SYSTEM)”(律师卷号:No.50277-1975);
同本申请同日由Ravi Murthy、Muralidhar Krishnaprasad、Sivasankaran Chandrasekar、Eric Sedlar、Vishu Krishnamurthy、以及Nipun Agarwal提交的美国专利申请,序列号为:_______,名称为:“用于将XML模式映射到对象关系数据库系统的机制(MECHANISM FOR MAPPING XML SCHEMAS TO OBJECT-RELATIONAL DATABASE SYSTEMS)”(律师卷号:50277-1977);
同本申请同日由Nipun Agarwal、Eric Sedlar、以及Ravi Murthy提交的美国专利申请,序列号为:_________,名称为“用于高效管理数据库系统中的变型数据的索引(INDEXING TOEFFICIENTLY MANAGE VERSIONED DATA IN A DATABASESYSTEM)”(律师卷号为50277-1978);
同本申请同日由Ravi Murthy、Eric Sedlar、Nipun Agarwal、以及Neema Jalali提交的美国专利申请,序列号为:________,名称为:“用于储存分层组织资源的内容和属性的机制(MECHANISMS FOR STORING CONTENT AND PROPERTIESOF HIERACHICALLY ORGANIZED RESOURCES)”(律师卷号:50277-1979);
同本申请同日由Ravi Murthy、Eric Sedlar、Nipun Agarwal、SamIdicula、以及Nicolas Montoya提交的美国专利申请,序列号为:________,名称为:“用于在数据库系统中统一存取控制的机制(MECHANISM UNIFORM ACCESS CONTROL IN ADATABASE SYSTEM)”(律师卷号:50277-1980);
同本申请同日由Syam Pannala、Eric Sedlar、Bhushan Khaladkar、Ravi Murthy、Sivasankaran Chandrasekar、以及Nipun Agarwal提交的美国专利申请,序列号为:________,名称为:“用于XML文档的惰性显示的可装载装置(LOADABLE UNITS FORLAZY MANIFESTATION OF XML DOCUMENTS)”(律师卷号:50277-1981);
同本申请同日由Neema Jalali、Eric Sedlar、Nipun Agarwal、以及Ravi Murthy申请的美国专利申请,序列号为:________,名称为:“在关系数据库系统中高效率地索引用于提供分层存取的结构化数据的机制(MECHANISM TO EFFICIENTLY INDEXSTRUCTURED DATA THAT PROVIDES HIERARCHICAL ACCESSIN A RELATIONAL DATABASE SYSTEM)”(律师卷号:50277-1982)。
技术领域
本发明涉及在关系数据库中储存根据一定层次进行组织的信息,尤其涉及管理用于捕捉该层次的元数据的技术。
背景技术
人们倾向于按类别组织信息。在其中组织信息的类别是通常相对于彼此以某种形式的层次进行组织的类别本身。例如,个体的动物属于种,种属于属,属属于科,科属于目,目属于纲。
随着计算机系统的出现,储存电子信息的技术已经得到发展,很大程度上反映了人们对分层组织的需求。例如,通常采用基于分层组织原理实现传统计算机文件系统。具体地,通常的文件系统具有按层次设置的目录以及储存在目录中的文档(document)。理想地是,目录之间的层次关系反映了已经赋予目录的含义之间的某种直观关系。同样,理想地是,每个文档基于在文档的内容和用来储存该文件的目录被赋予的含义之间的某种直观关系被储存在目录中。
图1示出了典型的文件系统的实例。示出的文件系统包括按层次排列的多个目录。在目录中储存有两个文档118和122。特别地,文档118和122的名称都是“Example.doc”,分别储存在目录116和124中,这两个目录的名称分别为“Word”和“App4”。
在目录层次中,目录116是名称为“Windows”的目录114的子目录,目录114是目录110的子目录。类似地,目录124是名称为“VMS”的目录126的子目录,目录126是目录110的子目录。目录110被称之为“根”目录,原因在于,该目录是所有其他目录起源的目录。在很多系统中,符号“/”用来指示根目录。
当按层次组织电子信息时,根据通过分层结构到包含该数据项的实体的“路径”可以查找信息的每一数据项。在一个分层文件系统中,到数据项的路径由根目录开始,沿着目录的层次结构向下进行,最终到达包含感兴趣的数据项的目录。例如,到文档118的路径依次包括目录110、114、以及116。
分层存储系统通常允许不同的数据项具有相同的名称。例如,在图1所示的文件系统中,文档118和122的名称都是“Example.doc”。从而,为了明确地识别给定文档,除了文档名称之外还有其它要求。
一种用来识别和定位储存在分层存储系统中的信息的特定数据项的简便方法是通过使用“路径名称”。路径名称法是一种根据通过分层结构到数据项的路径来唯一识别数据项的简便方法。路径名称包括一序列名称。在文件系统的情况下,在该名称序列中的每个名称都是“文件名”。术语“文件名”指的是目录名称和文档的名称,原因在于,目录和文档均被当作“文件”。
在文件系统中,给定路径名中的文件名序列开始于根目录的名称,包括沿着从根目录到感兴趣的数据项的路径的所有目录的名称,结束于感兴趣的数据项的名称。通常,要遍历的目录列表使用某种分隔符号(例如,“/”、“\”、或“;”)连接起来,以产生路径名称。因此,文档118的路径名称是:/Windows/Word/Example.doc,而文档122的路径名称是:/VMS/App4/Example.doc。
目录(文件)及其所包含的内容之间的关系随着分层组织系统的类型的不同而显著变化。在多种实施方式(例如Windows和DOS文件系统)所采用的一种模式中,需要每个文件刚好具有一个父,形成树状结构。在更复杂的模式中(例如在使用硬连接的UNIX文件系统中),分层结构采用定向图的形式,文件能够具有多个父。
和用来组织电子信息的分层法相反,关系数据库将信息储存在由行和列组成的表中。通过唯一的RowID来识别每行。每列代表了记录的属性,每行代表了特定的记录。通过向管理数据库的数据库管理系统(DBMS)提交查询,从数据库中获取数据。查询必须遵循数据库管理系统支持的数据库语言。结构化查询语言(SQL)是很多现有数据库管理系统支持的数据库语言的例子。
每种储存系统都有优点和缺点。分层组织的储存系统简单、直观、易于实现,是多数应用程序使用的标准模式。不幸地是,简单的分层组织没有提供复杂数据检索操作所需要的支持。例如,必须检查每一目录的内容,从而检索某天创建的具有特定文件名的所有文档。由于必须搜索所有文件,分层组织不便于检索过程。
关系数据库系统非常适于储存大量的信息并以非常灵活的方式存取数据。相对于分层组织系统而言,即使符合复杂的搜索条件的数据也可容易并高效地从关系数据系统中检索到。然而,定制并向数据库服务器提交查询的进程却没有仅遍历分层目录直观,并且超出了很多计算机用户所掌握的技术程度。
过去,分层组织系统和关系组织系统以不同的相不兼容的方式实现。然而,通过一些额外程序,关系组织系统能够模拟分层组织系统。当需要关系系统的储存能力和灵活性,同时又需要分层系统的直观性和普遍性时,尤其需要这种模拟。
附图说明
通过实例说明本发明,并非用于限制本发明,在附图中,相同的标号代表相同的部件,其中:
图1示出分层文件系统的框图;
图2示出和源相关联的节点层次的框图;
图3是根据本发明的实施例的能够被用来捕捉图2中示出的层次的关系表的框图;
图4示出根据本发明的实施例的分层结构和内容结构的框图;
图5是关系表的框图,其中通过储存在相应于叶节点的行中的值示出信息层次的非叶结点;
图6是储存在图5的表中的数据隐含的层次的框图;以及
图7是可以实施本发明的实施例的系统的框图。
具体实施方式
本发明描述了用于在关系数据库系统的结构中储存属于信息层次的源的方法和系统。在以下的描述中,出于说明目的,为了提供对本发明的透彻理解而阐明了许多具体细节。然而,很显然,即使没有这些特定细节,本发明也能实施。在其它实例中,为了避免对本发明不必要的模糊,以方框图示出已知结构和装置。
功能概述
本发明提供了多种便于在关系数据库系统中管理分层数据的技术。根据一个实施例,将用来储存属于层次的源的存储结构(“内容结构(content structure)”)与用来储存捕捉关于层次的数据的存储结构(“分层结构(hierarchy structure)”)分开。
在一些情况下,在分层结构之外维持的现有数据中已经明确地和隐含地反映了层次。这样的层次被称作“先有层次”。在这些情况下,需要在分层结构中捕捉先有层次,以便分层结构可以被用作到源的可选访问路径。例如,根据路径信息,可用分层结构访问源。而且,即使当通过直接向内容结构发出查询来访问源时,访问操作也能获得所有特征的益处,并访问和分层结构相关的结构,例如,任何安全机制和任何索引,安全机制内建在分层结构中,索引被建立以增强根据源在层次中的位置来访问源的操作性能。
每个先有层次都与以下数据关联,(1)存在于分层结构之外的数据,以及(2)反映了先有层次的数据。这里将这样的数据称作“外部层次定义”。为了在分层结构中捕捉先有层次,必须根据外部层次定义将数据(此处指的是“内部层次定义”)添加到分层结构中。
已经捕捉先有层次后,还存在两组反映层次的独立数据:外部层次定义和内部层次定义。改变任一种定义都改变了层次。由此,为了维持层次的一致性反映,响应于对外部层次定义做出的改变,必须改变内部层次定义。此处描述了用于维持两种层次定义之间的一致性的多项技术。
在关系数据库系统中储存分层数据
图2示出实例中使用的层次200的框图,此处给出的实例是为了便于理解对本发明实施例。层次200包括八个节点。在该层次中最高等级的节点被称作“根”节点。每个分支的末端的节点是“叶”节点。根节点和叶结点之间的节点是“中间”节点。在示意性层次中,节点1、2、以及3是中间节点,节点4、5、6、以及7是叶节点。
在信息层次中,节点对应于信息。通常,和每个节点相关联的信息项将有某种形式的名称和某种类型的内容。例如,在相应于分层文件系统的层次中,节点通常相应于文件(这里,“文件夹”或“目录”是文件的一种类型)。每个这样的文件将具有名称、以及某种形式的内容。
在很多情况下,在层次中和节点相关的名称不必是唯一的。在图2示出的实例中,节点1和节点7都具有名称“a”。尽管它们的名称相同,但它们却是分别的不同的节点,在层次中占有不同的位置,与完全不同的内容相关联。
一种规格适用全部(ONE-SIZE-FITS-ALL)
图3是可用来代表关系数据库系统中的层次200的两张表(源表302和链接表350)的框图。源表302包括用于层次中的每个节点的行。用于给定结点的行包括与给定节点关联的名称以及和给定节点关联的数据。例如,行304相应于节点1,包含和节点1关联的名称“a”和数据306。源表302是一种规格适用全部的方法的实例,其中,在层次中用于所有数据源的数据被储存在相同的结构中,而不考虑这些源的数据类型。在源表302的实例中,用来储存源数据内容的数据结构是单列308。用于该列的数据可以是例如LOB(Large Object,大对象)型的,诸如二进制LOB(BLOB)或字符LOB(CLOB)。
链接表350包括用于层次200中的每对父-子关系的一行。父列378持有表示父-子关系的父的值,子列380持有表示父-子关系的子的值。例如,行352表示根节点是节点1的父。同样,行354和行356分别表示节点1是节点2和节点3的父。
将分层结构与内容结构分开
表302和350以关系格式捕捉层次200的所有信息。但是,如果与层次200关联的源数据的内容使用由源表302代表的一种规格适用全部的方法储存,则不可能完全利用关系数据库系统的能力。特别地,源表302包括用于将和节点关联的资源内容储存在层次200中的单列。当和节点关联的源数据是简单的数据类型(例如,字符串或整型)时,这样的储存格式是足够用的。但是,在很多情况下,在层次中和节点关联的源数据是复杂的数据类型,例如,复杂记录或XML文档。在这样的情况下,源数据在单列中储存制约了用户对内容进行复杂搜索的能力。即使当该数据库系统提供了对在单列中搜索复杂的源数据分量的支持时,这样的搜索性能也会受到损害。
根据本发明的一个实施例,通过将和节点相关联的源内容和捕捉分层信息的表分开储存,克服了与储存和搜索属于信息层次的复杂源数据相关的问题。
例如,图4示出了与源表302类似的源表402。然而,源表402和源表302的不同之处在于源表402不再在每个源数据的行中储存该源数据的内容。当然,源表302中的DATA列被源表402中的DATA TYPE列以及DATA REF列这两列代替。
对于源表402中的每行,DATA TYPE列储存指示和在行中识别的节点相关联的源类型的数据。例如,行404相应于层次200的节点1。行404的DATA TYPE列示出和节点1关联的源的类型为T1。同样,行406相应于节点3,且行406的DATA TYPE列指示和节点3相关联的源的类型为T5。
对于源表402的每行,DATA REF列储存着和在行中识别的节点相关联的源的参考信息。如此处使用的,术语“参考”通常指在数据系统中用来定位其他数据的任何数据。例如,DATA REF列能够储存指针、或更复杂的信息,诸如Oracle数据库系统支持的“ref”数据类型。本发明并不限于用于定位和层次中的节点相关联的源的任何特定类型的数据。
与分层结构分开储存源内容有很多益处,分层结构用来捕捉并反映源数据之间的层次关系。例如,由于源数据与源表402分开储存,所以可以根据源数据的属性定义其中储存有源数据的内容结构。例如,和节点1关联的源数据是雇员记录,该源数据被储存在具有用于每一雇员记录字段的列的表450中。另一方面,和节点3关联的源数据是公司记录,该源数据被储存在具有用于每一公司记录字段的列的表456中。
另外,因为分层结构(例如,表402和350)和内容结构(例如,表450和456)分开,所以可以为现有的关系数据建立分层体系,对数据容量的影响很小,并且不需要改变用于访问该数据的现有询问。例如,员工表450可以在决定将信息安排进层次200很早之前就已经存在。同样,在决定之前,可以已经为访问表450已经定义了很多询问和视图。因为能够创建表350和402而不影响表450的现有结构,可以建立用于层次200的含有储存在表450中的资源的分层结构,而不需要访问表450或用于改变表450现存查询和视图。
根据一个实施例,可以以使用用于一些资源的一种规格适用全部的方法来实现资源表402,资源表402还包括对其他资源内容的参考。例如,虽然和节点1关联的资源内容可以被储存在表450中,但是,和节点2关联的资源内容可以继续储存在表402的单个的LOB列中。资源的数据类型,如在DATA TYPE列中示出的,可以被数据库服务器用作确定是否在资源表402的LOB列或一个或多个分离的表中储存资源内容的一个因素。
先前存在的层次
表450最初就可以完全孤立于分层结构存在,诸如资源表402和链接表350。因此,分层结构最初没有捕捉关于表450中的数据可以属于的任何数据结构的任何信息。然而,储存在这样的分层结构外部的信息可以明确地或隐含地在表450的各行之间建立层次。
在表450的情况下,通过包含在EMD_ID和MANAGER列中的信息隐含地建立这样的层次。特别地,表450的EMD_ID和MANAGER列中的数据建立一隐含的“管理层次”,其中:和emp_id1关联的员工直接在和emp_id 3关联的员工之下;和emp_id 2关联的员工直接在和emp_id 1关联的员工之下;以及和emp_id 3关联的员工没有任何管理者(从而是管理层次的根节点)。
在现在的实例中,管理层次是先前存在的层次且储存在EMD_ID和MANAGER列中的数据包括外部层次定义。根据管理层次,使用分层结构访问表450中的数据,必须在分层表中捕捉关于管理层次的信息。用于捕捉关于先前存在的数据结构的信息的多种技术将在此后作详细描述。
捕捉先前存在的层次
根据一个实施例,捕捉先前存在的层次信息涉及:(1)在源表中储存一列用于先前存在的层次中的每个节点,以及(2)在分层结构(例如,分层索引)中储存捕捉先前存在的层次的节点之间的父-子关系的信息。另外,如果先前存在的层次被嫁接进已经在分层结构中反映的较大的层次中,那么,必须将元数据增加到分层结构中,以将先前存在的层次的根节点建立为较大数据结构中的节点的子。
执行以下任务的操作是相当直接的:(1)在资源表中储存用于先前存在的层次中的每个节点的行,以及(2)将用于嫁接先前存在的层次的节点的元数据增加给较大的层次。另一方面,根据外部层次定义的属性,可以改变用于捕捉先前存在的层次的节点之间的父-子关系的技术。例如,如果SQL关系定义父-子关系,那么,采用使用合适的connect-by子句的SQL命令可以捕捉父-子信息。作为选择,如果根据层次相关的字段,父-子关系是隐含的,那么,采用列举法可以捕捉父-子信息。将在下面详细描述connect-by和列举法。
先前存在的层次的自动捕捉
根据一个实施例,数据库被配置,以响应于接收关于先前存在的层次的某种信息,自动执行先前存在层次捕捉操作。具体而言,根据一个实施例,数据库被配置,以响应于接收(1)用于识别和先前存在的层次关联的内容结构的信息和(2)用于指示在特定内容结构中包含的资源之间建立父-子关系的标准的连接标准,自动地执行先前存在的层次捕捉操作。
出于说明目的,假定希望捕捉和表450关联的管理层次。在这种情况下,响应于接收(1)识别表450的数据和(2)指示表450的给定行是EMD_ID等同于在给定行中规定的MANAGER的行的子,能够执行自动捕捉操作。可以根据这一信息用来自动捕捉先前存在的层次的技术将在下面描述。
使用CONNET BY捕捉父-子关系
如前边所提到的,一些先前存在的层次的父-子关系由SQL关系示出。例如,通过包含在表450的MANAGER列中的数据建立表450中的记录的管理层次。在这种情况下,先前存在的层次的父-子关系可以通过使用采用合适的CONNECT BY子句的数据库命令来捕捉。
例如,管理层次的自动捕捉操作通过以下动作执行:(1)在资源表402中创建行,以代表对应于表450中的行的节点;以及(2)通过执行包括CONNECT BY子句的SQL语句产生关于那些节点之间的分层关系的元数据。资源表402中代表用于表450的特定行的节点的每行都具有对该特定行的参考。例如,资源表402的行404代表用于表450的行420的节点,从而包括对行420的参考。
关于生成和先前存在的层次相关联的路径信息,假设表450被命名为‘EMP’并被定义以包括下述列:(emp_id integer,first_namevarchar2(80),last_name varchar2(80),age integer,manager integer )。在这些情况下,使用CONNECT BY关系(例如,‘START WITHmanager IS NULL CONNECT BY PRIOR manager=emp_id’)生成条目树(根据数据,可变深度)。在这种情况下,用户通常也能够指定列值以用作路径元素的名称(即‘first_name’)。
使用列举法捕捉先前存在的层次
在一些情况下,可以通过相互具有层次关系的字段隐含定义先前存在的层次。例如,考虑包含一个许诺销售的产品列表的关系表。例如,这样的关系表可以如下定义:
CREATE TABLE PRODUCT_INFO
(
manufacturer VARCHAR2(128)
product_type VARCHAR2(48)
product_name VARCHAR2(80)
sku NUMBER
);
这样的表可被填充,例如,如图5中的表500所示出的。在该实例中,层次被隐含在MANUFACTURER、PRODUCT_TYPE、PRODUCT_NAME、以及SKU字段之间的分层关系中。特别地,每个SKU值是和特定的PRODUCT_NAME值关联的很多潜在的SKU值中的一个。每个PRODUCT_NAME值是和特定的PRODUCT_TYPE值关联的很多潜在的PRODUCT_NAME值中的一个。每个PRODUCT_TYPE值是和特定的MANUFACTURER值关联的很多潜在的PRODUCT_TYPE值中的一个。
在表500包含的值中隐含的“产品目录层次”由图6说明。参看图6,表500的四个分层相关字段中的每个都对应于分层等级,其中,MANUFACTURER字段是最高等级(仅在根节点之下),SKU字段是最低等级(代表“叶”节点)。
当以这种方式定义先前存在的层次时,可以使用列举法来捕捉父-子关系。特别地,包含卷入层次中的列举值的一列或多列被用来生成“资源集节点(collection node)”。每列的每个值都是在层次的某一深度的新“资源集”,每列都被用于层次的新等级。最后给出的列被当作文件,而非资源集。
特别地,通过对包含在MANUFACTURER列中的值执行DISTINCT操作,可以建立层次的第一等级中的节点。通过连接用于所有行的MANUFACTURER和PRODUCT_TYPE值,并对连接后的产生的值执行DISTINCT操作,可以建立层次的第二等级中的节点。同样,通过连接用于所有行的MANUFACTURER、PRODUCT_TYPE、以及PRODUCT_NAME值,并对连接后的产生的值执行DISTINCT操作,可以建立层次的第三等级中的节点。最后,通过连接用于所有行的MANUFACTURER、PRODUCT_TYPE、PRODUCT_NAME、以及SKU值,并对连接后的产生的值执行DISTINCT操作,可以建立层次的叶等级。
假设给定等级的节点的名称并不是唯一的,执行上述的连接操作。例如,假设PRODUCT_TYPE值PD1的产品能够具有和PRODUCT_TYPE值PD2的产品相同的名称。然而,如果PRODUCT_NAME列的名称被要求是唯一的,那么,可以通过对PRODUCT_NAME列的值简单地执行DISTINCT操作,获得在层次的PRODUCT_NAME级的节点。
应当注意,通过储存在容纳用于节点的资源的关系表行中的值代表每个叶节点的相关路径名称。例如,行502(图5)容纳用于节点602(图6)的资源和对应于相关路径/MF1/PD2/PN3/SKU3的行502的列中的值。因此,当寻找特定节点(例如MF1/FD2)的子时,用于该节点的列被隐含地用来选择子(因此,用来寻找MF1/PD2的子的SQL将是‘SELECT FROM PRODUCT_INFO WHEREmanufacture=‘MF1’and‘product_type’=‘PD2”)。
维持一致性
如上所述,在先前存在的层次已经被捕捉后,存在反映该层次的两组独立数据:外部层次定义和内部层次定义。为了维持层次的一致性反映,响应于对外部层次做出的改变,必须修改内部层次定义。
例如,一旦捕捉,和表450关联的管理层次反映在(1)储存在分层结构的数据和(2)表450的EMP_ID列中的数据和表450的MANAGER列中的数据之间的关系中。因此,对管理层次的改变可以通过以下方式完成:(1)改变表450的EMP_ID或MANAGER列中的值或(2)改变分层结构中的值。为了维持分层结构中的数据和EMP_ID或MANAGER列中的数据的一致性,需要建立机制,使得对一组数据的改变会自动引起对另一组数据的相应修改。
根据一个实施例,改变表450,以做出作为对资源表402的巡视的一部分的某些检查(例如,安全性检查),也可以做出这些检查用于遍历表450。在表450上创建数据操纵语言(Data ManipulationLanguage,DML)触发器,以便对表450进行的插入、更新、或删除操作在分层结构的数据中反映。例如,如果需要删除表450中的行,则检查确保将被删除的行不会引起任何“悬空行(danglingrows)”。例如,在管理层次中,和行420关联的节点是和行422关联的节点的父。因此,删除行420将使行422和管理层次分开,从而造成行422“悬空”。因为悬空的行不再是层次的一部分,删除行422将导致从分层结构中删除和行420及行422相关的数据。
同样,当将行插入表450时,分层结构的信息将被更新从而为创建的新路径增加一个条目。注意,当插入新行时,则可能允许访问此前不能访问的子树。例如,假设删除行420后,再次插入行420。通过插入行420,行422被隐含地嫁接回管理层次。因此,行420的插入导致分层结构中的数据被更新,以包含用于行420和行422的节点和路径。
为维持内部层次定义和外部层次定义之间的一致性,需要执行精确的操作,这些精确的操作随多种因素而变化。必须做出什么行动的影响以维持一致性的一种因素是外部层次定义的属性。例如,根据SQL关系对表450应用管理层次,而根据列举对表500应用管理层次。当删除和管理层次中的叶节点关联的行时,通常,相应于该节点的资源表中的行也将被删除。然而,如果删除和产品目录层次的叶节点关联的行,则(1)删除资源表中相应于该节点的行,以及(2)确定被删除的叶节点的父是否有任何剩余的子。如果被删除的叶节点的父没有任何剩余的子。则删除资源表中相应于该节点的行。如果删除相应于父节点的行,则确定该父节点的父是否有任何剩余的子。如果该父节点的父没有任何剩余的子,则同样删除资源表的和父节点的父相关联的行。重复这一过程,删除所有无子非叶节点。
同样,对于涉及删除表中的所有行的丢弃和截尾操作,执行类似于上述用于删除操作的用于维持一致性的操作。
在上述实例中,DML触发器根据在内容结构上执行的插入、更新、以及删除操作执行对分层结构中的数据的更改。可以实现例如“INSTEAD OF”触发器的DML触发器。然而,为了保证一致性,同样必须创建触发器以保证对层次中的数据进行的插入、更新、以及删除操作导致对内容结构中的数据进行相应的操作。
硬件概述
图7是一个描述了实现本发明的具体实施例的计算机系统700的框图。计算机系统700包括总线702或其它用于传送信息的通信装置,以及与总线702连接用于处理信息的处理器704。计算机系统700还包括一个主存储器706,例如随机存取存储器(RAM)或其它动态存储设备,与总线702连接,用于储存信息和将被处理器704执行的指令。主存储器706也可以被用来储存临时变量或在处理器704执行指令的过程中产生的中间变量。计算机系统700还包括和总线702相连的只读存储器(ROM)708或者其它静态存储设备,用于储存静态信息和用于处理器704的指令。提供了存储设备710,例如磁盘或光盘,连接至总线702,用于储存信息和指令。
计算机系统700可以通过总线702连接至显示器712(例如阴极射线管(CRT)),用于显示信息给计算机用户。一包括字母和数字以及其它键的输入装置714,连接至总线702,用于将信息和指令选择传送给处理器704。另一种类型的用户输入装置是光标控制器716,例如鼠标、轨迹球、或者光标方向键,用于传送方向信息和命令选择给处理器704,并用于控制光标在显示器712上的移动。输入装置通常具有两个轴的两个自由度,一个是第一轴(例如x),一个是第二轴(例如y),这就允许该装置在平面上确定位置。
本发明涉及计算机系统700的应用,用于实施此处所描述的技术。根据本发明的一个实施例,响应于执行包含在主存储器706中的一个或多个序列的一个或多个指令的处理器704,可以通过计算机系统700实现这些技术。这些指令可以从另一计算机可读介质(例如存储装置710)读到主存储器706中。执行包含在主存储器706中的指令序列,使处理器704执行此处描述的处理步骤。在可选实施例中,硬件连接电路可以被用来代替或与软件指令结合来实现该发明。因此,本发明的实施例不被限制在任何特定的硬件电路与软件的结合中。
在这里用到的术语“计算机可读介质”指的是参与提供指令给处理器704用于执行的任何介质。这样的介质可能有多种形式,包括但不限于:非易失性介质、易失性介质、传输介质等。非易失性介质举例来说包括光盘或磁盘,如存储设备710。易失性介质举例来说包括动态存储器,例如主存储器706。传输介质包括同轴电缆、铜线、或光纤,也包括构成总线702的布线。传输介质也可以采用声波或光波的形式,例如无线电波中产生的声波和红外数据通信中的光波。
计算机可读介质的通常形式举例来说包括:软盘、软磁盘、硬盘、磁带、或其它任何磁性介质、CD-ROM、其它任何光学介质、穿孔卡片、纸带、其它任何具有孔图案的物理介质、只读存储器(RAM)、可编程只读存储器(PROM)、以及可擦写可编程只读存储器(EPROM)、闪存(FLASH-EPROM)、任何其它记忆芯片或卡式磁带、下文所述的载波信号、或者其它任何计算机可以读取的介质。
各种形式的计算机可读介质都可以被用来将一个或多个序列的一个或多个指令传送给处理器704用于执行。例如,指令首先装载到远端计算机的磁盘上。这台远端计算机可能把这些指令加载到其动态存储器中,通过调制解调器在电话线上传送指令。计算机系统700本地的调制解调器能够通过电话线接收数据,并使用红外发射器把数据转换成红外信号。红外探测器可以接收红外信号中携带的数据,合适的电路可以把数据传到总线702上去。总线702把数据加载到主存储器706中,处理器704再从主存储器中取回数据并执行指令。主存储器706接收到的指令可以在处理器704执行前或执行后有选择地储存在存储设备710上。
计算机系统700还包括一个与总线702相连的通信接口718。通信接口718提供了一种与连接到局域网络722的网络链路720的双向数据通信。例如,通信接口718可以是综合服务数字网(ISDN)卡,或者是调制解调器,向相应类型的电话线提供数据通信连接。作为另一实例,通信接口718可以是局域网(LAN)卡,提供到兼容的局域网的数据通信连接。也可以实现无线连接。在任何实现方式中,通信接口718都能够发送和接收电信号,电磁信号、或光信号,这些信号承载着代表各种信息的数字数据流。
网络链路720一般通过一个或多个网络向其它数据设备提供数据通信。例如,网络链路720可以提供通过局域网722至主机724或由互联网服务提供商(ISP)726操作的数据装置的连接。ISP 726反过来又通过万维分组数据通信网络,现在通常称为“互联网”728,提供数据通信服务。局域网722和互联网728都使用承载数字数据流的电信号、电磁信号、或光学信号。经过各种网络的信号、网络链路720上的信号、以及经过通信接口718的信号,承载着送到和来自计算机系统700的数字数据,是传输信息的载波的示范形式。
计算机系统700可以通过网络、网络链路720、以及通信接口718发送消息和接收数据,包括程序代码。在互联网实例中,服务器730可以通过互联网728、ISP 726、局域网722、和通信接口718传送被请求的应用程序代码。
当接收到代码后,接收到的代码可以由处理器704执行,或储存在存储装置710或其他非易失性存储器中用于随后执行。以这种方式,计算机系统700可以获得载波形式的应用代码。
在上述说明书中,已经参考具体实施例说明了本发明。然而,显然可以对其做出各种变化和改变,而不背离本发明宽广的精神和范围。因此,说明书和附图仅用来说明而非限定本发明。
Claims (14)
1.一种用于管理数据库系统中的数据的方法,包括以下步骤:
在数据库服务器处接收:
(a)数据,所述数据用于将一个或多个关系表识别为用来储存与资源内容相关联的数据的表,所述资源内容属于信息层次;以及
(b)连接标准,所述连接标准用于指示什么构成信息层次中的关系;
其中,所述一个或多个关系表包括至少一个表,所述表用于储存与所述资源内容相关联的数据以及起到外部层次定义的作用的某种数据,所述外部层次定义用于在所述资源之间建立层次关系;
使用用于标识所述一个或多个关系表的所述数据及所述连接标准,通过执行以下步骤,捕捉所述层次中的层次关系:执行相对于所述一个或多个关系表的一个或多个查询,以检索所述某种数据;以及
根据所述某种数据以及所述连接标准,在从所述一个或多个关系表中分离出来的一个或多个层次结构中储存作为内部层次定义的用于捕捉所述信息层次的信息;以及
使用所述一个或多个层次结构和路径信息以访问所述资源。
2.根据权利要求1所述的方法,其中,所述储存用于捕捉所述信息层次的信息的步骤包括在资源表中储存用于所述信息层次中的每个节点的行。
3.根据权利要求1所述的方法,其中,所述储存用于捕捉所述信息层次的信息的步骤包括在一个或多个层次结构中储存表示所述资源之间的父-子关系的信息。
4.根据权利要求1所述的方法,其中
所述信息层次中的资源相应于关系表中的行;以及
用储存在所述关系表的两个或更多个列中的值表示所述资源之间的父-子关系。
5.根据权利要求4所述的方法,其中,所述执行一个或多个查询的步骤包括执行用于指定所述两个或更多个列之间的CONNECT BY关系的查询。
6.根据权利要求5所述的方法,其中:
所述两个或更多个列包括含有用于表示关系中的子的数据的第一列和含有用于表示所述关系中的父的数据的第二列;以及
所述执行查询的步骤包括执行包含如下表述形式的查询:START WITH x IS NULL CONNECT BY PRIOR x=y;
其中,x代表所述第二列,y代表所述第一列。
7.根据权利要求1所述的方法,其中:
和所述信息层次中的叶节点关联的资源相应于关系表的行;以及
将在所述信息层次中与位于给定叶节点之上的非叶节点相关联的值储存在相应于所述给定叶节点的行中。
8.根据权利要求7所述的方法,其中:
将所述和非叶节点关联的值储存在所述关系表的一个或多个列中;以及
所述储存用于捕捉所述信息层次的信息的步骤包括:在资源表中将来自相应于所述信息层次的叶节点的行的用于每个不同值的行储存到所述一个或多个列中。
9.根据权利要求1所述的方法,还包括以下步骤:建立触发器,以响应于对构成所述外部层次定义的数据做出的改变,更新构成所述内部层次定义的数据。
10.根据权利要求1所述的方法,还包括以下步骤:建立触发器,以响应于对构成所述内部层次定义的数据做出的改变,更新构成所述外部层次定义的数据。
11.根据权利要求1所述的方法,还包括自动维持所述外部层次定义和所述内部层次定义之间的一致性的步骤。
12.根据权利要求11所述的方法,其中所述自动维持一致性的步骤包括以下步骤:
检测对所述一个或多个表的操作何时删除和所述信息层次中的节点关联的资源;
响应于检测所述操作,自动执行以下步骤:
在资源表中删除相应于所述节点的行;
确定从所述信息层次中除去所述节点是否导致一个或多个其他节点悬空;以及
如果从所述信息层次中除去所述节点导致一个或多个其他节点悬空,那么,在所述资源表中删除相应于所述一个或多个其他节点的行。
13.根据权利要求11所述的方法,其中所述自动维持一致性的步骤包括以下步骤:
检测对所述一个或多个表的操作何时删除和所述信息层次中的叶节点关联的资源;
响应于检测所述操作,自动执行以下步骤:
在资源表中删除相应于所述节点的行;
确定从所述信息层次中除去所述叶节点是否使所述叶节点的父节点没有剩余的子节点;以及
如果从所述信息层次中除去所述叶节点使所述叶节点的父节点没有剩余的子节点,那么,在所述资源表中删除相应于所述父节点的行。
14.根据权利要求11所述的方法,其中所述自动维持一致性的步骤包括以下步骤:
检测对所述一个或多个表的操作何时插入与所述信息层次中的节点关联的资源;
响应于检测所述操作,自动执行以下步骤:
在资源表中插入相应于所述节点的行;
确定来自所述信息层次的所述节点的增加是否导致将所述节点的一个或多个子节点增加给所述信息层次;以及
如果来自所述信息层次的所述节点的增加导致将所述节点的一个或多个子节点增加给所述信息层次,那么在所述资源表中插入相应于所述一个或多个子节点的行。
Applications Claiming Priority (4)
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 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN1561497A CN1561497A (zh) | 2005-01-05 |
CN1299223C true CN1299223C (zh) | 2007-02-07 |
Family
ID=26985223
Family Applications (2)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CNB028191692A Expired - Lifetime CN1299223C (zh) | 2001-09-28 | 2002-09-27 | 提供关系数据的一致性层次抽象化 |
CN028223470A Expired - Lifetime CN1585945B (zh) | 2001-09-28 | 2002-09-27 | 用于将xml模式映射到对象关系数据库系统的机制 |
Family Applications After (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN028223470A Expired - Lifetime CN1585945B (zh) | 2001-09-28 | 2002-09-27 | 用于将xml模式映射到对象关系数据库系统的机制 |
Country Status (7)
Country | Link |
---|---|
US (3) | US7096224B2 (zh) |
EP (2) | EP1433089A2 (zh) |
JP (2) | JP2005505058A (zh) |
CN (2) | CN1299223C (zh) |
AU (3) | AU2002334721B2 (zh) |
CA (2) | CA2461854C (zh) |
WO (2) | WO2003030031A2 (zh) |
Families Citing this family (439)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
AUPO489297A0 (en) * | 1997-01-31 | 1997-02-27 | Aunty Abha's Electronic Publishing Pty Ltd | A system for electronic publishing |
US7293228B1 (en) * | 1997-01-31 | 2007-11-06 | Timebase Pty Limited | Maltweb multi-axis viewing interface and higher level scoping |
US6158010A (en) * | 1998-10-28 | 2000-12-05 | Crosslogix, Inc. | System and method for maintaining security in a distributed computer network |
US7062456B1 (en) | 1999-02-09 | 2006-06-13 | The Chase Manhattan Bank | System and method for back office processing of banking transactions using electronic files |
US7366708B2 (en) * | 1999-02-18 | 2008-04-29 | Oracle Corporation | Mechanism to efficiently index structured data that provides hierarchical access in a relational database system |
US7716163B2 (en) | 2000-06-06 | 2010-05-11 | Microsoft Corporation | Method and system for defining semantic categories and actions |
US7788602B2 (en) | 2000-06-06 | 2010-08-31 | Microsoft Corporation | Method and system for providing restricted actions for recognized semantic categories |
US7770102B1 (en) | 2000-06-06 | 2010-08-03 | Microsoft Corporation | Method and system for semantically labeling strings and providing actions based on semantically labeled strings |
US7712024B2 (en) | 2000-06-06 | 2010-05-04 | Microsoft Corporation | Application program interfaces for semantically labeling strings and providing actions based on semantically labeled strings |
US8972717B2 (en) * | 2000-06-15 | 2015-03-03 | Zixcorp Systems, Inc. | Automatic delivery selection for electronic content |
US6961900B1 (en) * | 2000-08-28 | 2005-11-01 | Microsoft Corporation | Rendering data according to a present schema from an origin response message |
US7873649B2 (en) | 2000-09-07 | 2011-01-18 | Oracle International Corporation | Method and mechanism for identifying transaction on a row of data |
US7031962B2 (en) * | 2001-03-27 | 2006-04-18 | Bea Systems, Inc. | System and method for managing objects and resources with access rights embedded in nodes within a hierarchical tree structure |
US20030217333A1 (en) * | 2001-04-16 | 2003-11-20 | Greg Smith | System and method for rules-based web scenarios and campaigns |
US7778816B2 (en) | 2001-04-24 | 2010-08-17 | Microsoft Corporation | Method and system for applying input mode bias |
US7146399B2 (en) * | 2001-05-25 | 2006-12-05 | 2006 Trident Company | Run-time architecture for enterprise integration with transformation generation |
US8412746B2 (en) | 2001-05-25 | 2013-04-02 | International Business Machines Corporation | Method and system for federated querying of data sources |
US20030101170A1 (en) * | 2001-05-25 | 2003-05-29 | Joseph Edelstein | Data query and location through a central ontology model |
US20060064666A1 (en) * | 2001-05-25 | 2006-03-23 | Amaru Ruth M | Business rules for configurable metamodels and enterprise impact analysis |
US7099885B2 (en) * | 2001-05-25 | 2006-08-29 | Unicorn Solutions | Method and system for collaborative ontology modeling |
US7877421B2 (en) * | 2001-05-25 | 2011-01-25 | International Business Machines Corporation | Method and system for mapping enterprise data assets to a semantic information model |
US7895173B1 (en) * | 2001-06-27 | 2011-02-22 | Microsoft Corporation | System and method facilitating unified framework for structured/unstructured data |
US20030041305A1 (en) * | 2001-07-18 | 2003-02-27 | Christoph Schnelle | Resilient data links |
US7363310B2 (en) | 2001-09-04 | 2008-04-22 | Timebase Pty Limited | Mapping of data from XML to SQL |
US7047250B1 (en) | 2001-09-28 | 2006-05-16 | Oracle International Corporation | Indexing to efficiently manage versioned data in a database system |
US7028037B1 (en) | 2001-09-28 | 2006-04-11 | Oracle International Corporation | Operators for accessing hierarchical data in a relational system |
US7092967B1 (en) | 2001-09-28 | 2006-08-15 | Oracle International Corporation | Loadable units for lazy manifestation of XML documents |
US7051039B1 (en) | 2001-09-28 | 2006-05-23 | Oracle International Corporation | Mechanism for uniform access control in a database system |
US7047253B1 (en) | 2001-09-28 | 2006-05-16 | Oracle Interntional Corporation | Mechanisms for storing content and properties of hierarchically organized resources |
AU2002334721B2 (en) | 2001-09-28 | 2008-10-23 | Oracle International Corporation | An index structure to access hierarchical data in a relational database system |
EP1298539A1 (en) * | 2001-10-01 | 2003-04-02 | Sun Microsystems, Inc. | Method and device for marking and filtering data elements in a database |
US7472342B2 (en) * | 2001-10-24 | 2008-12-30 | Bea Systems, Inc. | System and method for portal page layout |
US7281206B2 (en) * | 2001-11-16 | 2007-10-09 | Timebase Pty Limited | Maintenance of a markup language document in a database |
US7107522B1 (en) | 2001-12-21 | 2006-09-12 | Bellsouth Intellectual Property Corp. | System and method for creating extensible content |
US7343585B1 (en) * | 2002-01-30 | 2008-03-11 | Oracle International Corporation | Operator approach for generic dataflow designs |
JP4039484B2 (ja) * | 2002-02-28 | 2008-01-30 | インターナショナル・ビジネス・マシーンズ・コーポレーション | XPath評価方法、これを用いたXML文書処理システム及びプログラム |
JP3624186B2 (ja) * | 2002-03-15 | 2005-03-02 | Tdk株式会社 | スイッチング電源装置用の制御回路及びこれを用いたスイッチング電源装置 |
US6965903B1 (en) | 2002-05-07 | 2005-11-15 | Oracle International Corporation | Techniques for managing hierarchical data with link attributes in a relational database |
US7707496B1 (en) | 2002-05-09 | 2010-04-27 | Microsoft Corporation | Method, system, and apparatus for converting dates between calendars and languages based upon semantically labeled strings |
US7548935B2 (en) * | 2002-05-09 | 2009-06-16 | Robert Pecherer | Method of recursive objects for representing hierarchies in relational database systems |
US7707024B2 (en) | 2002-05-23 | 2010-04-27 | Microsoft Corporation | Method, system, and apparatus for converting currency values based upon semantically labeled strings |
US7742048B1 (en) | 2002-05-23 | 2010-06-22 | Microsoft Corporation | Method, system, and apparatus for converting numbers based upon semantically labeled strings |
US7987246B2 (en) | 2002-05-23 | 2011-07-26 | Jpmorgan Chase Bank | Method and system for client browser update |
US6920460B1 (en) * | 2002-05-29 | 2005-07-19 | Oracle International Corporation | Systems and methods for managing partitioned indexes that are created and maintained by user-defined indexing schemes |
US8200622B2 (en) * | 2002-05-31 | 2012-06-12 | Informatica Corporation | System and method for integrating, managing and coordinating customer activities |
US7827546B1 (en) | 2002-06-05 | 2010-11-02 | Microsoft Corporation | Mechanism for downloading software components from a remote source for use by a local software application |
US7356537B2 (en) * | 2002-06-06 | 2008-04-08 | Microsoft Corporation | Providing contextually sensitive tools and help content in computer-generated documents |
US7716676B2 (en) * | 2002-06-25 | 2010-05-11 | Microsoft Corporation | System and method for issuing a message to a program |
US20040001099A1 (en) * | 2002-06-27 | 2004-01-01 | Microsoft Corporation | Method and system for associating actions with semantic labels in electronic documents |
US7209915B1 (en) | 2002-06-28 | 2007-04-24 | Microsoft Corporation | Method, system and apparatus for routing a query to one or more providers |
US7120645B2 (en) * | 2002-09-27 | 2006-10-10 | Oracle International Corporation | Techniques for rewriting XML queries directed to relational database constructs |
US7051041B1 (en) * | 2002-10-21 | 2006-05-23 | Hewlett-Packard Development Company, L.P. | Simplified relational database extension to DBM hash tables and method for using same |
DE10250641A1 (de) * | 2002-10-30 | 2004-05-13 | Siemens Ag | Auf- und abwärtskompatible Schemaevolution |
US7308474B2 (en) | 2002-11-06 | 2007-12-11 | Oracle International Corporation | Techniques for scalably accessing data in an arbitrarily large document by a device with limited resources |
US6947950B2 (en) | 2002-11-06 | 2005-09-20 | Oracle International Corporation | Techniques for managing multiple hierarchies of data from a single interface |
US7020653B2 (en) | 2002-11-06 | 2006-03-28 | Oracle International Corporation | Techniques for supporting application-specific access controls with a separate server |
US20040103199A1 (en) * | 2002-11-22 | 2004-05-27 | Anthony Chao | Method and system for client browser update from a lite cache |
US7451158B1 (en) * | 2002-11-27 | 2008-11-11 | Microsoft Corporation | System and method for creating, appending and merging a work management file |
US20040148272A1 (en) * | 2003-01-29 | 2004-07-29 | Raman Balan Sethu | Logical pathname as a reference mechanism for data |
US7783614B2 (en) * | 2003-02-13 | 2010-08-24 | Microsoft Corporation | Linking elements of a document to corresponding fields, queries and/or procedures in a database |
US7653930B2 (en) * | 2003-02-14 | 2010-01-26 | Bea Systems, Inc. | Method for role and resource policy management optimization |
US7591000B2 (en) | 2003-02-14 | 2009-09-15 | Oracle International Corporation | System and method for hierarchical role-based entitlements |
US8831966B2 (en) | 2003-02-14 | 2014-09-09 | Oracle International Corporation | Method for delegated administration |
US7840614B2 (en) | 2003-02-20 | 2010-11-23 | Bea Systems, Inc. | Virtual content repository application program interface |
US7415478B2 (en) * | 2003-02-20 | 2008-08-19 | Bea Systems, Inc. | Virtual repository complex content model |
US7483904B2 (en) * | 2003-02-20 | 2009-01-27 | Bea Systems, Inc. | Virtual repository content model |
US7293286B2 (en) | 2003-02-20 | 2007-11-06 | Bea Systems, Inc. | Federated management of content repositories |
US20040230917A1 (en) * | 2003-02-28 | 2004-11-18 | Bales Christopher E. | Systems and methods for navigating a graphical hierarchy |
US7810036B2 (en) | 2003-02-28 | 2010-10-05 | Bea Systems, Inc. | Systems and methods for personalizing a portal |
US20040230557A1 (en) * | 2003-02-28 | 2004-11-18 | Bales Christopher E. | Systems and methods for context-sensitive editing |
US7711550B1 (en) | 2003-04-29 | 2010-05-04 | Microsoft Corporation | Methods and system for recognizing names in a computer-generated document and for providing helpful actions associated with recognized names |
US6836778B2 (en) | 2003-05-01 | 2004-12-28 | Oracle International Corporation | Techniques for changing XML content in a relational database |
US7103611B2 (en) * | 2003-05-01 | 2006-09-05 | Oracle International Corporation | Techniques for retaining hierarchical information in mapping between XML documents and relational data |
US7051042B2 (en) * | 2003-05-01 | 2006-05-23 | Oracle International Corporation | Techniques for transferring a serialized image of XML data |
US7386568B2 (en) * | 2003-05-01 | 2008-06-10 | Oracle International Corporation | Techniques for partial rewrite of XPath queries in a relational database |
US20040230602A1 (en) * | 2003-05-14 | 2004-11-18 | Andrew Doddington | System and method for decoupling data presentation layer and data gathering and storage layer in a distributed data processing system |
CA2638965A1 (en) * | 2003-05-15 | 2004-11-15 | Ibm Canada Limited - Ibm Canada Limitee | Accessing a platform independent input method editor from an underlying operating system |
US7366722B2 (en) * | 2003-05-15 | 2008-04-29 | Jp Morgan Chase Bank | System and method for specifying application services and distributing them across multiple processors using XML |
US7331014B2 (en) * | 2003-05-16 | 2008-02-12 | Microsoft Corporation | Declarative mechanism for defining a hierarchy of objects |
US7739588B2 (en) | 2003-06-27 | 2010-06-15 | Microsoft Corporation | Leveraging markup language data for semantically labeling text strings and data and for providing actions based on semantically labeled text strings and data |
US20050010896A1 (en) * | 2003-07-07 | 2005-01-13 | International Business Machines Corporation | Universal format transformation between relational database management systems and extensible markup language using XML relational transformation |
US7519952B2 (en) * | 2003-07-28 | 2009-04-14 | International Business Machines Corporation | Detecting an integrity constraint violation in a database by analyzing database schema, application and mapping and inserting a check into the database and application |
US7069278B2 (en) | 2003-08-08 | 2006-06-27 | Jpmorgan Chase Bank, N.A. | System for archive integrity management and related methods |
US8150818B2 (en) | 2003-08-25 | 2012-04-03 | International Business Machines Corporation | Method and system for storing structured documents in their native format in a database |
US8219569B2 (en) * | 2003-08-25 | 2012-07-10 | Oracle International Corporation | In-place evolution of XML schemes |
US7747580B2 (en) | 2003-08-25 | 2010-06-29 | Oracle International Corporation | Direct loading of opaque types |
US7792866B2 (en) | 2003-08-25 | 2010-09-07 | International Business Machines Corporation | Method and system for querying structured documents stored in their native format in a database |
US7395271B2 (en) * | 2003-08-25 | 2008-07-01 | Oracle International Corporation | Mechanism to enable evolving XML schema |
US7490093B2 (en) | 2003-08-25 | 2009-02-10 | Oracle International Corporation | Generating a schema-specific load structure to load data into a relational database based on determining whether the schema-specific load structure already exists |
US8250093B2 (en) | 2003-08-25 | 2012-08-21 | International Business Machines Corporation | Method and system for utilizing a cache for path-level access control to structured documents stored in a database |
US7519574B2 (en) | 2003-08-25 | 2009-04-14 | International Business Machines Corporation | Associating information related to components in structured documents stored in their native format in a database |
US7814047B2 (en) | 2003-08-25 | 2010-10-12 | Oracle International Corporation | Direct loading of semistructured data |
US8775468B2 (en) | 2003-08-29 | 2014-07-08 | International Business Machines Corporation | Method and system for providing path-level access control for structured documents stored in a database |
US8694510B2 (en) | 2003-09-04 | 2014-04-08 | Oracle International Corporation | Indexing XML documents efficiently |
US8229932B2 (en) | 2003-09-04 | 2012-07-24 | Oracle International Corporation | Storing XML documents efficiently in an RDBMS |
US20050060345A1 (en) * | 2003-09-11 | 2005-03-17 | Andrew Doddington | Methods and systems for using XML schemas to identify and categorize documents |
US20050065964A1 (en) * | 2003-09-19 | 2005-03-24 | Ziemann David M. | Update of a tree-based database |
US20050091191A1 (en) * | 2003-09-24 | 2005-04-28 | Greg Miller | System and method for managing and utilizing information |
US7543268B2 (en) * | 2003-09-30 | 2009-06-02 | Sap Ag | Development environment for developing applications using a metamodel and a metadata API |
US20050071805A1 (en) * | 2003-09-30 | 2005-03-31 | Johannes Lauterbach | Developing applications using a metamodel |
US8255888B2 (en) * | 2003-09-30 | 2012-08-28 | Sap Ag | API derivation and XML schema derivation for developing applications |
US7877390B2 (en) * | 2003-10-20 | 2011-01-25 | International Business Machines Corporation | Systems and methods for providing autonomous persistent storage systems |
US20050091231A1 (en) * | 2003-10-24 | 2005-04-28 | Shankar Pal | System and method for storing and retrieving XML data encapsulated as an object in a database store |
US7634498B2 (en) * | 2003-10-24 | 2009-12-15 | Microsoft Corporation | Indexing XML datatype content system and method |
US9690811B1 (en) | 2003-11-05 | 2017-06-27 | Hewlett Packard Enterprise Development Lp | Single repository manifestation of a multi-repository system |
US7877400B1 (en) * | 2003-11-18 | 2011-01-25 | Adobe Systems Incorporated | Optimizations of XPaths |
US7882146B2 (en) * | 2003-12-01 | 2011-02-01 | Microsoft Corporation | XML schema collection objects and corresponding systems and methods |
US7313756B2 (en) * | 2003-12-15 | 2007-12-25 | Microsoft Corporation | Schema editor extensions |
US8949220B2 (en) * | 2003-12-19 | 2015-02-03 | Oracle International Corporation | Techniques for managing XML data associated with multiple execution units |
US7219102B2 (en) * | 2003-12-22 | 2007-05-15 | International Business Machines Corporation | Method, computer program product, and system converting relational data into hierarchical data structure based upon tagging trees |
US7689542B2 (en) * | 2004-01-13 | 2010-03-30 | Oracle International Corporation | Dynamic return type generation in a database system |
US7418456B2 (en) * | 2004-01-16 | 2008-08-26 | International Business Machines Corporation | Method for defining a metadata schema to facilitate passing data between an extensible markup language document and a hierarchical database |
JP4227033B2 (ja) * | 2004-01-20 | 2009-02-18 | 富士通株式会社 | データベース統合参照装置、データベース統合参照方法およびデータベース統合参照プログラム |
US7433940B2 (en) * | 2004-01-21 | 2008-10-07 | International Business Machines Corporation | Schema management |
US7346617B2 (en) * | 2004-01-23 | 2008-03-18 | Oracle International Corporation | Multi-table access control |
US20050172217A1 (en) * | 2004-02-04 | 2005-08-04 | Yiu-Ming Leung | System and method for schemaless data mapping with nested tables |
US8037102B2 (en) | 2004-02-09 | 2011-10-11 | Robert T. and Virginia T. Jenkins | Manipulating sets of hierarchical data |
CN1560763B (zh) * | 2004-02-19 | 2010-05-05 | 北京大学 | 一种可扩展标记语言路径查询翻译为结构查询的方法 |
US8311974B2 (en) * | 2004-02-20 | 2012-11-13 | Oracle International Corporation | Modularized extraction, transformation, and loading for a database |
US20050188295A1 (en) * | 2004-02-25 | 2005-08-25 | Loren Konkus | Systems and methods for an extensible administration tool |
US20050203931A1 (en) * | 2004-03-13 | 2005-09-15 | Robert Pingree | Metadata management convergence platforms, systems and methods |
US7873685B2 (en) * | 2004-05-13 | 2011-01-18 | Pixar | System and method for flexible path handling |
US7774601B2 (en) | 2004-04-06 | 2010-08-10 | Bea Systems, Inc. | Method for delegated administration |
US7761461B2 (en) * | 2004-04-08 | 2010-07-20 | International Business Machines Corporation | Method and system for relationship building from XML |
US20050234844A1 (en) * | 2004-04-08 | 2005-10-20 | Microsoft Corporation | Method and system for parsing XML data |
US7440954B2 (en) | 2004-04-09 | 2008-10-21 | Oracle International Corporation | Index maintenance for operations involving indexed XML data |
US7499915B2 (en) * | 2004-04-09 | 2009-03-03 | Oracle International Corporation | Index for accessing XML data |
US7493305B2 (en) * | 2004-04-09 | 2009-02-17 | Oracle International Corporation | Efficient queribility and manageability of an XML index with path subsetting |
US7398265B2 (en) * | 2004-04-09 | 2008-07-08 | Oracle International Corporation | Efficient query processing of XML data using XML index |
US7366735B2 (en) | 2004-04-09 | 2008-04-29 | Oracle International Corporation | Efficient extraction of XML content stored in a LOB |
WO2005101246A1 (en) * | 2004-04-09 | 2005-10-27 | Oracle International Corporation | Index for accessing xml data |
US7603347B2 (en) * | 2004-04-09 | 2009-10-13 | Oracle International Corporation | Mechanism for efficiently evaluating operator trees |
US20060028252A1 (en) * | 2004-04-13 | 2006-02-09 | Bea Systems, Inc. | System and method for content type management |
US20050228816A1 (en) * | 2004-04-13 | 2005-10-13 | Bea Systems, Inc. | System and method for content type versions |
US7236990B2 (en) | 2004-04-13 | 2007-06-26 | Bea Systems, Inc. | System and method for information lifecycle workflow integration |
US7236989B2 (en) | 2004-04-13 | 2007-06-26 | Bea Systems, Inc. | System and method for providing lifecycles for custom content in a virtual content repository |
US7246138B2 (en) | 2004-04-13 | 2007-07-17 | Bea Systems, Inc. | System and method for content lifecycles in a virtual content repository that integrates a plurality of content repositories |
US7236975B2 (en) * | 2004-04-13 | 2007-06-26 | Bea Systems, Inc. | System and method for controlling access to anode in a virtual content repository that integrates a plurality of content repositories |
US20050251512A1 (en) * | 2004-04-13 | 2005-11-10 | Bea Systems, Inc. | System and method for searching a virtual content repository |
US7930277B2 (en) | 2004-04-21 | 2011-04-19 | Oracle International Corporation | Cost-based optimizer for an XML data repository within a database |
US7653651B1 (en) | 2004-04-29 | 2010-01-26 | Sap Ag | System and method for transparent persistence management |
US7590639B1 (en) | 2004-04-29 | 2009-09-15 | Sap Ag | System and method for ordering a database flush sequence at transaction commit |
US7469256B1 (en) | 2004-04-29 | 2008-12-23 | Sap Ag | Cached persistent data management through state tracking |
US9646107B2 (en) | 2004-05-28 | 2017-05-09 | Robert T. and Virginia T. Jenkins as Trustee of the Jenkins Family Trust | Method and/or system for simplifying tree expressions such as for query reduction |
JP4866844B2 (ja) * | 2004-06-16 | 2012-02-01 | オラクル・インターナショナル・コーポレイション | Lobに格納されたxml内容の効率的な抽出 |
WO2006009768A1 (en) | 2004-06-23 | 2006-01-26 | Oracle International Corporation | Efficient evaluation of queries using translation |
US7516121B2 (en) | 2004-06-23 | 2009-04-07 | Oracle International Corporation | Efficient evaluation of queries using translation |
US7308453B2 (en) * | 2004-06-29 | 2007-12-11 | Nokia Corporation | Meta-data approach to indexing, retrieval and management of stored messages in a portable communication device |
US7620632B2 (en) * | 2004-06-30 | 2009-11-17 | Skyler Technology, Inc. | Method and/or system for performing tree matching |
US7882147B2 (en) * | 2004-06-30 | 2011-02-01 | Robert T. and Virginia T. Jenkins | File location naming hierarchy |
US8566300B2 (en) | 2004-07-02 | 2013-10-22 | Oracle International Corporation | Mechanism for efficient maintenance of XML index structures in a database system |
US7885980B2 (en) | 2004-07-02 | 2011-02-08 | Oracle International Corporation | Mechanism for improving performance on XML over XML data using path subsetting |
US20070208946A1 (en) * | 2004-07-06 | 2007-09-06 | Oracle International Corporation | High performance secure caching in the mid-tier |
US7668806B2 (en) | 2004-08-05 | 2010-02-23 | Oracle International Corporation | Processing queries against one or more markup language sources |
US7685137B2 (en) | 2004-08-06 | 2010-03-23 | Oracle International Corporation | Technique of using XMLType tree as the type infrastructure for XML |
US7366974B2 (en) * | 2004-09-03 | 2008-04-29 | Jp Morgan Chase Bank | System and method for managing template attributes |
US20060075074A1 (en) * | 2004-09-07 | 2006-04-06 | Microsoft Corporation | Adaptor migration tool |
US20060059210A1 (en) * | 2004-09-16 | 2006-03-16 | Macdonald Glynne | Generic database structure and related systems and methods for storing data independent of data type |
US7493313B2 (en) * | 2004-09-17 | 2009-02-17 | Microsoft Corporation | Durable storage of .NET data types and instances |
US7657894B2 (en) * | 2004-09-29 | 2010-02-02 | Intel Corporation | Detecting lock acquisition hierarchy violations in multithreaded programs |
US20060072626A1 (en) * | 2004-09-29 | 2006-04-06 | Lucent Technologies Inc. | Data synchronization in a telecommunication management network |
US20090132466A1 (en) * | 2004-10-13 | 2009-05-21 | Jp Morgan Chase Bank | System and method for archiving data |
US20060085451A1 (en) * | 2004-10-15 | 2006-04-20 | Microsoft Corporation | Mapping of schema data into data structures |
US7801923B2 (en) | 2004-10-29 | 2010-09-21 | Robert T. and Virginia T. Jenkins as Trustees of the Jenkins Family Trust | Method and/or system for tagging trees |
US7627591B2 (en) | 2004-10-29 | 2009-12-01 | Skyler Technology, Inc. | Method and/or system for manipulating tree expressions |
US7730114B2 (en) * | 2004-11-12 | 2010-06-01 | Microsoft Corporation | Computer file system |
US7627547B2 (en) * | 2004-11-29 | 2009-12-01 | Oracle International Corporation | Processing path-based database operations |
US7882149B2 (en) * | 2004-11-30 | 2011-02-01 | Canon Kabushiki Kaisha | System and method for future-proofing devices using metaschema |
US7630995B2 (en) | 2004-11-30 | 2009-12-08 | Skyler Technology, Inc. | Method and/or system for transmitting and/or receiving data |
US7636727B2 (en) | 2004-12-06 | 2009-12-22 | Skyler Technology, Inc. | Enumeration of trees from finite number of nodes |
US7849106B1 (en) | 2004-12-03 | 2010-12-07 | Oracle International Corporation | Efficient mechanism to support user defined resource metadata in a database repository |
US20060123020A1 (en) * | 2004-12-07 | 2006-06-08 | Microsoft Corporation | Computer file system allowing ambiguous names |
US7392259B2 (en) * | 2004-12-14 | 2008-06-24 | Electronics And Telecommunications Research Institute | Method and system for supporting XQuery trigger in XML-DBMS based on relational DBMS |
US8131766B2 (en) * | 2004-12-15 | 2012-03-06 | Oracle International Corporation | Comprehensive framework to integrate business logic into a repository |
US7509359B1 (en) * | 2004-12-15 | 2009-03-24 | Unisys Corporation | Memory bypass in accessing large data objects in a relational database management system |
US7921076B2 (en) | 2004-12-15 | 2011-04-05 | Oracle International Corporation | Performing an action in response to a file system event |
US20060136483A1 (en) * | 2004-12-22 | 2006-06-22 | International Business Machines Corporation | System and method of decomposition of multiple items into the same table-column pair |
US7620641B2 (en) * | 2004-12-22 | 2009-11-17 | International Business Machines Corporation | System and method for context-sensitive decomposition of XML documents based on schemas with reusable element/attribute declarations |
US8316059B1 (en) | 2004-12-30 | 2012-11-20 | Robert T. and Virginia T. Jenkins | Enumeration of rooted partial subtrees |
US7559020B2 (en) * | 2004-12-30 | 2009-07-07 | Microsoft Corporation | Methods and systems for preserving unknown markup in a strongly typed environment |
US8615530B1 (en) | 2005-01-31 | 2013-12-24 | Robert T. and Virginia T. Jenkins as Trustees for the Jenkins Family Trust | Method and/or system for tree transformation |
US7523131B2 (en) | 2005-02-10 | 2009-04-21 | Oracle International Corporation | Techniques for efficiently storing and querying in a relational database, XML documents conforming to schemas that contain cyclic constructs |
US7444345B2 (en) * | 2005-02-15 | 2008-10-28 | International Business Machines Corporation | Hierarchical inherited XML DOM |
US7681177B2 (en) | 2005-02-28 | 2010-03-16 | Skyler Technology, Inc. | Method and/or system for transforming between trees and strings |
US7478102B2 (en) * | 2005-03-28 | 2009-01-13 | Microsoft Corporation | Mapping of a file system model to a database object |
US8356040B2 (en) * | 2005-03-31 | 2013-01-15 | Robert T. and Virginia T. Jenkins | Method and/or system for transforming between trees and arrays |
US7305414B2 (en) | 2005-04-05 | 2007-12-04 | Oracle International Corporation | Techniques for efficient integration of text searching with queries over XML data |
WO2006108069A2 (en) * | 2005-04-06 | 2006-10-12 | Google, Inc. | Searching through content which is accessible through web-based forms |
US8458201B2 (en) * | 2005-04-08 | 2013-06-04 | International Business Machines Corporation | Method and apparatus for mapping structured query language schema to application specific business objects in an integrated application environment |
US8145653B2 (en) * | 2005-04-08 | 2012-03-27 | International Business Machines Corporation | Using schemas to generate application specific business objects for use in an integration broker |
US20060230048A1 (en) * | 2005-04-08 | 2006-10-12 | International Business Machines Corporation | Method and apparatus for object discovery agent based mapping of application specific markup language schemas to application specific business objects in an integrated application environment |
US7685150B2 (en) * | 2005-04-19 | 2010-03-23 | Oracle International Corporation | Optimization of queries over XML views that are based on union all operators |
US20060235839A1 (en) * | 2005-04-19 | 2006-10-19 | Muralidhar Krishnaprasad | Using XML as a common parser architecture to separate parser from compiler |
US7949941B2 (en) | 2005-04-22 | 2011-05-24 | Oracle International Corporation | Optimizing XSLT based on input XML document structure description and translating XSLT into equivalent XQuery expressions |
US7899821B1 (en) | 2005-04-29 | 2011-03-01 | Karl Schiffmann | Manipulation and/or analysis of hierarchical data |
US7454435B2 (en) * | 2005-05-03 | 2008-11-18 | Microsoft Corporation | Systems and methods for granular changes within a data storage system |
US7496588B2 (en) | 2005-06-27 | 2009-02-24 | Siperian, Inc. | Method and apparatus for data integration and management |
US8166059B2 (en) * | 2005-07-08 | 2012-04-24 | Oracle International Corporation | Optimization of queries on a repository based on constraints on how the data is stored in the repository |
US7930680B2 (en) * | 2005-07-08 | 2011-04-19 | Microsoft Corporation | XML schema design for environment-specific types based on base types |
US20070016605A1 (en) * | 2005-07-18 | 2007-01-18 | Ravi Murthy | Mechanism for computing structural summaries of XML document collections in a database system |
US8762410B2 (en) | 2005-07-18 | 2014-06-24 | Oracle International Corporation | Document level indexes for efficient processing in multiple tiers of a computer system |
US7406478B2 (en) * | 2005-08-11 | 2008-07-29 | Oracle International Corporation | Flexible handling of datetime XML datatype in a database system |
US7814065B2 (en) * | 2005-08-16 | 2010-10-12 | Oracle International Corporation | Affinity-based recovery/failover in a cluster environment |
US8065606B1 (en) | 2005-09-16 | 2011-11-22 | Jpmorgan Chase Bank, N.A. | System and method for automating document generation |
US20070067343A1 (en) * | 2005-09-21 | 2007-03-22 | International Business Machines Corporation | Determining the structure of relations and content of tuples from XML schema components |
US7953734B2 (en) | 2005-09-26 | 2011-05-31 | Oracle International Corporation | System and method for providing SPI extensions for content management system |
US7752205B2 (en) | 2005-09-26 | 2010-07-06 | Bea Systems, Inc. | Method and system for interacting with a virtual content repository |
US7992085B2 (en) | 2005-09-26 | 2011-08-02 | Microsoft Corporation | Lightweight reference user interface |
US7818344B2 (en) | 2005-09-26 | 2010-10-19 | Bea Systems, Inc. | System and method for providing nested types for content management |
US7917537B2 (en) | 2005-09-26 | 2011-03-29 | Oracle International Corporation | System and method for providing link property types for content management |
US20070073638A1 (en) * | 2005-09-26 | 2007-03-29 | Bea Systems, Inc. | System and method for using soft links to managed content |
US7788590B2 (en) | 2005-09-26 | 2010-08-31 | Microsoft Corporation | Lightweight reference user interface |
US7877379B2 (en) * | 2005-09-30 | 2011-01-25 | Oracle International Corporation | Delaying evaluation of expensive expressions in a query |
CN100407199C (zh) * | 2005-09-30 | 2008-07-30 | 南京大学 | 基于关系数据库信息技术产品保护轮廓的一致性检查方法 |
US8024368B2 (en) * | 2005-10-07 | 2011-09-20 | Oracle International Corporation | Generating XML instances from flat files |
US9367642B2 (en) | 2005-10-07 | 2016-06-14 | Oracle International Corporation | Flexible storage of XML collections within an object-relational database |
US8554789B2 (en) * | 2005-10-07 | 2013-10-08 | Oracle International Corporation | Managing cyclic constructs of XML schema in a rdbms |
US8073841B2 (en) | 2005-10-07 | 2011-12-06 | Oracle International Corporation | Optimizing correlated XML extracts |
US8356053B2 (en) | 2005-10-20 | 2013-01-15 | Oracle International Corporation | Managing relationships between resources stored within a repository |
US8949455B2 (en) | 2005-11-21 | 2015-02-03 | Oracle International Corporation | Path-caching mechanism to improve performance of path-related operations in a repository |
US20070118503A1 (en) * | 2005-11-22 | 2007-05-24 | Connelly Stephen P | Methods and systems for providing data to a database |
JP4328762B2 (ja) * | 2005-12-06 | 2009-09-09 | キヤノン株式会社 | 情報処理装置、情報処理方法、プログラム及び記憶媒体 |
US7774300B2 (en) * | 2005-12-09 | 2010-08-10 | International Business Machines Corporation | System and method for data model and content migration in content management applications |
US7933928B2 (en) * | 2005-12-22 | 2011-04-26 | Oracle International Corporation | Method and mechanism for loading XML documents into memory |
US20070214179A1 (en) * | 2006-03-10 | 2007-09-13 | Khanh Hoang | Searching, filtering, creating, displaying, and managing entity relationships across multiple data hierarchies through a user interface |
US8150803B2 (en) | 2006-01-03 | 2012-04-03 | Informatica Corporation | Relationship data management |
US7523121B2 (en) | 2006-01-03 | 2009-04-21 | Siperian, Inc. | Relationship data management |
US7730032B2 (en) | 2006-01-12 | 2010-06-01 | Oracle International Corporation | Efficient queriability of version histories in a repository |
US7849091B1 (en) * | 2006-01-25 | 2010-12-07 | At&T Intellectual Property Ii, L.P. | Meta-data indexing for XPath location steps |
US7519606B2 (en) * | 2006-01-31 | 2009-04-14 | International Business Machines Corporation | Schema mapping specification framework |
US8010909B1 (en) * | 2006-02-06 | 2011-08-30 | Microsoft Corporation | Derived hierarchy methods and system for definition, visualization and editing of data |
US7617198B2 (en) * | 2006-02-09 | 2009-11-10 | Sap Ag | Generation of XML search profiles |
US7529758B2 (en) * | 2006-02-10 | 2009-05-05 | International Business Machines Corporation | Method for pre-processing mapping information for efficient decomposition of XML documents |
US9229967B2 (en) | 2006-02-22 | 2016-01-05 | Oracle International Corporation | Efficient processing of path related operations on data organized hierarchically in an RDBMS |
US9495356B2 (en) * | 2006-03-30 | 2016-11-15 | International Business Machines Corporation | Automated interactive visual mapping utility and method for validation and storage of XML data |
US20070239762A1 (en) * | 2006-03-30 | 2007-10-11 | International Business Machines Corporation | Automated interactive visual mapping utility and method for transformation and storage of XML data |
US8880506B2 (en) * | 2009-10-16 | 2014-11-04 | Oracle International Corporation | Leveraging structured XML index data for evaluating database queries |
US20070250527A1 (en) * | 2006-04-19 | 2007-10-25 | Ravi Murthy | Mechanism for abridged indexes over XML document collections |
US7711755B2 (en) * | 2006-05-17 | 2010-05-04 | Topcoder, Inc. | Dynamic XSD enumeration |
US8510292B2 (en) * | 2006-05-25 | 2013-08-13 | Oracle International Coporation | Isolation for applications working on shared XML data |
US10318752B2 (en) * | 2006-05-26 | 2019-06-11 | Oracle International Corporation | Techniques for efficient access control in a database system |
US7730080B2 (en) * | 2006-06-23 | 2010-06-01 | Oracle International Corporation | Techniques of rewriting descendant and wildcard XPath using one or more of SQL OR, UNION ALL, and XMLConcat() construct |
US7499909B2 (en) * | 2006-07-03 | 2009-03-03 | Oracle International Corporation | Techniques of using a relational caching framework for efficiently handling XML queries in the mid-tier data caching |
US7801856B2 (en) * | 2006-08-09 | 2010-09-21 | Oracle International Corporation | Using XML for flexible replication of complex types |
US7856415B2 (en) * | 2006-09-01 | 2010-12-21 | Dell Products L.P. | System and method for mapping events into a data structure |
CN101512523A (zh) | 2006-09-12 | 2009-08-19 | 国际商业机器公司 | 把内容动态上下文相关地集成到门户网站应用程序中的系统和方法 |
US8346725B2 (en) * | 2006-09-15 | 2013-01-01 | Oracle International Corporation | Evolution of XML schemas involving partial data copy |
US7870163B2 (en) * | 2006-09-28 | 2011-01-11 | Oracle International Corporation | Implementation of backward compatible XML schema evolution in a relational database system |
US8484326B2 (en) * | 2006-09-28 | 2013-07-09 | Rockstar Bidco Lp | Application server billing |
US8463852B2 (en) | 2006-10-06 | 2013-06-11 | Oracle International Corporation | Groupware portlets for integrating a portal with groupware systems |
US7933935B2 (en) * | 2006-10-16 | 2011-04-26 | Oracle International Corporation | Efficient partitioning technique while managing large XML documents |
US9183321B2 (en) * | 2006-10-16 | 2015-11-10 | Oracle International Corporation | Managing compound XML documents in a repository |
US20080092037A1 (en) * | 2006-10-16 | 2008-04-17 | Oracle International Corporation | Validation of XML content in a streaming fashion |
US7827177B2 (en) * | 2006-10-16 | 2010-11-02 | Oracle International Corporation | Managing compound XML documents in a repository |
US7797310B2 (en) * | 2006-10-16 | 2010-09-14 | Oracle International Corporation | Technique to estimate the cost of streaming evaluation of XPaths |
US8010889B2 (en) * | 2006-10-20 | 2011-08-30 | Oracle International Corporation | Techniques for efficient loading of binary XML data |
US8104076B1 (en) | 2006-11-13 | 2012-01-24 | Jpmorgan Chase Bank, N.A. | Application access control system |
US9436779B2 (en) * | 2006-11-17 | 2016-09-06 | Oracle International Corporation | Techniques of efficient XML query using combination of XML table index and path/value index |
US20080120283A1 (en) * | 2006-11-17 | 2008-05-22 | Oracle International Corporation | Processing XML data stream(s) using continuous queries in a data stream management system |
US8478760B2 (en) * | 2006-11-17 | 2013-07-02 | Oracle International Corporation | Techniques of efficient query over text, image, audio, video and other domain specific data in XML using XML table index with integration of text index and other domain specific indexes |
US8307348B2 (en) * | 2006-12-05 | 2012-11-06 | Microsoft Corporation | Simplified representation of XML schema structures |
US7840590B2 (en) * | 2006-12-18 | 2010-11-23 | Oracle International Corporation | Querying and fragment extraction within resources in a hierarchical repository |
US20080147615A1 (en) * | 2006-12-18 | 2008-06-19 | Oracle International Corporation | Xpath based evaluation for content stored in a hierarchical database repository using xmlindex |
US7934207B2 (en) * | 2006-12-19 | 2011-04-26 | Microsoft Corporation | Data schemata in programming language contracts |
US8522255B2 (en) * | 2006-12-29 | 2013-08-27 | Sap Ag | Multi-tiered message parsing |
US20080163197A1 (en) * | 2006-12-30 | 2008-07-03 | Sap Ag | Multi-product installation tool database architecture |
CN101216824B (zh) * | 2007-01-05 | 2010-04-21 | 冯卫国 | 一种将树型结构数据库发布为分布式xml数据库的方法 |
US20080189311A1 (en) * | 2007-02-01 | 2008-08-07 | Microsoft Corporation | Visual controls for stored procedure and object relational class development |
US8214797B2 (en) * | 2007-02-01 | 2012-07-03 | Microsoft Corporation | Visual association creation for object relational class development |
US7979476B2 (en) * | 2007-02-07 | 2011-07-12 | Canon Kabushiki Kaisha | Information processing apparatus, control method therefor, program, and storage medium |
US7631003B2 (en) * | 2007-02-20 | 2009-12-08 | Microsoft Corporation | Automated transformation for style normalization of schemas |
US20080222515A1 (en) * | 2007-02-26 | 2008-09-11 | Microsoft Corporation | Parameterized types and elements in xml schema |
US7860899B2 (en) * | 2007-03-26 | 2010-12-28 | Oracle International Corporation | Automatically determining a database representation for an abstract datatype |
US20080237436A1 (en) * | 2007-03-26 | 2008-10-02 | Runbeck Election Services, Inc. | Election ballot printing system and method |
US8024701B2 (en) * | 2007-03-27 | 2011-09-20 | Microsoft Corporation | Visual creation of object/relational constructs |
US7668860B2 (en) * | 2007-04-02 | 2010-02-23 | Business Objects Software Ltd. | Apparatus and method for constructing and using a semantic abstraction for querying hierarchical data |
US8396909B1 (en) * | 2007-04-12 | 2013-03-12 | United Services Automobile Association (Usaa) | Electronic file management hierarchical structure |
US8375072B1 (en) | 2007-04-12 | 2013-02-12 | United Services Automobile Association (Usaa) | Electronic file management hierarchical structure |
US7765241B2 (en) * | 2007-04-20 | 2010-07-27 | Microsoft Corporation | Describing expected entity relationships in a model |
CN100458793C (zh) * | 2007-05-10 | 2009-02-04 | 浪潮集团山东通用软件有限公司 | 数据访问层Xml格式数据与关系数据间的映射转换方法 |
US20090081545A1 (en) * | 2007-06-28 | 2009-03-26 | Ultralife Corporation | HIGH CAPACITY AND HIGH RATE LITHIUM CELLS WITH CFx-MnO2 HYBRID CATHODE |
US7904809B2 (en) * | 2007-06-29 | 2011-03-08 | Microsoft Corporation | Model-based editors for dynamic validation |
US7836066B2 (en) * | 2007-07-12 | 2010-11-16 | Oracle International Corporation | Using SQL extensibility for processing dynamically typed XML data in XQuery queries |
US7836098B2 (en) | 2007-07-13 | 2010-11-16 | Oracle International Corporation | Accelerating value-based lookup of XML document in XQuery |
US8271477B2 (en) * | 2007-07-20 | 2012-09-18 | Informatica Corporation | Methods and systems for accessing data |
US9760839B1 (en) | 2007-07-25 | 2017-09-12 | United Services Automobile Association (Usaa) | Electronic recording statement management |
US7840609B2 (en) * | 2007-07-31 | 2010-11-23 | Oracle International Corporation | Using sibling-count in XML indexes to optimize single-path queries |
KR100941971B1 (ko) | 2007-08-03 | 2010-02-11 | 한국전자통신연구원 | 멀티미디어 검색을 위한 질의 표현 장치 및 방법 |
US7979420B2 (en) * | 2007-10-16 | 2011-07-12 | Oracle International Corporation | Handling silent relations in a data stream management system |
US8296316B2 (en) * | 2007-10-17 | 2012-10-23 | Oracle International Corporation | Dynamically sharing a subtree of operators in a data stream management system operating on existing queries |
US7991768B2 (en) | 2007-11-08 | 2011-08-02 | Oracle International Corporation | Global query normalization to improve XML index based rewrites for path subsetted index |
US8543898B2 (en) * | 2007-11-09 | 2013-09-24 | Oracle International Corporation | Techniques for more efficient generation of XML events from XML data sources |
US8250062B2 (en) * | 2007-11-09 | 2012-08-21 | Oracle International Corporation | Optimized streaming evaluation of XML queries |
US9842090B2 (en) * | 2007-12-05 | 2017-12-12 | Oracle International Corporation | Efficient streaming evaluation of XPaths on binary-encoded XML schema-based documents |
US9330149B2 (en) * | 2007-12-18 | 2016-05-03 | Oracle International Corporation | Techniques for query and DML over relational tables using spreadsheet applications |
US20090182703A1 (en) * | 2008-01-16 | 2009-07-16 | Microsoft Corporation | Exposing relational database interfaces on xml data |
US8527867B2 (en) * | 2008-01-18 | 2013-09-03 | Oracle International Corporation | Enabling users to edit very large XML data |
US7996444B2 (en) * | 2008-02-18 | 2011-08-09 | International Business Machines Corporation | Creation of pre-filters for more efficient X-path processing |
US8515946B2 (en) * | 2008-02-28 | 2013-08-20 | Microsoft Corporation | Location description for federation and discoverability |
US8868482B2 (en) * | 2008-03-20 | 2014-10-21 | Oracle International Corporation | Inferring schemas from XML document collections |
US20090248716A1 (en) * | 2008-03-31 | 2009-10-01 | Caterpillar Inc. | Hierarchy creation and management tool |
US8224873B1 (en) | 2008-05-22 | 2012-07-17 | Informatica Corporation | System and method for flexible security access management in an enterprise |
US8166071B1 (en) | 2008-05-22 | 2012-04-24 | Informatica Corporation | System and method for efficiently securing enterprise data resources |
US8429196B2 (en) * | 2008-06-06 | 2013-04-23 | Oracle International Corporation | Fast extraction of scalar values from binary encoded XML |
US8024325B2 (en) | 2008-06-25 | 2011-09-20 | Oracle International Corporation | Estimating the cost of XML operators for binary XML storage |
US8943087B2 (en) * | 2008-07-25 | 2015-01-27 | International Business Machines Corporation | Processing data from diverse databases |
US8972463B2 (en) * | 2008-07-25 | 2015-03-03 | International Business Machines Corporation | Method and apparatus for functional integration of metadata |
US9110970B2 (en) * | 2008-07-25 | 2015-08-18 | International Business Machines Corporation | Destructuring and restructuring relational data |
US20100030727A1 (en) * | 2008-07-29 | 2010-02-04 | Sivasankaran Chandrasekar | Technique For Using Occurrence Constraints To Optimize XML Index Access |
US8073843B2 (en) * | 2008-07-29 | 2011-12-06 | Oracle International Corporation | Mechanism for deferred rewrite of multiple XPath evaluations over binary XML |
US7958112B2 (en) | 2008-08-08 | 2011-06-07 | Oracle International Corporation | Interleaving query transformations for XML indexes |
US8676841B2 (en) | 2008-08-29 | 2014-03-18 | Oracle International Corporation | Detection of recurring non-occurrences of events using pattern matching |
JP5484471B2 (ja) | 2008-09-19 | 2014-05-07 | オラクル・インターナショナル・コーポレイション | 記憶側記憶要求管理 |
US8949285B2 (en) * | 2008-09-19 | 2015-02-03 | Ciena Corporation | Systems and methods for handling performance monitoring data |
CN101727465B (zh) * | 2008-11-03 | 2011-12-21 | 中国移动通信集团公司 | 分布式列存储数据库索引建立、查询方法及装置与系统 |
US8904276B2 (en) | 2008-11-17 | 2014-12-02 | At&T Intellectual Property I, L.P. | Partitioning of markup language documents |
US9495475B2 (en) * | 2008-11-21 | 2016-11-15 | Sap Se | Method of representing an XML schema definition and data within a relational database management system using a reusable custom-defined nestable compound data type |
US8126932B2 (en) * | 2008-12-30 | 2012-02-28 | Oracle International Corporation | Indexing strategy with improved DML performance and space usage for node-aware full-text search over XML |
US8219563B2 (en) * | 2008-12-30 | 2012-07-10 | Oracle International Corporation | Indexing mechanism for efficient node-aware full-text search over XML |
US8145859B2 (en) | 2009-03-02 | 2012-03-27 | Oracle International Corporation | Method and system for spilling from a queue to a persistent store |
US8352517B2 (en) | 2009-03-02 | 2013-01-08 | Oracle International Corporation | Infrastructure for spilling pages to a persistent store |
US8935293B2 (en) * | 2009-03-02 | 2015-01-13 | Oracle International Corporation | Framework for dynamically generating tuple and page classes |
US8380702B2 (en) * | 2009-03-10 | 2013-02-19 | Oracle International Corporation | Loading an index with minimal effect on availability of applications using the corresponding table |
US8176063B2 (en) * | 2009-03-12 | 2012-05-08 | Siemens Product Lifecycle Management Software Inc. | System and method for non-overwriting extensible mapping |
US20100250729A1 (en) * | 2009-03-30 | 2010-09-30 | Morris Robert P | Method and System For Providing Access To Metadata Of A Network Accessible Resource |
US20100250591A1 (en) * | 2009-03-30 | 2010-09-30 | Morris Robert P | Methods, Systems, And Computer Program Products For Providing Access To Metadata For An Identified Resource |
US8560941B2 (en) * | 2009-04-08 | 2013-10-15 | Microsoft Corporation | Schema based user interface mechanisms |
US8478801B2 (en) * | 2009-05-20 | 2013-07-02 | Vmware, Inc. | Efficient reconstruction of virtual disk hierarchies across storage domains |
US9497248B2 (en) | 2009-06-02 | 2016-11-15 | International Business Machines Corporation | System for enabling rich network applications |
US8387076B2 (en) * | 2009-07-21 | 2013-02-26 | Oracle International Corporation | Standardized database connectivity support for an event processing server |
US8321450B2 (en) * | 2009-07-21 | 2012-11-27 | Oracle International Corporation | Standardized database connectivity support for an event processing server in an embedded context |
US8386466B2 (en) * | 2009-08-03 | 2013-02-26 | Oracle International Corporation | Log visualization tool for a data stream processing server |
US8527458B2 (en) * | 2009-08-03 | 2013-09-03 | Oracle International Corporation | Logging framework for a data stream processing server |
US8423512B2 (en) * | 2009-09-08 | 2013-04-16 | Oracle International Corporation | Leveraging XML capabilities of a database to enhance handling of document data |
CN102043802B (zh) * | 2009-10-16 | 2013-09-25 | 上海飞机制造有限公司 | 基于结构摘要的xml关键字检索方法 |
US9424365B2 (en) * | 2009-10-30 | 2016-08-23 | Oracle International Corporation | XPath-based creation of relational indexes and constraints over XML data stored in relational tables |
US9305057B2 (en) * | 2009-12-28 | 2016-04-05 | Oracle International Corporation | Extensible indexing framework using data cartridges |
US9430494B2 (en) * | 2009-12-28 | 2016-08-30 | Oracle International Corporation | Spatial data cartridge for event processing systems |
US8959106B2 (en) | 2009-12-28 | 2015-02-17 | Oracle International Corporation | Class loading using java data cartridges |
US8244735B2 (en) | 2010-05-03 | 2012-08-14 | International Business Machines Corporation | Efficient and scalable data evolution with column oriented databases |
US8296326B1 (en) * | 2010-08-20 | 2012-10-23 | Cellco Partnership | Grid-based user interface techniques for interacting with nested hierarchical data structures |
US9741060B2 (en) | 2010-09-17 | 2017-08-22 | Oracle International Corporation | Recursive navigation in mobile CRM |
US8713049B2 (en) | 2010-09-17 | 2014-04-29 | Oracle International Corporation | Support for a parameterized query/view in complex event processing |
CN103119586B (zh) | 2010-09-17 | 2016-10-19 | 甲骨文国际公司 | 用于多形态序列化的方法和装置 |
US9229947B2 (en) | 2010-09-27 | 2016-01-05 | Fisher-Rosemount Systems, Inc. | Methods and apparatus to manage process data |
US9773028B2 (en) | 2010-09-29 | 2017-09-26 | International Business Machines Corporation | Manipulating non-schema attributes for objects in a schema based directory |
US8818963B2 (en) | 2010-10-29 | 2014-08-26 | Microsoft Corporation | Halloween protection in a multi-version database system |
CN102467607A (zh) * | 2010-11-11 | 2012-05-23 | 江苏大学 | 一种医嘱、给药提醒装置 |
US9189280B2 (en) | 2010-11-18 | 2015-11-17 | Oracle International Corporation | Tracking large numbers of moving objects in an event processing system |
US9038177B1 (en) | 2010-11-30 | 2015-05-19 | Jpmorgan Chase Bank, N.A. | Method and system for implementing multi-level data fusion |
US8583652B2 (en) | 2010-11-30 | 2013-11-12 | Oracle International Corporation | Efficiently registering a relational schema |
US8489649B2 (en) | 2010-12-13 | 2013-07-16 | Oracle International Corporation | Extensible RDF databases |
US9182757B2 (en) | 2011-03-30 | 2015-11-10 | Fisher-Rosemount Systems, Inc. | Methods and apparatus to transmit device description files to a host |
US8990416B2 (en) | 2011-05-06 | 2015-03-24 | Oracle International Corporation | Support for a new insert stream (ISTREAM) operation in complex event processing (CEP) |
EP2717166A4 (en) | 2011-05-24 | 2015-07-29 | Nec Corp | INFORMATION PROCESSING SYSTEM, DATA MANAGEMENT METHOD, INFORMATION PROCESSING DEVICE, AND CONTROL METHOD AND CONTROL PROGRAM THEREOF |
US9329975B2 (en) | 2011-07-07 | 2016-05-03 | Oracle International Corporation | Continuous query language (CQL) debugger in complex event processing (CEP) |
US9292588B1 (en) | 2011-07-20 | 2016-03-22 | Jpmorgan Chase Bank, N.A. | Safe storing data for disaster recovery |
CN102323956B (zh) * | 2011-09-29 | 2014-12-17 | 用友软件股份有限公司 | 数据管理装置和数据管理方法 |
US9020981B2 (en) * | 2011-09-30 | 2015-04-28 | Comprehend Systems, Inc. | Systems and methods for generating schemas that represent multiple data sources |
US8732213B2 (en) | 2011-12-23 | 2014-05-20 | Amiato, Inc. | Scalable analysis platform for semi-structured data |
US8676788B2 (en) * | 2012-03-13 | 2014-03-18 | International Business Machines Corporation | Structured large object (LOB) data |
CN102662997B (zh) * | 2012-03-15 | 2015-09-16 | 播思通讯技术(北京)有限公司 | 一种存储xml数据到关系数据库的方法 |
US8812542B1 (en) * | 2012-03-30 | 2014-08-19 | Emc Corporation | On-the-fly determining of alert relationships in a distributed system |
US9251181B2 (en) | 2012-06-18 | 2016-02-02 | International Business Machines Corporation | Dynamic map template discovery and map creation |
US9646028B2 (en) * | 2012-08-31 | 2017-05-09 | Facebook, Inc. | Graph query logic |
EP2893463A4 (en) * | 2012-09-07 | 2016-06-15 | American Chemical Soc | AUTOMATED EVALUATORS FOR COMPOSITIONS |
US9563663B2 (en) | 2012-09-28 | 2017-02-07 | Oracle International Corporation | Fast path evaluation of Boolean predicates |
US9262479B2 (en) | 2012-09-28 | 2016-02-16 | Oracle International Corporation | Join operations for continuous queries over archived views |
US10956422B2 (en) | 2012-12-05 | 2021-03-23 | Oracle International Corporation | Integrating event processing with map-reduce |
US10298444B2 (en) | 2013-01-15 | 2019-05-21 | Oracle International Corporation | Variable duration windows on continuous data streams |
US9098587B2 (en) | 2013-01-15 | 2015-08-04 | Oracle International Corporation | Variable duration non-event pattern matching |
KR20140096717A (ko) * | 2013-01-29 | 2014-08-06 | 한국전자통신연구원 | Bim 기반 빌딩에너지 관리 장치 및 방법 |
WO2014123529A1 (en) * | 2013-02-07 | 2014-08-14 | Hewlett-Packard Development Company, L.P. | Formatting semi-structured data in a database |
US9047249B2 (en) | 2013-02-19 | 2015-06-02 | Oracle International Corporation | Handling faults in a continuous event processing (CEP) system |
US9390135B2 (en) | 2013-02-19 | 2016-07-12 | Oracle International Corporation | Executing continuous event processing (CEP) queries in parallel |
US10540373B1 (en) | 2013-03-04 | 2020-01-21 | Jpmorgan Chase Bank, N.A. | Clause library manager |
US9195712B2 (en) | 2013-03-12 | 2015-11-24 | Microsoft Technology Licensing, Llc | Method of converting query plans to native code |
US10489365B2 (en) * | 2013-03-14 | 2019-11-26 | Oracle International Corporation | Predicate offload of large objects |
WO2014144889A2 (en) * | 2013-03-15 | 2014-09-18 | Amazon Technologies, Inc. | Scalable analysis platform for semi-structured data |
US10642837B2 (en) | 2013-03-15 | 2020-05-05 | Oracle International Corporation | Relocating derived cache during data rebalance to maintain application performance |
US10528590B2 (en) | 2014-09-26 | 2020-01-07 | Oracle International Corporation | Optimizing a query with extrema function using in-memory data summaries on the storage server |
US11074231B1 (en) * | 2013-03-15 | 2021-07-27 | Informatica Llc | Validating modifications to mapping statements for processing hierarchical data structures |
US10248620B2 (en) | 2013-04-30 | 2019-04-02 | Entit Software Llc | Database table column annotation |
US9418113B2 (en) | 2013-05-30 | 2016-08-16 | Oracle International Corporation | Value based windows on relations in continuous data streams |
US11966554B2 (en) * | 2013-09-16 | 2024-04-23 | Field Squared, Inc. | User interface defined document |
US9934279B2 (en) | 2013-12-05 | 2018-04-03 | Oracle International Corporation | Pattern matching across multiple input data streams |
GB2521198A (en) * | 2013-12-13 | 2015-06-17 | Ibm | Refactoring of databases to include soft type information |
JP5764226B2 (ja) * | 2014-02-17 | 2015-08-12 | 前田建設工業株式会社 | 情報処理装置、情報処理方法、プログラム、および媒体 |
US10474645B2 (en) | 2014-02-24 | 2019-11-12 | Microsoft Technology Licensing, Llc | Automatically retrying transactions with split procedure execution |
US9524302B2 (en) * | 2014-03-05 | 2016-12-20 | Scality, S.A. | Distributed consistent database implementation within an object store |
US10366070B2 (en) | 2015-02-20 | 2019-07-30 | Scality S.A. | Locking and I/O improvements of systems built with distributed consistent database implementations within an object store |
US10248682B2 (en) | 2015-02-20 | 2019-04-02 | Scality, S.A. | Object storage system capable of performing snapshots, branches and locking |
US10261960B2 (en) | 2014-09-12 | 2019-04-16 | Scality, S.A. | Snapshots and forks of storage systems using distributed consistent databases implemented within an object store |
US9779118B2 (en) * | 2014-03-17 | 2017-10-03 | Kenshoo Ltd. | Live database schema tree change |
US10635645B1 (en) | 2014-05-04 | 2020-04-28 | Veritas Technologies Llc | Systems and methods for maintaining aggregate tables in databases |
US10599860B2 (en) * | 2014-05-22 | 2020-03-24 | Tata Consultancy Services Limited | Accessing enterprise data |
US9244978B2 (en) | 2014-06-11 | 2016-01-26 | Oracle International Corporation | Custom partitioning of a data stream |
US9712645B2 (en) | 2014-06-26 | 2017-07-18 | Oracle International Corporation | Embedded event processing |
US10120907B2 (en) | 2014-09-24 | 2018-11-06 | Oracle International Corporation | Scaling event processing using distributed flows and map-reduce operations |
US9886486B2 (en) | 2014-09-24 | 2018-02-06 | Oracle International Corporation | Enriching events with dynamically typed big data for event processing |
US9754048B1 (en) * | 2014-10-06 | 2017-09-05 | Google Inc. | Storing semi-structured data |
US10333696B2 (en) | 2015-01-12 | 2019-06-25 | X-Prime, Inc. | Systems and methods for implementing an efficient, scalable homomorphic transformation of encrypted data with minimal data expansion and improved processing efficiency |
US10067953B2 (en) * | 2015-05-08 | 2018-09-04 | International Business Machines Corporation | Indexing a chameleon schema |
US9916359B2 (en) * | 2015-06-01 | 2018-03-13 | Sap Se | Indexing dynamic hierarchical data |
WO2017018901A1 (en) | 2015-07-24 | 2017-02-02 | Oracle International Corporation | Visually exploring and analyzing event streams |
US10872065B1 (en) * | 2015-08-03 | 2020-12-22 | Intelligence Designs, LLC | System for managing relational databases using XML objects |
US10169351B2 (en) * | 2015-08-19 | 2019-01-01 | International Business Machines Corporation | Merging directory information from a user directory to a common directory |
CN105930474A (zh) * | 2016-04-26 | 2016-09-07 | 南京国电南自电网自动化有限公司 | 基于数据库技术的动态模型构造方法 |
US10733562B2 (en) * | 2016-06-03 | 2020-08-04 | Arkadiusz Binder | Method, device, system of model-driven engineering of efficient industrial automation process and business process modeling with BPMN using native computation of XML schemas and objects |
US10628424B2 (en) * | 2016-09-15 | 2020-04-21 | Oracle International Corporation | Graph generation for a distributed event processing system |
GB201615963D0 (en) * | 2016-09-20 | 2016-11-02 | Ibm | Relational operations between db tables and application tables |
US10025568B2 (en) * | 2016-11-11 | 2018-07-17 | Sap Se | Database object lifecycle management |
US10558529B2 (en) | 2016-11-11 | 2020-02-11 | Sap Se | Database object delivery infrastructure |
US10891273B2 (en) | 2016-11-11 | 2021-01-12 | Sap Se | Database container delivery infrastructure |
US10909090B2 (en) | 2016-11-11 | 2021-02-02 | Sap Se | Database proxy object delivery infrastructure |
CN108228604B (zh) * | 2016-12-14 | 2021-11-23 | 北京国双科技有限公司 | 基于内存对象的模型构建方法、信息查询方法及装置 |
CN106802938A (zh) * | 2016-12-30 | 2017-06-06 | 厦门南讯软件科技有限公司 | 基于组件化的客户分层属性动态生成方法 |
CN106909673A (zh) * | 2017-03-01 | 2017-06-30 | 国电南瑞科技股份有限公司 | 一种遵循数据库接口标准的数据存储模块的实现方法 |
RU2650032C1 (ru) * | 2017-03-20 | 2018-04-06 | Алексей Петрович Семенов | Электронная база данных и способ её формирования |
US11120027B2 (en) | 2017-09-06 | 2021-09-14 | Rovi Guides, Inc. | Systems and methods for identifying a category of a search term and providing search results subject to the identified category |
US11086876B2 (en) | 2017-09-29 | 2021-08-10 | Oracle International Corporation | Storing derived summaries on persistent memory of a storage device |
CN107657036A (zh) * | 2017-09-29 | 2018-02-02 | 北京酷我科技有限公司 | 一种数据库对象布局模型的产生方法 |
JP6890557B2 (ja) * | 2018-01-17 | 2021-06-18 | 株式会社日立製作所 | 分析モデル作成システム、プログラミング装置および分析モデル作成方法 |
CN108804346A (zh) * | 2018-05-30 | 2018-11-13 | 广东思诺伟智能技术有限公司 | 一种电池soc数据在flash存储器存储的方法 |
CN108875077B (zh) * | 2018-07-10 | 2021-02-09 | 上海达梦数据库有限公司 | 数据库的列存储方法、装置、服务器及存储介质 |
US11423060B2 (en) * | 2018-10-04 | 2022-08-23 | Oracle International Corporation | Storing and versioning hierarchical data in a binary format |
US11204940B2 (en) * | 2018-11-16 | 2021-12-21 | International Business Machines Corporation | Data replication conflict processing after structural changes to a database |
US11550785B2 (en) | 2019-04-19 | 2023-01-10 | Oracle International Corporation | Bidirectional mapping of hierarchical data to database object types |
CN110232063A (zh) * | 2019-04-19 | 2019-09-13 | 平安科技(深圳)有限公司 | 层级数据查询方法、装置、计算机设备和存储介质 |
TWI780333B (zh) * | 2019-06-03 | 2022-10-11 | 緯創資通股份有限公司 | 動態處理並播放多媒體內容的方法及多媒體播放裝置 |
US10990596B2 (en) | 2019-06-14 | 2021-04-27 | Oracle International Corporation | Non-disruptive referencing of special purpose operators for database management systems |
US11200234B2 (en) | 2019-06-14 | 2021-12-14 | Oracle International Corporation | Non-disruptive dynamic ad-hoc database catalog services |
CN110471650B (zh) * | 2019-07-11 | 2022-08-09 | 新华三大数据技术有限公司 | 一种Web Service发布方法、装置及服务器 |
US11086829B2 (en) * | 2020-01-02 | 2021-08-10 | International Business Machines Corporation | Comparing schema definitions using sampling |
CN111241065B (zh) * | 2020-01-13 | 2024-01-30 | 大汉软件股份有限公司 | 一种支持国产数据库的数据库适配开发与操作方法 |
CN111708772A (zh) * | 2020-06-18 | 2020-09-25 | 辽宁振兴银行股份有限公司 | 一种减少数据库冗余,提高运行效率的操作方法 |
CN111813555B (zh) * | 2020-07-21 | 2022-02-15 | 国网湖南省电力有限公司 | 基于互联网技术的超融合基础架构分层资源管理系统 |
CN113505269B (zh) * | 2021-07-02 | 2024-03-29 | 卡斯柯信号(成都)有限公司 | 基于xml的二进制文件检测方法和装置 |
US20240037074A1 (en) * | 2022-07-29 | 2024-02-01 | Oracle International Corporation | Method and system to implement directory reads for a database file system |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5680614A (en) * | 1992-05-20 | 1997-10-21 | Nec Corporation | Relational database management system |
US5974407A (en) * | 1997-09-29 | 1999-10-26 | Sacks; Jerome E. | Method and apparatus for implementing a hierarchical database management system (HDBMS) using a relational database management system (RDBMS) as the implementing apparatus |
Family Cites Families (114)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US65659A (en) * | 1867-06-11 | evinger | ||
US93672A (en) * | 1869-08-17 | Improved clothes-pin | ||
JPS6386026A (ja) * | 1986-09-30 | 1988-04-16 | Matsushita Electric Ind Co Ltd | 関係型デ−タベ−スの構築方法 |
JPH0194429A (ja) * | 1987-10-06 | 1989-04-13 | Nec Corp | リレーショナル型データベースにおける階層的検索方式 |
JPH03238535A (ja) * | 1990-02-15 | 1991-10-24 | Nec Corp | リレーショナルデータベース管理システムにおける表およびデータの関係管理システム |
US5257365A (en) | 1990-03-16 | 1993-10-26 | Powers Frederick A | Database system with multi-dimensional summary search tree nodes for reducing the necessity to access records |
US5295261A (en) | 1990-07-27 | 1994-03-15 | Pacific Bell Corporation | Hybrid database structure linking navigational fields having a hierarchial database structure to informational fields having a relational database structure |
US5317742A (en) * | 1991-06-21 | 1994-05-31 | Racal-Datacom, Inc. | Dynamic translation of network management primitives to queries to a database |
JPH05233393A (ja) * | 1992-02-21 | 1993-09-10 | Nippon Denki Joho Service Kk | 階層構造型データの処理方式 |
US5467471A (en) | 1993-03-10 | 1995-11-14 | Bader; David A. | Maintaining databases by means of hierarchical genealogical table |
US5956715A (en) | 1994-12-13 | 1999-09-21 | Microsoft Corporation | Method and system for controlling user access to a resource in a networked computing environment |
CA2167790A1 (en) | 1995-01-23 | 1996-07-24 | Donald S. Maier | Relational database system and method with high data availability during table data restructuring |
US5724577A (en) | 1995-06-07 | 1998-03-03 | Lockheed Martin Corporation | Method for operating a computer which searches a relational database organizer using a hierarchical database outline |
SE504472C2 (sv) | 1995-06-22 | 1997-02-17 | Abb Flexible Automation As | Färgmatningssystem för sprutmålningsrobot |
US5960194A (en) | 1995-09-11 | 1999-09-28 | International Business Machines Corporation | Method for generating a multi-tiered index for partitioned data |
US5734887A (en) | 1995-09-29 | 1998-03-31 | International Business Machines Corporation | Method and apparatus for logical data access to a physical relational database |
US5893109A (en) | 1996-03-15 | 1999-04-06 | Inso Providence Corporation | Generation of chunks of a long document for an electronic book system |
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 |
US6208993B1 (en) | 1996-07-26 | 2001-03-27 | Ori Software Development Ltd. | Method for organizing directories |
US5950188A (en) * | 1996-11-14 | 1999-09-07 | Sybase, Inc. | Database system with methods for executing system-created internal SQL command statements |
US5987506A (en) | 1996-11-22 | 1999-11-16 | Mangosoft Corporation | Remote access and geographically distributed computers in a globally addressable storage environment |
US5878415A (en) | 1997-03-20 | 1999-03-02 | Novell, Inc. | Controlling access to objects in a hierarchical database |
US5983215A (en) | 1997-05-08 | 1999-11-09 | The Trustees Of Columbia University In The City Of New York | System and method for performing joins and self-joins in a database system |
JPH10307743A (ja) * | 1997-05-09 | 1998-11-17 | Nippon Telegr & Teleph Corp <Ntt> | 複数データベース柔軟検索方法及び装置 |
JP3777025B2 (ja) | 1997-08-20 | 2006-05-24 | インターナショナル・ビジネス・マシーンズ・コーポレーション | システム資源表示装置およびその方法 |
GB2329044B (en) * | 1997-09-05 | 2002-10-09 | Ibm | Data retrieval system |
US6141655A (en) | 1997-09-23 | 2000-10-31 | At&T Corp | Method and apparatus for optimizing and structuring data by designing a cube forest data structure for hierarchically split cube forest template |
JPH11102369A (ja) * | 1997-09-29 | 1999-04-13 | Fujitsu Ltd | データベース検索装置及びプログラム記憶媒体 |
US6038563A (en) | 1997-10-31 | 2000-03-14 | Sun Microsystems, Inc. | System and method for restricting database access to managed object information using a permissions table that specifies access rights corresponding to user access rights to the managed objects |
US5999941A (en) | 1997-11-25 | 1999-12-07 | Micron Electronics, Inc. | Database access using active server pages |
US6003040A (en) | 1998-01-23 | 1999-12-14 | Mital; Vijay | Apparatus and method for storing, navigating among and adding links between data items in computer databases |
US6012067A (en) | 1998-03-02 | 2000-01-04 | Sarkar; Shyam Sundar | Method and apparatus for storing and manipulating objects in a plurality of relational data managers on the web |
US6356920B1 (en) | 1998-03-09 | 2002-03-12 | X-Aware, Inc | Dynamic, hierarchical data exchange system |
JPH11296541A (ja) | 1998-04-14 | 1999-10-29 | Fujitsu Ltd | 構造化データ管理システム及び構造化データ管理プログラムを記録したコンピュータ読み取り可能な記録媒体 |
JPH11306071A (ja) * | 1998-04-16 | 1999-11-05 | Fujitsu Ltd | 階層化データ管理システムおよび階層化データ管理プログラム記憶媒体 |
US6240407B1 (en) | 1998-04-29 | 2001-05-29 | International Business Machines Corp. | Method and apparatus for creating an index in a database system |
US6772350B1 (en) | 1998-05-15 | 2004-08-03 | E.Piphany, Inc. | System and method for controlling access to resources in a distributed environment |
US6263332B1 (en) | 1998-08-14 | 2001-07-17 | Vignette Corporation | System and method for query processing of structured documents |
US6487546B1 (en) | 1998-08-27 | 2002-11-26 | Oracle Corporation | Apparatus and method for aggregate indexes |
US6269380B1 (en) * | 1998-08-31 | 2001-07-31 | Xerox Corporation | Property based mechanism for flexibility supporting front-end and back-end components having different communication protocols |
US6718322B1 (en) | 1998-10-02 | 2004-04-06 | Ncr Corporation | SQL-based analytic algorithm for rule induction |
US6584459B1 (en) | 1998-10-08 | 2003-06-24 | International Business Machines Corporation | Database extender for storing, querying, and retrieving structured documents |
US6366934B1 (en) * | 1998-10-08 | 2002-04-02 | International Business Machines Corporation | Method and apparatus for querying structured documents using a database extender |
US6279007B1 (en) | 1998-11-30 | 2001-08-21 | Microsoft Corporation | Architecture for managing query friendly hierarchical values |
US6918082B1 (en) | 1998-12-17 | 2005-07-12 | Jeffrey M. Gross | Electronic document proofing system |
US6704739B2 (en) * | 1999-01-04 | 2004-03-09 | Adobe Systems Incorporated | Tagging data assets |
US6370537B1 (en) | 1999-01-14 | 2002-04-09 | Altoweb, Inc. | System and method for the manipulation and display of structured data |
US6154741A (en) | 1999-01-29 | 2000-11-28 | Feldman; Daniel J. | Entitlement management and access control system |
US6427123B1 (en) * | 1999-02-18 | 2002-07-30 | Oracle Corporation | Hierarchical indexing for accessing hierarchically organized information in a relational system |
US7366708B2 (en) * | 1999-02-18 | 2008-04-29 | Oracle Corporation | Mechanism to efficiently index structured data that provides hierarchical access in a relational database system |
HK1020419A2 (en) * | 1999-03-16 | 2000-03-17 | Shi Piu Joseph Fong | Frame model for universal database in database reengineering and integration |
JP2000267906A (ja) * | 1999-03-19 | 2000-09-29 | Mitsubishi Electric Corp | データベースモデル変換方法 |
US6341289B1 (en) | 1999-05-06 | 2002-01-22 | International Business Machines Corporation | Object identity and partitioning for user defined extents |
US6343287B1 (en) | 1999-05-19 | 2002-01-29 | Sun Microsystems, Inc. | External data store link for a profile service |
US20020124100A1 (en) | 1999-05-20 | 2002-09-05 | Jeffrey B Adams | Method and apparatus for access to, and delivery of, multimedia information |
US6496842B1 (en) | 1999-05-28 | 2002-12-17 | Survol Interactive Technologies | Navigating heirarchically organized information |
US6470344B1 (en) | 1999-05-29 | 2002-10-22 | Oracle Corporation | Buffering a hierarchical index of multi-dimensional data |
US7472349B1 (en) | 1999-06-01 | 2008-12-30 | Oracle International Corporation | Dynamic services infrastructure for allowing programmatic access to internet and other resources |
US6574655B1 (en) | 1999-06-29 | 2003-06-03 | Thomson Licensing Sa | Associative management of multimedia assets and associated resources using multi-domain agent-based communication between heterogeneous peers |
US6199195B1 (en) * | 1999-07-08 | 2001-03-06 | Science Application International Corporation | Automatically generated objects within extensible object frameworks and links to enterprise resources |
US6754661B1 (en) | 1999-07-13 | 2004-06-22 | Microsoft Corporation | Hierarchical storage systems for holding evidentiary objects and methods of creating and operating upon hierarchical storage systems |
US6438562B1 (en) | 1999-08-24 | 2002-08-20 | Oracle Corporation | Parallel index maintenance |
US6665684B2 (en) | 1999-09-27 | 2003-12-16 | Oracle International Corporation | Partition pruning with composite partitioning |
US6826727B1 (en) | 1999-11-24 | 2004-11-30 | Bitstream Inc. | Apparatus, methods, programming for automatically laying out documents |
US6721727B2 (en) | 1999-12-02 | 2004-04-13 | International Business Machines Corporation | XML documents stored as column data |
US6418448B1 (en) | 1999-12-06 | 2002-07-09 | Shyam Sundar Sarkar | Method and apparatus for processing markup language specifications for data and metadata used inside multiple related internet documents to navigate, query and manipulate information from a plurality of object relational databases over the web |
US20020116371A1 (en) | 1999-12-06 | 2002-08-22 | David Dodds | System and method for the storage, indexing and retrieval of XML documents using relation databases |
US6510434B1 (en) | 1999-12-29 | 2003-01-21 | Bellsouth Intellectual Property Corporation | System and method for retrieving information from a database using an index of XML tags and metafiles |
US6785673B1 (en) * | 2000-02-09 | 2004-08-31 | At&T Corp. | Method for converting relational data into XML |
US6604100B1 (en) | 2000-02-09 | 2003-08-05 | At&T Corp. | Method for converting relational data into a structured document |
AU2001236998A1 (en) | 2000-02-11 | 2001-08-20 | Acta Technologies, Inc. | Nested relational data model |
US7072896B2 (en) | 2000-02-16 | 2006-07-04 | Verizon Laboratories Inc. | System and method for automatic loading of an XML document defined by a document-type definition into a relational database including the generation of a relational schema therefor |
US6449620B1 (en) | 2000-03-02 | 2002-09-10 | Nimble Technology, Inc. | Method and apparatus for generating information pages using semi-structured data stored in a structured manner |
US20020056025A1 (en) | 2000-11-07 | 2002-05-09 | Qiu Chaoxin C. | Systems and methods for management of memory |
US6934712B2 (en) | 2000-03-21 | 2005-08-23 | International Business Machines Corporation | Tagging XML query results over relational DBMSs |
US6516322B1 (en) * | 2000-04-28 | 2003-02-04 | Microsoft Corporation | XML-based representation of mobile process calculi |
US20030158897A1 (en) | 2000-05-09 | 2003-08-21 | Viryanet Ltd. | Networked platform for creating and supporting communities |
US6845507B2 (en) | 2000-05-18 | 2005-01-18 | Ss & C Technologies, Inc. | Method and system for straight through processing |
US6915304B2 (en) | 2000-05-23 | 2005-07-05 | Kenneth A. Krupa | System and method for converting an XML data structure into a relational database |
US6704024B2 (en) | 2000-08-07 | 2004-03-09 | Zframe, Inc. | Visual content browsing using rasterized representations |
TW522306B (en) | 2000-08-08 | 2003-03-01 | Replaytv Inc | Method and system for remote television replay control |
US6708186B1 (en) | 2000-08-14 | 2004-03-16 | Oracle International Corporation | Aggregating and manipulating dictionary metadata in a database system |
US6675230B1 (en) | 2000-08-22 | 2004-01-06 | International Business Machines Corporation | Method, system, and program for embedding a user interface object in another user interface object |
US7752214B2 (en) | 2000-09-01 | 2010-07-06 | Op40, Inc. | Extended environment data structure for distributed digital assets over a multi-tier computer network |
US6871204B2 (en) | 2000-09-07 | 2005-03-22 | Oracle International Corporation | Apparatus and method for mapping relational data and metadata to XML |
US6910044B2 (en) * | 2000-09-20 | 2005-06-21 | Sap Aktiengesellschaft | Method and apparatus for structuring, maintaining, and using families of data |
WO2002046916A2 (en) | 2000-10-20 | 2002-06-13 | Polexis, Inc. | Extensible information system (xis) |
US6785718B2 (en) | 2000-10-23 | 2004-08-31 | Schneider Logistics, Inc. | Method and system for interfacing with a shipping service |
US20020099738A1 (en) * | 2000-11-22 | 2002-07-25 | Grant Hugh Alexander | Automated web access for back-end enterprise systems |
US7917888B2 (en) | 2001-01-22 | 2011-03-29 | Symbol Technologies, Inc. | System and method for building multi-modal and multi-channel applications |
US6964025B2 (en) | 2001-03-20 | 2005-11-08 | Microsoft Corporation | Auto thumbnail gallery |
JP4529063B2 (ja) | 2001-03-30 | 2010-08-25 | ルネサスエレクトロニクス株式会社 | システムシミュレータ、シミュレーション方法及びシミュレーションプログラム |
US6778977B1 (en) | 2001-04-19 | 2004-08-17 | Microsoft Corporation | Method and system for creating a database table index using multiple processors |
US6968334B2 (en) | 2001-05-15 | 2005-11-22 | Nokia Corporation | Method and business process to maintain privacy in distributed recommendation systems |
US7197764B2 (en) | 2001-06-29 | 2007-03-27 | Bea Systems Inc. | System for and methods of administration of access control to numerous resources and objects |
US6795821B2 (en) | 2001-07-17 | 2004-09-21 | Trendium, Inc. | Database systems, methods and computer program products including primary key and super key indexes for use with partitioned tables |
US6725212B2 (en) | 2001-08-31 | 2004-04-20 | International Business Machines Corporation | Platform-independent method and system for graphically presenting the evaluation of a query in a database management system |
AU2002334721B2 (en) | 2001-09-28 | 2008-10-23 | Oracle International Corporation | An index structure to access hierarchical data in a relational database system |
US7487168B2 (en) | 2001-11-01 | 2009-02-03 | Microsoft Corporation | System and method for loading hierarchical data into relational database systems |
US6826568B2 (en) | 2001-12-20 | 2004-11-30 | Microsoft Corporation | Methods and system for model matching |
US7523127B2 (en) * | 2002-01-14 | 2009-04-21 | Testout Corporation | System and method for a hierarchical database management system for educational training and competency testing simulations |
US6732222B1 (en) | 2002-02-01 | 2004-05-04 | Silicon Motion, Inc. | Method for performing flash memory file management |
US9374451B2 (en) | 2002-02-04 | 2016-06-21 | Nokia Technologies Oy | System and method for multimodal short-cuts to digital services |
US7127700B2 (en) * | 2002-03-14 | 2006-10-24 | Openwave Systems Inc. | Method and apparatus for developing web services using standard logical interfaces to support multiple markup languages |
US7570943B2 (en) | 2002-08-29 | 2009-08-04 | Nokia Corporation | System and method for providing context sensitive recommendations to digital services |
US7120645B2 (en) | 2002-09-27 | 2006-10-10 | Oracle International Corporation | Techniques for rewriting XML queries directed to relational database constructs |
US6826857B1 (en) | 2002-11-14 | 2004-12-07 | Anders Bachmann | Perpetual calendar |
US6836778B2 (en) | 2003-05-01 | 2004-12-28 | Oracle International Corporation | Techniques for changing XML content in a relational database |
US7103611B2 (en) | 2003-05-01 | 2006-09-05 | Oracle International Corporation | Techniques for retaining hierarchical information in mapping between XML documents and relational data |
US7634480B2 (en) | 2003-05-08 | 2009-12-15 | Microsoft Corporation | Declarative rules for metadirectory |
US20050010896A1 (en) | 2003-07-07 | 2005-01-13 | International Business Machines Corporation | Universal format transformation between relational database management systems and extensible markup language using XML relational transformation |
US7814047B2 (en) | 2003-08-25 | 2010-10-12 | Oracle International Corporation | Direct loading of semistructured data |
US7747580B2 (en) | 2003-08-25 | 2010-06-29 | Oracle International Corporation | Direct loading of opaque types |
US7685137B2 (en) | 2004-08-06 | 2010-03-23 | Oracle International Corporation | Technique of using XMLType tree as the type infrastructure for XML |
-
2002
- 2002-09-26 AU AU2002334721A patent/AU2002334721B2/en not_active Expired
- 2002-09-27 CN CNB028191692A patent/CN1299223C/zh not_active Expired - Lifetime
- 2002-09-27 JP JP2003533163A patent/JP2005505058A/ja active Pending
- 2002-09-27 CA CA2461854A patent/CA2461854C/en not_active Expired - Lifetime
- 2002-09-27 CA CA2462300A patent/CA2462300C/en not_active Expired - Lifetime
- 2002-09-27 EP EP02799692A patent/EP1433089A2/en not_active Ceased
- 2002-09-27 WO PCT/US2002/030783 patent/WO2003030031A2/en active Application Filing
- 2002-09-27 US US10/259,278 patent/US7096224B2/en not_active Expired - Lifetime
- 2002-09-27 JP JP2003531372A patent/JP4443221B2/ja not_active Expired - Lifetime
- 2002-09-27 AU AU2002334747A patent/AU2002334747B2/en not_active Expired
- 2002-09-27 CN CN028223470A patent/CN1585945B/zh not_active Expired - Lifetime
- 2002-09-27 WO PCT/US2002/031168 patent/WO2003027908A2/en active Application Filing
- 2002-09-27 EP EP02800376A patent/EP1440394A2/en not_active Ceased
- 2002-09-27 US US10/260,384 patent/US7051033B2/en not_active Expired - Lifetime
- 2002-09-27 AU AU2002334706A patent/AU2002334706B2/en not_active Expired
-
2005
- 2005-12-21 US US11/315,835 patent/US7158981B2/en not_active Expired - Lifetime
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5680614A (en) * | 1992-05-20 | 1997-10-21 | Nec Corporation | Relational database management system |
US5974407A (en) * | 1997-09-29 | 1999-10-26 | Sacks; Jerome E. | Method and apparatus for implementing a hierarchical database management system (HDBMS) using a relational database management system (RDBMS) as the implementing apparatus |
Also Published As
Publication number | Publication date |
---|---|
AU2002334706B2 (en) | 2007-11-22 |
US20030140308A1 (en) | 2003-07-24 |
CN1585945A (zh) | 2005-02-23 |
AU2002334721B2 (en) | 2008-10-23 |
WO2003030031A2 (en) | 2003-04-10 |
CA2462300C (en) | 2014-01-21 |
US20030065659A1 (en) | 2003-04-03 |
US20060101041A1 (en) | 2006-05-11 |
EP1433089A2 (en) | 2004-06-30 |
EP1440394A2 (en) | 2004-07-28 |
JP4443221B2 (ja) | 2010-03-31 |
CA2461854A1 (en) | 2003-04-10 |
US7051033B2 (en) | 2006-05-23 |
WO2003030031A3 (en) | 2004-02-12 |
WO2003027908A2 (en) | 2003-04-03 |
CN1585945B (zh) | 2011-05-18 |
JP2005505058A (ja) | 2005-02-17 |
CA2462300A1 (en) | 2003-04-03 |
AU2002334747B2 (en) | 2008-10-30 |
US7158981B2 (en) | 2007-01-02 |
CN1561497A (zh) | 2005-01-05 |
WO2003027908A3 (en) | 2004-02-12 |
JP2005505042A (ja) | 2005-02-17 |
US7096224B2 (en) | 2006-08-22 |
CA2461854C (en) | 2010-11-23 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN1299223C (zh) | 提供关系数据的一致性层次抽象化 | |
US7047253B1 (en) | Mechanisms for storing content and properties of hierarchically organized resources | |
US9009099B1 (en) | Method and system for reconstruction of object model data in a relational database | |
CN1297904C (zh) | 使用动态内容表和内容表集的分级存储管理方法和装置 | |
US6430575B1 (en) | Collaborative document management system with customizable filing structures that are mutually intelligible | |
RU2400803C2 (ru) | Долговременное хранилище типов и экземпляров данных .net | |
AU2002334747A1 (en) | Providing a consistent hierarchical abstraction of relational data | |
CN1295636C (zh) | 用于访问关系型数据库系统中的分层数据的高效索引结构 | |
US7197493B2 (en) | Collection management database of arbitrary schema | |
US7043490B2 (en) | Method, system, and program product to support multiple content-management data models | |
EP1585036A2 (en) | Management of parameterized database queries | |
US20180336223A1 (en) | Context weighted metalabels for enhanced search in hierarchical abstract data organization systems | |
US20090043733A1 (en) | Systems and methods for efficiently storing, retrieving and querying data structures in a relational database system | |
US10657221B2 (en) | File system for medical images and data | |
CN1255747C (zh) | 描述供利用的商务和技术信息的方法 | |
US8386500B2 (en) | Apparatus, system, and method for XML based disconnected data access for multivalued/hierarchical databases | |
US7028037B1 (en) | Operators for accessing hierarchical data in a relational system | |
US20090063654A1 (en) | Apparatus, system, and method for xml based disconnected data access for multivalued/hierarchical databases | |
Kakivaya et al. | Durable storage of .NET data types and instances | |
WO2009027185A1 (en) | Apparatus, system, and method for xml based disconnected data access for multivalued/hierarchical databases |
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 |
Granted publication date: 20070207 |
|
CX01 | Expiry of patent term |