公开(公告)号：US20130006961A1

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

申请号：US13172627

申请日：2011-06-29

申请人： Jonathan McPherson ,  Roderic Lewis

发明人： Jonathan McPherson ,  Roderic Lewis

IPC分类号： G06F17/30

CPC分类号： G06F16/2428 ,  G06F16/2423

摘要： A data driven natural interface is provided for automated relational queries. Multiple datasets are displayed in an easily selectable manner on a surface. Upon detecting selection and movement of a dataset to another surface, the moved data is presented on the other surface. Upon detecting selection and movement of another dataset to the other surface, a join path between the moved datasets is computed, the datasets joined, and results displayed on the other surface. The system continues to join newly selected data with existing data as new datasets are moved to the other surface allowing query results to take shape before the user's eyes, without a need to test or execute the query.

摘要翻译： 为自动化关系查询提供数据驱动的自然界面。 多个数据集以易于选择的方式显示在表面上。 当检测到数据集到另一个表面的选择和移动时，移动的数据被呈现在另一个表面上。 在检测到另一个数据集到另一个表面的选择和移动后，计算移动的数据集之间的连接路径，数据集连接，结果显示在另一个表面上。 随着新的数据集被移动到另一个表面，系统继续将新选择的数据与现有数据结合在一起，允许查询结果在用户眼睛之前形成，而不需要测试或执行查询。

公开(公告)号：US20070106951A1

公开(公告)日：2007-05-10

申请号：US11268686

申请日：2005-11-07

申请人： Michael McCormack ,  Christopher Bryant ,  George Fordham ,  Jonathan McPherson ,  Scott Gardner ,  Clinton Covington ,  Daniel Hough

发明人： Michael McCormack ,  Christopher Bryant ,  George Fordham ,  Jonathan McPherson ,  Scott Gardner ,  Clinton Covington ,  Daniel Hough

IPC分类号： G06F9/00

CPC分类号： G06F17/248

摘要： A one-screen entry point to a document management program (“program”) is provided to allow a user to browse templates associated with the program. The templates can be local templates and/or online templates provided by one or more Web services. The one-screen entry point allows a user to search, browse, or download online templates, and/or create documents using the templates. Each template is identified with a template category and displayed together with templates identified with the same template category. Local templates are presented along with online templates if the local templates and the online templates are identified with the same online template category. A user or an administrator of the program can create and/or customize local templates and local template categories. A blank template is provided so a user can create custom documents for the program.

摘要翻译： 提供到文档管理程序（“程序”）的单屏入口点，以允许用户浏览与程序相关联的模板。 模板可以是一个或多个Web服务提供的本地模板和/或在线模板。 单屏入口点允许用户使用模板搜索，浏览或下载在线模板和/或创建文档。 每个模板用模板类别标识，并与使用相同模板类别标识的模板一起显示。 如果本地模板和在线模板用相同的在线模板类别标识，本地模板将与在线模板一起显示。 程序的用户或管理员可以创建和/或自定义本地模板和本地模板类别。 提供了一个空白模板，用户可以为程序创建自定义文档。

公开(公告)号：US10311062B2

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

申请号：US13590206

申请日：2012-08-21

申请人： Jonathan McPherson ,  Cameron Elliot Smith ,  David Michael Jade ,  Joseph Milan Filcik ,  Juventino Rojas Arredondo

发明人： Jonathan McPherson ,  Cameron Elliot Smith ,  David Michael Jade ,  Joseph Milan Filcik ,  Juventino Rojas Arredondo

IPC分类号： G06F17/30 ,  G06F16/2457

摘要： Technologies are described herein for filtering data in a result set using inexact and/or culture dependent terms. A user provides one or more filter terms for filtering a result set being viewed. One or more data type interpretations are determined for each filter term based on the value of the term. The data type interpretations may further be based on a locale associated with the user. For each filter term, the columns of the result set to which the filter term is to be applied is selected based on the data type interpretations determined for the filter term and the data types of the columns. The filter terms are then applied to the selected columns of the result set, thus causing the rows of the result set as displayed to the user to be limited to rows wherein at least one column value satisfies a filter term.

公开(公告)号：US20140059038A1

公开(公告)日：2014-02-27

申请号：US13590206

申请日：2012-08-21

申请人： Jonathan McPherson ,  Cameron Elliot Smith ,  David Michael Jade ,  Joseph Milan Filcik ,  Juventino Rojas Arredondo

发明人： Jonathan McPherson ,  Cameron Elliot Smith ,  David Michael Jade ,  Joseph Milan Filcik ,  Juventino Rojas Arredondo

IPC分类号： G06F17/30

CPC分类号： G06F17/30528

摘要： Technologies are described herein for filtering data in a result set using inexact and/or culture dependent terms. A user provides one or more filter terms for filtering a result set being viewed. One or more data type interpretations are determined for each filter term based on the value of the term. The data type interpretations may further be based on a locale associated with the user. For each filter term, the columns of the result set to which the filter term is to be applied is selected based on the data type interpretations determined for the filter term and the data types of the columns. The filter terms are then applied to the selected columns of the result set, thus causing the rows of the result set as displayed to the user to be limited to rows wherein at least one column value satisfies a filter term.

摘要翻译： 本文描述了技术，用于使用不精确和/或依赖于文化的术语过滤结果集中的数据。 用户提供一个或多个过滤条件来过滤正在查看的结果集。 基于该项的值，为每个过滤项确定一个或多个数据类型解释。 数据类型解释还可以基于与用户相关联的区域设置。 对于每个过滤项，将根据为过滤项定义的数据类型解释和列的数据类型选择要应用过滤项的结果集的列。 然后将滤波器项应用于结果集合的所选择的列，从而使得对用户显示的结果集合的行被限制为其中至少一个列值满足过滤项的行。

公开(公告)号：US20120311474A1

公开(公告)日：2012-12-06

申请号：US13152251

申请日：2011-06-02

申请人： Jonathan McPherson ,  Roderic Wells Lewis, JR.

发明人： Jonathan McPherson ,  Roderic Wells Lewis, JR.

IPC分类号： G06F17/30 ,  G06F3/048

CPC分类号： G06F16/26 ,  G09G5/14 ,  G09G2340/0464

摘要： Technologies are described herein for generating and manipulating visual maps of relational databases. A list of data tables is retrieved from the database and ordered according to the number of relationships for each data table. A database map is generated containing tiles corresponding to each data table in the list, wherein tiles corresponding to related data tables are adjacent along at least one edge or corner of the tiles where possible. The display attributes of each tile may be adjusted to reflect properties of the corresponding data table. The database map is then displayed to a user in a user interface, and controls are provided that allow the user to navigate and zoom the database map in the user interface in order to reveal data contained in the data tables corresponding to the displayed tiles.

摘要翻译： 这里描述了用于生成和操纵关系数据库的视觉映射的技术。 从数据库检索数据表的列表，并根据每个数据表的关系数进行排序。 生成包含对应于列表中的每个数据表的图块的数据库图，其中对应于相关数据表的图块在可能的沿着图块的至少一个边缘或角落相邻。 可以调整每个图块的显示属性以反映相应数据表的属性。 然后，数据库映射在用户界面中向用户显示，并且提供允许用户在用户界面中导航和缩放数据库映射的控件，以便揭示包含在与所显示的瓦片对应的数据表中的数据。