专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明申请

US20070005562A1 User interface mechanism to formulate complex query against an entity relationship model 失效
标题翻译：用户界面机制根据实体关系模型制定复杂查询
公开(公告)号：US20070005562A1
公开(公告)日：2007-01-04
申请号：US11170418
申请日：2005-06-29
申请人： Carolyn Chau , Jason Carlson , Robert Meyers , Brian Welcker , Lisa Mueller , Aaron Meyers
发明人： Carolyn Chau , Jason Carlson , Robert Meyers , Brian Welcker , Lisa Mueller , Aaron 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.
摘要翻译：图形用户界面及其使用方法，其允许用户与实体关系模型进行交互。用户界面包括允许用户在实体，角色和字段之间导航以创建针对模型运行的查询的区域。单击实体中的实体将显示实体的可用字段。用户可以将实体和字段拖放到设计界面，以便快速轻松地构建查询。当实体或字段根据删除的项目（实体或字段），放置的位置以及与项目相关联的属性将实体或字段删除到设计表面时，将应用规则。可以对实体进行分组和过滤，以对查询的结果进行排序和限制。运行查询后，结果可能会显示在用户的单独区域中。

2. 发明申请

US20070233680A1 Auto-generating reports based on metadata 审中-公开
标题翻译：基于元数据自动生成报表
公开(公告)号：US20070233680A1
公开(公告)日：2007-10-04
申请号：US11396174
申请日：2006-03-31
申请人： Jason Carlson , Carolyn Chau , Robert Meyers
发明人： Jason Carlson , Carolyn Chau , Robert Meyers
IPC分类号： G06F17/30
CPC分类号： G06F16/242 , G06F16/283
摘要： Mechanisms are provided for auto-generating reports based on metadata. Entities in databases may have some associated metadata, and this metadata may serve as the basis of the reports. Such reports may be generated not only automatically but also dynamically. The generation of reports may also be a function of the role traversal between entities, such that if a role indicates at most one instance of the target entity is related to an instance of the source entity, a single-type report can be created, whereas if the role indicates many instances of the target entity may be related, a different kind or report can be generated, namely, a multi-type report. Lastly, even though reports are auto-generated, such reports can be overridden or customized via user interfaces or application programming interfaces.
摘要翻译：提供了基于元数据自动生成报告的机制。数据库中的实体可能具有一些关联的元数据，并且此元数据可以作为报告的基础。这样的报告不仅可以自动生成，而且可以动态地生成。报告的生成也可能是实体之间的角色遍历的功能，使得如果角色最多指出一个目标实体的一个实例与源实体的实例相关，则可以创建单一类型的报告，而如果角色指示目标实体的许多实例可能相关，则可以生成不同类型或报告，即，多类型报告。最后，即使自动生成报告，也可以通过用户界面或应用程序编程接口来覆盖或定制报告。

3. 发明申请

US20070005583A1 Method for building powerful calculations of an entity relationship model 审中-公开
标题翻译：建立实体关系模型强大计算的方法
公开(公告)号：US20070005583A1
公开(公告)日：2007-01-04
申请号：US11170898
申请日：2005-06-29
申请人： Carolyn Chau , Jason Carlson , Robert Meyers
发明人： Carolyn Chau , Jason Carlson , Robert Meyers
IPC分类号： G06F17/30
CPC分类号： G06F16/288
摘要： A method of creating and defining complex functions and/or expressions that may be run against an entity relationship model. An anchor entity serves as a beginning point of the expression and determines what data that will be returned by the user-created expression within the context of a query. When a relationship from any entity is traversed, including the anchor entity, the role name for the target entity is displayed hierarchically beneath the entity it was navigated from. When an entity is selected, the relationships from this entity are shown as possible navigation paths. The user may select one of these paths to navigate and add to the query tree or chose a field from the field list. Entities can be dragged and dropped into a formula area to create the expression. Functions, and mathematical and logical operations can be performed on the entities and fields in creating the expression. The fields and entities can be filtered to refine the results retrieved by the expression.
摘要翻译：一种创建和定义可能针对实体关系模型运行的复杂函数和/或表达式的方法。锚实体充当表达式的起始点，并确定在查询的上下文中由用户创建的表达式返回的数据。当遍历任何实体的关系（包括锚点实体）时，目标实体的角色名称将在其导航的实体之下分层显示。当选择实体时，来自该实体的关系被显示为可能的导航路径。用户可以选择这些路径之一来导航并添加到查询树中，或从字段列表中选择一个字段。可以将实体拖放到公式区域中以创建表达式。函数和数学和逻辑运算可以在创建表达式的实体和字段上执行。可以对字段和实体进行过滤，以细化表达式检索的结果。

