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

1. 发明授权

US07225189B1 Data source write back and offline data editing and storage in a spreadsheet 有权
标题翻译：数据源在电子表格中回写和离线数据编辑和存储
公开(公告)号：US07225189B1
公开(公告)日：2007-05-29
申请号：US10782074
申请日：2004-02-19
申请人： Michael J. McCormack , Robert W. Coffen , Richard L. Dickinson , Sumit Chauhan , Su-Piao Bill Wu , Eric W. Patterson , Paul A. Hafner , Larry Tseng , Xiaohui Pan , Michael J. Eatough
发明人： Michael J. McCormack , Robert W. Coffen , Richard L. Dickinson , Sumit Chauhan , Su-Piao Bill Wu , Eric W. Patterson , Paul A. Hafner , Larry Tseng , Xiaohui Pan , Michael J. Eatough
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/246
摘要： Methods and systems provide for bi-directional communication between a spreadsheet application worksheet and a database data source that allows modified data to be written from a spreadsheet application to source data in a database data source from which the original pre-modified data was obtained. Offline data changes in a spreadsheet application are cached by a data provider application and are published to a remote data source when the spreadsheet application is synchronized with the data source. Error conditions and data conflicts resulting from new or modified data published to a database data source from a spreadsheet application worksheet are reported to a user of the spreadsheet application worksheet through a data provider application to allow the user an opportunity to resolve error conditions and data conflicts between the user's data changes and other data changes made to the same source data contained in the database data source.
摘要翻译：方法和系统提供电子表格应用程序工作表和数据库数据源之间的双向通信，该数据库数据源允许从电子表格应用程序写入修改的数据，以便从中获取原始预修改数据的数据库数据源中的源数据。电子表格应用程序中的脱机数据更改由数据提供程序应用程序缓存，并在电子表格应用程序与数据源同步时发布到远程数据源。从电子表格应用程序工作表发布到数据库数据源的新的或修改后的数据导致的错误条件和数据冲突将通过数据提供程序应用程序向用户提供电子表格应用程序工作表，以允许用户解决错误条件和数据冲突在用户的数据更改和对数据库数据源中包含的相同源数据进行的其他数据更改之间。

2. 发明授权

US07127672B1 Creating and managing structured data in an electronic spreadsheet 有权
标题翻译：在电子电子表格中创建和管理结构化数据
公开(公告)号：US07127672B1
公开(公告)日：2006-10-24
申请号：US10646131
申请日：2003-08-22
申请人： Eric W. Patterson , Robert Wayne Coffen , Su-Piao Bill Wu , Michael J. McCormack
发明人： Eric W. Patterson , Robert Wayne Coffen , Su-Piao Bill Wu , Michael J. McCormack
IPC分类号： G06N3/00
CPC分类号： G06F17/246 , G06F17/2725
摘要： An electronic spreadsheet is provided for automatically creating, expanding, and validating lists of cells. A list is created by receiving a user request for selecting a cell range, identifying a list range for the selected cell range, determining a header row for the list range, and generating a border for surrounding the list range. A list is expanded by determining that one or more cells are adjacent to the list and automatically expanding the list to include the new cells. A list is validated by determining a data type of data entered into the list and comparing the data type of the data entered into the list to a list data type. If, as a result of the comparison, the data type of the data entered into the list does not match the list data type, then the data type of the data entered into the list is invalid.
摘要翻译：提供电子电子表格，用于自动创建，扩展和验证单元格列表。通过接收用于选择单元格范围的用户请求，识别所选单元格范围的列表范围，确定列表范围的标题行，以及生成围绕列表范围的边框来创建列表。通过确定一个或多个单元格与列表相邻并自动扩展列表以包括新单元格来扩展列表。通过确定输入到列表中的数据的数据类型并将输入到列表中的数据的数据类型与列表数据类型进行比较来验证列表。如果作为比较的结果，输入到列表中的数据的数据类型与列表数据类型不匹配，则输入到列表中的数据的数据类型是无效的。

3. 发明授权

