Abstract
We investigate the implication problem for classes of data dependencies over SQL table definitions. Under Zaniolo's “no information” interpretation of null markers we establish an axiomatization and algorithms to decide the implication problem for the combined class of functional and multivalued dependencies in the presence of NOT NULL constraints. The resulting theory subsumes three previously orthogonal frameworks. We further show that the implication problem of this class is equivalent to that in a propositional fragment of Schaerf and Cadoli's [1995] family of para-consistent S-3 logics. In particular, S is the set of variables that correspond to attributes declared NOT NULL. We also show how our equivalences for multivalued dependencies can be extended to Delobel's class of full first-order hierarchical decompositions, and the equivalences for functional dependencies can be extended to arbitrary Boolean dependencies. These dualities allow us to transfer several findings from the propositional fragments to the corresponding classes of data dependencies, and vice versa. We show that our results also apply to Codd's null interpretation “value unknown at present”, but not to Imielinski's [1989] or-relations utilizing Levene and Loizou's weak possible world semantics [Levene and Loizou 1998]. Our findings establish NOT NULL constraints as an effective mechanism to balance not only the certainty in database relations but also the expressiveness with the efficiency of entailment relations. They also control the degree by which the implication of data dependencies over total relations is soundly approximated in SQL table definitions.
Supplemental Material
Available for Download
Supplemental movie, appendix, image and software files for, The implication problem of data dependencies over SQL table definitions: Axiomatic, algorithmic and logical characterizations.
- Abiteboul, S., Hull, R., and Vianu, V. 1995. Foundations of Databases. Addison-Wesley, Boston, MA. Google ScholarDigital Library
- Antova, L., Koch, C., and Olteanu, D. 2009. 10(106) worlds and beyond: Efficient representation and processing of incomplete information. VLDB J. 18, 5, 1021--1040. Google ScholarDigital Library
- Arenas, M., Barcelo, P., Libkin, L., and Murlak, F. 2010. Relational and XML Data Exchange. Synthesis Lectures on Data Management. Morgan & Claypool Publishers. Google ScholarDigital Library
- Arenas, M., Fan, W., and Libkin, L. 2008. On the complexity of verifying consistency of XML specifications. SIAM J. Comput. 38, 3, 841--880. Google ScholarDigital Library
- Arenas, M. and Libkin, L. 2004. A normal form for XML documents. ACM Trans. Datab. Syst. 29, 1, 195--232. Google ScholarDigital Library
- Arenas, M. and Libkin, L. 2005. An information-theoretic approach to normal forms for relational and XML data. J. ACM 52, 2, 246--283. Google ScholarDigital Library
- Armstrong, W. W. 1974. Dependency structures of database relationships. Inf. Process. 74, 580--583.Google Scholar
- Atzeni, P. and Morfuni, N. 1986. Functional dependencies and constraints on null values in database relations. Inf. Control 70, 1, 1--31. Google ScholarDigital Library
- Beeri, C. 1980. On the membership problem for functional and multivalued dependencies in relational databases. ACM Trans. Datab. Syst. 5, 3, 241--259. Google ScholarDigital Library
- Beeri, C. and Bernstein, P. 1979. Computational problems related to the design of normal form relational schemas. ACM Trans. Datab. Syst. 4, 1, 30--59. Google ScholarDigital Library
- Beeri, C., Bernstein, P. A., and Goodman, N. 1978. A sophisticate's introduction to database normalization theory. In Proceedings of the 4th International Conference on Very Large Databases (VLDB). IEEE Computer Society, 113--124. Google ScholarDigital Library
- Beeri, C., Dowd, M., Fagin, R., and Statman, R. 1984. On the structure of Armstrong relations for functional dependencies. J. ACM 31, 1, 30--46. Google ScholarDigital Library
- Beeri, C., Fagin, R., and Howard, J. H. 1977. A complete axiomatization for functional and multivalued dependencies in database relations. In Proceedings of the SIGMOD International Conference on Management of Data. ACM, 47--61. Google ScholarDigital Library
- Beeri, C., Fagin, R., Maier, D., and Yannakakis, M. 1983. On the desirability of acyclic database schemes. J. ACM 30, 3, 479--513. Google ScholarDigital Library
- Beeri, C. and Vardi, M. 1984. Formal systems for tuple and equality generating dependencies. SIAM J. Comput. 13, 1, 76--98.Google ScholarCross Ref
- Bernstein, P. 1976. Synthesizing third normal form relations from functional dependencies. ACM Trans. Datab. Syst. 1, 4, 277--298. Google ScholarDigital Library
- Biskup, J. 1978. On the complementation rule for multivalued dependencies. Acta Inf. 10, 297--305.Google ScholarDigital Library
- Biskup, J. 2009. Security in Computing Systems. Springer.Google Scholar
- Biskup, J., Dayal, U., and Bernstein, P. 1979. Synthesizing independent database schemas. In Proceedings of the ACM SIGMOD International Conference on Management of Data (SIGMOD). ACM, 143--151. Google ScholarDigital Library
- Biskup, J., Embley, D., and Lochner, J. 2008. Reducing inference control to access control for normalized database schemas. Inf. Proc. Letters 106, 1, 8--12. Google ScholarDigital Library
- Biskup, J. and Link, S. 2011. Appropriate inferences of data dependencies in relational databases. Ann. Math. Artif. Intell. 63, 3-4, 213--255. Google ScholarDigital Library
- Biskup, J. and Weibert, T. 2008. Keeping secrets in incomplete databases. Int. J. Inf. Sec. 7, 3, 199--217. Google ScholarDigital Library
- Bojanczyk, M., Muscholl, A., Schwentick, T., and Segoufin, L. 2009. Two-Variable logic on data trees and XML reasoning. J. ACM 56, 3, Article 13. Google ScholarDigital Library
- Börger, E., Grädel, E., and Gurevich, Y. 1997. The Classical Decision Problem. Springer.Google Scholar
- Cadoli, M. and Schaerf, M. 1996. On the complexity of entailment in propositional multivalued logics. Ann. Math. Artif. Intell. 18, 1, 29--50.Google ScholarCross Ref
- Cali, A., Calvanese, D., De Giacomo, G., and Lenzerini, M. 2004. Data integration under integrity constraints. Inf. Syst. 29, 2, 147--163. Google ScholarDigital Library
- Casanova, M., Fagin, R., and Papadimitriou, C. 1984. Inclusion dependencies and their interaction with functional dependencies. J. Comput. System Sci. 28, 1, 29--59.Google ScholarCross Ref
- Chandra, A., Lewis, H., and Makowsky, J. 1981. Embedded implicational dependencies and their inference problem. In Proceedings of the 13th Annual ACM Symposium on Theory of Computing (STOC). ACM, 342--354. Google ScholarDigital Library
- Chomicki, J. 2007. Consistent query answering: Five easy pieces. In Proceedings of the 11th International Conference on Database Theory (ICDT). Lecture Notes in Computer Science Series, vol. 4353, Springer, 1--17. Google ScholarDigital Library
- Codd, E. F. 1970. A relational model of data for large shared data banks. Comm. ACM 13, 6, 377--387. Google ScholarDigital Library
- Codd, E. F. 1975. Understanding relations. ACM SIGFIDET FDT Bull. 7, 3-4, 23--28.Google Scholar
- Codd, E. F. 1979. Extending the database relational model to capture more meaning. ACM Trans. Datab. Syst. 4, 4, 397--434. Google ScholarDigital Library
- Cresswell, M. and Hughes, G. 1996. A New Introduction to Modal Logic. Routledge, London and New York.Google Scholar
- Date, C. and Darwen, H. 1997. A Guide to the SQL Standard. Addison-Wesley Professional, Reading, MA. Google ScholarDigital Library
- Davidson, S., Fan, W., and Hara, C. 2007. Propagating XML constraints to relations. J. Comput. Syst. Sci. 73, 3, 316--361. Google ScholarDigital Library
- Davis, M. and Putnam, H. 1960. A computing procedure for quantification theory. J. ACM 7, 201--215. Google ScholarDigital Library
- De Marchi, F., Lopes, S., Petit, J.-M., and Toumani, F. 2003. Analysis of existing databases at the logical level: The DBA companion project. SIGMOD Rec. 32, 1, 47--52. Google ScholarDigital Library
- De Marchi, F. and Petit, J.-M. 2007. Semantic sampling of existing databases through informative Armstrong databases. Inf. Syst. 32, 3, 446--457. Google ScholarDigital Library
- Delobel, C. 1978. Normalization and hierarchical dependencies in the relational data model. ACM Trans. Datab. Syst. 3, 3, 201--222. Google ScholarDigital Library
- Delobel, C. and Adiba, M. 1985. Relational Database Systems. Elsevier North Holland, New York. Google ScholarDigital Library
- Demetrovics, J., Katona, G., Miklos, D., and Thalheim, B. 2006. On the number of independent functional dependencies. In Proceedings of the 4th International Symposium on Foundations of Information and Knowledge Bases (FoIKS). Lecture Notes in Computer Science, vol. 3861, Springer, 83--91. Google ScholarDigital Library
- Deutsch, A., Ludäscher, B., and Nash, A. 2007. Rewriting queries using views with access patterns under integrity constraints. Theor. Comput. Sci. 371, 3, 200--226. Google ScholarDigital Library
- Deutsch, A., Popa, L., and Tannen, V. 2006. Query reformulation with constraints. SIGMOD Rec. 35, 1, 65--73. Google ScholarDigital Library
- Diederich, J. and Milton, J. 1988. New methods and fast algorithms for database normalization. ACM Trans. Datab. Syst. 13, 3, 339--365. Google ScholarDigital Library
- Dowling, W. and Gallier, J. 1984. Linear-time algorithms for testing the satisfiability of propositional Horn formulae. J. Log. Program. 1, 3, 267--284.Google ScholarCross Ref
- Engel, K. 1997. Sperner Theory. Cambridge University Press, Cambridge, UK. Google ScholarDigital Library
- Fagin, R. 1977a. Functional dependencies in a relational data base and propositional logic. IBM J. Res. Devel. 21, 6, 543--544. Google ScholarDigital Library
- Fagin, R. 1977b. Multivalued dependencies and a new normal form for relational databases. ACM Trans. Datab. Syst. 2, 3, 262--278. Google ScholarDigital Library
- Fagin, R. 1982a. Armstrong databases. Tech. rep. RJ3440(40926), IBM Research Laboratory, San Jose, CA.Google Scholar
- Fagin, R. 1982b. Horn clauses and database dependencies. J. ACM 29, 4, 952--985. Google ScholarDigital Library
- Fagin, R., Kolaitis, P., Miller, R., and Popa, L. 2005. Data exchange: Semantics and query answering. Theor. Comput. Sci. 336, 1, 89--124. Google ScholarDigital Library
- Fagin, R., Kolaitis, P., Popa, L., and Tan, W. 2009. Reverse data exchange: coping with nulls. In Proceedings of the 28th ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems (PODS). ACM, 23--32. Google ScholarDigital Library
- Fagin, R. and Vardi, M. 1986. The theory of data dependencies - A survey. In Mathematics of Information Processing. Proceedings of Symposia in Applied Mathematics Series, vol. 34, American Mathematical Society, 19--72.Google Scholar
- Fan, W., Geerts, F., Jia, X., and Kementsietsidis, A. 2008. Conditional functional dependencies for capturing data inconsistencies. ACM Trans. Datab. Syst. 33, 2, Article 6. Google ScholarDigital Library
- Farkas, C. and Jajodia, S. 2002. The inference problem: a survey. SIGKDD Explor. 4, 2, 6--11. Google ScholarDigital Library
- Ferrarotti, F., Hartmann, S., Köhler, H., Link, S., and Vincent, M. 2011. The Boyce-Codd-Heath normal form for SQL. In Proceedings of the 18th International Workshop on Logic, Language, Information and Computation (WoLLIC). Lecture Notes in Artificial Intelligence, vol. 6642, Springer, 110--122. Google ScholarDigital Library
- Galil, Z. 1982. An almost linear-time algorithm for computing a dependency basis in a relational database. J. ACM 29, 1, 96--102. Google ScholarDigital Library
- Gottlob, G., Pichler, R., and Wei, F. 2010. Tractable database design and datalog abduction through bounded treewidth. Inf. Syst. 35, 3, 278--298. Google ScholarDigital Library
- Gottlob, G. and Zicari, R. 1988. Closed world databases opened through null values. In Proceedings of the 14th International Conference on Very Large Databases (VLDB). IEEE Computer Society, 50--61. Google ScholarDigital Library
- Grahne, G. 1984. Dependency satisfaction in databases with incomplete information. In Proceedings of the 10th International Conference on Very Large Databases (VLDB). IEEE Computer Society, 37--45. Google ScholarDigital Library
- Grahne, G. and Räihä, K.-J. 1983. Database decomposition into Fourth Normal Form. In Proceedings of the 9th International Conference on Very Large Databases (VLDB). IEEE Computer Society, 186--196. Google ScholarDigital Library
- Grant, J. 1977. Null values in a relational data base. Inf. Process. Lett. 6, 5, 156--157.Google ScholarCross Ref
- Hagihara, K., Ito, M., Taniguchi, K., and Kasami, T. 1979. Decision problems for multivalued dependencies in relational databases. SIAM J. Comput. 8, 2, 247--264.Google ScholarDigital Library
- Hartmann, S., Kirchberg, M., and Link, S. 2012. Design by example for SQL table definitions with functional dependencies. VLDB J. 21, 1, 121--144. Google ScholarDigital Library
- Hartmann, S., Leck, U., and Link, S. 2011. On Codd families of keys over incomplete relations. Comput. J. 54, 7, 1166--1180. Google ScholarDigital Library
- Hartmann, S. and Link, S. 2008. Characterising nested database dependencies by fragments of propositional logic. Ann. Pure Appl. Logic 152, 1-3, 84--106.Google ScholarCross Ref
- Hartmann, S. and Link, S. 2009. Efficient reasoning about a robust XML key fragment. ACM Trans. Datab. Syst. 34, 2, Article 10. Google ScholarDigital Library
- Hartmann, S. and Link, S. 2010a. Numerical constraints on XML data. Inf. Comput. 208, 5, 521--544. Google ScholarDigital Library
- Hartmann, S. and Link, S. 2010b. When data dependencies over SQL tables meet the Logics of Paradox and S-3. In Proceedings of the 29th ACM SIGMOD-SIGART-SIGACT Symposium on Principles of Database Systems (PODS). ACM, 317--326. Google ScholarDigital Library
- Imielinksi, T. 1989. Incomplete information in logical databases. IEEE Data Eng. Bull. 12, 2, 29--40.Google Scholar
- Imielinski, T. and Lipski Jr., W. 1984. Incomplete information in relational databases. J. ACM 31, 4, 761--791. Google ScholarDigital Library
- Imielinski, T., Van der Meyden, R., and Vadaparty, K. 1995. Complexity tailored design: a new design methodology for databases with incomplete information. J. Comput. Syst. Sci. 51, 3, 405--432. Google ScholarDigital Library
- Jensen, C., Snodgrass, R., and Soo, M. 1996. Extending existing dependency theory to temporal databases. IEEE Trans. Knowl. Data Engin. 8, 4, 563--582. Google ScholarDigital Library
- Khardon, R., Mannila, H., and Roth, D. 1999. Reasoning with examples: Propositional formulae and database dependencies. Acta Inf. 36, 267--286.Google ScholarCross Ref
- Kleene, S. 1952. An Introduction to Metamathematics. North Holland, Amsterdam, The Netherlands.Google Scholar
- Klug, A. and Price, R. 1982. Determining view dependencies using tableaux. ACM Trans. Datab. Syst. 7, 3, 361--380. Google ScholarDigital Library
- Köhler, H. and Link, S. 2010. Armstrong axioms and Boyce-Codd-Heath normal form under bag semantics. Inf. Process. Lett. 110, 16, 717--724. Google ScholarDigital Library
- Kolahi, S. 2007. Dependency-Preserving normalization of relational and XML data. J. Comput. Syst. Sci. 73, 4, 636--647. Google ScholarDigital Library
- Kolahi, S. and Libkin, L. 2010. An information-theoretic analysis of worst-case redundancy in database design. ACM Trans. Datab. Syst. 35, 1, Article 5. Google ScholarDigital Library
- Langeveldt, W. and Link, S. 2010. Empirical evidence for the usefulness of Armstrong relations on the acquisition of meaningful functional dependencies. Inf. Syst. 35, 3, 352--374. Google ScholarDigital Library
- Levene, M. and Loizou, G. 1997. Null inclusion dependencies in relational databases. Inf. Comput. 136, 2, 67--108. Google ScholarDigital Library
- Levene, M. and Loizou, G. 1998. Axiomatisation of functional dependencies in incomplete relations. Theor. Comput. Sci. 206, 1-2, 283--300. Google ScholarDigital Library
- Levene, M. and Loizou, G. 1999. Database design for incomplete relations. ACM Trans. Datab. Syst. 24, 1, 80--125. Google ScholarDigital Library
- Levesque, H. 1989. A knowledge-level account of abduction. In Proceedings of the 11th International Joint Conference on Artificial Intelligence (IJCAI). Morgan Kaufmann, 1061--1067. Google ScholarDigital Library
- Libkin, L. and Wong, L. 1996. Semantic representations and query languages for Or-sets. J. Comput. Syst. Sci. 52, 1, 125--142. Google ScholarDigital Library
- Lien, E. 1982. On the equivalence of database models. J. ACM 29, 2, 333--362. Google ScholarDigital Library
- Link, S. 2008a. Charting the completeness frontier of inference systems for multivalued dependencies. Acta Inf. 45, 7-8, 565--591. Google ScholarDigital Library
- Link, S. 2008b. On the implication of multivalued dependencies in partial database relations. Int. J. Found. Comput. Sci. 19, 3, 691--715.Google ScholarCross Ref
- Link, S. 2012. Characterizing multivalued dependency implication over undetermined universes. J. Comput. Syst. Sci. 78, 4, 1026--1044. Google ScholarDigital Library
- Makinouchi, A. 1977. A consideration on normal form of not-necessarily-normalized relation in the relational data model. In Proceedings of the 3rd International Conference on Very Large Databases (VLDB). IEEE Computer Society, 447--453. Google ScholarDigital Library
- Makowsky, J. and Vardi, M. 1986. On the expressive power of data dependencies. Acta Inf. 23, 3, 231--244. Google ScholarDigital Library
- Malvestuto, F. 1992. A unique formal system for binary decompositions of database relations, probability distributions, and graphs. Inf. Sci. 59, 1-2, 21--52. Google ScholarDigital Library
- Mannila, H. and Räihä, K.-J. 1986. Design by example: An application of Armstrong relations. J. Comput. Syst. Sci. 33, 2, 126--141. Google ScholarDigital Library
- Mannila, H. and Räihä, K.-J. 1994. Algorithms for inferring functional dependencies from relations. Data Knowl. Engin. 12, 1, 83--99. Google ScholarDigital Library
- Marquis, P. and Porquet, N. 2003. Resource-Bounded paraconsistent inference. Ann. Math. Artif. Intell. 39, 349--384. Google ScholarDigital Library
- Niepert, M., Van Gucht, D., and Gyssens, M. 2010. Logical and algorithmic properties of stable conditional independence. Int. J. Approx. Reason. 51, 5, 531--543. Google ScholarDigital Library
- Paredaens, J., De Bra, P., Gyssens, M., and Van Gucht, D. 1989. The Structure of the Relational Database Model. Springer. Google ScholarDigital Library
- Paulley, G. 2000. Exploiting functional dependence in query optimization. Tech. rep. UW-CS-2000-11, University of Waterloo, Waterloo, Canada.Google Scholar
- Paulley, G. and Larson, P.-A. 1994. Exploiting uniqueness in query optimization. In Proceedings of the 10th International Conference on Data Engineering (ICDE). IEEE Computer Society, 68--79. Google ScholarDigital Library
- Petrov, S. Y. 1989. Finite axiomatization of languages for representation of system properties: Axiomatization of dependencies. Inf. Sci. 47, 339--372. Google ScholarDigital Library
- Priest, G. 1979. Logic of paradox. J. Philos. Logic 8, 219--241.Google ScholarCross Ref
- Reiter, R. 1978. On closed world data bases. In Logic and Data Bases, Plenum Press, New York, 119--140.Google Scholar
- Robinson, J. 1965. A machine oriented logic based on resolution principle. J. ACM 12, 397--415. Google ScholarDigital Library
- Sagiv, Y. 1980. An algorithm for inferring multivalued dependencies with an application to propositional logic. J. ACM 27, 2, 250--262. Google ScholarDigital Library
- Sagiv, Y., Delobel, C., Parker Jr., D. S., and Fagin, R. 1981. An equivalence between relational database dependencies and a fragment of propositional logic. J. ACM 28, 3, 435--453. Google ScholarDigital Library
- Sagiv, Y., Delobel, C., Parker Jr., D. S., and Fagin, R. 1987. Correction to “An equivalence between relational database dependencies and a fragment of propositional logic”. J. ACM 34, 4, 1016--1018. Google ScholarDigital Library
- Saxton, L. and Tang, X. 2004. Tree multivalued dependencies for XML datasets. In Proceedings of the 5th International Conference on Advances in Web-Age Information Management (WAIM). Lecture Notes in Computer Science, vol. 3129, Springer, 357--367.Google ScholarCross Ref
- Schaerf, M. and Cadoli, M. 1995. Tractable reasoning via approximation. Artif. Intell. 74, 249--310. Google ScholarDigital Library
- Silva, A. and Melkanoff, M. 1979. A method for helping discover the dependencies of a relation. In Proceedings of the Workshop on Formal Bases for Data Bases - Advances in Data Base Theory. Plemum Press, 115--133.Google Scholar
- Sözat, M. and Yazici, A. 2001. A complete axiomatization for fuzzy functional and multivalued dependencies in fuzzy database relations. ACM Fuzzy Sets Syst. 117, 2, 161--181. Google ScholarDigital Library
- Tari, Z., Stokes, J., and Spaccapietra, S. 1997. Object normal forms and dependency constraints for object-oriented schemata. ACM Trans. Datab. Syst. 22, 513--569. Google ScholarDigital Library
- Thalheim, B. 2000. Entity-Relationship Modeling. Springer. Google ScholarDigital Library
- Toman, D. and Weddell, G. 2008. On keys and functional dependencies as first-class citizens in description logics. J. Autom. Reason. 40, 2-3, 117--132. Google ScholarDigital Library
- Vadaparty, K. and Naqvi, S. 1995. Using constraints for efficient query processing in nondeterministic databases. IEEE Trans. Knowl. Data Engin. 7, 6, 850--864. Google ScholarDigital Library
- Vardi, M. 1982. The complexity of relational query languages. In Proceedings of the 14th ACM Symposium on Theory of Computing (STOC). ACM, 137--146. Google ScholarDigital Library
- Vincent, M. 1999. Semantic foundations of 4NF in relational database design. Acta Inf. 36, 3, 173--213.Google ScholarCross Ref
- Vincent, M. and Liu, J. 2003. Multivalued dependencies and a 4NF for XML. In Proceedings of the 15th International Conference on Advanced Information Systems Engineering (CaISE). Lecture Notes in Computer Science, vol. 2681, Springer, 14--29. Google ScholarDigital Library
- Vincent, M., Liu, J., and Liu, C. 2004. Strong functional dependencies and their application to normal forms in XML. ACM Trans. Datab. Syst. 29, 3, 445--462. Google ScholarDigital Library
- Weddell, G. 1992. Reasoning about functional dependencies generalized for semantic data models. ACM Trans. Datab. Syst. 17, 1, 32--64. Google ScholarDigital Library
- Wijsen, J. 1999. Temporal FDs on complex objects. ACM Trans. Datab. Syst. 24, 1, 127--176. Google ScholarDigital Library
- Wong, S., Butz, C., and Wu, D. 2000. On the implication problem for probabilistic conditional independency. Trans. Syst. Man Cybernet. A: Syst. Hum. 30, 6, 785--805. Google ScholarDigital Library
- Wu, M. 1992. The practical need for fourth normal form. In Proceedings of the 23rd ACM SIGCSE Technical Symposium on Computer Science Education. ACM, 19--23. Google ScholarDigital Library
- Zaniolo, C. 1980. Mixed transitivity for functional and multivalued dependencies in database relations. Inf. Process. Lett. 10, 1, 32--34.Google ScholarCross Ref
- Zaniolo, C. 1984. Database relations with null values. J. Comput. Syst. Sci. 28, 1, 142--166.Google ScholarCross Ref
- Ziarko, W. 1991. The discovery, analysis, and representation of data dependencies in databases, In Knowledge Discovery in Databases, MIT Press, Cambridge, MA, 195--212.Google Scholar
Index Terms
- The implication problem of data dependencies over SQL table definitions: Axiomatic, algorithmic and logical characterizations
Recommendations
When data dependencies over SQL tables meet the logics of paradox and S-3
PODS '10: Proceedings of the twenty-ninth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systemsWe study functional and multivalued dependencies over SQL tables with NOT NULL constraints. Under a no-information interpretation of null values we develop tools for reasoning. We further show that in the absence of NOT NULL constraints the associated ...
On the logical implication of multivalued dependencies with null values
CATS '06: Proceedings of the 12th Computing: The Australasian Theroy Symposium - Volume 51The implication of multivalued dependencies (MVDs) in relational databases has originally been defined in the context of some fixed finite universe (Fagin 1977, Zaniolo 1976). While axiomatisability, implication problem and many design problems have ...
Appropriate inferences of data dependencies in relational databases
We study inference systems for the combined class of functional and full hierarchical dependencies in relational databases. Two notions of implication are considered: the original notion in which a dependency is implied by a given set of dependencies ...
Comments