-
公开(公告)号：US20070028158A1
公开(公告)日：2007-02-01
申请号：US11193346
申请日：2005-08-01
申请人： Dragan Djorovich , Matthew Jakubiak , Suresh Kannan , Brahmesh Puttannaiah , Natascha Kearsey , Chris Evans , Stephen Cave
发明人： Dragan Djorovich , Matthew Jakubiak , Suresh Kannan , Brahmesh Puttannaiah , Natascha Kearsey , Chris Evans , Stephen Cave
CPC分类号： G06Q10/10 , G06F16/2425
摘要： A process definition method is disclosed. The method is typically for use with a report compiled from source data stored in a database and displayed to a user as a table having a plurality of cells. The method comprises: a) presenting the table of cells to the user; b) selecting one of the plurality of cells; and c) defining a drill out function associated with that cell.
摘要翻译： 公开了一种流程定义方法。 该方法通常用于从存储在数据库中的源数据编译的报告，并将其作为具有多个单元格的表显示给用户。 该方法包括：a）向用户呈现单元格表; b）选择所述多个单元中的一个; 和c）定义与该单元相关联的钻孔功能。
-
公开(公告)号：US07370062B2
公开(公告)日：2008-05-06
申请号：US10673394
申请日：2003-09-30
申请人： Christopher Evans , Paolo Fragapane , Stephen Cave , James Steadman , Andrew Osborn , Kathryn Nash
发明人： Christopher Evans , Paolo Fragapane , Stephen Cave , James Steadman , Andrew Osborn , Kathryn Nash
IPC分类号： G06F17/30
CPC分类号： G06F17/30454 , G06F17/303 , G06F17/30466 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99942 , Y10S707/99945
摘要： A method of rewriting a Structured Query Language (SQL) statement in order to prevent processing of a join between a master table and a detail table in a database is disclosed. The method includes determining in the SQL statement a unique identifier to a row of the master table. The unique identifier is then equated to an identifier to related rows of the detail table using the join condition. A revised SQL statement may then be produced that only refers to the detail table using the identifier to the rows of the detail table. Subsequently, the revised SQL statement is processed.
摘要翻译： 公开了一种重写结构化查询语言（SQL）语句以防止处理数据库中的主表和详细表之间的连接的方法。 该方法包括在SQL语句中确定主表的行的唯一标识符。 然后使用连接条件将唯一标识符等同于详细表的相关行的标识符。 然后可以产生修改后的SQL语句，该SQL语句仅将详细信息表使用到详细表的行的标识符。 随后，修改的SQL语句被处理。
-
公开(公告)号：US07725457B2
公开(公告)日：2010-05-25
申请号：US10739338
申请日：2003-12-19
CPC分类号： G06F17/30454
摘要： A method of modifying a Structured Query Language (SQL) statement in order to reduce the number of joins executed by a database is disclosed. The method includes presenting the SQL statement to the database and identifying joins in the SQL statement for removal in accordance with one or more predetermined criteria. For each identified join, the SQL statement may be modified so as to remove the identified join and to change references to a first instance of a table which is referred to by the identified join to a second instance of the table.
摘要翻译： 公开了一种修改结构化查询语言（SQL）语句以减少数据库执行的连接数量的方法。 该方法包括将SQL语句呈现给数据库，并根据一个或多个预定标准识别SQL语句中的连接以进行删除。 对于每个已标识的连接，可以修改SQL语句，以便删除所标识的连接，并将对由标识的连接引用的表的第一个实例的引用更改为表的第二个实例。
-
公开(公告)号：US20050076007A1
公开(公告)日：2005-04-07
申请号：US10739338
申请日：2003-12-19
IPC分类号： G06F17/30
CPC分类号： G06F17/30454
摘要： A method of modifying a Structured Query Language (SQL) statement in order to reduce the number of joins executed by a database is described. The method comprises: a) presenting the SQL statement to the database; b) identifying joins in the SQL statement for removal in accordance with one or more predetermined criteria; and c) for each identified join, modifying the SQL statement so as to remove the identified join and to change references to a first instance of a table which is referred to by the identified join to a second instance of the table.
摘要翻译： 描述了一种修改结构化查询语言（SQL）语句以减少数据库执行的连接数量的方法。 该方法包括：a）将SQL语句呈现给数据库; b）根据一个或多个预定标准识别SQL语句中的连接以便移除; 和c）对于每个已标识的连接，修改SQL语句以便删除所标识的连接，并将对所标识的连接引用的表的第一个实例的引用更改为表的第二个实例。
-
-
-
搜索结果
4 条记录 (耗时 0.022 秒)