US09152656B2 Database data type creation and reuse 有权
标题翻译：数据库数据类型的创建和重用
公开(公告)号：US09152656B2
公开(公告)日：2015-10-06
申请号：US12417429
申请日：2009-04-02
申请人： Michael J. McCormack , Scott T. Gardner , Jason A. Bould , Sumit Chauhan , David J. Conger , Robert E. Coggins , Andrew R. Miller , Ryan McMinn
发明人： Michael J. McCormack , Scott T. Gardner , Jason A. Bould , Sumit Chauhan , David J. Conger , Robert E. Coggins , Andrew R. Miller , Ryan McMinn
IPC分类号： G06F17/30
CPC分类号： G06F17/30342 , G06F3/0482 , G06F17/30289 , G06F17/30292
摘要： Embodiments are provided for creating and reusing custom data types in a database. A selection of a field or group of fields may be received from a database table in the database by a database software application executing on a computer system. Each selected field may include a set of field properties. The application may further receive a user input to initiate saving the selected field or group of fields as a custom data type. In response to receiving the input, the application may be configured to generate a dialog for receiving custom data type information for the selected field or group of fields and save the selected field or group of fields as a custom data type. The custom data type may then be reused by the application in the database.
摘要翻译：提供了用于在数据库中创建和重用自定义数据类型的实施例。可以通过在计算机系统上执行的数据库软件应用程序从数据库中的数据库表中接收字段或字段组的选择。每个所选字段可以包括一组字段属性。应用程序还可以接收用户输入以开始将所选择的字段或字段组保存为自定义数据类型。响应于接收到输入，应用可以被配置为生成用于接收所选字段或字段组的定制数据类型信息的对话框，并将所选择的字段或字段组保存为自定义数据类型。自定义数据类型可以由数据库中的应用程序重新使用。

4. 发明申请

US20090248740A1 DATABASE FORM AND REPORT CREATION AND REUSE 审中-公开
标题翻译：数据库表格和报告创建和重用
公开(公告)号：US20090248740A1
公开(公告)日：2009-10-01
申请号：US12417508
申请日：2009-04-02
申请人： Michael J. McCormack , Scott T. Gardner , Jason A. Bould , Sumit Chauhan , David J. Conger , Robert E. Coggins , Andrew R. Miller , Ryan McMinn
发明人： Michael J. McCormack , Scott T. Gardner , Jason A. Bould , Sumit Chauhan , David J. Conger , Robert E. Coggins , Andrew R. Miller , Ryan McMinn
IPC分类号： G06F7/00 , G06F12/00 , G06F12/16
CPC分类号： G06F16/21
摘要： Embodiments are provided for creating and reusing database forms and reports. A selection of an object may be received from a database by a database software application executing on a computer system. The object may include a form or a report. The application may further receive an input to initiate saving the selected object as a new form template or a new report template. In response to receiving the input, the application may be configured to generate a dialog for receiving the selected object and save the selected object as a new form template or a new report template. Any controls, sub-forms, sub-reports, properties, macros, code, and object model references which may be included in the selected object are persisted in the newly created templates for reuse.
摘要翻译：提供了用于创建和重用数据库表单和报告的实施例。可以通过在计算机系统上执行的数据库软件应用从数据库接收对象的选择。对象可以包括表单或报表。应用程序还可以接收一个输入，以启动将所选择的对象保存为新的表单模板或新的报告模板。响应于接收到输入，应用可以被配置为生成用于接收所选择的对象并将选择的对象保存为新的表单模板或新的报告模板的对话。可能包含在所选对象中的任何控件，子表单，子报表，属性，宏，代码和对象模型引用都将保留在新创建的模板中以供重用。

5. 发明申请

US20090132576A1 DATABASE PART CREATION, MERGE AND REUSE 有权
标题翻译：数据库创建，合并和重用
公开(公告)号：US20090132576A1
公开(公告)日：2009-05-21
申请号：US11942963
申请日：2007-11-20
申请人： Andrew R. Miller , Sumit Chauhan , Robert E. Coggins , Michael J. McCormack , Scott T. Gardner , Jason A. Bould , David Jon Conger , Suraj Poozhiyil , Vijal Mital
发明人： Andrew R. Miller , Sumit Chauhan , Robert E. Coggins , Michael J. McCormack , Scott T. Gardner , Jason A. Bould , David Jon Conger , Suraj Poozhiyil , Vijal Mital
IPC分类号： G06F7/14 , G06F7/00
CPC分类号： G06F17/30498 , G06F17/30289
摘要： Embodiments are provided to merge, manage, create, and reuse database parts in a computer system. Database parts may include database tables, datatypes, field combinations or entire databases. A selection of a database part is received by a database software application executing on a computer system. The application may be configured to check for metadata associated with the database part to identify an action property. If, after checking for the metadata, a merge action property is identified, then the application may check for a metadata property associated with a database table. If a merge action associated with the database table is identified, then the application may merge the database part with the database table in the database. The application may also be configured to generate a user interface for creating database parts using database tables and for creating a database part by saving a database.
摘要翻译：提供实施例以在计算机系统中合并，管理，创建和重用数据库部分。数据库部分可能包括数据库表，数据类型，字段组合或整个数据库。数据库部分的选择由在计算机系统上执行的数据库软件应用程序接收。应用可以被配置为检查与数据库部分相关联的元数据以识别动作属性。如果在检查元数据之后，识别出合并操作属性，则应用程序可以检查与数据库表相关联的元数据属性。如果识别与数据库表相关联的合并操作，则应用程序可能会将数据库部分与数据库中的数据库表进行合并。应用程序还可以被配置为生成用于使用数据库表创建数据库部分并通过保存数据库来创建数据库部分的用户界面。

