2019
DOI: 10.4204/eptcs.288.5
|View full text |Cite
|
Sign up to set email alerts
|

Finding the Transitive Closure of Functional Dependencies using Strategic Port Graph Rewriting

Abstract: We present a new approach to the logical design of relational databases, based on strategic port graph rewriting. We show how to model relational schemata as attributed port graphs and provide port graph rewriting rules to perform computations on functional dependencies. Using these rules we present a strategic graph program to find the transitive closure of a set of functional dependencies. This program is sound, complete and terminating, assuming that there are no cyclical dependencies in the schema.

Help me understand this report
View preprint versions

Search citation statements

Order By: Relevance

Paper Sections

Select...
2
1
1
1

Citation Types

0
6
0

Year Published

2020
2020
2024
2024

Publication Types

Select...
2
1

Relationship

1
2

Authors

Journals

citations
Cited by 3 publications
(6 citation statements)
references
References 15 publications
0
6
0
Order By: Relevance
“…Transitivity Strategy: This strategy, without the calls to the Augmentation strategy in line 17 and line 23, was shown to be terminating in [27]. We use the same measures, since they are not affected by the call to the Augmentation strategy: For repeat(one(T ransitivity k ); #Augmentation#), the measure is the number of possible matches of the LHS subgraph of f1.…”
Section: Discussionmentioning
confidence: 99%
See 4 more Smart Citations
“…Transitivity Strategy: This strategy, without the calls to the Augmentation strategy in line 17 and line 23, was shown to be terminating in [27]. We use the same measures, since they are not affected by the call to the Augmentation strategy: For repeat(one(T ransitivity k ); #Augmentation#), the measure is the number of possible matches of the LHS subgraph of f1.…”
Section: Discussionmentioning
confidence: 99%
“…This design decision is based on the separation of concerns principle. The Functional Dependency Port Graph (FDPGs) [27] is a particular case of the above defined Database Port Graph, with Attribute and FD nodes only. An example FDPG is given in Figure 10 in Appendix E.…”
Section: Definition 3 (Relational Database Port Graph Vdsl Rdpg-vdsl)mentioning
confidence: 99%
See 3 more Smart Citations