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

1. 发明授权

US07299223B2 Spreadsheet to SQL translation 有权
标题翻译：电子表格到SQL翻译
公开(公告)号：US07299223B2
公开(公告)日：2007-11-20
申请号：US10893547
申请日：2004-07-15
申请人： Aman Namait , Allison Waingold , Martin Roth , Andrew Witkowski
发明人： Aman Namait , Allison Waingold , Martin Roth , Andrew Witkowski
IPC分类号： G06F17/30 , G06F17/00
CPC分类号： G06F17/246 , G06F17/30427 , Y10S707/99933 , Y10S707/99934 , Y10S707/99942
摘要： Users can create computational models in a spreadsheet application and automatically apply the model to data stored in a relational database. By importing a sample of the data from a database table into the spreadsheet application, users can build spreadsheet models that perform analysis and computations on the sample data. Once the model is complete, the spreadsheet model is translated into an SQL format model understood by the database. The SQL model can operate on the entire data set in the database, rather than just the sample data used to construct the model. The SQL model and its associated data are stored in the database, and the model can be executed on a different sets of data. A web browser based front-end allows model users to access the SQL model via a web browser, eliminating the need for model users to have a spreadsheet application.
摘要翻译：用户可以在电子表格应用程序中创建计算模型，并自动将模型应用于存储在关系数据库中的数据。通过将数据库表中的数据样本导入电子表格应用程序，用户可以构建对样本数据进行分析和计算的电子表格模型。模型完成后，电子表格模型将被转换为数据库了解的SQL格式模型。 SQL模型可以对数据库中的整个数据集进行操作，而不仅仅是用于构建模型的样本数据。 SQL模型及其相关数据存储在数据库中，模型可以在不同的数据集上执行。基于Web浏览器的前端允许模型用户通过Web浏览器访问SQL模型，从而无需模型用户使用电子表格应用程序。

2. 发明申请

US20050039114A1 Spreadsheet to SQL translation 有权
标题翻译：电子表格到SQL翻译
公开(公告)号：US20050039114A1
公开(公告)日：2005-02-17
申请号：US10893547
申请日：2004-07-15
申请人： Aman Naimat , Allison Waingold , Martin Roth , Andrew Witkowski
发明人： Aman Naimat , Allison Waingold , Martin Roth , Andrew Witkowski
IPC分类号： G06F17/24 , G06F17/30 , G06F17/21
CPC分类号： G06F17/246 , G06F17/30427 , Y10S707/99933 , Y10S707/99934 , Y10S707/99942
摘要： Users can create computational models in a spreadsheet application and automatically apply the model to data stored in a relational database. By importing a sample of the data from a database table into the spreadsheet application, users can build spreadsheet models that perform analysis and computations on the sample data. Once the model is complete, the spreadsheet model is translated into an SQL format model understood by the database. The SQL model can operate on the entire data set in the database, rather than just the sample data used to construct the model. The SQL model and its associated data are stored in the database, and the model can be executed on a different sets of data. A web browser based front-end allows model users to access the SQL model via a web browser, eliminating the need for model users to have a spreadsheet application.
摘要翻译：用户可以在电子表格应用程序中创建计算模型，并自动将模型应用于存储在关系数据库中的数据。通过将数据库表中的数据样本导入电子表格应用程序，用户可以构建对样本数据进行分析和计算的电子表格模型。模型完成后，电子表格模型将被转换为数据库了解的SQL格式模型。 SQL模型可以对数据库中的整个数据集进行操作，而不仅仅是用于构建模型的样本数据。 SQL模型及其相关数据存储在数据库中，模型可以在不同的数据集上执行。基于Web浏览器的前端允许模型用户通过Web浏览器访问SQL模型，从而无需模型用户使用电子表格应用程序。

3. 发明授权

