Wyniki wyszukiwania - BazTech

1

Integration of Relational and Graph Databases Functionally

Pokorný Jarosław

Foundations of Computing and Decision Sciences

|

2019

|

Vol. 44, No. 4

427--441

EN

In today’s multi-model database world there is an effort to integrate databases expressed in different data models. The aim of the article is to show possibilities of integration of relational and graph databases with the help of a functional data model and its formal language - a typed lambda calculus. We suppose the existence of a data schema both for the relational and graph database. In this approach, relations are considered as characteristic functions and property graphs as sets of single-valued and multivalued functions. Then it is possible to express a query over such integrated heterogeneous database by one query expression expressed in a version of the typed lambda calculus. A more user-friendly version of such language could serve as a powerful query tool in practice. We discuss also queries sent to the integrated system and translated into queries in SQL and Cypher - the graph query language for Neo4j.

2

Evaluation of the efficiency of integrated ERP systems and business intelligence tools based on the diagnostic cases in the MSE sector

Drelichowski L.

Information Systems in Management

|

2012

|

Vol. 1, No. 1

14--24

EN

In the paper, an evaluation of the efficiency of the application of ERP class integrated systems and BI tools was carried out, through analysis of two cases micro-and-small enterprises (MSEs). An analysis of the observed successes allowed precise definition of key factors in their successes or failures, in the scope of the efficiency of BI tools application in management. Confirmed rules for guaranteeing of unconditional compatibility of the contents of data warehouses with the transactional databases are, in the opinion of the author, a necessary condition for long-term success with BI application in decisions-making processes. The solutions proposed in the paper for a data processing organisation system were effectively verified over several years’ use at the POZKAL printing house in Inowroclaw. Such solutions force compatibility of transactional databases with data warehouse contents, an area often underestimated by the authors of other publications in this area.

3

Integracja danych przestrzennych o środowisku naturalnym - wyzwanie dla instytucji z branży ochrony środowiska?

Nałęcz T.

Roczniki Geomatyki

|

2007

|

T. 5, z. 1

81-89

EN

Global history of Geographic Information Systems development is inextricably linked with research on natural environment. When analyzing GIS technology development in the area of natural environment protection in Poland during the last dozen years or so, it may seem complicated and chaotic . Almost every institution was independently gathering all necessary data to complete projects. There was neither information flow nor cooperation in the field of data exchange between individual institutions. At present, various projects connected with collecting data on natural environment have been finished or are drawing to a close. At the end of the stage of gathering GIS data it is necessary to undertake activities concerning databases assessment and to begin developing procedures of cooperation between institutions who manage environmental resources in order to create a platform of data sharing, which in the future could provide the basis for supporting the decision taking process. There is an urgent need to begin the integration process, especially in large, currently implemented projects, in which spatial data are one of the most important elements in management. The Water Framework Directive appeared to be a stimulating element for a large part of the community connected with environment protection. Polish legislation was changed in the result of implementation of European Union regulations, the process of introducing WFD in Poland made us aware of the vital role of spatial data in environment management and in accomplishing current projects. The continuation of the objectives arising from the WFD implementation are, among other things, works undertaken within the framework of establishing the water register. EKOINFONET, a computer system of Inspection of Environment Protection, is an equally important project and the attempts at its implementing have already (similarly to the water register) a few years. tradition. Unfortunately, in spite of such large projects realization there is still no unanimous concept of bringing together and organizing dispersed data bases into one integrated system. At present, accomplishment of the above mentioned projects is not only an assignment given to the institutions involved in the execution process but it is also necessary to start debate on placing these projects in the environment spatial data management structures. Integration activities are supported by worldwide tendency to organize spatial resources. An expression of this trend in Europe is the initiative of the INSPIRE Directive, which is both a challenge and an opportunity for the whole community connected with environment protection in Poland, to develop a uniform system which would take into consideration the needs of different institutions. However, only when a national infrastructure is created, it will be (hopefully) possible to solve most of the spatial data problems, e.g. overlapping of certain elements in databases supervised by the Surveyor General and Geologist General of Poland.