Logical Database Models Research Articles

Using the results of remote sensing of land for programmed agricultural production in arid conditions

The article considers methodological approaches to substantiating the main tasks solved by the developed software package for managing agricultural production in the programmed cultivation of agricultural crops. There are characteristic differences in the reflection spectrum of agricultural plants due to the influence of water vapor absorption. The total reflected radiation in the optical and near-infrared range, recorded by remote sensing, depends on the biological and varietal characteristics of plants, the development of the leaf surface, their growth phases, the chemical composition of the soil, and other factors. The set of vegetation indices NDVI and its modifications is justified. Problems of mathematical modeling of irrigation technologies in arid conditions based on differential equations are revealed. The model takes into account agrochemical features of soils, biological properties of crops, agroclimatic conditions, as well as technological parameters of irrigation regimes. The necessity and expediency of using digital information technologies in agricultural production, including irrigation reclamation, for operational management and control of agrotechnological parameters of crop cultivation are justified. A conceptual and logical database model for programmed crop cultivation has been developed. The developed software package will allow systemically aggregating and accumulating agrophysical and hydrometeorological information to justify land reclamation measures.

Investigating the Relationship Between SLOC and Logical Database Measures to Improve the Early Estimation of Software Cost

Project planning is a critical activity in the software development life cycle. At the early stages of a project, the managers need to estimate required time, effort and cost to plan, track and then to deliver the project successfully. Many studies have attempted to provide methods for precise software cost estimation. The current software cost estimation methods are mainly based on software size estimation and functional system requirements. The main assumption of this study is that, as the primary source of complexity in today’s software is the interaction between the database and the user, database measures may provide inputs allowing current software estimation methods to achieve more accurate results. Accordingly, this study attempts to gain insights from objective measures, collected through the logical database model of software systems, for better prediction of the software’s effort and hence cost through software lines of code (SLOC) measure. For this purpose, more than 2.5 million lines of code developed by four different companies, for 79 different software packages with their related database design measures, are analyzed. The results of this study show that there is a close correlation between the software size and database design measure, namely, the number of tables which can be collected at the logical database design stage. By adapting this result, the current estimation models could be improved significantly.

DESIGN OF AUTOMATED INFORMATION SUPPORT SYSTEMFOR MARINE AGENT IN SERVICE ERGATIC SYSTEMS

Within the framework of this article, the problematic of the process of information support of data management pro-cesses by the marine agent in the ergatic service system is indicated and a project of an automated information system that takes into account the specifics of the agency company is proposed. The specificity of the marine agent’s activities as an element of the ergatic service system is indicated, and the need to take into account its social and psychological aspects of labouris substantiated. The relevance of the automated information systems usage to support the recording of production activities by a marine agent based on the use of modern information technologies and software has been substantiated. The specificity of the introduction port community modern information systems is described, main functional capabilities and advantages of such systems are given. The criteria for the effective implementation of software solutions and systems for automating the process of recording information in service ergatic systems for structuring and ensuring the availability of technical information are considered. Methods of system analysis, functional modeling of business processes, methods of object modeling of software development, methods of relational description of conceptu-al schemes of the subject area, as well as the method of profiling database performance are used as a scientific basis of thepaper. The results of the marine agent key business processes in the activities formalization are presented, a structural-organizational dia-gram of the agent company’s departments and a conceptual contextual scheme of his work in IDEF0 notation are developed. The structure of the logical database model using the MySQL system has been developed and described. The profiling of the createdda-tabase was carried out to assess the effectiveness of its use when performing standard CRUID operations using phpMyAdmin. The processes of sending data and updating the status of a record are numerically evaluated, and features of the balance of the server's hardware resources consumed by the database management system used while managing the database created are revealed.Object model for the information system functioning has been created in the form of a list of its use options, class diagrams and components, which makes it possible to reflect the main connections between key object entities. The capabilities of the created class for perform-ing CRUID operations, using the Entity class for implementing data management methods, authorization and registration classesfor delegation to the data validation class for checking the results of user input in the system interface for their correctness are de-scribed. The composition of the operating forms package is describes, which contains classes of named user interface forms used by the spacing and positioning functional components to support the process of viewing electronic documents, filtering data, sending emails, sending data to print, generating reports and exporting data, searching data with the DataSearcher class. The purposeand functional composition of the registration and authorization components, the formation of the information system interface, data management, data backup and archiving, logging of completed actions, generation of reporting documents and processing of elec-tronic forms are described.

Desarrollo de Sistema Web de Reclutamiento y Selección y de Directivos por Competencias mediante PHP CodeIgniter 3.0

