专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US08943040B1 Using a table to track whether a dynamic partitioning condition evaluates to true 有权
标题翻译：使用表来跟踪动态分区条件是否为true
公开(公告)号：US08943040B1
公开(公告)日：2015-01-27
申请号：US12731787
申请日：2010-03-25
申请人： Ambuj Shatdal , B. Anantha Subramanian , Ahmad Said Ghazal
发明人： Ambuj Shatdal , B. Anantha Subramanian , Ahmad Said Ghazal
IPC分类号： G06F17/30
CPC分类号： G06F17/30486 , Y10S707/968
摘要： A query to perform an ordered analytic function contains a clause specifying creation of dynamic partitions, where the clause contains a partitioning condition to specify the dynamic partitions. During processing of the query, dynamic partitions are identified based on evaluating the partitioning condition. To identify the dynamic partitions, a first table is created that contains a first column to track rows of an input table for indicating whether the partitioning condition evaluates to true. The first column of the first table is used to identify the dynamic partitions.
摘要翻译：执行有序分析函数的查询包含一个指定创建动态分区的子句，其中该子句包含用于指定动态分区的分区条件。在处理查询期间，基于评估分区条件来识别动态分区。要识别动态分区，将创建第一个表，其中包含第一列以跟踪输入表的行，以指示分区条件是否为真。第一个表的第一列用于标识动态分区。

2. 发明公开

US20240202576A1 METHODS AND SYSTEMS FOR FACILITATING FEATURE ENGINEERING FOR MACHINE LEARNING MODELS 审中-公开
公开(公告)号：US20240202576A1
公开(公告)日：2024-06-20
申请号：US18080929
申请日：2022-12-14
申请人： Ahmad Said Ghazal , Hanumath Rao Maduri , Olli Pekka Kostamaa
发明人： Ahmad Said Ghazal , Hanumath Rao Maduri , Olli Pekka Kostamaa
IPC分类号： G06N20/00 , G06F16/953
CPC分类号： G06N20/00 , G06F16/953
摘要： A system for facilitating feature engineering for machine learning models. Further, the system comprises a communication device, a processing device, and a storage device. Further, the communication device receives a request from a client device. Further, the communication device transmits a result to the client device. Further, the processing device analyzes the request. Further, the processing device determines an operation for facilitating feature engineering for a machine learning model based on the analyzing. Further, the processing device identifies a data source associated with the machine learning model based on the determining. Further, the processing device analyzes the raw data source. Further, the processing device performs an operation using an engine based on the determining, the analyzing of the request, and the analyzing of the raw data source. Further, the processing device generates the result based on the performing. Further, the storage device stores the result in a database.

3. 发明授权

US06643636B1 Optimizing a query using a non-covering join index 有权
标题翻译：使用非覆盖连接索引优化查询
公开(公告)号：US06643636B1
公开(公告)日：2003-11-04
申请号：US09874804
申请日：2001-06-05
申请人： Grace Kwan-On Au , Ahmad Said Ghazal , Paul Laurence Sinclair
发明人： Grace Kwan-On Au , Ahmad Said Ghazal , Paul Laurence Sinclair
IPC分类号： G06F1730
CPC分类号： G06F17/30469 , G06F17/30454 , Y10S707/99932
摘要： A method, database system and computer program are disclosed for optimizing a SQL query, in which the SQL query includes a WHERE clause and a FROM clause. An evaluation is done to determine whether a non-covering join index partially but not completely covers the query. If it does, the join index is added to the FROM clause of the query without removing the partially covered base tables and the WHERE clause of the query is modified by: (1) mapping a query condition to the join index for its partially covered base tables; and (2) adding a join back condition from the join index to a base table from which the join index was formed.
摘要翻译：公开了用于优化SQL查询的方法，数据库系统和计算机程序，其中SQL查询包括WHERE子句和FROM子句。进行评估以确定是否部分但不完全覆盖查询的非覆盖连接索引。如果是，则将连接索引添加到查询的FROM子句中，而不删除部分覆盖的基表，并且通过以下方式修改查询的WHERE子句：（1）将查询条件映射到其部分覆盖的基础的连接索引桌子和（2）从连接索引添加连接返回条件到形成连接索引的基表。

4. 发明授权

