-
公开(公告)号：US07526473B2
公开(公告)日：2009-04-28
申请号：US11158242
申请日：2005-06-21
IPC分类号： G06F7/00
CPC分类号： G06F17/30604 , Y10S707/99932 , Y10S707/99933
摘要： A preferred path between two selected entities is determined. Initially, there is provided a representation of the data structure in the form of a plurality of entities having relations between them indicative of roles and the relations reflecting a cardinality of one of a one-to-one, one-to-many and a many-to-one relationship between the entities. A query is entered that provides an indication of a first selected entity and a second selected entity. A preferred path is selected through the entities and relations that couples the first selected entity to the second selected entity. The preferred path is selected from a plurality of paths as a function of the number of changes in cardinality along the plurality of paths and a indicator indicative of a preferred role relating two entities.
摘要翻译： 确定两个所选实体之间的优选路径。 最初，以多个实体的形式提供数据结构的表示，它们之间的关系表示角色和反映一对一，一对多和多个之一的基数的关系 实体之间的一对一关系。 输入提供第一选定实体和第二被选实体的指示的查询。 通过将第一所选实体耦合到第二所选实体的实体和关系来选择优选路径。 作为沿着多个路径的基数的变化的数量的函数的多个路径选择优选路径，以及指示与两个实体相关联的优选角色的指示符。
-
2.发明授权User interface mechanism to formulate complex query against an entity relationship model 失效用户界面机制根据实体关系模型制定复杂查询公开(公告)号：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.
摘要翻译： 图形用户界面及其使用方法，其允许用户与实体关系模型进行交互。 用户界面包括允许用户在实体，角色和字段之间导航以创建针对模型运行的查询的区域。 单击实体中的实体将显示实体的可用字段。 用户可以将实体和字段拖放到设计界面，以便快速轻松地构建查询。 当实体或字段根据删除的项目（实体或字段），放置的位置以及与项目相关联的属性将实体或字段删除到设计表面时，将应用规则。 可以对实体进行分组和过滤，以对查询的结果进行排序和限制。 运行查询后，结果可能会显示在用户的单独区域中。
-
公开(公告)号：US08024650B2
公开(公告)日：2011-09-20
申请号：US11396148
申请日：2006-03-31
CPC分类号： G06F17/30539
摘要： Mechanisms are provided for drilling on data elements in arbitrary ad-hoc reports. Data elements in one ad-hoc report can be examined and then drilled on, in order to obtain other related data elements in other ad-hoc reports. Thus, in one exemplary aspect of the disclosure, when a user selects a data element in an ad-hoc report, another ad-hoc report is generated containing data elements that are obtained as a result of taking into account 1) the original query associated with data element in the ad-hoc report; 2) the context of the selection in the ad-hoc report, and 3) the granularity of the resulting query associated with the resulting ad-hoc report.
摘要翻译： 提供了在任意特别报告中对数据元素进行钻取的机制。 可以对一个特设报告中的数据元素进行检查，然后进行钻取，以便在其他特别报告中获取其他相关数据元素。 因此，在本公开的一个示例性方面，当用户在特别报告中选择数据元素时，生成包含作为考虑到的结果而获得的数据元素的另一个临时报告1）原始查询相关联 在特定报告中使用数据元素; 2）特设报告中选择的上下文，以及3）与生成的特别报告相关联的结果查询的粒度。
-
4.发明授权公开(公告)号：US07814093B2
公开(公告)日：2010-10-12
申请号：US10627180
申请日：2003-07-25
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.
摘要翻译： 提供数据查询和报告方法和系统。 该方法和系统允许非技术计算机用户构建和执行复杂的数据库查询。 该方法和系统可以满足用于生成和验证数据库查询的简单，易于理解的交互式和迭代方式的需求。 该方法和系统降低了与各种规模的组织（特别是较小的企业）检索有用信息相关的复杂性和成本。 该方法和系统支持强大的安全模型，使组织能够保护敏感数据，同时提供广泛的数据访问。
-
-
-
搜索结果
4 条记录 (耗时 0.027 秒)
