Modificación de reglas de negocio creadas automáticamente en bases de datos relacionales
Fecha
2011-07-11
Autores
Díaz de La Paz, Lisandra
Título de la revista
ISSN de la revista
Título del volumen
Editor
Universidad Central “Marta Abreu” de Las Villas
Resumen
El desarrollo de sistemas de información (SI) está necesariamente vinculado a las reglas de negocio (RN). Estas definen el correcto funcionamiento de una organización y constituyen las bases para la toma de decisiones. Generalmente se encuentran descritas en manuales de políticas, que los directivos del negocio deben conocer para desarrollar su gestión cotidiana y los desarrolladores de SI para implementarlas y chequearlas de manera automática. Las RN con el transcurso del tiempo suelen cambiar debido al dinamismo empresarial. Esto provoca el surgimiento de nuevas restricciones que deben ser reflejados en los SI correspondientes.
La presente investigación aborda el control de cambios y versiones de las RN tipo restricción en bases de datos (BD) relacionales. Para ello es necesario analizar las operaciones de inserción, eliminación y actualización de las políticas del negocio, considerando su impacto en la BD y las posibles contradicciones entre los datos y las versiones de las reglas.
Como resultado, se proponen variantes que soportan el mantenimiento de las RN y se selecciona la más adecuada para reflejar las asociaciones dato-regla según el análisis realizado. Para su implementación se utilizan recursos de BD siguiendo el estándar SQL. Además se expone una secuencia de pasos para modificar una RN tipo restricción.
The information systems (IS) development is closely related to business rules (BR). These rules define the right working of an organization and are the bases for decision making. Such rules are generally described on policy manuals, which should be known by the head of the business in order to run their everyday business adequately. These rules should be also known by developers of the IS upon the score of implementing and checking them automatically. BR are likely to change with the passing of time due to company dynamic. This may cause the rising of new restrictions which must be reflected in the corresponding IS. This investigation deals with the change and version control of the BR type restrictions on relational databases (DB). To accomplish this it is necessary to analyze insertion, elimination and updating operations in BR, always taking into account its impact on the DB and its possible contradictions between data and rule versions. As a result, variants supporting the keeping of BR are proposed and the best of all is selected to reflect data-rule associations according to one previously done analysis. For implementing the best variant database resources are used according to SQL Standards. In addition, a sequence of steps to modify a restriction type rule is presented.
The information systems (IS) development is closely related to business rules (BR). These rules define the right working of an organization and are the bases for decision making. Such rules are generally described on policy manuals, which should be known by the head of the business in order to run their everyday business adequately. These rules should be also known by developers of the IS upon the score of implementing and checking them automatically. BR are likely to change with the passing of time due to company dynamic. This may cause the rising of new restrictions which must be reflected in the corresponding IS. This investigation deals with the change and version control of the BR type restrictions on relational databases (DB). To accomplish this it is necessary to analyze insertion, elimination and updating operations in BR, always taking into account its impact on the DB and its possible contradictions between data and rule versions. As a result, variants supporting the keeping of BR are proposed and the best of all is selected to reflect data-rule associations according to one previously done analysis. For implementing the best variant database resources are used according to SQL Standards. In addition, a sequence of steps to modify a restriction type rule is presented.
Descripción
Palabras clave
Modificación, Reglas de Negocio, Automatización, Estándar SQL