The itinerary of recruitment procedures to occupy management positions, both public and private sectors, is a complex process by the level of completeness required in all its stages, from defining the proper competences for the job to the planning and evaluation of those competences. Under current advances in web technology, the main objective of this article is to describe the practical advantages of the web development tool PHP CodeIgniter 3.0 to give a solution in particular. The System for the Recruitment and Managers Selection SRMS v1.0 is presented, starting from the SRMS requirements and structural design, until the implementation and functioning details. Thus, SRMS v1.0 is a web system that supports the processes of recruitment in recruitment contests under a determined professional profile, as the defined required skills for the job. The use of PHP CodeIgniter 3.0 stands out because it, given a correct analysis of requirements and its logical database model, enables a rapid development of web applications.

Rancang Bangun dan Basis Data pada Klinik 24 Jam Secara Konseptual dan Logikal

The aim of this research is to design a database model which is conceptual and logical for a 24-hour clinic. The methods used in this research are the data collection through literature studies, surveys, and interviews to the clinic management to get a description of the business processes implemented at a 24-hour clinic. Then we use the conceptual database design method which identifies important entities, relationships entities, and existing attributes. After that, we create a database logical model which represents the clinical database 24 hours. From that, the model is expected to be a logical database model for further development into a clinical application 24 hours to improve the health services to the public.

A new method for computing fuzzy functional dependencies in relational database systems

In this paper, we present a new method for computing fuzzy functional dependencies between attributes in fuzzy relational database systems. The method is based on the use of fuzzy implications. A literature analysis has shown that there is no algorithm that would enable the identification of attribute relationships in fuzzy relational schemas. This fact was the motive for development a new methodology in the analysis of fuzzy functional dependencies over a given set of attributes. Solving this, not so new problem, is not only research challenge having theoretical importance, but it also has practical significance. Possible applications of the proposed methodology include GIS, data mining, information retrieval, reducing data redundancy in fuzzy relations through implementation of logical database model, estimation of missing values etc.

A construction schema for provincial spatial database of China

In order to provide a provincial spatial database, this paper presents a scheme for spatial database construction to meet the needs of China. The objective and overall technical route of spatial database construction are described. The logical and physical database models are designed. Key issues are addressed, such as integration of multi-scale heterogeneous spatial databases, spatial data version management based on metadata and integrative management of map cartography and spatial database.

Engineering information modeling in databases: needs and constructions

PurposeTo provide a selective bibliography for researchers and practitioners interested in database modeling of engineering information with sources which can help them develop engineering information systems.Design/methodology/approachIdentifies the requirements for engineering information modeling and then investigates how current database models satisfy these requirements at two levels: conceptual data models and logical database models.FindingsPresents the relationships among the conceptual data models and the logical database models for engineering information modeling viewed from database conceptual design.Originality/valueCurrently few papers provide comprehensive discussions about how current engineering information modeling can be supported by database technologies. This paper fills this gap. The contribution of the paper is to identify the direction of database study viewed from engineering applications and provide a guidance of information modeling for engineering design, manufacturing, and production management.

A unified approach to structured and XML data modeling and manipulation

In this paper we propose an approach to defining logical database models, based on the instantiation of a general abstract model, and discuss its application to the management of mixed XML/relational data. Our abstract model is equipped with a parametric query algebra and relational-like algebraic equivalences, that do not have to be redefined when new models are generated. We present an instantiation of our model that unifies the main approaches to represent and manipulate relational and XML data, and in particular SQL, SQL/XML, XQuery, and Oracle’s XML Type. Additionally, our algebra can represent queries not expressible by other algebras taken from the literature. Among others, it can represent nested XQuery expressions with no constraints on nesting and on node constructors.

Handling complex and uncertain information in the ExIFO and NF/sup 2/ data models

Trends in databases leading to complex objects present opportunities for representing imprecision and uncertainty that were difficult to integrate cohesively in simpler database models. In fact, one can begin at the conceptual level with a model that allows uncertainty assumptions and then transform those assumptions into a logical model having the necessary semantic foundations upon which to base a meaningful query language. Here we provide such a constructive approach beginning with the ExIFO model for expression of the conceptual design then show how the conceptual design is transformed into the logical design (for which we utilize the extended NF/sup 2/ logical database model). The steps are straightforward, unambiguous, and preserve the relevant information, including information concerning uncertainty.

Uncertainty in a nested relational database model

Some database models have already been developed to deal with complex values but they have constrains that data stored is precise and queries are crisp. However, as many researchers have pointed out, there is a need to present, manipulate, and query complex and uncertain data of various non-traditional database applications such as oceanography, multimedia, meteorology, office automation systems, engineering designs, expert database systems and geographic information systems. In this paper, we present a logical database model, which is an extension of a nested relational data model (also known as an NF 2 data model), for representing and manipulating complex and uncertain data in databases. We also introduce a possible physical representation of such complex and uncertain values in databases and describe the query processing of the model that we discuss here.

単板・関係・網・階層の複合論理操作DBMSとしての実用GEODASの新仕様について

単板・関係・網・階層の複合論理操作DBMSとしての実用GEODASの新仕様について