公开(公告)号：US09880815B2

公开(公告)日：2018-01-30

申请号：US13746895

申请日：2013-01-22

Applicant: Grzegorz Roman Pusz ,  Neil Thomson

Inventor： Grzegorz Roman Pusz ,  Neil Thomson

IPC: G06F9/44 ,  G06F17/30

CPC classification number: G06F8/34 ,  G06F8/73 ,  G06F17/30398

Abstract: A SQL Visualizer including means for transforming a textual SQL statement into a graphical diagram which represents the textual SQL statement.

公开(公告)号：US20160019199A1

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

申请号：US14515951

申请日：2014-10-16

Applicant: Neil Thomson ,  Grzegorz R. Pusz ,  Pawel Hubczak ,  Jaroslaw Jerzy Balinski

Inventor： Neil Thomson ,  Grzegorz R. Pusz ,  Pawel Hubczak ,  Jaroslaw Jerzy Balinski

IPC: G06F17/24 ,  G06F3/0486 ,  G06F3/0484 ,  G06F3/0481 ,  G06F3/0482

CPC classification number: G06F3/04817 ,  G06F3/048 ,  G06F3/0482 ,  G06F3/0486 ,  G06F8/20 ,  G06F8/34 ,  G06F17/246

Abstract: A rules editor for creating rules for a software application. The editor is suitable for running on a computing device having at least a processor, a memory, a display device and an input device. The editor includes a graphical editor for: retrieving from the memory and displaying on the display device one or more graphical icons; and enabling a user to select and arrange at least some of the icons on the display device using the input device so as to form a graphical representation of a rule to be processed by the software application. The editor includes a spreadsheet editor for displaying on the display device one or more spreadsheets forming a spreadsheet representation of rules to be processed by the software application, and enabling the user to edit the spreadsheet representation. The processor is arranged to automatically maintain the graphical and spreadsheet representations synchronized following amendment of the graphical representation in the graphical editor or amendment of the spreadsheet representation in the spreadsheet editor.

Abstract translation: 用于为软件应用程序创建规则的规则编辑器。 编辑器适用于至少具有处理器，存储器，显示设备和输入设备的计算设备上的运行。 编辑器包括图形编辑器，用于从存储器检索并在显示设备上显示一个或多个图形图标; 并且使得用户能够使用所述输入设备来选择和布置所述显示设备上的至少一些所述图标，以便形成要由所述软件应用程序处理的规则的图形表示。 编辑器包括用于在显示设备上显示一个或多个电子表格的电子表格编辑器，其形成由软件应用程序处理的规则的电子表格表示，以及使用户能够编辑电子表格表示。 处理器被布置为在图形编辑器中的图形表示修改之后自动维护图形和电子表格表示，在电子表格编辑器中修改电子表格表示。

公开(公告)号：US20160018952A1

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

申请号：US14521754

申请日：2014-10-23

Applicant: Neil Thomson ,  Grzegorz R. Pusz ,  Sebastian Oktawiusz Mlynarczyk

Inventor： Neil Thomson ,  Grzegorz R. Pusz ,  Sebastian Oktawiusz Mlynarczyk

IPC: G06F3/0481 ,  G06F3/0484

CPC classification number: G06F3/04817 ,  G06F3/048 ,  G06F3/0482 ,  G06F3/0486 ,  G06F8/20 ,  G06F8/34 ,  G06F17/246

Abstract: A multi-format editor for creating a software application. The editor is suitable for running on a computing device having at least a processor, a memory, a display device and an input device. The editor comprises a graphical editor for: retrieving from the memory and displaying on said display device a number of graphical elements; and enabling a user to select and arrange at least some of the graphical elements on the display device using the input device so as to form a graphical representation of a process to be performed by the software application. The editor further includes a textual editor for displaying on the display device a textual representation of computer instructions describing a process to be performed by the software application, and enabling the user to edit the textual representation. The processor is arranged to automatically maintain the graphical and textual representations synchronized following amendment of the graphical representation in the graphical editor or amendment of the textual representation in the textual editor.

