A relational framework and case shells of a new type
- PDF / 306,761 Bytes
- 12 Pages / 594 x 792 pts Page_size
- 51 Downloads / 189 Views
NEW MEANS OF CYBERNETICS, INFORMATICS, COMPUTER ENGINEERING, AND SYSTEMS ANALYSIS A RELATIONAL FRAMEWORK AND CASE SHELLS OF A NEW TYPE B. E. Panchenkoa and V. N. Gajdabrus b
UDC 004.652
Abstract. This paper describes a CASE shell of a new type, namely, the instrumental system SWS constructed in accordance with a framework data model. A scheme of the instrumental system is proposed. The list of main user functions of the SWS shows that the typification and formalization of requests to a database with a well-formalized data model and unification and minimization of the interface allow modelling the totality of user requests. The results of a numerical experiment on the real-time formation of OLAP data elements are presented. The real-time approach is shown to be most advanced. Keywords: relational framework, framework data model, CASE shell, preliminarily adjusted request, unification and minimization of an interface, OLAP. INTRODUCTION A comprehensive analysis of many types of object domains (ObDs) [1] made it possible to reveal the possibility of implementing the following two approaches to the satisfaction of user needs using a relational data model (RDM): the mechanism of requests to a partially normalized relational database (DB) schema that is no stronger than the Boyce–Codd normal form (BCNF) and, possibly, the third normal form (3NF) [2]; the mechanism of typification of the majority of requests, unification of basic algorithms that process them, and assembling of these algorithms into a nonanomalous DB schema [3]. The main criterion for the applicability of such approaches is the coefficient of forecasting the development of an ObD and variety of user requests [1] (request ratio), i.e., the ratio of the number of confirmed changes to the total number of forecasted and spontaneous changes for a definite time period, for example, for a year. Interestingly, ObDs with the request ratio equal to 1 are satisfactory for the second approach. These domains can be deeply investigated, their development can be forecasted, and they can be modelled on the basis of RDMs. Applications that model processes in ObDs can have a minimal interface for unskilled users that allows one to minimize (or practically to eliminate) the use of the mechanism of external requests to a DB. Among such ObDs are various business applications of companies and corporations developing according to forecasted market factors. Needs of users of ObDs with a small request ratio such as, for example, Internet search engines, various social networks, and Internet show windows whose DB schemas depend not on owners of systems and actual cause-and-effect relationships in an ObD but on chaotic user requests can be efficiently modelled by flexible language constructions. PROBLEM STATEMENT A relational framework allows one to represent any application as an environment for data control with a prescribed purpose [4]. Since data processing requires the use of some model or other, an RDM is most attractive in this case. A framework is a special case of an RDM.
Data Loading...
