公开(公告)号：US20090019005A1

公开(公告)日：2009-01-15

申请号：US11827796

申请日：2007-07-13

申请人： Ying Hu ,  Seema Sundara ,  Jagannathan Srinivasan

发明人： Ying Hu ,  Seema Sundara ,  Jagannathan Srinivasan

IPC分类号： G06F17/30

CPC分类号： G06F17/30457

摘要： Systems, methodologies, media, and other embodiments associated with supporting materialized views with user-defined aggregates are described. One example system includes logic for exposing a set of interface actions to support a user-defined aggregate in a materialized view associated with a base table. The materialized view may store both the user-defined aggregate and a user-defined aggregate context that facilitates logically connecting the user-defined aggregate to the base table. The example system may also include logic for supporting the user-defined aggregate. The support may be based on the set of interface actions. Example systems and methods may, therefore, facilitate incremental updating of the materialized view and/or rewriting a query to access the materialized view.

摘要翻译： 描述了使用用户定义的聚合来支持物化视图的系统，方法，介质和其他实施例。 一个示例系统包括用于在与基表相关联的物化视图中暴露一组接口动作以支持用户定义的聚合的逻辑。 物化视图可以存储用户定义的聚合和有助于将用户定义的聚合逻辑连接到基表的用户定义的聚合上下文。 示例系统还可以包括用于支持用户定义的聚合的逻辑。 支持可以基于一组接口动作。 因此，示例系统和方法可以促进物化视图的增量更新和/或重写查询以访问物化视图。

公开(公告)号：US20080288473A1

公开(公告)日：2008-11-20

申请号：US11804508

申请日：2007-05-18

申请人： Ying Hu ,  Seema Sundara ,  Jagannathan Srinivasan

发明人： Ying Hu ,  Seema Sundara ,  Jagannathan Srinivasan

IPC分类号： G06F17/30

CPC分类号： G06F17/30522 ,  G06F17/30533

摘要： Systems, methodologies, media, and other embodiments associated with supporting queries with hard time constraints are described. One exemplary system embodiment includes logic for accepting a query having a hard time constraint. The example system may also include logic for selectively rewriting the query having the hard time constraint into a query having a row limitation or a sample percentage limitation. In one example, the row limitation or sample percentage limitation are computed by repetitively comparing an estimated query execution time to the hard time constraint. The example system may also include logic for establishing a timer(s) associated with the rewritten query.

摘要翻译： 描述了与支持具有硬时间约束的查询相关联的系统，方法，媒体和其他实施例。 一个示例性系统实施例包括用于接受具有硬时间约束的查询的逻辑。 示例系统还可以包括用于选择性地将具有硬时间约束的查询重写到具有行限制或样本百分比限制的查询中的逻辑。 在一个示例中，通过将估计的查询执行时间与硬时间约束重复比较来计算行限制或抽样百分比限制。 示例系统还可以包括用于建立与重写查询相关联的定时器的逻辑。

公开(公告)号：US07127467B2

公开(公告)日：2006-10-24

申请号：US10254383

申请日：2002-09-24

申请人： Aravind Yalamanchi ,  Dieter Gawlick ,  Jagannathan Srinivasan

发明人： Aravind Yalamanchi ,  Dieter Gawlick ,  Jagannathan Srinivasan

IPC分类号： G06F17/30

CPC分类号： G06F17/2241 ,  G06F17/2247 ,  G06F17/30289 ,  G06F17/30917 ,  Y10S707/961 ,  Y10S707/99933 ,  Y10S707/99943

摘要： A method for managing expressions includes receiving a first query that includes a first conditional expression. The first expression is then represented as data in a column of a table. A second query is received that specifies a first set of criteria, and the second query is executed to select data based at least on whether expressions in the column satisfy the first set of criteria. In an embodiment, the second query further specifies a second set of criteria, wherein executing the second query includes selecting data based on whether data in columns other than the expression column satisfy the second criteria. A special index is defined, which can be created on the column that stores the expressions as data, to filter large sets of expressions efficiently. A method of evaluating an expression set stored as data in a table classifies each predicate from each expression, and filters the expression set based on the predicate classification.

公开(公告)号：US07987164B2

公开(公告)日：2011-07-26

申请号：US12007325

申请日：2008-01-09

申请人： Ying Hu ,  Seema Sundara ,  Jagannathan Srinivasan

发明人： Ying Hu ,  Seema Sundara ,  Jagannathan Srinivasan

IPC分类号： G06F7/00 ,  G06F17/00

CPC分类号： G06F17/30336