Abstract translation: 用于创建软件应用程序的多格式编辑器。 编辑器适用于至少具有处理器，存储器，显示设备和输入设备的计算设备上的运行。 编辑器包括图形编辑器，用于从存储器检索并在所述显示设备上显示多个图形元素; 并且使得用户能够使用所述输入设备来选择和布置所述显示设备上的至少一些所述图形元素，以形成由所述软件应用执行的处理的图形表示。 编辑器还包括文本编辑器，用于在显示设备上显示描述由软件应用程序执行的过程的计算机指令的文本表示，并使用户能够编辑文本表示。 处理器被布置为在图形编辑器中的图形表示的修改或文本编辑器中的文本表示的修改之后自动保持图形和文本表示同步。

公开(公告)号：US08392473B2

公开(公告)日：2013-03-05

申请号：US12876587

申请日：2010-09-07

Applicant: Neil Thomson ,  Grzegorz Roman Pusz

Inventor： Neil Thomson ,  Grzegorz Roman Pusz

IPC: G06F12/00 ,  G06F17/30

CPC classification number: G06F17/30392 ,  G06F17/30554

Abstract: A method of generating computer instructions for creating instances of a hierarchical data format from a flat record stream, the flat record stream containing data in a flat format and containing at least some data redundancy. The method uses a computing device having at least a processor, a memory, a display device and an input device. The method includes allowing a developer to use the input device to create a graphical representation of the hierarchical data format, and allowing a developer to use the input device to create a graphical representation of a mapping between the flat format and the hierarchical format. The method further includes generating, at the processor, computer instructions which when executed on a computer cause the computer to create from the flat record stream instances of the hierarchical format, wherein the instances of the hierarchical format remove the data redundancy.

Abstract translation: 一种从平面记录流生成分层数据格式实例的计算机指令的方法，平坦记录流包含平面格式的数据并且至少包含一些数据冗余。 该方法使用至少具有处理器，存储器，显示装置和输入装置的计算装置。 该方法包括允许开发者使用输入设备来创建分层数据格式的图形表示，并且允许开发者使用输入设备来创建平面格式和分层格式之间的映射的图形表示。 该方法还包括在处理器处生成当在计算机上执行时计算机使计算机从平面记录流的分层格式实例创建计算机指令，其中分层格式的实例消除数据冗余。

公开(公告)号：US08392013B2

公开(公告)日：2013-03-05

申请号：US11341156

申请日：2006-01-27

Applicant: Neil Thomson ,  Grzegorz R. Pusz

Inventor： Neil Thomson ,  Grzegorz R. Pusz

IPC: G06F19/00 ,  G06F3/048 ,  G06Q10/00 ,  G06G7/48

CPC classification number: G06Q10/10 ,  G06F8/34 ,  G06F9/4494

Abstract: A method for automating a process includes the following steps: providing a user interface which graphically presents a plurality of icons to a user, wherein each icon represents an operation step having at least one input and at least one output; enabling the user to select one or more of the icons; enabling the user to form connections between the selected icons to represent data flow between the operation steps represented by the icons; and generating computer instructions for executing the operation steps corresponding to the selected icons, and in accordance with the connections, in such a way that each operation step can only be executed when data is present at all of its inputs, and cannot be executed when data is absent at any one of its inputs.

Abstract translation: 一种用于自动化过程的方法包括以下步骤：提供向用户图形地呈现多个图标的用户界面，其中每个图标表示具有至少一个输入和至少一个输出的操作步骤; 使用户能够选择一个或多个图标; 使用户能够在所选图标之间形成连接，以表示由图标表示的操作步骤之间的数据流; 以及生成用于执行与所选择的图标相对应的操作步骤的计算机指令，并且根据连接，使得每个操作步骤只能在数据存在于其所有输入时执行，并且当数据 没有任何一个输入。

公开(公告)号：US20120059863A1

公开(公告)日：2012-03-08

申请号：US12876587

申请日：2010-09-07

Applicant: Neil Thomson ,  Grzegorz Roman Pusz

Inventor： Neil Thomson ,  Grzegorz Roman Pusz

IPC: G06F17/30

CPC classification number: G06F17/30392 ,  G06F17/30554

Abstract: A method of generating computer instructions for creating instances of a hierarchical data format from a flat record stream, the flat record stream containing data in a flat format and containing at least some data redundancy. The method uses a computing device having at least a processor, a memory, a display device and an input device. The method includes allowing a developer to use the input device to create a graphical representation of the hierarchical data format, and allowing a developer to use the input device to create a graphical representation of a mapping between the flat format and the hierarchical format. The method further includes generating, at the processor, computer instructions which when executed on a computer cause the computer to create from the flat record stream instances of the hierarchical format, wherein the instances of the hierarchical format remove the data redundancy.