US07523395B1 Web application generator for spreadsheet calculators 有权
标题翻译：用于电子表格计算器的Web应用程序生成器
公开(公告)号：US07523395B1
公开(公告)日：2009-04-21
申请号：US10452699
申请日：2003-05-30
申请人： Aman Namait , Max Schireson , Allison Waingold
发明人： Aman Namait , Max Schireson , Allison Waingold
IPC分类号： G06F17/00
CPC分类号： G06F17/246 , G06F17/3089
摘要： A method and system automatically creates and operates a web application from a spreadsheet without the need for specialized programming. The web application includes a guided data entry process created from spreadsheet worksheets. The web application interfaces with a database application, so that model data may be retrieved for analysis. The web application implements the model as a calculator data defining the relationships between the model values. A rendering data defines the appearance of the model values in the web application. A instance data includes the model values for an instance of the web application. A calculation engine calculates model values. A layout engine creates display information from the calculator, rendering, and instance data set. The rendering data includes objects having display methods for creating display information in accordance with its object type. Object types include inputs, outputs, and user interface elements.
摘要翻译：方法和系统自动地从电子表格创建和操作Web应用程序，而不需要专门的编程。 Web应用程序包括从电子表格工作表创建的引导数据输入过程。 Web应用程序与数据库应用程序接口，以便可以检索模型数据以进行分析。 Web应用程序将模型实现为定义模型值之间的关系的计算器数据。渲染数据定义了Web应用程序中模型值的外观。实例数据包括Web应用程序实例的模型值。计算引擎计算模型值。布局引擎从计算器，渲染和实例数据集创建显示信息。呈现数据包括具有根据其对象类型创建显示信息的显示方法的对象。对象类型包括输入，输出和用户界面元素。

4. 发明授权

US07865507B2 Data quality analyzer 有权
标题翻译：数据质量分析仪
公开(公告)号：US07865507B2
公开(公告)日：2011-01-04
申请号：US10663296
申请日：2003-09-15
申请人： Aman Namait , Allison Waingold , Xin Jiang , John S. Kowtko
发明人： Aman Namait , Allison Waingold , Xin Jiang , John S. Kowtko
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06Q30/02 , G06Q10/10
摘要： A method of and system for evaluating contacts stored in data source. In one embodiment the method allows a user to define a data format; allows a user to define a plurality of rules intended to operate on and assess a quality of data formatted according to the data format; map data identifying a plurality of contacts from the data source to the data format; and execute the plurality of rules on the mapped data to produce a set of analyzed data that allows evaluation of potential contacts according to an assessed quality of the data.
摘要翻译：用于评估存储在数据源中的联系人的方法和系统。在一个实施例中，该方法允许用户定义数据格式; 允许用户定义旨在对根据数据格式格式化的数据的质量进行操作和评估的多个规则; 将从数据源识别多个联系人的数据映射到数据格式; 并对映射的数据执行多个规则以产生一组分析数据，其允许根据所评估的数据质量评估潜在的联系人。

5. 发明申请

US20050060313A1 Data quality analyzer 有权
标题翻译：数据质量分析仪
公开(公告)号：US20050060313A1
公开(公告)日：2005-03-17
申请号：US10663296
申请日：2003-09-15
申请人： Aman Naimat , Allison Waingold , Xin Jiang , John Kowtko
发明人： Aman Naimat , Allison Waingold , Xin Jiang , John Kowtko
IPC分类号： G06F17/30
CPC分类号： G06Q30/02 , G06Q10/10
摘要： A method of and system for evaluating contacts stored in data source. In one embodiment the method allows a user to define a data format; allows a user to define a plurality of rules intended to operate on and assess a quality of data formatted according to the data format; map data identifying a plurality of contacts from the data source to the data format; and execute the plurality of rules on the mapped data to produce a set of analyzed data that allows evaluation of potential contacts according to an assessed quality of the data.
摘要翻译：用于评估存储在数据源中的联系人的方法和系统。在一个实施例中，该方法允许用户定义数据格式; 允许用户定义旨在对根据数据格式格式化的数据的质量进行操作和评估的多个规则; 将从数据源识别多个联系人的数据映射到数据格式; 并对映射的数据执行多个规则以产生一组分析数据，其允许根据所评估的数据质量评估潜在的联系人。