摘要： A method, system, and computer program product provides improved performance for rebuild of user-defined indexes during partition maintenance operations (partition split, merge, and move). A method of maintaining a index of a partitioned database table comprises performing a partition maintenance operation on the partitioned database table wherein a plurality of rows of the partitioned database table are moved from one partition to another, storing mapping information for at least some of the plurality of moved rows, including an old mapping for each of the moved rows and a corresponding new mapping for each of the moved rows, and when rebuilding the index, replacing an old mapping in the index for each of the plurality of moved rows with the corresponding stored new mapping for each of the plurality of moved rows.

摘要翻译： 方法，系统和计算机程序产品提供了在分区维护操作（分区拆分，合并和移动）期间重建用户定义索引的改进性能。 维护分区数据库表的索引的方法包括对分区数据库表执行分区维护操作，其中分区数据库表的多行被从一个分区移动到另一分区，存储多个分区数据库表中的至少一个的映射信息 移动的行，包括每个移动的行的旧映射和每个被移动的行的对应的新映射，以及当重建索引时，用对应的多个移动的行中的每一个代替索引中的旧映射 为多个移动的行中的每一个存储新的映射。

公开(公告)号：US20100161680A1

公开(公告)日：2010-06-24

申请号：US12317362

申请日：2008-12-22

申请人： Medha Atre ,  Seema Sundara ,  Jagannathan Srinivasan

发明人： Medha Atre ,  Seema Sundara ,  Jagannathan Srinivasan

IPC分类号： G06F17/30 ,  G06F7/00

CPC分类号： G06F17/30554

摘要： Systems, methods, and other embodiments associated with visualizing data using summary graphs are described. One example method includes constructing a summary graph for display. The summary graph represents the data as a summary node having a plurality of property edges connected to the summary node. The summary node represents the set of values for the node in the data.

摘要翻译： 描述了使用概要图形与可视化数据相关联的系统，方法和其他实施例。 一个示例性方法包括构建用于显示的摘要图。 汇总图表示作为具有连接到汇总节点的多个属性边缘的汇总节点的数据。 汇总节点表示数据中节点的值集合。

公开(公告)号：US20100036862A1

公开(公告)日：2010-02-11

申请号：US12188927

申请日：2008-08-08

申请人： Souripriya Das ,  Eugene Inseok Chong ,  Zhe Wu ,  Melliyal Annamalai ,  Jagannathan Srinivasan

发明人： Souripriya Das ,  Eugene Inseok Chong ,  Zhe Wu ,  Melliyal Annamalai ,  Jagannathan Srinivasan

IPC分类号： G06F17/30

CPC分类号： G06F17/30917 ,  G06F17/3033

摘要： Techniques for generating hash values for instances of distinct data values. In the techniques, each distinct data value is mapped to hash value generation information which describes how to generate a unique hash value for instances of the distinct data value. The hash value generation information for a distinct data value is then used to generate the hash value for an instance of the distinct data value. The hash value generation information may indicate whether a collision has occurred in generating the hash values for instances of the distinct data values and if so, how the collision is to be resolved. The techniques are employed to normalize RDF triples by generating the UIDS employed in the normalization from the triples' lexical values.

摘要翻译： 用于为不同数据值的实例生成哈希值的技术。 在这些技术中，每个不同的数据值被映射到哈希值生成信息，该信息描述如何为不同数据值的实例生成唯一的哈希值。 然后，用于不同数据值的散列值生成信息用于生成不同数据值的实例的散列值。 哈希值生成信息可以指示是否在针对不同数据值的实例生成哈希值时发生冲突，并且如果是，则如何解决冲突。 这些技术用于通过从三元组词汇值生成在归一化中使用的UIDS来标准化RDF三元组。

公开(公告)号：US07328209B2

公开(公告)日：2008-02-05

申请号：US10916547

申请日：2004-08-11

申请人： Souripriya Das ,  Eugene Inseok Chong ,  George Eadon ,  Jagannathan Srinivasan

发明人： Souripriya Das ,  Eugene Inseok Chong ,  George Eadon ,  Jagannathan Srinivasan

IPC分类号： G06F17/30

CPC分类号： G06F17/30418 ,  G06F17/30421 ,  G06F17/30513 ,  Y10S707/99933 ,  Y10S707/99934

摘要： The method for processing data in a relational database wherein ontology data that specifies terms and relationships between pairs of said terms expressed in an OWL document is stored in the database, database queries that include a semantic matching operator are formed which identify the ontology data and further specify a stated relationship between two input terms, and the query is executed to invoke the semantic matching operator to determine if the two input terms are related by the stated relationship by consulting said ontology data.