Abstract translation: 一种从平面记录流生成分层数据格式实例的计算机指令的方法，平坦记录流包含平面格式的数据并且至少包含一些数据冗余。 该方法使用至少具有处理器，存储器，显示装置和输入装置的计算装置。 该方法包括允许开发者使用输入设备来创建分层数据格式的图形表示，并且允许开发者使用输入设备来创建平面格式和分层格式之间的映射的图形表示。 该方法还包括在处理器处生成当在计算机上执行时计算机使计算机从平面记录流的分层格式实例创建计算机指令，其中分层格式的实例消除数据冗余。

公开(公告)号：US20110161941A1

公开(公告)日：2011-06-30

申请号：US12648617

申请日：2009-12-29

Applicant: Neil Thomson ,  Grzegorz Roman Pusz

Inventor： Neil Thomson ,  Grzegorz Roman Pusz

IPC: G06F3/048 ,  G06F17/00 ,  G06F9/45 ,  G06F15/16

CPC classification number: G06F8/38 ,  G06F8/34

Abstract: A method of creating a form-based application using a computing device having at least a processor, a memory, a display device and an input device, includes: retrieving from the memory and providing on the display device a number of form icons, each form icon representing a form to be displayed to a user of the application; retrieving from the memory and providing on the display device a number of service icons, each service icon representing a service which may be called in response to actions of the user; allowing a developer of the application to use the input device to select one or more of the form icons and one or more of the service icons and to arrange the selected icons on a display; allowing the developer to use the input device to arrange links between the selected icons, wherein the links together with the selected icons form an Application Diagram which represents the navigation of a user of the application between the forms and services represented by the selected form and service icons respectively; and compiling, at the processor, the application on the basis of the Application Diagram.

Abstract translation: 使用具有至少处理器，存储器，显示设备和输入设备的计算设备来创建基于表单的应用的方法包括：从存储器检索并在显示设备上提供多个表单图标，每种形式 图标表示要向应用的用户显示的表单; 从存储器检索并在显示设备上提供多个服务图标，每个服务图标表示可以响应于用户的动作而被调用的服务; 允许应用的开发者使用输入设备来选择一个或多个表单图标和一个或多个服务图标，并将所选择的图标排列在显示器上; 允许开发者使用输入设备来布置所选择的图标之间的链接，其中链接与所选择的图标形成应用图，该应用图表示由所选择的表单和服务表示的表单和服务之间的应用的用户的导航 图标分别; 并在应用图的基础上在处理器上编译应用程序。

公开(公告)号：US20110161934A1

公开(公告)日：2011-06-30

申请号：US12648649

申请日：2009-12-29

Applicant: Neil Thomson ,  Grzegorz Roman Pusz

Inventor： Neil Thomson ,  Grzegorz Roman Pusz

IPC: G06F9/44

CPC classification number: G06F11/3684 ,  G06F8/34 ,  G06Q10/10

Abstract: A method and apparatus for generating dummy data for use in testing a data processing application using a computing device having a processor, a memory, a display device and an input device. A developer specifies attributes of dummy data, and specifies at least one probability distribution. A representation of the probability distribution is then shown on the display device and the probability distribution is applied to the specified attributes to generate dummy data values.

Abstract translation: 一种用于生成用于使用具有处理器，存储器，显示装置和输入装置的计算装置测试数据处理应用的虚拟数据的方法和装置。 开发者指定虚拟数据的属性，并指定至少一个概率分布。 然后在显示设备上显示概率分布的表示，并将概率分布应用于指定的属性以生成伪数据值。

公开(公告)号：US20060294098A1

公开(公告)日：2006-12-28

申请号：US11511939

申请日：2006-08-28

Applicant: Neil Thomson ,  Andre Paiement ,  Dave Gould ,  Martin Peticlerc ,  Brian Donnelly ,  Gordon Chow

Inventor： Neil Thomson ,  Andre Paiement ,  Dave Gould ,  Martin Peticlerc ,  Brian Donnelly ,  Gordon Chow

IPC: G06F17/30

CPC classification number: G06F17/30569 ,  G06F17/30539 ,  G06F17/30663 ,  Y10S707/99942

