公开(公告)号：US07890532B2

公开(公告)日：2011-02-15

申请号：US11013619

申请日：2004-12-15

Applicant: Daniel J. Cole ,  Gloria M. Godfrey ,  Neil W. Black ,  Sumit Chauhan ,  Suraj T. Poozhiyil

Inventor： Daniel J. Cole ,  Gloria M. Godfrey ,  Neil W. Black ,  Sumit Chauhan ,  Suraj T. Poozhiyil

IPC: G06F7/00 ,  G06F17/00

CPC classification number: G06F17/30595 ,  Y10S707/99943

Abstract: Methods, systems, and computer-readable media implementing various aspects of complex data in a conceptual table are disclosed which enable complex data in the form of tables to be added to a conceptual table. The complex data can map to scalar values in a plurality of data tables. Complex data may be entered via data modeling methods, accessed via cursoring methods, and queried via query expansion methods.

Abstract translation: 公开了在概念表中实现复杂数据的各个方面的方法，系统和计算机可读介质，其使得以表的形式的复杂数据被添加到概念表中。 复数数据可以映射到多个数据表中的标量值。 可以通过数据建模方法输入复杂数据，通过游标方式访问，并通过查询扩展方法进行查询。

公开(公告)号：US20090248740A1

公开(公告)日：2009-10-01

申请号：US12417508

申请日：2009-04-02

Applicant: Michael J. McCormack ,  Scott T. Gardner ,  Jason A. Bould ,  Sumit Chauhan ,  David J. Conger ,  Robert E. Coggins ,  Andrew R. Miller ,  Ryan McMinn

Inventor： 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 classification number: G06F16/21

Abstract: 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.

Abstract translation: 提供了用于创建和重用数据库表单和报告的实施例。 可以通过在计算机系统上执行的数据库软件应用从数据库接收对象的选择。 对象可以包括表单或报表。 应用程序还可以接收一个输入，以启动将所选择的对象保存为新的表单模板或新的报告模板。 响应于接收到输入，应用可以被配置为生成用于接收所选择的对象并将选择的对象保存为新的表单模板或新的报告模板的对话。 可能包含在所选对象中的任何控件，子表单，子报表，属性，宏，代码和对象模型引用都将保留在新创建的模板中以供重用。

公开(公告)号：US20090132576A1

公开(公告)日：2009-05-21

申请号：US11942963

申请日：2007-11-20

Applicant: Andrew R. Miller ,  Sumit Chauhan ,  Robert E. Coggins ,  Michael J. McCormack ,  Scott T. Gardner ,  Jason A. Bould ,  David Jon Conger ,  Suraj Poozhiyil ,  Vijal Mital

Inventor： 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 classification number: G06F17/30498 ,  G06F17/30289

Abstract: 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.

Abstract translation: 提供实施例以在计算机系统中合并，管理，创建和重用数据库部分。 数据库部分可能包括数据库表，数据类型，字段组合或整个数据库。 数据库部分的选择由在计算机系统上执行的数据库软件应用程序接收。 应用可以被配置为检查与数据库部分相关联的元数据以识别动作属性。 如果在检查元数据之后，识别出合并操作属性，则应用程序可以检查与数据库表相关联的元数据属性。 如果识别与数据库表相关联的合并操作，则应用程序可能会将数据库部分与数据库中的数据库表进行合并。 应用程序还可以被配置为生成用于使用数据库表创建数据库部分并通过保存数据库来创建数据库部分的用户界面。

公开(公告)号：US07225189B1

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

申请号：US10782074

申请日：2004-02-19

Applicant: 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

Inventor： 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 classification number: G06F17/246

Abstract: 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.

Abstract translation: 方法和系统提供电子表格应用程序工作表和数据库数据源之间的双向通信，该数据库数据源允许从电子表格应用程序写入修改的数据，以便从中获取原始预修改数据的数据库数据源中的源数据。 电子表格应用程序中的脱机数据更改由数据提供程序应用程序缓存，并在电子表格应用程序与数据源同步时发布到远程数据源。 从电子表格应用程序工作表发布到数据库数据源的新的或修改后的数据导致的错误条件和数据冲突将通过数据提供程序应用程序向用户提供电子表格应用程序工作表，以允许用户解决错误条件和数据冲突 在用户的数据更改和对数据库数据源中包含的相同源数据进行的其他数据更改之间。