4. 发明申请

US20060287981A1 Traversing a relational model with preferred paths 有权
公开(公告)号：US20060287981A1
公开(公告)日：2006-12-21
申请号：US11158242
申请日：2005-06-21
申请人： Aaron Meyers , Christopher Hays , Jason Carlson , Robert Meyers
发明人： Aaron Meyers , Christopher Hays , Jason Carlson , Robert Meyers
IPC分类号： G06F17/30
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.

5. 发明申请

US20050039033A1 Method and system for building a report for execution against a data store 有权
标题翻译：用于构建针对数据存储执行的报告的方法和系统
公开(公告)号：US20050039033A1
公开(公告)日：2005-02-17
申请号：US10627180
申请日：2003-07-25
申请人： Aaron Meyers , Robert Meyers , Eric Meyers
发明人： Aaron Meyers , Robert Meyers , Eric Meyers
IPC分类号： G06F17/30 , H04L9/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.
摘要翻译：提供数据查询和报告方法和系统。该方法和系统允许非技术计算机用户构建和执行复杂的数据库查询。该方法和系统可以满足用于生成和验证数据库查询的简单，易于理解的交互式和迭代方式的需求。该方法和系统降低了与各种规模的组织（特别是较小的企业）检索有用信息相关的复杂性和成本。该方法和系统支持强大的安全模型，使组织能够保护敏感数据，同时提供广泛的数据访问。

6. 发明申请

US20050034064A1 Method and system for creating and following drill links 审中-公开
标题翻译：创建和跟踪钻取链接的方法和系统
公开(公告)号：US20050034064A1
公开(公告)日：2005-02-10
申请号：US10765232
申请日：2004-01-26
申请人： Aaron Meyers , Robert Meyers , Eric Meyers
发明人： Aaron Meyers , Robert Meyers , Eric Meyers
IPC分类号： G06F17/30 , G06F17/00
CPC分类号： G06F16/248 , G06F16/2423 , G06F16/2428 , G06F16/284
摘要： A method and system for creating and following drill links in a report are disclosed. A relational abstraction of a data store is defined, the definition including a plurality of views, scalar or aggregate fields associated with the views, and relations between the views. A report is generated that includes at least one drill link associated with a sequence of one or more relations originating at a base view of the relational abstraction. Upon selecting a drill link contained in a first report, information about the drill link is extracted from the report, and the extracted information and the destination view associated with the drill link are used to create a second report.
摘要翻译：公开了一种在报告中创建和跟踪钻取链接的方法和系统。定义数据存储的关系抽象，该定义包括与视图相关联的多个视图，标量或聚合字段以及视图之间的关系。生成报告，该报告包括至少一个与源于关系抽象的基本视图的一个或多个关系的序列相关联的钻取链接。在选择包含在第一报告中的钻取链接时，从报告中提取关于钻取链接的信息，并且使用与钻取链接相关联的提取的信息和目的地视图来创建第二报告。

7. 发明申请

US20050021538A1 Method and system for displaying a relational abstraction of a data store 审中-公开
标题翻译：显示数据存储的关系抽象的方法和系统
公开(公告)号：US20050021538A1
公开(公告)日：2005-01-27
申请号：US10754288
申请日：2004-01-09
申请人： Aaron Meyers , Robert Meyers , Eric Meyers
发明人： Aaron Meyers , Robert Meyers , Eric Meyers
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F16/248 , G06F16/2423 , G06F16/2428
摘要： A method and system for displaying a relational abstraction data store are disclosed. A relational abstraction of a data store is defined, the definition including a plurality of views, scalar or aggregate fields associated with the views, and relations between the views. The fields and relations associated with views are displayed and related to a base view through a sequence of relations. The fields displayed are constrained based upon the sequence of relations from the base view. Scalar fields are displayed where the sequence of relations does not contain a to-many relation. Aggregate fields are displayed where the sequence of relations contains at least one to-many relation. Distinct aggregate fields are displayed where the relation path sequence contains a to-many relation followed by a many-to-one relation. A field may be displayed with additional information indicating how, or whether, the fields may be used. The display of fields may be constrained in predetermined ways. The display of relations may be displayed with additional information about the nature of the relations and the sequence of the relation path. Fields and relations may be displayed using a hierarchical means of display such as in trees structures or lists, or may be displayed using a natural language description.
摘要翻译：公开了一种用于显示关系抽象数据存储的方法和系统。定义数据存储的关系抽象，该定义包括与视图相关联的多个视图，标量或聚合字段以及视图之间的关系。与视图关联的字段和关系通过一系列关系显示并与基础视图相关。显示的字段基于从基本视图的关系序列来约束。显示标量字段，其中关系序列不包含多对多关系。显示聚合字段，其中关系序列至少包含一对多关系。显示不同的聚合字段，其中关系路径序列包含多对一关系，后跟多对一关系。可以显示一个字段，其中附加的信息指示如何或将来可以使用字段。场的显示可以以预定的方式被约束。关系的显示可以显示关于关系的性质和关系路径的顺序的附加信息。可以使用诸如树结构或列表中的分层显示方式来显示字段和关系，或者可以使用自然语言描述来显示。