Abstract: A system for capturing the context of, and translating, or mapping, from data in an originating database presentation, or in an originating format, to data in a target database presentation, or target format. The translation uses the context of the originating report/query in terms of the originating database as a basis for the translation. The originating context is translated to the target context and is used to accurately map data from one presentation to another. By using a context and a translation map, which define specifics of the translation between contexts against different data sources, the invention is able to achieve a mapping engine that can efficiently map data between databases of different types. The translation map includes rules set automatically by the system, or set by a human administrator. The rules permit special treatment of different mapping scenarios. For example, specified types of mappings can be prevented so that selected users will be denied the ability to access restricted target information. Member exceptions are used that permit mapping between different data models, as, for example, where rows or columns in an originating data source (e.g. OLAP) are not present in a target data source (e.g. Relational). Other aspects of the invention include using supplemental member translations, translating items in an OLAP level to more than one translation object, delegating data items in cases where there is little or no correspondence between data models, translating a data item to a plurality of data items, translating a data item to a range, and additional aspects. An administrator interface is provided to create, modify, monitor and manage a mapping system.

Abstract translation: 用于从原始数据库呈现或原始格式的数据捕获目标数据库呈现或目标格式的数据的系统，用于捕获来自原始数据库呈现中的数据的上下文，并将其转换或映射。 翻译使用始发数据库的起始报告/查询的上下文作为翻译的基础。 原始上下文被转换为目标上下文，用于将数据从一个呈现精确地映射到另一个。 通过使用上下文和翻译图，其定义了针对不同数据源的上下文之间的转换的细节，本发明能够实现能够在不同类型的数据库之间有效地映射数据的映射引擎。 翻译地图包括系统自动设置的规则，或由人事管理员设定的规则。 这些规则允许对不同的映射方案进行特殊处理。 例如，可以防止指定类型的映射，以使被选择的用户被拒绝访问受限目标信息的能力。 使用允许不同数据模型之间的映射的成员例外，例如在源数据源（例如，OLAP）中的行或列不存在于目标数据源（例如，关系）中的情况下。 本发明的其它方面包括使用补充成员转换，将OLAP级别中的项目翻译成多于一个翻译对象，在数据模型之间很少或没有对应关系的情况下委派数据项，将数据项转换成多个数据项 ，将数据项转换到一个范围，以及其他方面。 提供管理员界面来创建，修改，监视和管理映射系统。

公开(公告)号：US08464229B2

公开(公告)日：2013-06-11

申请号：US12648617

申请日：2009-12-29

Applicant: Neil Thomson ,  Grzegorz Roman Pusz

Inventor： Neil Thomson ,  Grzegorz Roman Pusz

IPC: G06F9/45 ,  G06F9/44

CPC classification number: G06F8/38 ,  G06F8/34

Abstract: A method of creating a form-based web application using a computing device having at least a processor, a memory, a display device and an input device. The method includes retrieving from the memory and providing on the display device a number of form icons, each form icon representing a form to be displayed to a user of the application. The method further includes retrieving from said memory and providing on the display device a number of service icons, each service icon representing a service which may be called in response to actions of the user. The method further includes allowing a developer of the application to use the input device to select one or more of the form icons and one or more of the service icons and to arrange the selected icons on the display device. The method also includes allowing the developer to use the input device to arrange links between the selected icons, wherein the links together with the selected icons form an Application Diagram which represents the navigation of a user of the application between the forms and services represented by the selected form and service icons respectively. The method further includes compiling, at the processor, the application on the basis of the Application Diagram.

Abstract translation: 一种使用至少具有处理器，存储器，显示设备和输入设备的计算设备来创建基于表单的web应用的方法。 该方法包括从存储器检索并在显示设备上提供多个表单图标，每个表单图标表示要向应用程序的用户显示的表单。 该方法还包括从所述存储器检索并在显示设备上提供多个服务图标，每个服务图标表示可以响应于用户的动作而被调用的服务。 该方法还包括允许应用程序的开发者使用输入设备来选择一个或多个表单图标和一个或多个服务图标，并将所选择的图标排列在显示设备上。 该方法还包括允许开发者使用输入设备来布置所选择的图标之间的链接，其中链接与所选择的图标形成应用图，该应用图表示由表示的表单和服务之间的应用的用户的导航 选择的表单和服务图标。 该方法还包括基于应用图在处理器处编译应用程序。