Relational databases remain the leading data storage technology. Nevertheless, many companies want to reduce operating expenses, to make scalable applications that use cloud computing technologies. Use of NoSQL database is one of the possible solutions, and it is forecasted that the NoSQL market will be growing at a CAGR of approximately 50 percent over the next five years. The paper offers a solution for quick data migration from a relational database into a document-oriented database. We have created semi-automatically two logical levels over physical data. Users can refine generated logical data model and configure data migration template for each needed document. Data migration features are implemented into relational database browser Dig Browser. Real patients' database was migrated to Clasterpoint database. The offered approach provides means to obtain at least proof-of-concept for new document-oriented database solution in a couple of days.
30 September 2019 in Insights into Regional Development
During the decades the district heating’s (DH) advantages (more cost-efficient heat generation and reduced air pollution) overcompensated the additional costs of transmission and distribution of the centrally produced thermal energy to consumers. Rapid increase in the efficiency of low-power heaters, development of separated low heat density areas in cities reduce the competitiveness of the large centralized DH systems in comparison with the distributed cluster-size networks and even local heating. Reduction of transmission costs, enhancement of the network efficiency by optimization of the design of the DH networks become a critical issue. The methodology for determination of the key drivers of the cost-efficiency of the DH networks to implement the most efficient (cost-minimal) thermal energy transmission was developed in this study. An inductive benchmarking modelling was applied; the general causal regularity is based on the observations of specific cases, thus determining the relationships between the network’s design and thermal indicators as predictors and transmission costs as the target variable. The key drivers of the network efficiency were disclosed – the network length and the largest inner diameter of the pipes. The methodology is applicable for use by municipalities and heat providers for the heating planning of the new housing developments as well as renovation and/or expansion of the existing DH networks.
The sustainability of the climate is a global problem that requires the involvement of all levels of public governance and the private sector. Energy issues play a crucial role in the Green Deal (GD), and many of these issues are being addressed at the local government (LG) level. The division of competences within the framework of the GD among the European Union (EU), national governments, LGs, and the private sector has not been sufficiently discussed. Existing studies often neglect the specific role of LGs. The aim of this study was to evaluate the extent to which the role of LGs aligns with the core principles of public governance, namely sustainability, solidarity, subsidiarity, and proportionality. The novelty of this study’s methodology lies in the comprehensive and integrated application of all four principles to assess the distribution of competences necessary to achieve global goals. The conclusion of the study demonstrates that, although the functionality and competences of LGs generally comply with these principles, the role of LGs as consultants to and co-legislators with national and EU authorities should be further discussed and expanded. Overall, this study highlights the importance of strengthening the role of LGs as valuable contributors to the governance process.
The paper discusses an external solution for data quality management in information systems. In contradiction to traditional data quality assurance methods, the proposed approach provides the usage of a domain specific language (DSL) for description data quality models. Data quality models consists of graphical diagrams, which elements contain requirements for data object's values and procedures for data object's analysis. The DSL interpreter makes the data quality model executable therefore ensuring measurement and improving of data quality. The described approach can be applied: (1) to check the completeness, accuracy and consistency of accumulated data; (2) to support data migration in cases when software architecture and/or data models are changed; (3) to gather data from different data sources and to transfer them to data warehouse.
This paper is devoted to the system modelling and information transfer to information system. The BiLingva (Bilingual Language) is a domain specific modelling language used to model event oriented information systems. Unlike many other modelling languages BiLingva allows unconstrained use of state diagram concepts and activities diagram concepts in the same diagram. This approach is most appropriate in this specific domain. In the second part of the paper authors analyze a new approach for transferring information system model in BiLingva language to the information system. It is proposed to make user friendly and model consistent configurable software that takes over information from BiLingva model. In the end this paper provides a few examples of running systems developed with this technology thus confirming usefulness of this approach.