RUI: Query Optimization for Multi-Database and Data Warehousing

RUI：多数据库和数据仓库的查询优化

• 批准号: 0083312
• 负责人: Fereidoon Sadri
• 金额: $ 14.84万
• 依托单位: University of North Carolina Greensboro
• 依托单位国家: 美国
• 项目类别: Continuing Grant
• 财政年份: 2001
• 资助国家: 美国
• 起止时间: 2001-04-01 至 2004-12-31
• 项目状态: 已结题
• 来源: https://www.nsf.gov/awardsearch/showAward?AWD_ID=0083312&HistoricalAwards=false
• 关键词: RUI; Query; Optimization; Multi; Database

RUI: Query Optimization for Multi-Database and Data Warehousing In multi-database systems, similar information may be represented under different structures (schemas). Current database languages are suitable for querying a single database, but are not powerful enough to reconcile such "schematic heterogeneity" among databases. New languages have been proposed to achieve interoperability among multiple databases. This research project is concerned with query optimization for such languages, in particular "schemaSQL", a recently proposed extension of the industry-standard database language SQL. The restructuring capabilities provided by schemaSQL and similar languages have applications far beyond multi-database systems. For example, operating data over possibly many years of operation are summarized and stored in a data warehouse. The warehouse data can then be analyzed for patterns and trends to improve the operations. Restructuring of the warehouse data can potentially result in a significant increase in query processing efficiency. This research project involves a team of graduate and undergraduate students, and will enhance the development of human resources in science and engineering both at graduate as well as undergraduate level. The results of this project will provide a new approach to querying and query optimization using restructuring and will have applications in multi-database systems interoperability and efficient query processing, data warehousing efficiency, and physical database structuring for optimized operation. URL: http://www.uncg.edu/~sadrif/nsf/query-optimization.html

RUI：对多数据库和数据仓库的查询优化，在多数据库系统中，可以在不同的结构（模式）下表示类似的信息。当前的数据库语言适合查询单个数据库，但功能不足以调和数据库之间的“示意性异质性”。已经提出了新的语言来实现多个数据库之间的互操作性。该研究项目与此类语言的查询优化有关，特别是“ Schemasql”，这是最近提议的行业标准数据库语言SQL的扩展。 Schemasql和类似语言提供的重组功能的应用程序远远超出了多数据库系统。例如，在数据仓库中汇总并存储了可能多年的运行数据的操作数据。然后可以分析仓库数据的模式和趋势以改善操作。仓库数据的重组可能会导致查询处理效率的显着提高。该研究项目涉及一支毕业生和本科生的团队，并将在研究生和本科水平上增强人力资源的发展。该项目的结果将提供一种新的方法来使用重组来查询和查询优化，并将在多数据库系统互操作性和有效查询处理，数据仓库效率以及物理数据库结构中具有用于优化操作的应用程序。 URL：http：//www.uncg.edu/~sadrif/nsf/query-optimization.html