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

1. 发明公开

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.

2. 发明授权

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）从连接索引添加连接返回条件到形成连接索引的基表。

3. 发明授权

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.
摘要翻译：通过使用虚拟连接索引和相关的覆盖非唯一次要索引来优化从计算机化数据库管理系统中的数据库检索数据。通过组合一个或多个常用的一个或多个表的列来创建虚拟连接索引。覆盖非唯一次要索引是通过组合虚拟连接索引的一个或多个常用列来生成的。生成覆盖的非唯一次要索引后，数据不会存储在虚拟连接索引中。此后，可以仅通过访问覆盖非唯一次要索引中的一个或多个来解决一些查询或其部分。

4. 发明授权

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.
摘要翻译：执行有序分析函数的查询包含一个指定创建动态分区的子句，其中该子句包含用于指定动态分区的分区条件。在处理查询期间，基于评估分区条件来识别动态分区。要识别动态分区，将创建第一个表，其中包含第一列以跟踪输入表的行，以指示分区条件是否为真。第一个表的第一列用于标识动态分区。

5. 发明授权

US07672926B2 Method and system for updating value correlation optimizations 有权
标题翻译：更新价值相关优化的方法和系统
公开(公告)号：US07672926B2
公开(公告)日：2010-03-02
申请号：US11837556
申请日：2007-08-13
申请人： Ahmad Said Ghazal , Paul Laurence Sinclair
发明人： Ahmad Said Ghazal , Paul Laurence Sinclair
IPC分类号： G06F17/30 , G06F17/45
CPC分类号： G06F17/30442 , G06F17/30477 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934
摘要： A method, computer program, and database system are disclosed for executing database queries. The database includes a first table (T1) having a primary key (PK) column and a first correlated value column (CV1) and a second table (T2) having a foreign key (FK) column related to the primary key column of the first table and a second correlated value column (CV2). One implementation of the method includes preparing a database query for execution based at least in part on application of a derived constraint rule (DCR) having the form, (PK=FK)→CV2+C1≦CV1≦CV2+C2, where C1 and C2 are constants and “→” means “implies,” to produce an execution plan. A frequency of errors due to changes in DCRs is taken into account when preparing the execution plan. The plan is then executed.
摘要翻译：公开了用于执行数据库查询的方法，计算机程序和数据库系统。该数据库包括具有主键（PK）列和第一相关值列（CV1）的第一表（T1）和具有与第一个对应关系的主键列相关的外键（FK）列的第二表（T2）表和第二个相关值列（CV2）。该方法的一个实施方式包括至少部分地基于应用具有形式（PK = FK）→CV2 + C1＆n1E; CV1＆n1E; CV2 + C2的导出约束规则（DCR）来准备用于执行的数据库查询，其中C1和 C2是常数，“→”表示“暗示”，以产生执行计划。在准备执行计划时，会考虑由于DCR的变化引起的错误频率。然后执行该计划。

6. 发明申请

US20090313211A1 PUSHING JOINS ACROSS A UNION 审中-公开
标题翻译：推动联盟
公开(公告)号：US20090313211A1
公开(公告)日：2009-12-17
申请号：US12140852
申请日：2008-06-17
申请人： Ahmad Said Ghazal , William Joseph McKenna
发明人： Ahmad Said Ghazal , William Joseph McKenna
IPC分类号： G06F17/30
CPC分类号： G06F16/24524
摘要： Selecting a join plan for a query containing a join and a union block includes determining whether to propose a join plan with the join pushed across the union block. A selection is made between a join plan in which the join is not pushed across the union block and any proposed join plan in which the join is pushed across the union block.
摘要翻译：为包含连接和联合块的查询选择连接计划包括确定是否通过跨联合块推送的连接提出连接计划。在连接不通过联合块阻止的连接计划之间进行选择，以及连接通过联合块推送的任何提议的连接计划。

7. 发明授权

