Reglas de negocio en bases de datos relacionales
Archivos
Fecha
2010-07-10
Autores
Pérez Alonso, Alain
Título de la revista
ISSN de la revista
Título del volumen
Editor
Universidad Central “Marta Abreu” de Las Villas
Resumen
Múltiples autores sugieren considerar como factor de esencial importancia la forma en que se manejan los requisitos, enfocados actualmente como reglas de negocio. Estas por tanto han de tener un tratamiento especial desde tempranas fases de diseño e implementación en los sistemas de información.
Las bases de datos de estos sistemas son un lugar ideal para implementar dichos requerimientos debido a su cercanía con los datos del negocio. Por ello el presente trabajo fija su objetivo en obtener los beneficios de esta filosofía entre los que se pueden citar: agilidad para responder a requisitos dinámicos, transparencia en las auditorías que se lleven a cabo y la reducción de costos en crear o actualizar partes del sistema que implementan políticas del negocio.
Como resultado se obtiene la definición de cuatro patrones junto a un lenguaje que le brinda a las reglas un elevado nivel técnico, de este lenguaje se establecen semejanzas con uno reconocido mundialmente. Ambos son creados bajo la premisa de no alejarse de un lenguaje natural, pues este último es el inicio de toda regla. Se establecen además métodos de manipulación dentro del sistema para que las reglas cumplan su función correctamente.
Para lograr implementar reglas de negocio se recurren a numerosos recursos de bases de datos como funciones, vistas, tablas, transacciones, triggers y procedimientos los cuales son especificados siguiendo un estándar para los gestores de bases de datos.
A great assortment of authors suggest considering, as a paramount element, the ways in which the different requirement are managed. These requisites are currently acknowledged as stable business rules. Thus, these ways must be specially treated since the very first phases of the design, as well as since the very first phases of its implementation on the information systems. These systems databases are an ideal place to foster the already mentioned requirement due to its very close relationship with the business’ data. That is why this research’s purpose is to obtain benefits from this philosophy. Some of these benefits are: quickness and skillfulness to respond to a dynamic requisite, openness and transparency on the diverse audits to come and costs reduction when creating or upgrading system’s parts which advance business policies. As a result, a definition of four patterns, along with a language which gives a high technical level to the rules was obtained. This language has similarities to one which is known worldwide. These were created with the principle of being as close to natural language as possible, for the last one is the foundation of every rule. Some contained by the system management methods are also established for the rules to accomplish its right function. To advance business rules countless database resources are used. These resources can be functions, views, tables, transactions, triggers and several procedures which are specified according to a database management standard.
A great assortment of authors suggest considering, as a paramount element, the ways in which the different requirement are managed. These requisites are currently acknowledged as stable business rules. Thus, these ways must be specially treated since the very first phases of the design, as well as since the very first phases of its implementation on the information systems. These systems databases are an ideal place to foster the already mentioned requirement due to its very close relationship with the business’ data. That is why this research’s purpose is to obtain benefits from this philosophy. Some of these benefits are: quickness and skillfulness to respond to a dynamic requisite, openness and transparency on the diverse audits to come and costs reduction when creating or upgrading system’s parts which advance business policies. As a result, a definition of four patterns, along with a language which gives a high technical level to the rules was obtained. This language has similarities to one which is known worldwide. These were created with the principle of being as close to natural language as possible, for the last one is the foundation of every rule. Some contained by the system management methods are also established for the rules to accomplish its right function. To advance business rules countless database resources are used. These resources can be functions, views, tables, transactions, triggers and several procedures which are specified according to a database management standard.
Descripción
Palabras clave
Reglas de Negocio, Implementación, Bases de Datos Relacionales, Sistemas de Información