Normalization by second order graphs: A visual alternative to simplify systems
This issue stems from the need for tools to analyze and make decisions around complex systems, where they apply the rules for linearly dependent sets, with the purpose of providing a visual tool, which serves to support complexity reduction processes. Two great precedents are Armstrong's Axiom...
Main Author: | |
---|---|
Format: | Article |
Language: | Spanish |
Published: |
Universidad de Costa Rica
2021-01-01
|
Series: | e-Ciencias de la Información |
Subjects: | |
Online Access: | https://revistas.ucr.ac.cr/index.php/eciencias/article/view/38790 |
_version_ | 1797292113404100608 |
---|---|
author | Edward Muñoz Garro |
author_facet | Edward Muñoz Garro |
author_sort | Edward Muñoz Garro |
collection | DOAJ |
description |
This issue stems from the need for tools to analyze and make decisions around complex systems, where they apply the rules for linearly dependent sets, with the purpose of providing a visual tool, which serves to support complexity reduction processes. Two great precedents are Armstrong's Axioms, which has been applied from its publication to the present for database normalization, the other is set theory, a fundamental pillar of the Structured Query Language; based on them, together with the second-order logic, which adds qualifiers for subsets or properties, this work has been prepared, with an explanatory metrology with a qualitative approach, in an axiomatic system. As a result, a support tool has been provided to analyze complex systems naturally, by breaking cycles and detecting patterns, without interfering with existing models; however, for large systems it can be difficult to address it in its entirety, so it is recommended to divide by subsystems. With this work a technique has been accomplished, repeatable by anyone, but with a strong theoretical foundation. This work has great utility for the normalization of relational databases and an enormous potential for application in the design of systems beyond computational systems, it is also useful for understanding dependencies by their axiomatic nature.
|
first_indexed | 2024-03-07T19:47:02Z |
format | Article |
id | doaj.art-179d7ab7154c4d5faa0b9eba6edcbd9b |
institution | Directory Open Access Journal |
issn | 1659-4142 |
language | Spanish |
last_indexed | 2024-03-07T19:47:02Z |
publishDate | 2021-01-01 |
publisher | Universidad de Costa Rica |
record_format | Article |
series | e-Ciencias de la Información |
spelling | doaj.art-179d7ab7154c4d5faa0b9eba6edcbd9b2024-02-28T20:01:31ZspaUniversidad de Costa Ricae-Ciencias de la Información1659-41422021-01-0111110.15517/eci.v11i1.38790Normalization by second order graphs: A visual alternative to simplify systemsEdward Muñoz Garro0Universidad de Costa Rica, COSTA RICA This issue stems from the need for tools to analyze and make decisions around complex systems, where they apply the rules for linearly dependent sets, with the purpose of providing a visual tool, which serves to support complexity reduction processes. Two great precedents are Armstrong's Axioms, which has been applied from its publication to the present for database normalization, the other is set theory, a fundamental pillar of the Structured Query Language; based on them, together with the second-order logic, which adds qualifiers for subsets or properties, this work has been prepared, with an explanatory metrology with a qualitative approach, in an axiomatic system. As a result, a support tool has been provided to analyze complex systems naturally, by breaking cycles and detecting patterns, without interfering with existing models; however, for large systems it can be difficult to address it in its entirety, so it is recommended to divide by subsystems. With this work a technique has been accomplished, repeatable by anyone, but with a strong theoretical foundation. This work has great utility for the normalization of relational databases and an enormous potential for application in the design of systems beyond computational systems, it is also useful for understanding dependencies by their axiomatic nature. https://revistas.ucr.ac.cr/index.php/eciencias/article/view/38790Armstrong's Axiomsnormalization of relational databasescomplexity reductionbreak cycles and detect patterns |
spellingShingle | Edward Muñoz Garro Normalization by second order graphs: A visual alternative to simplify systems e-Ciencias de la Información Armstrong's Axioms normalization of relational databases complexity reduction break cycles and detect patterns |
title | Normalization by second order graphs: A visual alternative to simplify systems |
title_full | Normalization by second order graphs: A visual alternative to simplify systems |
title_fullStr | Normalization by second order graphs: A visual alternative to simplify systems |
title_full_unstemmed | Normalization by second order graphs: A visual alternative to simplify systems |
title_short | Normalization by second order graphs: A visual alternative to simplify systems |
title_sort | normalization by second order graphs a visual alternative to simplify systems |
topic | Armstrong's Axioms normalization of relational databases complexity reduction break cycles and detect patterns |
url | https://revistas.ucr.ac.cr/index.php/eciencias/article/view/38790 |
work_keys_str_mv | AT edwardmunozgarro normalizationbysecondordergraphsavisualalternativetosimplifysystems |