公开(公告)号：US20090300586A1

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

申请号：US12129304

申请日：2008-05-29

申请人： Fausto Bernardini ,  Jarir K. Chaar ,  Yi-Min Chee ,  Joseph P. Huchel ,  Thomas A. Jobson, JR. ,  Daniel V. Oppenheim ,  Krishna C. Ratakonda

发明人： Fausto Bernardini ,  Jarir K. Chaar ,  Yi-Min Chee ,  Joseph P. Huchel ,  Thomas A. Jobson, JR. ,  Daniel V. Oppenheim ,  Krishna C. Ratakonda

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.

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

公开(公告)号：US20100017252A1

公开(公告)日：2010-01-21

申请号：US12173175

申请日：2008-07-15

申请人： Jarir K. Chaar ,  Joseph P. Huchel ,  Thomas A. Jobson, JR. ,  Daniel V. Oppenheim ,  Krishina C. Ratakonda

发明人： Jarir K. Chaar ,  Joseph P. Huchel ,  Thomas A. Jobson, JR. ,  Daniel V. Oppenheim ,  Krishina C. Ratakonda

IPC分类号： G06Q10/00 ,  G06Q50/00

CPC分类号： G06F8/70 ,  G06Q10/06 ,  G06Q10/0631 ,  G06Q10/0637 ,  Y02P90/86

摘要： A method, system, and computer-readable medium for maintaining a project schedule of projects being executed within a software factory are presented. A project management tool receives alerts from the software factory as completion statuses, of software packets being used within the software factory, change. These alerts enable a consolidated and coordinated updating of the project schedule.

摘要翻译： 提出了一种用于维护在软件工厂内执行的项目的项目进度表的方法，系统和计算机可读介质。 项目管理工具从软件工厂收到软件工厂内使用的软件包的完成状态的更改。 这些警报可以对项目进度进行统一和协调的更新。

公开(公告)号：US20120185461A1

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

申请号：US13425524

申请日：2012-03-21

申请人： Howard S. Bloom ,  Roy Froehlich ,  Thomas A. Jobson, JR. ,  Edith A. Kanyock ,  Charles F. Matula ,  Arnold M. Rosenberg

发明人： Howard S. Bloom ,  Roy Froehlich ,  Thomas A. Jobson, JR. ,  Edith A. Kanyock ,  Charles F. Matula ,  Arnold M. Rosenberg

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语句的单独部分进行搜索的结果，并将其与该组临时表相结合。 来自新临时表的所有结果都合并成一个单独的结果表。