6. 发明授权

US07895174B2 Database part table junctioning 有权
标题翻译：数据库部分表连接
公开(公告)号：US07895174B2
公开(公告)日：2011-02-22
申请号：US12057075
申请日：2008-03-27
申请人： Michael J. McCormack , Scott T. Gardner , Andrew R. Miller , Sumit Chauhan , Jason A. Bould
发明人： Michael J. McCormack , Scott T. Gardner , Andrew R. Miller , Sumit Chauhan , Jason A. Bould
IPC分类号： G06F17/30
CPC分类号： G06F17/30604
摘要： Embodiments are provided to define relationships for merging template or database part tables with one or more database tables in a computer system. A database application may utilize a schema to receive metadata associated with a target database part table in one or more markup language elements. The database application may then receive metadata associated with a source database table to be joined with the target table in the schema elements. The database application may then receive join type metadata in the schema elements. The join type metadata may specify whether fields from the source table are to be merged into the target table or whether fields from the target table are to be merged into the source table. In response to receiving the target table metadata and the source table metadata, the database application may then merge the target and source tables utilizing the join type metadata.
摘要翻译：提供实施例以定义将模板或数据库部分表与计算机系统中的一个或多个数据库表合并的关系。数据库应用程序可以使用模式来接收与一个或多个标记语言元素中的目标数据库部分表相关联的元数据。然后，数据库应用程序可以接收与要在模式元素中与目标表连接的源数据库表相关联的元数据。然后，数据库应用程序可以在模式元素中接收连接类型元数据。连接类型元数据可以指定源表中的字段是否被合并到目标表中，或者来自目标表的字段是否被合并到源表中。响应于接收目标表元数据和源表元数据，数据库应用程序然后可以使用连接类型元数据来合并目标表和源表。

7. 发明授权

US07870164B2 Database part creation, merge and reuse 有权
标题翻译：数据库部分创建，合并和重用
公开(公告)号：US07870164B2
公开(公告)日：2011-01-11
申请号：US11942963
申请日：2007-11-20
申请人： Andrew R. Miller , Sumit Chauhan , Robert E. Coggins , Michael J. McCormack , Scott T. Gardner , Jason A. Bould , David Jon Conger , Suraj Poozhiyil , Vijay Mital
发明人： Andrew R. Miller , Sumit Chauhan , Robert E. Coggins , Michael J. McCormack , Scott T. Gardner , Jason A. Bould , David Jon Conger , Suraj Poozhiyil , Vijay Mital
IPC分类号： G06F17/30
CPC分类号： G06F17/30498 , G06F17/30289
摘要： Embodiments are provided to merge, manage, create, and reuse database parts in a computer system. Database parts may include database tables, datatypes, field combinations or entire databases. A selection of a database part is received by a database software application executing on a computer system. The application may be configured to check for metadata associated with the database part to identify an action property. If, after checking for the metadata, a merge action property is identified, then the application may check for a metadata property associated with a database table. If a merge action associated with the database table is identified, then the application may merge the database part with the database table in the database. The application may also be configured to generate a user interface for creating database parts using database tables and for creating a database part by saving a database.
摘要翻译：提供实施例以在计算机系统中合并，管理，创建和重用数据库部分。数据库部分可能包括数据库表，数据类型，字段组合或整个数据库。数据库部分的选择由在计算机系统上执行的数据库软件应用程序接收。应用可以被配置为检查与数据库部分相关联的元数据以识别动作属性。如果在检查元数据之后，识别出合并操作属性，则应用程序可以检查与数据库表相关联的元数据属性。如果识别与数据库表相关联的合并操作，则应用程序可能会将数据库部分与数据库中的数据库表进行合并。应用程序还可以被配置为生成用于使用数据库表创建数据库部分并通过保存数据库来创建数据库部分的用户界面。

8. 发明申请

