首页>
外国专利>
Application of a spreadsheet formula algorithm against a dataset such as a large external data source
Application of a spreadsheet formula algorithm against a dataset such as a large external data source
展开▼
机译:电子表格公式算法在大型外部数据源等数据集中的应用
展开▼
页面导航
摘要
著录项
相似文献
摘要
Disclosed are a method, a device, a system and/or a manufacture of application of a spreadsheet formula algorithm against a dataset such as a large external data source. In one embodiment, a scalable method of analyzing data includes generating a prototype data through importing a data entry from the dataset and mapping to cells of a spreadsheet file that may be accessible as a software-as-a-service. A data model for analyzing the dataset is defined through a spreadsheet algorithm comprising spreadsheet formulas outputting a dependent variable. The spreadsheet formulas, with one or more independent variables as inputs, are stored in a syntax format permitting independent calculation of the dependent variable. An extrapolated algorithm expressed in a programming language that may include SQL is generated from the formula algorithm and applied against the dataset utilizing parallel processing to generate a value for the dependent variable of each data entry of the dataset.
展开▼