8. 发明申请

US20070256028A1 Dynamic determination of actions on selected items on a report 有权
标题翻译：动态确定报告上所选项目的操作
公开(公告)号：US20070256028A1
公开(公告)日：2007-11-01
申请号：US11411642
申请日：2006-04-26
申请人： Christopher Hays , Jason Carlson , Robert Meyers
发明人： Christopher Hays , Jason Carlson , Robert Meyers
IPC分类号： G06F17/00
CPC分类号： G06Q10/00
摘要： Various technologies for processing a selection on an item on a report. In one implementation, a request to perform an action on the item may be received. Whether one or more actions corresponding to the item exist based on one or more parameters and one or more values of the parameters associated with the item may be dynamically determined. A list of one or more actions may be displayed if the one or more actions exist.
摘要翻译：用于处理关于报告上的项目的选择的各种技术。在一个实现中，可以接收对该项目执行动作的请求。可以基于一个或多个参数存在与物品相对应的一个或多个动作，并且可以动态地确定与该物品相关联的参数的一个或多个值。如果存在一个或多个动作，则可以显示一个或多个动作的列表。

9. 发明申请

US20070233666A1 Drilling on elements in arbitrary ad-hoc reports 有权
标题翻译：在任意特设报告中钻取元素
公开(公告)号：US20070233666A1
公开(公告)日：2007-10-04
申请号：US11396148
申请日：2006-03-31
申请人： Jason Carlson , Robert Meyers
发明人： Jason Carlson , Robert Meyers
IPC分类号： G06F17/30 , G06F7/00
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）与生成的特别报告相关联的结果查询的粒度。

10. 发明授权

US08745044B2 Generating descriptions of matching resources based on the kind, quality, and relevance of available sources of information about the matching resources 有权
标题翻译：根据有关匹配资源的可用信息源的种类，质量和相关性，生成匹配资源的描述
公开(公告)号：US08745044B2
公开(公告)日：2014-06-03
申请号：US12172165
申请日：2008-07-11
申请人： Chad Carson , Mohan V. Nibhanupudi , Robert Meyers , Dmitri Pavlovski , Douglas Cook
发明人： Chad Carson , Mohan V. Nibhanupudi , Robert Meyers , Dmitri Pavlovski , Douglas Cook
IPC分类号： G06F17/30
CPC分类号： G06F17/30864 , Y10S707/99933 , Y10S707/99935
摘要： Techniques are provided for generating descriptions of matching resources in a manner that takes into account the kind, quality, and relevance of the available sources of information about the matching resources. For example, after the search engine identifies matching resources based on the query terms, the search engine determines the kinds of available sources of information about each matching resource. For each matching resource, based on the kinds of available sources of information about the matching resource, one of a plurality of processes is selected to generate a description for the matching resource. Using the content-sensitive description generation techniques described herein, a single result set may include abstracts that were generated using several different processes, where the difference in process corresponds to a difference in the kind, quality, and relevance of the available sources of information about each matching resource.
摘要翻译：提供了以考虑可用的关于匹配资源的信息源的种类，质量和相关性的方式产生匹配资源的描述的技术。例如，在搜索引擎基于查询词语识别匹配资源之后，搜索引擎确定关于每个匹配资源的可用信息源的种类。对于每个匹配资源，基于关于匹配资源的可用信息源的种类，选择多个进程之一来生成匹配资源的描述。使用本文描述的内容敏感描述生成技术，单个结果集可以包括使用几个不同进程生成的抽象，其中过程的差异对应于可用的信息源的种类，质量和相关性的差异每个匹配资源。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式