Normalized ranking of semantic query search results
    1.
    发明授权
    Normalized ranking of semantic query search results 有权
    语义查询搜索结果的归一化排序

    公开(公告)号:US09229930B2

    公开(公告)日:2016-01-05

    申请号:US13595125

    申请日:2012-08-27

    IPC分类号: G06F17/30

    摘要: A method, system, and computer program product for normalized ranking of semantic query search results. The method commences by forming a SPARQL query, the SPARQL query specifying a collection of named RDF graphs, then executing the SPARQL query to retrieve matched documents selected from the collection of named RDF graphs. Having retrieved the matches, the method calculates an absolute normalized score for the matched document. The calculation of an absolute normalized score for a second matched document allows for relevance ranking. To enhance the relationship of the computer-calculated score to the relevance (and not solely to occurrence counts) embodiments consider the number of distinct variables selected in the SPARQL query, and also consider the total number of bindings to the aforementioned variables. For comparing from among possibly different sized documents, a further normalization component is implemented by considering the total number of triples found in the document's underlying subgraph.

    摘要翻译: 一种用于语义查询搜索结果的归一化排序的方法,系统和计算机程序产品。 该方法通过形成SPARQL查询,SPARQL查询指定一个命名RDF图的集合,然后执行SPARQL查询来检索从命名RDF图的集合中选择的匹配文档。 检索到匹配后,该方法计算匹配文档的绝对归一化分数。 对于第二匹配文档的绝对归一化分数的计算允许相关性排名。 为了增强计算机计算的分数与相关性(而不仅仅是出现次数)的关系,实施例考虑在SPARQL查询中选择的不同变量的数量,并且还考虑与上述变量的绑定的总数。 为了从可能不同大小的文档中进行比较,通过考虑文档底层子图中发现的三元组的总数来实现进一步的标准化组件。

    Column constraints based on arbitrary sets of objects
    2.
    发明授权
    Column constraints based on arbitrary sets of objects 有权
    基于任意对象集的列约束

    公开(公告)号:US08214354B2

    公开(公告)日:2012-07-03

    申请号:US11395652

    申请日:2006-03-31

    IPC分类号: G06F7/00 G06F17/30

    摘要: 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.

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

    Data visualization with summary graphs
    3.
    发明授权
    Data visualization with summary graphs 有权
    数据可视化与汇总图

    公开(公告)号:US08126926B2

    公开(公告)日:2012-02-28

    申请号:US12317362

    申请日:2008-12-22

    IPC分类号: G06F7/00 G06F17/30

    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.

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

    Method and system for speeding up rebuild of user-defined indexes during partition maintenance operations in the database systems
    5.
    发明申请
    Method and system for speeding up rebuild of user-defined indexes during partition maintenance operations in the database systems 有权
    在数据库系统中的分区维护操作期间加快重建用户定义索引的方法和系统

    公开(公告)号:US20090177622A1

    公开(公告)日:2009-07-09

    申请号:US12007325

    申请日:2008-01-09

    IPC分类号: G06F17/30

    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.

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

    Materialized views with user-defined aggregates
    6.
    发明申请
    Materialized views with user-defined aggregates 有权
    具有用户定义聚合的物化视图

    公开(公告)号:US20090019005A1

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

    申请号:US11827796

    申请日:2007-07-13

    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.

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

    Queries with hard time constraints
    7.
    发明申请
    Queries with hard time constraints 有权
    具有困难时间限制的查询

    公开(公告)号:US20080288473A1

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

    申请号:US11804508

    申请日:2007-05-18

    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.

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

    Managing expressions in a database system

    公开(公告)号:US07127467B2

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

    申请号:US10254383

    申请日:2002-09-24

    IPC分类号: G06F17/30

    摘要: 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.

    Method and system for efficiently evaluating a query against partitioned data
    10.
    发明授权
    Method and system for efficiently evaluating a query against partitioned data 有权
    用于有效评估对分区数据的查询的方法和系统

    公开(公告)号:US06816853B1

    公开(公告)日:2004-11-09

    申请号:US09872887

    申请日:2001-05-31

    IPC分类号: G06F1730

    摘要: A method and mechanism to execute a query against a partitioned database object. Data processed or created for an earlier partition is maintained even after further processing is performed against a subsequent partition. A shared data object, such as a context object, is maintained to store data from processing the partitions of a partitioned table. Rather than discarding or overwriting the shared data object after processing each partition, the data from a subsequent partition is instead appended to the shared data object.

    摘要翻译: 对分区数据库对象执行查询的方法和机制。 即使在针对后续分区执行进一步处理之后,仍保留对较早分区进行处理或创建的数据。 维护诸如上下文对象的共享数据对象以存储来自处理分区表的分区的数据。 在处理每个分区之后,不是丢弃或覆盖共享数据对象,而是将来自后续分区的数据替换为附加到共享数据对象。