On Referring Expressions in Information Systems Derived from Conceptual Modelling
On Referring Expressions in Information Systems Derived from Conceptual Modelling
复制标题
概念建模衍生的信息系统中的指称表达
DOI：
10.1007/978-3-319-46397-1_14
复制
发表时间：
2016
期刊：
影响因子：
--
通讯作者：
G. Weddell
中科院分区：
文献类型：
--
作者：
Alexander Borgida;David Toman;G. Weddell
我们将最近关于引用表达类型的工作应用于概念建模中的识别问题。特别是，我们考虑这样的类型如何在基于概念模式的信息系统映射到关系模式加 SQL 查询的设置中产生关注点分离。我们从一个简单的以对象为中心的表示（如语义数据模型）开始，其中命名不是问题，因为一切都是自我识别的（可能使用代理）。然后，我们允许分析人员为每个类附加一个首选的“引用表达式类型”，并以广义函数依赖的形式指定唯一性约束。我们展示了（1）如何有效地诊断与引用表达式的分配有关的许多格式良好的条件，以及（2）附加到类的上述类型如何允许从概念模式和对其查询的组合中派生出具体的关系模式和对它的 SQL 查询。
We apply recent work on referring expression types to the issue of identification in Conceptual Modelling. In particular, we consider how such types yield a separation of concerns in a setting where an Information System based on a conceptual schema is to be mapped to a relational schema plus SQL queries. We start from a simple object-centered representation (as in semantic data models), where naming is not an issue because everything is self-identified (possibly using surrogates). We then allow the analyst to attach to every class a preferred “referring expression type”, and to specify uniqueness constraints in the form of generalized functional dependencies. We show (1) how a number of well-formedness conditions concerning an assignment of referring expressions can be efficiently diagnosed, and (2) how the above types attached to classes allow a concrete relational schema and SQL queries over it to be derived from a combination of the conceptual schema and queries over it.