STAGED AUTOMATED VALIDATION OF WORK PACKETS INPUTS AND DELIVERABLES IN A SOFTWARE FACTORY
    2.
    发明申请
    STAGED AUTOMATED VALIDATION OF WORK PACKETS INPUTS AND DELIVERABLES IN A SOFTWARE FACTORY 失效
    工厂包装盒自动验证软件工厂中的输入和输出

    公开(公告)号:US20090300586A1

    公开(公告)日:2009-12-03

    申请号:US12129304

    申请日:2008-05-29

    IPC分类号: G06F9/44

    CPC分类号: G06F8/61 G06F8/36 G06Q10/06

    摘要: A method, system, and computer-readable medium for staged validation of work packets within a software factory are presented. In one embodiment, the method includes creating a preliminary work packet. A validation constraint is appended to the preliminary work packet to create a constrained work packet. The constrained work packet is submitted to the software factory, within which the validation constraint is validated at different stages to confirm that the validation constraint is proper for the constrained work packet. If a validation result fails to meet all requirements of the validation constraint at each stage, the validation constraint is resolved, and the constrained work packet is re-submitted at that stage.

    摘要翻译: 提出了一种用于软件工厂内工作包分阶段验证的方法,系统和计算机可读介质。 在一个实施例中,该方法包括创建初步工作包。 验证约束附加到初步工作包以创建受约束的工作包。 受约束的工作包被提交给软件工厂,其中验证约束在不同阶段被验证,以确认验证约束适用于约束工作包。 如果验证结果不能满足每个阶段的验证约束的所有要求,则解决验证约束,并且在该阶段重新提交约束的工作包。

    METHOD, SYSTEM AND PROGRAM PRODUCT FOR REWRITING STRUCTURED QUERY LANGUAGE (SQL) STATEMENTS
    3.
    发明申请
    METHOD, SYSTEM AND PROGRAM PRODUCT FOR REWRITING STRUCTURED QUERY LANGUAGE (SQL) STATEMENTS 失效
    用于重构结构化查询语言(SQL)语句的方法,系统和程序产品

    公开(公告)号:US20120185461A1

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

    申请号:US13425524

    申请日:2012-03-21

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30463

    摘要: A method and system for rewriting Structured Query Language (SQL) statements. A SQL statement having search criteria including conditions pertaining to fields in database tables is received. A table from the SQL statement listing all combinations of the search criteria is created, every combination reflecting a subset of information used to determine combined results. A set of patterns among the possible combinations of the SQL statement based on the fields referenced in the combinations is identified. The table based on the set of patterns is sorted. Based on the sorting, the table is divided into temporary tables which are joined with the SQL statement. New temporary tables are generated. Each new temporary table includes results of a search conducted using a separate portion of the SQL statement as joined with the set of temporary tables. All results from the new temporary tables are combined into a single result table.

    摘要翻译: 用于重写结构化查询语言(SQL)语句的方法和系统。 接收到具有搜索条件的SQL语句,包括与数据库表中的字段有关的条件。 创建来自列出所有搜索条件组合的SQL语句的表,每个组合反映用于确定组合结果的信息子集。 识别基于组合中引用的字段的SQL语句的可能组合中的一组模式。 基于一组模式的表被排序。 基于排序,表分为与SQL语句相连的临时表。 生成新的临时表。 每个新的临时表包括使用SQL语句的单独部分进行搜索的结果,并将其与该组临时表相结合。 来自新临时表的所有结果都合并成一个单独的结果表。