公开(公告)号：US07895174B2

公开(公告)日：2011-02-22

申请号：US12057075

申请日：2008-03-27

Applicant: Michael J. McCormack ,  Scott T. Gardner ,  Andrew R. Miller ,  Sumit Chauhan ,  Jason A. Bould

Inventor： Michael J. McCormack ,  Scott T. Gardner ,  Andrew R. Miller ,  Sumit Chauhan ,  Jason A. Bould

IPC: G06F17/30

CPC classification number: G06F17/30604

Abstract: 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.

Abstract translation: 提供实施例以定义将模板或数据库部分表与计算机系统中的一个或多个数据库表合并的关系。 数据库应用程序可以使用模式来接收与一个或多个标记语言元素中的目标数据库部分表相关联的元数据。 然后，数据库应用程序可以接收与要在模式元素中与目标表连接的源数据库表相关联的元数据。 然后，数据库应用程序可以在模式元素中接收连接类型元数据。 连接类型元数据可以指定源表中的字段是否被合并到目标表中，或者来自目标表的字段是否被合并到源表中。 响应于接收目标表元数据和源表元数据，数据库应用程序然后可以使用连接类型元数据来合并目标表和源表。

公开(公告)号：US07836100B2

公开(公告)日：2010-11-16

申请号：US11924838

申请日：2007-10-26

Applicant: Abigail Elisabeth Short ,  Daniel J. Cole ,  Matthew Pohle ,  Michael Allen Brotherton ,  Vitore Selca ,  Sumit Chauhan ,  Richard Shawn McDowell

Inventor： Abigail Elisabeth Short ,  Daniel J. Cole ,  Matthew Pohle ,  Michael Allen Brotherton ,  Vitore Selca ,  Sumit Chauhan ,  Richard Shawn McDowell

IPC: G06F7/00

CPC classification number: G06F17/30342

Abstract: Embodiments are provided to calculate and provide information based in part on a defined expression. In an embodiment, a database system can be configured to include a number of calculated columns as part of a database table structure. The database system can be configured to present a calculated result based in part on a determined result type. In one embodiment, a database system can be configured to enable calculated columns to be defined on a table of a database, wherein a component can be used to evaluate an expression associated with a column calculation to determine a proper result type. The proper result type can be stored and used when presenting a result of the calculation. Other embodiments are available.

Abstract translation: 提供实施例以部分地基于定义的表达来计算和提供信息。 在一个实施例中，数据库系统可以被配置为包括多个计算列作为数据库表结构的一部分。 数据库系统可以被配置为基于确定的结果类型呈现计算结果。 在一个实施例中，可以配置数据库系统以使计算列能够在数据库的表上定义，其中可以使用组件来评估与列计算相关联的表达式以确定适当的结果类型。 当呈现计算结果时，可以存储和使用正确的结果类型。 其他实施例是可用的。

公开(公告)号：US20090307661A1

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

申请号：US12134732

申请日：2008-06-06

Applicant: David M. Vierzba ,  Andrew R. Miller ,  Sumit Chauhan ,  Timothy E. Getsch ,  Scott T. Gardner

Inventor： David M. Vierzba ,  Andrew R. Miller ,  Sumit Chauhan ,  Timothy E. Getsch ,  Scott T. Gardner

IPC: G06F9/44

CPC classification number: G06F8/70

Abstract: Computer software applications may be separated into components and distilled into functional and identifying attributes, which may then be used to regenerate the computer software application on a different system. A component of a computer software program is received. From the component, one or more functional attributes describing the operation of the component on a first operating platform are distilled from which the component can be generated to operate on one or more operating platforms. Attributes identifying the component are identified. The functional attributes and the identifying attributes of the component are stored in a distillation store. From the distillation store, using information about a selected operating platform on which the computer software program is to be executed, components of the computer software program may be generated to execute on the selected operating platform.

Abstract translation: 计算机软件应用程序可以分成组件，并将其转化为功能和标识属性，然后可以将其用于在不同的系统上重新生成计算机软件应用程序。 接收计算机软件程序的组件。 从组件中，描述了描述在第一操作平台上的组件的操作的一个或多个功能属性，从该组件可以生成组件以在一个或多个操作平台上操作。 识别组件的属性。 组件的功能属性和识别属性存储在蒸馏仓库中。 从蒸馏存储器中，使用关于要在其上执行计算机软件程序的所选择的操作平台的信息，可以生成计算机软件程序的组件以在所选择的操作平台上执行。