US07272591B1 Method and system for updating value correlation optimizations 有权
标题翻译：更新价值相关优化的方法和系统
公开(公告)号：US07272591B1
公开(公告)日：2007-09-18
申请号：US10762735
申请日：2004-01-22
申请人： Ahmad Said Ghazal , Paul Laurence Sinclair
发明人： Ahmad Said Ghazal , Paul Laurence Sinclair
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/30442 , G06F17/30477 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934
摘要： A method, computer program, and database system are disclosed for executing database queries. The database includes a first table (T1) having a primary key (PK) column and a first correlated value column (CV1) and a second table (T2) having a foreign key (FK) column related to the primary key column of the first table and a second correlated value column (CV2). One implementation of the method includes preparing a database query for execution based at least in part on application of a derived constraint rule (DCR) having the form, (PK=FK)→CV2+C1≦CV1≦CV2+C2, where C1 and C2 are constants and “→” means “implies,” to produce an execution plan. Abort steps that are conditioned on changes in the DCR are also included in the execution plan. The plan is then executed.
摘要翻译：公开了用于执行数据库查询的方法，计算机程序和数据库系统。数据库包括具有主键（PK）列和第一相关值列（CV 1）的第一表（T 1）和具有与主键列相关的外键（FK）列的第二表（T 2）和第二相关值列（CV2）。该方法的一个实施方式包括至少部分地基于具有以下形式的导出约束规则（DCR）的应用来准备用于执行的数据库查询：（PK = FK）→CV 2 + C < 1> 1 <= CV 1 = = CV 2 + C 2 其中C 1 < 和C 2是常数，“ - >”表示“暗示”，以产生执行计划。执行计划中也包括根据DCR更改限制的中止步骤。然后执行该计划。

8. 发明授权

US06662175B1 Semantic query optimization using value correlation 有权
标题翻译：使用价值相关的语义查询优化
公开(公告)号：US06662175B1
公开(公告)日：2003-12-09
申请号：US09850765
申请日：2001-05-08
申请人： Ahmad Said Ghazal , Paul Laurence Sinclair
发明人： Ahmad Said Ghazal , Paul Laurence Sinclair
IPC分类号： G06F1730
CPC分类号： G06F17/30454 , G06F17/30463 , Y10S707/99932
摘要： A method and computer system for optimizing queries to a database are disclosed. The database includes a first table (T1) having a primary key (PK) column and a first correlated value column (CV1) and a second table (T2) having a foreign key (FK) column related to the primary key column of the first table and a second correlated value column (CV2). The method includes joining T1 to the T2 using PK=FK as the join condition to produce a join result having rows. Each row includes a value from CV1 and a value from CV2. The method further includes creating an initial running constraint (RC). The initial running constraint includes a null range. The method further includes producing a derived constraint rule (DCR) having the following form: (PK=FK)→CV2+C1≦CV1≦CV2+C2 where C1 and C2 are constants, and “→” means “implies,” by performing the following processing for each row in the join result: computing a new constraint (NEW), having a range, and modifying RC by merging the range of NEW with the range of RC.
摘要翻译：公开了一种用于优化对数据库的查询的方法和计算机系统。该数据库包括具有主键（PK）列和第一相关值列（CV1）的第一表（T1）和具有与第一个对应关系的主键列相关的外键（FK）列的第二表（T2）表和第二个相关值列（CV2）。该方法包括使用PK = FK作为连接条件将T1连接到T2，以产生具有行的连接结果。每行包括CV1的值和来自CV2的值。该方法还包括创建初始运行约束（RC）。初始运行约束包括空范围。该方法还包括产生具有以下形式的派生约束规则（DCR）：其中C1和C2是常数，“ - >”表示“暗示”，通过对连接结果中的每一行执行以下处理：计算新的约束（NEW），具有范围，并通过将NEW的范围与RC的范围合并来修改RC。

9. 发明授权

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子句的第一级分区以产生修改的查询。在另一种情况下，与处理查询相关联的行每行都拆分，然后至少部分地基于外连接谓词的属性进行散列。执行左外连接并处理全局聚合以产生假脱机表以处理查询。

10. 发明授权

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.
摘要翻译：公开了一种用于处理包括一个或多个表达式的数据库查询的方法，计算机程序和数据库系统。该方法包括在一个或多个表达式中解析列。对一个或多个表达式执行表达式优化。之后，进一步查询优化。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式