Modelirovanie i Analiz Informatsionnykh Sistem
RUS  ENG    JOURNALS   PEOPLE   ORGANISATIONS   CONFERENCES   SEMINARS   VIDEO LIBRARY   PACKAGE AMSBIB  
General information
Latest issue
Archive
Impact factor

Search papers
Search references

RSS
Latest issue
Current issues
Archive issues
What is RSS



Model. Anal. Inform. Sist.:
Year:
Volume:
Issue:
Page:
Find






Personal entry:
Login:
Password:
Save password
Enter
Forgotten password?
Register


Modelirovanie i Analiz Informatsionnykh Sistem, 2022, Volume 29, Number 3, Pages 210–227
DOI: https://doi.org/10.18255/1818-1015-2022-3-210-227
(Mi mais777)
 

Discrete mathematics in relation to computer science

Testing dependencies and inference rules in databases

S. V. Zykin

Sobolev institute of mathematics SB RAS, 4 Acad. Koptyug av., Novosibirsk 630090, Russia
References:
Abstract: The process of testing dependencies and inference rules can be used in two ways. First, testing allows verification hypotheses about unknown inference rules. The main goal, in this case, is to search for the relation - a counterexample that illustrates the feasibility of the initial dependencies and contradicts the consequence. The found counterexample refutes the hypothesis, the absence of a counterexample allows searching for a generalization of the rule and conditions for its feasibility (logically imply). Testing cannot be used as a proof of the feasibility of inference rules, since the process of generalization requires the search for universal inference conditions for each rule, which cannot be programmed, since even the form of these conditions is unknown. Secondly, when designing a particular database, it may be necessary to test the feasibility of a rule for which there is no theoretical justification. Such a situation can take place in the presence of anomalies in the superkey. The solution to this problem is based on using join dependency inference rules. For these dependencies, a complete system of rules (axioms) has not yet been found. This paper discusses: 1) a technique for testing inference rules using the example of join dependencies, 2) a scheme of a testing algorithm is proposed, 3) some hypotheses are considered for which there are no counterexamples and inference rules, 4) an example of using testing when searching for a correct decomposition of a superkey is proposed.
Keywords: relational databases, join dependencies, inference rules, testing.
Funding agency Grant number
Ministry of Science and Higher Education of the Russian Federation FWNF-2022-0016
The research was funded in accordance with the state task of the IM SB RAS, project FWNF-2022-0016.
Received: 30.07.2022
Revised: 31.08.2022
Accepted: 02.09.2022
Bibliographic databases:
Document Type: Article
UDC: 004.652.4
MSC: 68P15
Language: Russian
Citation: S. V. Zykin, “Testing dependencies and inference rules in databases”, Model. Anal. Inform. Sist., 29:3 (2022), 210–227
Citation in format AMSBIB
\Bibitem{Zyk22}
\by S.~V.~Zykin
\paper Testing dependencies and inference rules in databases
\jour Model. Anal. Inform. Sist.
\yr 2022
\vol 29
\issue 3
\pages 210--227
\mathnet{http://mi.mathnet.ru/mais777}
\crossref{https://doi.org/10.18255/1818-1015-2022-3-210-227}
\mathscinet{http://mathscinet.ams.org/mathscinet-getitem?mr=4495438}
Linking options:
  • https://www.mathnet.ru/eng/mais777
  • https://www.mathnet.ru/eng/mais/v29/i3/p210
  • Citing articles in Google Scholar: Russian citations, English citations
    Related articles in Google Scholar: Russian articles, English articles
    Моделирование и анализ информационных систем
    Statistics & downloads:
    Abstract page:62
    Full-text PDF :15
    References:10
     
      Contact us:
     Terms of Use  Registration to the website  Logotypes © Steklov Mathematical Institute RAS, 2024