公开(公告)号：US07693862B2

公开(公告)日：2010-04-06

申请号：US11170418

申请日：2005-06-29

申请人： Carolyn Khanh Chau ,  Jason David Carlson ,  Robert Alan Meyers ,  Brian Lee Welcker ,  Lisa Renee Mueller ,  Aaron Stephen Meyers

发明人： Carolyn Khanh Chau ,  Jason David Carlson ,  Robert Alan Meyers ,  Brian Lee Welcker ,  Lisa Renee Mueller ,  Aaron Stephen Meyers

IPC分类号： G06F17/30

CPC分类号： G06F17/30604 ,  Y10S707/99943

摘要： A graphical user interface and method of use thereof that allows users to interact with an entity relationship model. The user interface includes zones that allow users to navigate among the entities, roles and fields to create queries that are run against the model. Clicking on an entity in the shows the available fields for the entity. Users can drag and drop entities and fields onto a design surface to quickly and easily build queries. Rules are applied when either an entity or a field is dropped onto the design surface based upon the item being dropped (either an entity or a field), the position of the drop and also the properties that are associated with the item. Entities may be grouped and filtered to sort and limit the results of the query. After query is run, the results may be displayed in a separate area to the user.

摘要翻译： 图形用户界面及其使用方法，其允许用户与实体关系模型进行交互。 用户界面包括允许用户在实体，角色和字段之间导航以创建针对模型运行的查询的区域。 单击实体中的实体将显示实体的可用字段。 用户可以将实体和字段拖放到设计界面，以便快速轻松地构建查询。 当实体或字段根据删除的项目（实体或字段），放置的位置以及与项目相关联的属性将实体或字段删除到设计表面时，将应用规则。 可以对实体进行分组和过滤，以对查询的结果进行排序和限制。 运行查询后，结果可能会显示在用户的单独区域中。

公开(公告)号：US07814093B2

公开(公告)日：2010-10-12

申请号：US10627180

申请日：2003-07-25

申请人： Aaron Stephen Meyers ,  Robert Alan Meyers ,  Eric Stephen Meyers

发明人： Aaron Stephen Meyers ,  Robert Alan Meyers ,  Eric Stephen Meyers

IPC分类号： G06F7/00

CPC分类号： G06F17/30595 ,  G06F17/30392 ,  G06F17/30398 ,  G06F17/30554

摘要： A data query and reporting method and system are provided. The method and system allow non-technical computer users to build and execute complex database queries. The method and system accommodate the need for a simple, easy-to-understand interactive and iterative means for generating and validating database queries. The method and system reduce the complexity and costs associated with retrieving useful information for organizations of all sizes, especially smaller businesses. The method and system support a robust security model, enabling organizations to protect sensitive data while providing broad data access.

摘要翻译： 提供数据查询和报告方法和系统。 该方法和系统允许非技术计算机用户构建和执行复杂的数据库查询。 该方法和系统可以满足用于生成和验证数据库查询的简单，易于理解的交互式和迭代方式的需求。 该方法和系统降低了与各种规模的组织（特别是较小的企业）检索有用信息相关的复杂性和成本。 该方法和系统支持强大的安全模型，使组织能够保护敏感数据，同时提供广泛的数据访问。