US06505188B1 Virtual join index for relational databases 有权
标题翻译：关系数据库的虚拟连接索引
公开(公告)号：US06505188B1
公开(公告)日：2003-01-07
申请号：US09594963
申请日：2000-06-15
申请人： Ahmad Said Ghazal , Paul Laurence Sinclair , Chi Kim Hoang
发明人： Ahmad Said Ghazal , Paul Laurence Sinclair , Chi Kim Hoang
IPC分类号： G06F1730
CPC分类号： G06F17/30498 , G06F17/30501 , Y10S707/954 , Y10S707/99932
摘要： The retrieval of data from a database in a computerized database management system is optimized through the use of a virtual join index and associated covering non-unique secondary indexes. The virtual join index is created by combining one or more commonly-used columns of one or more tables. The covering non-unique secondary indexes are generating by combining one or more commonly-used columns of the virtual join index. Data is not stored in the virtual join index after the covering non-unique secondary indexes are generated. Thereafter, some queries or portions thereof may be resolved solely by accessing one or more of the covering non-unique secondary indexes.
摘要翻译：通过使用虚拟连接索引和相关的覆盖非唯一次要索引来优化从计算机化数据库管理系统中的数据库检索数据。通过组合一个或多个常用的一个或多个表的列来创建虚拟连接索引。覆盖非唯一次要索引是通过组合虚拟连接索引的一个或多个常用列来生成的。生成覆盖的非唯一次要索引后，数据不会存储在虚拟连接索引中。此后，可以仅通过访问覆盖非唯一次要索引中的一个或多个来解决一些查询或其部分。

5. 发明授权

US08768916B1 Multi level partitioning a fact table 有权
标题翻译：多级划分事实表
公开(公告)号：US08768916B1
公开(公告)日：2014-07-01
申请号：US13332695
申请日：2011-12-21
申请人： Ahmad Said Ghazal
发明人： Ahmad Said Ghazal
IPC分类号： G06F17/30
CPC分类号： G06F17/30584 , G06F17/30339 , G06F17/30592
摘要： Inputs are received. The inputs are a star schema data model comprising a non-partitioned fact table (F) comprising fields (f1, f2, . . . fn); a set of queries (Q=q1, q2, . . . qm); and a set of weights for each query in Q. Each weight defines the priority of a respective query in a workload. The inputs are pre-processed to produce a most-granular-partitioning. The most-granular-partitioning is processed to produce an initial multi-level partitioned primary index, the processing including determining the scan cost of one of the queries in Q. The initial multi-level partitioned primary index is processed to produce a final multi-level partitioned primary index, the processing including determining the query cost of one of the queries in Q. F is partitioned using the final multi-level partitioned primary index. A query from Q is run against F to produce a result. The result is stored.
摘要翻译：接收到输入。输入是包括包括字段（f1，f2，...，fn）的非分割事实表（F）的星型模式数据模型; 一组查询（Q = q1，q2，...，qm）; 以及Q中每个查询的一组权重。每个权重定义工作负载中相应查询的优先级。输入被预处理以产生最细粒度的分区。处理最细粒度分割以产生初始多级分区主索引，该处理包括确定Q中的查询之一的扫描成本。处理初始多级分区主索引以产生最终多分区主索引，使用最终的多级分区主索引对处理包括确定Q中的查询之一的查询成本进行分区。来自Q的查询针对F运行以产生结果。结果存储。

6. 发明申请

US20130173589A1 TECHNIQUES FOR OPTIMIZING OUTER JOINS 有权
标题翻译：优化外部接口的技术
公开(公告)号：US20130173589A1
公开(公告)日：2013-07-04
申请号：US13340300
申请日：2011-12-29
申请人： Yu Xu , Ahmad Said Ghazal
发明人： Yu Xu , Ahmad Said Ghazal
IPC分类号： G06F17/30
CPC分类号： G06F17/30489 , G06F17/30466
摘要： Techniques for optimizing outer joins in database operations are provided. In an embodiment, a query having an outer join with a GROUP BY clause is rewritten and expanded to expand a first level partition of that GROUP BY clause to produce a modified query. In another situation, rows associated with processing a query are each row split and then hashed based at least in part on attributes of the outer join predicate. A left outer join is performed and a global aggregation processed to produce a spooled table to process the query.
摘要翻译：提供了在数据库操作中优化外连接的技术。在一个实施例中，具有与GROUP BY子句的外连接的查询被重写和扩展，以扩展该GROUP BY子句的第一级分区以产生修改的查询。在另一种情况下，与处理查询相关联的行每行都拆分，然后至少部分地基于外连接谓词的属性进行散列。执行左外连接并处理全局聚合以产生假脱机表以处理查询。

7. 发明授权