US20090248710A1 Database Part Table Junctioning 有权
标题翻译：数据库部分表结合
公开(公告)号：US20090248710A1
公开(公告)日：2009-10-01
申请号：US12057075
申请日：2008-03-27
申请人： Michael J. McCormack , Scott T. Gardner , Andrew R. Miller , Sumit Chauhan , Jason A. Bould
发明人： Michael J. McCormack , Scott T. Gardner , Andrew R. Miller , Sumit Chauhan , Jason A. Bould
IPC分类号： G06F17/30
CPC分类号： G06F17/30604
摘要： Embodiments are provided to define relationships for merging template or database part tables with one or more database tables in a computer system. A database application may utilize a schema to receive metadata associated with a target database part table in one or more markup language elements. The database application may then receive metadata associated with a source database table to be joined with the target table in the schema elements. The database application may then receive join type metadata in the schema elements. The join type metadata may specify whether fields from the source table are to be merged into the target table or whether fields from the target table are to be merged into the source table. In response to receiving the target table metadata and the source table metadata, the database application may then merge the target and source tables utilizing the join type metadata.
摘要翻译：提供实施例以定义将模板或数据库部分表与计算机系统中的一个或多个数据库表合并的关系。数据库应用程序可以使用模式来接收与一个或多个标记语言元素中的目标数据库部分表相关联的元数据。然后，数据库应用程序可以接收与要在模式元素中与目标表连接的源数据库表相关联的元数据。然后，数据库应用程序可以在模式元素中接收连接类型元数据。连接类型元数据可以指定源表中的字段是否被合并到目标表中，或者来自目标表的字段是否被合并到源表中。响应于接收目标表元数据和源表元数据，数据库应用程序然后可以使用连接类型元数据来合并目标表和源表。

9. 发明申请

US20090204635A1 DATABASE DATA TYPE CREATION AND REUSE 有权
标题翻译：数据库数据类型创建和重用
公开(公告)号：US20090204635A1
公开(公告)日：2009-08-13
申请号：US12417429
申请日：2009-04-02
申请人： Michael J. McCormack , Scott T. Gardner , Jason A. Bould , Sumit Chauhan , David J. Conger , Robert E. Coggins , Andrew R. Miller , Ryan McMinn
发明人： Michael J. McCormack , Scott T. Gardner , Jason A. Bould , Sumit Chauhan , David J. Conger , Robert E. Coggins , Andrew R. Miller , Ryan McMinn
IPC分类号： G06F17/30
CPC分类号： G06F17/30342 , G06F3/0482 , G06F17/30289 , G06F17/30292
摘要： Embodiments are provided for creating and reusing custom data types in a database. A selection of a field or group of fields may be received from a database table in the database by a database software application executing on a computer system. Each selected field may include a set of field properties. The application may further receive a user input to initiate saving the selected field or group of fields as a custom data type. In response to receiving the input, the application may be configured to generate a dialog for receiving custom data type information for the selected field or group of fields and save the selected field or group of fields as a custom data type. The custom data type may then be reused by the application in the database.
摘要翻译：提供了用于在数据库中创建和重用自定义数据类型的实施例。可以通过在计算机系统上执行的数据库软件应用程序从数据库中的数据库表中接收字段或字段组的选择。每个所选字段可以包括一组字段属性。应用程序还可以接收用户输入以开始将所选择的字段或字段组保存为自定义数据类型。响应于接收到输入，应用可以被配置为生成用于接收所选字段或字段组的定制数据类型信息的对话框，并将所选择的字段或字段组保存为自定义数据类型。自定义数据类型可以由数据库中的应用程序重新使用。

10. 发明授权

US07546291B2 Data source task pane 失效
标题翻译：数据源任务窗格
公开(公告)号：US07546291B2
公开(公告)日：2009-06-09
申请号：US11317648
申请日：2005-12-22
申请人： Vitore Selca , Christopher W. Bryant , Richard L. Dickinson , Richard Shawn McDowell , Zachary P. Woodall , Michael J. McCormack
发明人： Vitore Selca , Christopher W. Bryant , Richard L. Dickinson , Richard Shawn McDowell , Zachary P. Woodall , Michael J. McCormack
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/30587 , G06F17/30392 , G06F17/30595 , Y10S707/99933 , Y10S707/99942 , Y10S707/99943
摘要： A user interface is provided that allows users to create queries interactively. The user interface operates by creating a source query (or, for example, SQL commands) for the user while they select fields from a data source. This provides users with an alternative to using conventional designers, wizards, or other tools to manually generate a query.
摘要翻译：提供了一种允许用户以交互方式创建查询的用户界面。用户界面通过在用户从数据源中选择字段时为用户创建源查询（或例如SQL命令）来操作。这为用户提供了使用常规设计器，向导或其他工具手动生成查询的替代方法。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式