摘要翻译： 用于处理关系数据库中的数据的方法，其中指定在OWL文档中表示的所述术语对之间的术语和关系的本体数据被存储在数据库中，形成包括语义匹配算子的数据库查询，其识别本体数据，并进一步 指定两个输入项之间的关系，并执行查询以调用语义匹配运算符，以通过查询所述本体数据来确定两个输入项是否与所述关系相关。

公开(公告)号：US20070233641A1

公开(公告)日：2007-10-04

申请号：US11395652

申请日：2006-03-31

申请人： Eugene Chong ,  Souripriya Das ,  George Eadon ,  Jagannathan Srinivasan

发明人： Eugene Chong ,  Souripriya Das ,  George Eadon ,  Jagannathan Srinivasan

IPC分类号： G06F17/30

CPC分类号： G06F17/3051 ,  G06F17/30407 ,  G06F17/30734

摘要： Techniques for using arbitrary sets of objects to constrain objects in database systems. The constraint set of objects is associated with the constrained object in the database system and the database system will perform an operation which adds an object to the constrained object only if the object being added belongs to the constraint set. In a preferred embodiment, the techniques are employed to obtain constraint sets of terms from ontologies which are then used to constrain columns containing those terms. An implementation of the techniques makes a materialized view out of the objects in the constraint set and uses the materialized view to define a referential integrity constraint on the constrained column.

摘要翻译： 使用任意对象组来约束数据库系统中的对象的技术。 对象的约束集与数据库系统中的约束对象相关联，并且数据库系统将执行一个操作，只有当被添加的对象属于约束集时，才会向约束对象添加一个对象。 在优选实施例中，使用这些技术来从本体获得约束条件集，然后将其用于约束包含这些术语的列。 该技术的实现使约束集中的对象成为物化视图，并使用物化视图来限制受限列上的引用完整性约束。

公开(公告)号：US20070050381A1

公开(公告)日：2007-03-01

申请号：US11215639

申请日：2005-08-29

申请人： Ying Hu ,  Timothy Chorma ,  Seema Sundara ,  Jagannathan Srinivasan

发明人： Ying Hu ,  Timothy Chorma ,  Seema Sundara ,  Jagannathan Srinivasan

IPC分类号： G06F7/00

CPC分类号： G06F17/30324

摘要： A database management system that has bitmap values in which set bits in a representation of a bitstring specify a set of objects whose definitions are built into the database management system. The database management system further includes user-accessible operations on the bitmap values. The bitmap values are represented by means of a mapping specifier that specifies a range of the set of objects and a representation of a string of bits that has been mapped onto the set of object specified by the range specifier. Objects containing bitmap values may be indexed by means of an index tree that includes summary bitmap values.

摘要翻译： 具有位图值的数据库管理系统，其中位列表示中的设置位指定其定义被内置到数据库管理系统中的一组对象。 数据库管理系统还包括对位图值的用户可访问操作。 位图值通过指定对象集合的范围的映射说明符和已经映射到范围说明符指定的对象集合的位串的表示来表示。 包含位图值的对象可以通过包含摘要位图值的索引树进行索引。

公开(公告)号：US20060235837A1

公开(公告)日：2006-10-19

申请号：US11108242

申请日：2005-04-18

申请人： Eugene Chong ,  Souripriya Das ,  George Eadon ,  Jagannathan Srinivasan

发明人： Eugene Chong ,  Souripriya Das ,  George Eadon ,  Jagannathan Srinivasan

IPC分类号： G06F17/30

CPC分类号： G06F17/30448

摘要： The TABLE function mechanism available in a RDBMS is used to integrate RDF models into SQL queries. The table function invocation takes parameters including an RDF pattern, an RDF model, and an RDF rule base and returns result rows to the SQL query that contain RDF triples resulting from the application of the pattern to the triples of the model and the triples inferred by applying the rule base to the model. The RDBMS includes relational representations of the triples and the rules. Optimizations include indexes and materialized views of the representations of the triples, precomputed inferred triples, and a method associated with the TABLE function that rewrites the part of the SQL query that contains the TABLE function invocation as an equivalent SQL string. The latter technique is generally applicable to TABLE functions.

摘要翻译： RDBMS中可用的TABLE函数机制用于将RDF模型集成到SQL查询中。 表函数调用采用包括RDF模式，RDF模型和RDF规则库的参数，并将结果行返回给包含由模式应用到模型三元组的RDF三元组的SQL查询，以及三维模型推断出的三元组 将规则库应用于模型。 RDBMS包括三元组和规则的关系表示。 优化包括三元组表示的索引和物化视图，预先计算的推断三元组，以及与TABLE函数相关联的方法，将包含TABLE函数调用的SQL查询的一部分重写为等效的SQL字符串。 后一种技术通常适用于TABLE函数。