Relational support for flexible schema scenarios
Relational support for flexible schema scenarios
复制标题
对灵活模式场景的关系支持
DOI：
--
复制
发表时间：
2008
影响因子：
2.5
通讯作者：
P. Zabback
中科院分区：
文献类型：
--
作者：
Srini Acharya;Peter Carlin;C. Galindo;Krzysztof Kozielczyk;P. Terlecki;P. Zabback
对处理数据异构性、层次结构和模式演化的应用程序的有效支持是关系引擎的一个重要挑战。在本文中，我们将展示如何在Microsoft SQL Server中处理这种灵活性。为此，该引擎已配备在一个集成的包的关系扩展。该软件包包括稀疏存储，列集操作，过滤索引，过滤统计和层次结构查询与OrdPath标签。此外，元数据的经济加载允许我们独立于表中的列数来回答查询，并大大提高了伸缩能力。描述了一个基于宽表的原型内容和协作应用程序的设计，沿着实验验证了其性能。
Efficient support for applications that deal with data heterogeneity, hierarchies and schema evolution is an important challenge for relational engines. In this paper we show how this flexibility can be handled in Microsoft SQL Server. For this purpose, the engine has been equipped in an integrated package of relational extensions. The package includes sparse storage, column set operations, filtered indices, filtered statistics and hierarchy querying with OrdPath labeling. In addition, economical loading of metadata allow us to answer queries independently of the number of columns in a table and drastically improve scaling capabilities. The design of a prototypical content and collaboration application based on a wide table is described, along with experiments validating its performance.