公开(公告)号：US20070299823A1

公开(公告)日：2007-12-27

申请号：US11475401

申请日：2006-06-26

Applicant: Timothy E. Getsch ,  Sumit Chauhan ,  Clinton D. Covington

Inventor： Timothy E. Getsch ,  Sumit Chauhan ,  Clinton D. Covington

IPC: G06F17/30

CPC classification number: G06F17/30554

Abstract: A customized form is provided for entering parameters associated with a query. A user may desire to modify a report resulting from a query to a database. To enter the parameters for modification, a customized form is displayed to the user. The customized form allows for entry of the parameters according to prompts that are related by their presentation to the form being generated.

Abstract translation: 提供用于输入与查询相关联的参数的自定义表单。 用户可能希望将从查询产生的报告修改到数据库。 要输入修改参数，会向用户显示一个自定义表单。 自定义表单允许根据与演示相关的提示将参数输入到正在生成的表单中。

公开(公告)号：US08892601B2

公开(公告)日：2014-11-18

申请号：US13281242

申请日：2011-10-25

Applicant: Steven Greenberg ,  Michael Hopkins Smith ,  Vijayalakshmi Ramkumar ,  Brian Eugene Kihneman ,  Alexander Alexandrovich Spiridonov ,  David Michael Jade ,  Shen Wang ,  Sumit Chauhan ,  Gregory Chan ,  Tobias Joakim Bertil Ternström ,  Russell Mark Sinclair ,  Todd Haugen ,  Ritu Singh ,  Daniel J. Cole ,  Peter Alan Carlin ,  Christopher Todd Seitzinger

Inventor： Steven Greenberg ,  Michael Hopkins Smith ,  Vijayalakshmi Ramkumar ,  Brian Eugene Kihneman ,  Alexander Alexandrovich Spiridonov ,  David Michael Jade ,  Shen Wang ,  Sumit Chauhan ,  Gregory Chan ,  Tobias Joakim Bertil Ternström ,  Russell Mark Sinclair ,  Todd Haugen ,  Ritu Singh ,  Daniel J. Cole ,  Peter Alan Carlin ,  Christopher Todd Seitzinger

IPC: G06F7/00 ,  G06F17/30 ,  G06F21/31 ,  G06F9/44 ,  H04L29/08 ,  H04W4/00

CPC classification number: G06F9/44 ,  G06F17/3089 ,  G06F21/31 ,  H04L67/02 ,  H04W4/60

Abstract: Creating web application using cloud-based friction-free databases without web hosting knowledge. User credentials are received at a web application service for initiating a web application task via client software. The user credentials are analyzed to determine whether to grant the user permission to initiate the requested web application task. The web application task is initiated when the permission is granted. Data associated with the initiated web application task is received at the web application service for analysis of the data to host and render a web application based solely on received data provided without basis of web hosting knowledge.

Abstract translation: 使用基于云的无摩擦数据库创建Web应用程序，而不需要Web托管知识。 用户凭证在Web应用程序服务中被接收，用于通过客户端软件发起Web应用程序任务。 分析用户凭证以确定是否授予用户启动所请求的web应用程序任务的权限。 Web应用程序任务在授予权限时启动。 在Web应用服务处接收与发起的Web应用任务相关联的数据，用于分析数据以仅基于接收到的数据进行托管和呈现Web应用，而不依赖于web托管知识。

公开(公告)号：US08396848B2

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

申请号：US11475401

申请日：2006-06-26

Applicant: Timothy E. Getsch ,  Sumit Chauhan ,  Clinton D. Covington

Inventor： Timothy E. Getsch ,  Sumit Chauhan ,  Clinton D. Covington

IPC: G06F17/30

CPC classification number: G06F17/30554

Abstract: A customized form is provided for entering parameters associated with a query. A user may desire to modify a report resulting from a query to a database. To enter the parameters for modification, a customized form is displayed to the user. The customized form allows for entry of the parameters according to prompts that are related by their presentation to the form being generated.

Abstract translation: 提供用于输入与查询相关联的参数的自定义表单。 用户可能希望将从查询产生的报告修改到数据库。 要输入修改参数，会向用户显示一个自定义表单。 自定义表单允许根据与演示相关的提示将参数输入到正在生成的表单中。