US07321891B1 Processing database queries 有权
标题翻译：处理数据库查询
公开(公告)号：US07321891B1
公开(公告)日：2008-01-22
申请号：US10782422
申请日：2004-02-19
申请人： Ahmad Said Ghazal
发明人： Ahmad Said Ghazal
IPC分类号： G06F17/30
CPC分类号： G06F17/30448 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935 , Y10S707/99936 , Y10S707/99939 , Y10S707/99945
摘要： Methods, computer programs, and database systems for analyzing one or more queries are disclosed. Queries may include one or more conditions and one or more sub-queries, with each sub-queries introduced by connecting condition. The method determines the satisfiability of the query, including the satisfiability of the connecting conditions and conditions in the sub-queries. Queries may include one or more conditions of the form (X+Y OP C). The method determines the satisfiability of the query, including the satisfiability of the conditions of the form (X+Y OP C).
摘要翻译：公开了用于分析一个或多个查询的方法，计算机程序和数据库系统。查询可以包括一个或多个条件和一个或多个子查询，每个子查询通过连接条件引入。该方法确定查询的可满足性，包括子查询中连接条件和条件的可满足性。查询可能包含一种或多种形式的条件（X + Y OP C）。该方法确定查询的可满足性，包括表单条件（X + Y OP C）的可满足性。

8. 发明授权

US08868545B2 Techniques for optimizing outer joins 有权
标题翻译：优化外连接的技术
公开(公告)号：US08868545B2
公开(公告)日：2014-10-21
申请号：US13340300
申请日：2011-12-29
申请人： Yu Xu , Ahmad Said Ghazal
发明人： Yu Xu , Ahmad Said Ghazal
IPC分类号： G06F17/30
CPC分类号： G06F17/30489 , G06F17/30466
摘要： Techniques for optimizing outer joins in database operations are provided. In an embodiment, a query having an outer join with a GROUP BY clause is rewritten and expanded to expand a first level partition of that GROUP BY clause to produce a modified query. In another situation, rows associated with processing a query are each row split and then hashed based at least in part on attributes of the outer join predicate. A left outer join is performed and a global aggregation processed to produce a spooled table to process the query.
摘要翻译：提供了在数据库操作中优化外连接的技术。在一个实施例中，具有与GROUP BY子句的外连接的查询被重写和扩展，以扩展该GROUP BY子句的第一级分区以产生修改的查询。在另一种情况下，与处理查询相关联的行每行都拆分，然后至少部分地基于外连接谓词的属性进行散列。执行左外连接并处理全局聚合以产生假脱机表以处理查询。

9. 发明授权

US08140521B1 Performing SQL query optimization by simplifying sub-expressions 有权
标题翻译：通过简化子表达式执行SQL查询优化
公开(公告)号：US08140521B1
公开(公告)日：2012-03-20
申请号：US10800493
申请日：2004-03-15
申请人： Stephen Fife Sheldon , Arthur Vargas Lopes , Grace Kwan-On Au , Ahmad Said Ghazal
发明人： Stephen Fife Sheldon , Arthur Vargas Lopes , Grace Kwan-On Au , Ahmad Said Ghazal
IPC分类号： G06F7/00
CPC分类号： G06F17/3046
摘要： A method, computer program, and database system are disclosed for processing a database query that includes one or more expressions. The method includes resolving columns in one or more of the expressions. Expression optimization is performed on one or more of the expressions. Afterward, further query optimization is performed.
摘要翻译：公开了一种用于处理包括一个或多个表达式的数据库查询的方法，计算机程序和数据库系统。该方法包括在一个或多个表达式中解析列。对一个或多个表达式执行表达式优化。之后，进一步查询优化。

10. 发明授权

US07127457B1 Method and system for executing database queries 有权
标题翻译：执行数据库查询的方法和系统
公开(公告)号：US07127457B1
公开(公告)日：2006-10-24
申请号：US10696333
申请日：2003-10-29
申请人： Ahmad Said Ghazal
发明人： Ahmad Said Ghazal
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/30463 , Y10S707/99933 , Y10S707/99934
摘要： A method, computer program, and computer network are disclosed for executing database queries. The method includes identifying a first set of conditions corresponding to a selected step for executing a query. A second set of conditions corresponding to one or more steps for executing the query that feed the selected step is identified. Each condition in the first set is checked for mathematical redundancy, including redundancy without equivalency, with regard to the other conditions in the union of the conditions corresponding to the selected step and the conditions in the second set. Each condition in the first set that is redundant is included in a third set. If there is only one condition in the third set, an identifier of the one condition is stored.
摘要翻译：公开了一种用于执行数据库查询的方法，计算机程序和计算机网络。该方法包括识别与用于执行查询的所选择的步骤相对应的第一组条件。识别与用于执行供给所选步骤的查询的一个或多个步骤相对应的第二组条件。对于与所选择的步骤对应的条件和第二组中的条件的并集的其他条件，第一组中的每个条件被检查数学冗余，包括无等效的冗余。第一组中的多余的每个条件都包含在第三组中。如果第三组中只有一个条件，则存储一个条件的标识符。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式