利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

44 条记录 (耗时 0.021 秒)

    Techniques for handling function-defined hierarchical dimensions
    35.
    发明授权
    Techniques for handling function-defined hierarchical dimensions 有权
    用于处理功能定义的层次维度的技术

    公开(公告)号：US06493708B1

    公开(公告)日：2002-12-10

    申请号：US09517361

    申请日：2000-03-02

    申请人： Mohamed Ziauddin ,  Andrew Witkowski

    发明人： Mohamed Ziauddin ,  Andrew Witkowski

    IPC分类号： G06F1730

    CPC分类号： G06F17/30383 ,  Y10S707/99933

    摘要： Techniques are described which allow function-defined hierarchies to be registered with a database server. The information provided to the server during the registration process is used by the server to determine how to roll up data that has been aggregated at one level of a function-defined hierarchy to another level of the function-defined hierarchy. Techniques are also provided to perform rollup from one level of a function-defined hierarchy to another level of the function-defined hierarchy on data stored in a materialized view. Further, techniques are provided for rewriting queries that require aggregation at one level of a function-defined hierarchy to cause them to access data from a materialized view that stores data at a different level of the function-defined hierarchy.

    摘要翻译： 描述了允许将功能定义的层次结构注册到数据库服务器的技术。 在注册过程中提供给服务器的信息由服务器使用，以确定如何将已经在功能定义层次结构的一个级别聚合的数据汇总到功能定义层次结构的另一个级别。 还提供技术来从存储在物化视图中的数据执行从功能定义层级的一个级别到功能定义层次结构的另一级别的汇总。 此外，提供了用于重写需要在功能定义层次结构的一个级别进行聚合的查询的技术，以使得它们从存储在功能定义层次结构的不同级别的数据的物化视图访问数据。

    Automatic Recognition and Capture of SQL Execution Plans
    38.
    发明申请
    Automatic Recognition and Capture of SQL Execution Plans 有权
    自动识别和捕获SQL执行计划

    公开(公告)号：US20090106320A1

    公开(公告)日：2009-04-23

    申请号：US12188662

    申请日：2008-08-08

    申请人： Benoit Dageville ,  Dinesh Das ,  Mohamed Ziauddin

    发明人： Benoit Dageville ,  Dinesh Das ,  Mohamed Ziauddin

    IPC分类号： G06F17/30 ,  G06F9/44

    CPC分类号： G06F17/30469 ,  G06F17/30463

    摘要： Approaches, techniques, and mechanisms are disclosed for capturing and utilizing information related to query plans exhibiting interesting characteristics. A database server receives a request to execute a command. The database server executes the command according to a query plan. In response to determining that the command matches one or more pre-defined criteria, the database server captures information related to the execution of the first command. The criteria may include, for example, whether or not the command is repeatable, the existence of bind variables, access of a particular object, high resource utilization, receipt from a particular user, client, or application, etc. The information recorded may include, for example, performance statistics collected during execution of the first plan, data indicating the execution context during execution of the first plan, and properties of the first plan. The recorded information may subsequently be utilized by the database server in executing other database other database commands.

    摘要翻译： 公开了用于捕获和利用与显示有趣特征的查询计划相关的信息的方法，技术和机制。 数据库服务器接收执行命令的请求。 数据库服务器根据查询计划执行该命令。 响应于确定该命令匹配一个或多个预定义标准，数据库服务器捕获与执行第一命令有关的信息。 标准可以包括例如，命令是否可重复，绑定变量的存在，特定对象的访问，高资源利用率，来自特定用户，客户端或应用程序的接收等。所记录的信息可以包括 例如，在执行第一计划期间收集的性能统计数据，在执行第一计划期间指示执行上下文的数据以及第一计划的属性。 记录的信息随后可被数据库服务器用于执行其他数据库命令。

    Query optimizer cost model
    39.
    发明授权
    Query optimizer cost model 有权
    查询优化器成本模型

    公开(公告)号：US06957211B1

    公开(公告)日：2005-10-18

    申请号：US10139864

    申请日：2002-05-06

    申请人： Mikhail Tyulenev ,  Hakan Jakobsson ,  Mohamed Ziauddin

    发明人： Mikhail Tyulenev ,  Hakan Jakobsson ,  Mohamed Ziauddin

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30463 ,  Y10S707/99932

    摘要： An embodiment of the invention optimizes a DBMS operation based upon multiple criteria, such as input/outputs and CPU time. Multiple optimization criteria are normalized to a common unit of measurement. Normalized optimization criteria are used in a cost function. Estimated execution times are calculated under a variety of different workload environments. Cost values are scaled to a variety of computer architectures.

    摘要翻译： 本发明的实施例基于诸如输入/输出和CPU时间的多个标准优化DBMS操作。 多个优化标准被归一化为常用的测量单位。 规范化优化标准用于成本函数。 估计的执行时间是在各种不同的工作负载环境下计算的。 成本值被缩放到各种计算机体系结构。