6. 发明授权

US07877379B2 Delaying evaluation of expensive expressions in a query 有权
标题翻译：在查询中延迟评估昂贵的表达式
公开(公告)号：US07877379B2
公开(公告)日：2011-01-25
申请号：US11242361
申请日：2005-09-30
申请人： Allison Waingold , Rafi Ahmed , Bhaskar Ghosh , Dinesh Das , Mohamed Zait
发明人： Allison Waingold , Rafi Ahmed , Bhaskar Ghosh , Dinesh Das , Mohamed Zait
IPC分类号： G06F7/00
CPC分类号： G06F17/30463 , Y10S707/99932
摘要： Techniques are provided for delaying evaluation of expensive expressions in a query. Expensive expressions in the query are established by cost information or by looking up a list of known expensive expressions for a match. After an execution plan is determined by using the early evaluation technique, one or more equivalent execution plans is established. The one or more equivalent execution plans may include both a type of execution plans that delay evaluation of expensive expressions and a type of execution plans that do not. In addition, the one or more equivalent execution plans may include both parallelized and non-parallelized alternatives to the execution plan identified by the early evaluation technique. Finally, based on a set of criteria, which may include comparing cost information among all the equivalent execution plans generated thus far, the best execution plan is chosen for the query.
摘要翻译：提供了用于延迟查询中昂贵表达式的评估的技术。查询中的昂贵表达式是通过成本信息建立的，或通过查找匹配的已知昂贵表达式的列表来确定。在通过使用早期评估技术确定执行计划之后，建立一个或多个等效执行计划。一个或多个等效执行计划可以包括延迟对昂贵表达式的评估的执行计划的类型以及不执行计划的类型。此外，一个或多个等效执行计划可以包括由早期评估技术识别的执行计划的并行化和非并行化替代方案。最后，基于一组标准，其中可能包括比较到目前为止生成的所有等效执行计划中的成本信息，为查询选择最佳执行计划。

7. 发明申请

US20070078812A1 Delaying evaluation of expensive expressions in a query 有权
标题翻译：在查询中延迟评估昂贵的表达式
公开(公告)号：US20070078812A1
公开(公告)日：2007-04-05
申请号：US11242361
申请日：2005-09-30
申请人： Allison Waingold , Rafi Ahmed , Bhaskar Ghosh , Dinesh Das , Mohamed Zait
发明人： Allison Waingold , Rafi Ahmed , Bhaskar Ghosh , Dinesh Das , Mohamed Zait
IPC分类号： G06F17/30
CPC分类号： G06F17/30463 , Y10S707/99932
摘要： Techniques are provided for delaying evaluation of expensive expressions in a query. Expensive expressions in the query are established by cost information or by looking up a list of known expensive expressions for a match. After an execution plan is determined by using the early evaluation technique, one or more equivalent execution plans is established. The one or more equivalent execution plans may include both a type of execution plans that delay evaluation of expensive expressions and a type of execution plans that do not. In addition, the one or more equivalent execution plans may include both parallelized and non-parallelized alternatives to the execution plan identified by the early evaluation technique. Finally, based on a set of criteria, which may include comparing cost information among all the equivalent execution plans generated thus far, the best execution plan is chosen for the query.
摘要翻译：提供了用于延迟查询中昂贵表达式的评估的技术。查询中的昂贵表达式是通过成本信息建立的，或通过查找匹配的已知昂贵表达式的列表来确定。在通过使用早期评估技术确定执行计划之后，建立一个或多个等效执行计划。一个或多个等效执行计划可以包括延迟对昂贵表达式的评估的执行计划的类型以及不执行计划的类型。此外，一个或多个等效执行计划可以包括由早期评估技术识别的执行计划的并行化和非并行化替代方案。最后，基于一组标准，其中可能包括比较到目前为止生成的所有等效执行计划中的成本信息，为查询选择最佳执行计划。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式