III: Small: Issues in Understanding, Indexing, Querying, and Visualizing Spatio-Textual Spreadsheets on the Web

III：小：网络上的空间文本电子表格的理解、索引、查询和可视化问题

• 批准号: 1018475
• 负责人: Hanan Samet
• 金额: $ 50万
• 依托单位: University of Maryland, College Park
• 依托单位国家: 美国
• 项目类别: Standard Grant
• 财政年份: 2010
• 资助国家: 美国
• 起止时间: 2010-09-01 至 2014-08-31
• 项目状态: 已结题
• 来源: https://www.nsf.gov/awardsearch/showAward?AWD_ID=1018475&HistoricalAwards=false
• 关键词: III; Small; Issues; Understanding; Indexing

Numerous organizations including government agencies are sitting on mountains of spreadsheet data that are becoming increasingly common on the web, but whose contents remain out of reach via search engines because direct links to the contents of their constituent cells arerare. Thus spreadsheet data represent legacy databases, especiallysince many of their underlying schemas are no longer accessible. Thegoal of this research is to discover the schema according to which the spreadsheet is constructed. The focus is on the spatio-textualspreadsheet which is a spreadsheet where the values of the spatialattributes are specified textually. Such spreadsheets support spatialsearches whose output is visual and whose utility is enhanced by beingable to handle spatial synonyms. This is done, in part, by devisingmethods to automatically discover the spatial attributes of thespreadsheet as well as how to distinguish between several instances ofthem which arise due to the presence of a containment hierarchy. Inparticular, use is made of spatial coherence which is manifested byobserving that spatial data in the same column are usually of the samespatial type, while spatial data in the same spreadsheet row usuallyexhibit a containment relationship. Moreover, adjacent or nearby rowsexhibit spreadsheet coherence in that they are usually similar. Thebroad impact of this research is to make spreadsheet data a firstclass citizen on the web with the same chances of being discovered andaccessed as data found in other documents. Reports describingresults of this and related research will be available athttp://www.cs.umd.edu/~hjs/spreadsheets.html

包括政府机构在内的许多组织都坐拥堆积如山的电子表格数据，这些数据在网络上变得越来越普遍，但其内容仍然无法通过搜索引擎获得，因为很少有直接链接到其组成单元格的内容。 因此，电子表格数据代表遗留数据库，特别是因为它们的许多底层模式不再可访问。 本研究的目的是发现电子表格的架构。 重点是spatio-textualspreadsheet，这是一个spatialattributes的值以文本方式指定的电子表格。 这样的电子表格支持空间搜索，其输出是可视的，并且其效用通过能够处理空间同义词而增强。 这部分是通过设计方法来自动发现spreadsheet的空间属性，以及如何区分由于包含层次结构的存在而出现的几个实例。 特别是，使用空间一致性，这是通过观察同一列中的空间数据通常是相同的空间类型来表现的，而同一电子表格行中的空间数据通常表现出包含关系。 此外，相邻或邻近的行可以增强电子表格的一致性，因为它们通常是相似的. 这项研究的广泛影响是使电子表格数据成为网络上的一等公民，与其他文档中的数据一样有机会被发现和访问。 描述本研究结果和相关研究的报告将在http：//www.example.com上提供www.cs.umd.edu/~hjs/spreadsheets.html