Implementation Of Database Research Articles

Designing and implementing a LADM-based cadastral information system in Serbia, Montenegro and Republic of Srpska

A reliable and efficient land administration plays a vital role in the country's development. For that purpose, records that ensure data management about real properties, rights, and legal or natural persons that are right holders should be well organized. Maintenance of cadastral records in Serbia, Montenegro, and the Republic of Srpska (one of the two entities in Bosnia and Herzegovina) have encountered many issues in recent years. There was a need for modernization to provide more efficient cadastral information systems. Following the recommendations to implement all international standards related to the field of interest to achieve interoperability and incorporate best practices, it was natural to consider the development of the Land Administration Domain Model (LADM) country profiles and LADM based cadastral information systems in these case countries and the region. The domain models had to comply with the national laws, so the regulations also had to be analyzed in detail. Once the domain models were established and verified on the conceptual level, they were implemented as part of the technical solution for the cadastral information systems in the case countries and the region. The goal of the paper is to share the experience gained during the process of design and implementation of LADM based cadastral information systems in Serbia, Montenegro and the Republic of Srpska. This experience is summarized into methodological steps grouped into four design and implementation phases. These phases include conceptual modelling and development of LADM based country profiles in these regions, the definition of real estate cadastre business processes, database implementation and data migration, and finally, country profile's implementation in the form of a technical solution that is in use in cadastral offices and on the Web. The outcomes that resulted from the activities conducted in each of these steps are presented. The goal is also to present challenges we met during conducting activities in these phases and findings we reached in the process so they can be used as a basis for some other work and a more general methodology that will cover larger areas and countries outside Europe.

Social life cycle assessment of an innovative industrial wastewater treatment plant

BackgroundThe social impacts generated by industrial waste treatment processes have not been studied enough, as shown in the literature. Social life cycle assessment studies have mainly focused on the assessment of products and less on industrial waste, especially wastewater, although potentially relevant from an environmental point of view, and also from a social one for various stakeholders.PurposeThis case study concerns the social assessment of an innovative technology to treat the wastewater of a microelectronics company. In order to produce electronic components and semiconductors, the company has to treat and dispose of relevant wastewater streams containing various toxic substances. The wastewater streams need to be treated in order to protect the eco-system, representing a high cost for the company and a potential impact on the environment.For this reason, the company developed a LIFE project to demonstrate the viability to decrease the burdens on water bodies. The positive outcome of the test on the pilot plant paved the way for the construction of the full-scale plant that will treat all the wastewater generated by the company.The objective of this paper is the socio-economic assessment of a full-scale plant designed to treat three different kinds of wastewater.MethodsThe assessment of socio-economic potential impacts of a new technology has been carried out through the PSILCA (Product Social Impact Life Cycle Assessment) database implementation to evaluate 65 social indicators of a wastewater treatment plant.ResultsThe line with the highest impact is the one which treats tetramethylammonium hydroxide; this is because this wastewater flow is the most abundant (14 and 43 times greater than the other wastewaters, respectively).The most affected stakeholder is the Local Community, followed by the Actors of the Value Chain; in fact, the results referred to the functional unit considered exceed 300,000 medium risk hours in both cases. For the Local Community this result arises from the indicator “Contribution to environmental load,” which is understandable considering the object of the study since this indicator includes health effects. As far as the Value Chain Actors stakeholder is concerned, the two indicators most impacted are “Corruption” and “Social responsibility along the supply chain”.The analysis conducted has also shown that upstream has a fundamental relevance for the social risks detected.ConclusionsConsidering the current lack of studies on both environmental and social impacts of wastewater treatment, and the fact that Social Life Cycle Assessment has not been widely used in this field, as emerged from literature review, this work is the first use of the PSILCA database to assess an industrial wastewater plant. The use of a social life cycle assessment database allows the value chain of a product system to be considered: the results show that most of the overall social risk derives from upstream sectors.

МАРКЕТИНГОВЫЕ ИССЛЕДОВАНИЯ ПРИВЛЕЧЕНИЯ ИНВЕСТИЦИОННЫХ СРЕДСТВ В ЭКОЛОГИЧЕСКУЮ СРЕДУ РЕГИОНА

Abstract: the article presents a theoretical study of the possibility of attracting investment funds in the ecological environment of the region. The approaches to assessing the need for investment in this sector of the economy are considered in detail. Marketing research suggests that with a competent and timely investment in the environmental sphere, it is likely to bring the region to a new level of economic development. This article examines the state of the ecology of the Karachay-Cherkess Republic, identifies weaknesses, threats and barriers to the formation of the residents and guests of the KCR a sense of responsibility for the appearance of the republic and the desire to change it for the better. In conclusion, the proposed products of the project, the directions of the project development and measures to support the environmental sphere are presented. The purpose of the study: to reduce the negative impact on the health and improve the quality of life of the population; to involve the population in the circles of assistance in order to improve the environmental situation; eco-education; to increase the level of information content of residents and guests of the KCR on environmental safety and the involvement of the population in solving socio-environmental problems of the Republic; educational purpose. Research objectives: analysis of the pollution situation in the region; acquisition of knowledge on identifying the problem and ways to solve it for the environmental and social situation in the area; promotion and deepening of environmental knowledge among the population; development and implementation of an electronic database in the world wide web and generalization of this information (here you can learn about the resources for collecting, the progress of the project, waste paper, plastic, etc.). The problem of investing in environmental projects in the territory of the Karachay-Cherkess Republic is currently one of the main problems of the entire region as a whole. It represents changes in the natural environment that occur as a result of natural disasters and/or anthropogenic impacts. Such human influence leads to a violation of the structure and functioning of nature. Environmental problems arose as a result of the irrational attitude of man to nature, the rapid growth of industrial technologies, industrialization and population growth. The production of natural resources here is so great that the question arises about their use in the future. Due to environmental pollution, our planet is approaching its demise with progressive steps. The progress and fate of the population of the republic depends on the solution of environmental problems, so they become important and relevant on the way to their resolution. The state of the environment directly affects the efficiency of the production of goods and services and the potential for the reproduction of the social product in the long term. Therefore, in the paradigm of reproduction theory, there is a need to study the interrelationships of nature and society, which at the same time are quite contradictory.

Towards the Internet of Water: Using graph databases for hydrological analysis on the Flemish river system

AbstractThe “Internet of Water” project will deploy 2,500 sensors along the Flemish river system, in Belgium. These sensors will be part of a monitoring system. This will produce an enormous amount of data, on which prediction and analysis tasks can be performed. To represent, store, and query river data, relational databases are normally used. However, this choice introduces an “impedance mismatch” between the conceptual representation (typically a graph) and the storage model (relational tables). To solve this problem, this article proposes to use graph databases. The Flemish river system is presented as a use case and the Neo4j graph database and its high‐level query language, Cypher, are used for storing and querying the data, respectively. A relational alternative is implemented over the PostgreSQL database. A collection of representative queries of interest for hydrologists is defined over both database implementations.

Becoming a blockchain user: understanding consumers’ benefits realisation to use blockchain-based applications

ABSTRACT Data breaches and cyber incidents are on the rise, and companies continually research new technologies to defend against attacks and protect customer data. The blockchain is a data store designed to promote data privacy, as well as transaction integrity. Enterprises in several industries, especially banking, have investigated the implementation of blockchain-based databases to replace centralised databases as one mechanism for protecting customers’ data by separating transactional data from personally identifiable information. Despite the blockchain’s privacy protections, consumers remain largely unaware of these benefits. Building on the Health Belief Model (HBM), we include privacy concerns and inertia as critical factors that influence consumers’ perceptions of blockchain-based databases’ benefits. Using a sample of 304 respondents, we test a theoretical model incorporating these factors. Our study results indicate threat severity, threat susceptibility, awareness, and inertia significantly influence the perceived benefits of blockchain, which has a significant positive influence on consumers’ intention to switch to blockchain-based applications. Although consumers’ comfort with the status quo of traditional banking mechanisms is a significant barrier to the realisation of blockchain banking applications benefits, additional awareness of consumer privacy protections can persuade customers to use the blockchain-based applications, especially if they exhibit heightened privacy concerns.

The database of energy and operational characteristics of public buildings: development prospects for the purposes of state energy efficiency policy

This paper presents the database of energy and operational characteristics of public buildings as an effective information and technical tool for implementation of the policy of energy efficient modernization of buildings. Based on the results of the state pilot project of creating government buildings and district state administration buildings database, the article presents a list of potential users of the database in case of its scaling to the national level including other types of buildings. The author identifies the desired structural elements of the buildings database, suggesting the relevant sources of information. Based on the relevant foreign experience, the strategic prospects of the buildings database development are outlined, the principles of its maintenance are presented. The multiplier effect of the national buildings database implementation and further directions of research are determined.

Proposal of a spatial database for indoor navigation

This paper presents an approach to build a spatial database for indoor environments. It will be presented the main requirements for the implementation of an object-relational database for the representation and analysis of indoor environments, which considers the solutions for both type of representations, floor plan and schematic map. These representations consider the high number of information found in an indoor environment and the fact that they are disposed in different floors of the structure. The relationship between objects and their attributes defines the links and restrictions between them. Hence, the model should describe the entities and their interrelationships, as well as the attributes of the elements and their characteristics. After the database was developed, it was implemented an algorithm that calculates routes between points in the indoor environment, considering not only the shortest distance but also the floor change. The model was tested by Antunes and Delazari (2019) using an application and some interviews with users to evaluate the elements included in the database considering a navigating task. Some results pointed out the need to insert new information in the database regarding physical characteristics (color, material) of elements found in the indoor environment to assist users during orientation and navigation tasks. Moreover, it is necessary to include elements from the outdoor environment used as reference points in the cartographic representation.

Research effort devoted to regulating and supporting ecosystem services by environmental scientists and economists.

The economic valuation of ecosystem services in part reflects the desire to use conventional economic tools (markets and economic instruments) to conserve ecosystem services. However, for regulating and supporting ecosystem services that depend on ecosystem structure and function, estimation of economic value requires estimates of the current level of underlying ecological functions first. This primary step is in principle, the job of environmental scientists, not economists. Here, we provide a coarse-level quantitative assessment of the relationship between the research effort expended by environmental scientists (on the biophysical values) and economists (on the monetary values) on 15 different regulating and supporting services in 32 ecosystem types using peer-reviewed article hits retrieved from bibliographic databases as a measure of research effort. We find a positive, moderately strong (r = 0.69) correlation between research efforts in the two domains, a result that, while encouraging, is likely to reflect serendipity rather than the deliberate design of integrated environmental science-economics research programs. Our results suggest that compared to environmental science research effort economic valuation is devoted to a smaller, less diverse set of ecosystem services but a broader, more diverse, set of ecosystem types. The two domains differed more with respect to the ecosystem services that are the major focus of research effort than they did with respect to the ecosystem types of principal research interest. For example, carbon sequestration, erosion regulation, and nutrient cycling receive more relative research effort in the environmental sciences; air quality regulation in economic valuations. For both domains, cultivated areas, wetlands, and urban/semi-urban ecosystem types received relatively large research effort, while arctic and mountain tundra, cave and subterranean, cryosphere, intertidal/littoral zone, and kelp forest ecosystem types received negligible research effort. We suggest ways and means by which the field of sustainability science may be improved by the design and implementation of a searchable database of environmental science and economic valuation literature as well as a global ecosystem service research network and repository that explicitly links research on the estimation and prediction of biophysical ecosystem functions with that of the social sciences and other knowledge systems. These suggestions would, at least in principle, facilitate a more efficient research agenda between economists and environmental scientists and aid management, regulatory and judicial decision-makers.

The ISSPP PIPAC database: design, process, access, and first interim analysis.

ObjectivesSeveral trials have documented the favorable safety profile, and promising clinical results of pressurized intraperitoneal aerosol chemotherapy (PIPAC) directed treatment in different types of peritoneal malignancies. However, until the results of randomized trials are available, the quality of documentation and acceptance by the users may be improved through a worldwide registry. The International Society for the Study of Pleura and Peritoneum (www.ISSPP.org) facilitated this process by creating a dedicated focus group and providing the funding needed for the creation and implementation of an international database. This article describes the design and the journey of establishing this international database and the first, preliminary results from the ISSPP PIPAC online database.MethodsIn 2019 the ISSPP PIPAC Registry Group started to create a database with a minimal dataset relevant to many diseases and applicable in different framework conditions. The task was divided into three phases including design, testing, implementation, protocol, handbook, legal requirements, as well as registry rules and bylaws for the registry group.ResultsThe ISSPP PIPAC online database has six key elements (patient, consent, treatment, complications, response evaluation and follow-up). Following design, testing and implementation the database was successfully launched in June 2020. Ten institutions reported on 459 PIPAC procedures in 181 patients during the first 6 months, and the recorded data were comparable to the present literature.ConclusionsA new international multicenter PIPAC database has been developed, tested and implemented under the auspices of ISSPP. The database is accessible through the ISSPP website (www.ISSPP.org), and PIPAC institutions worldwide are highly encouraged to participate.

Systematic Literature Review: Current Products, Topic, and Implementation of Graph Database

Planning, developing, and updating software cannot be separated from the role of the database. From various types of databases, graph databases are considered to have various advantages over their predecessor, relational databases. Graph databases then become the latest trend in the software and data science industry, apart from the development of graph theory itself. The proliferation of research on GDB in the last decade raises questions about what topics are associated with GDB, what industries use GDB in its data processing, what the GDB models are, and what types of GDB have been used most frequently by users in the last few years. This article aims to answer these questions through a Literature Review, which is carried out by determining objectives, determining the limits of review coverage, determining inclusion and exclusion criteria for data retrieval, data extraction, and quality assessment. Based on a review of 60 studies, several research topics related to GDB are Semantic Web, Big Data, and Parallel computing. A total of 19 (30%) studies used Neo4j as their database. Apart from Social Networks, the industries that implement GDB the most are the Transportation sector, Scientific Article Networks, and general sectors such as Enterprise Data, Biological data, and History data. This Literature Review concludes that research on the topic of the Graph Database is still developing in the future. This is shown by the breadth of application and the variety of new derivatives of GDB products offered by researchers to address existing problems.

Factors for the Local Government Data-based Administration Implementation: Focusing on the Key Components and Participants

Factors for the Local Government Data-based Administration Implementation: Focusing on the Key Components and Participants

The development and implementation of a multidimensional relational database of fire danger metrological data

The study designs and implements a multi-dimensional relational database of fire danger metrological information, as well as areas with vegetation. During conceptualization, OLAP algorithms are taken into account as applied to the selection of long-term meteodata and their mathematical processing presented by multidimensional hypercubes. When designing the SQL structure, a layered architecture of geographic information system (GIS) is used, including attribute and geographical characters. The data according to the technology is tested in the Jewish Autonomous Region. The database contains metrological information from five weather stations from 1960 to 2020 and five branches of local forest districts from 1997 to 2020. At present, data is being filled in for the Omsk Region, Primorsky Krai of the Russian Federation and the Osh Region of the Kyrgyz Republic.

CAD와 BOM 통합 데이터베이스 기반 로봇 조립 계획 시스템 아키텍처 개발

This study proposes a system architecture based on integrated Computer-Aided Design (CAD) and Bill of Material (BOM) databases for a robot assembly planning system. The architecture consists of CAD, Product Data Management (PDM) and robot assembly planning applications based on CAD, BOM and robot databases. It manages shape and product structure data from 3D CAD files as data objects in CAD and BOM databases, and stores general robot assembly planning data from robot teaching results as robot path objects in the robot database. Robot engineers create robot assembly plans using a process BOM that incorporates data from the CAD, BOM and robot databases. Throughout the generation of robot assembly plans, the architecture uses the shape data of participating parts in CAD database to automatically calculate the positions of robot end-effectors. This paper describes the implementation of applications and databases in the architecture using FreeCAD, MariaDB and Apache Tomcat Web application server. It also outlines cases of experimental robot assembly planning using the implemented planning systems and robot arms at laboratory level.

On the issue of introducing an electronic database of children with oncological diseases into specialized medical organizations: results of a medical and social research

Accounting for children with cancer is characterized by low reliability of statistics. In addition, the available data do not have significant scientific value., Since they represent only an approximate number of patients identified annually and some general information (incidence, prevalence, etc.). Moreover, subsequent analysis of the accumulated information is of particular importance. An electronic database of children with cancer has been developed that meets these requirements and has been introduced into the clinical practice of pilot medical organizations.Purpose of the study. Our aim was to study the opinions of pediatric oncologists on the issues of registration of children with oncological diseases.Materials and methods. In order to assess the results of the implementation of the electronic database, a "Questionnaire for a survey of a pediatric oncologist to assess the effectiveness of the implementation of an electronic database" was developed, which contained 15 questions. For objectivity, the questionnaires were filled in anonymously by the respondents.Results. The medico- social study involved 187 pediatric oncologists. The majority of respondents (71.3 ± 3.3%) noted that currently there is no register of children with cancer in the Russian Federation, 15.4 ± 2.6% noted the regional register, 9.1 ± 2.1% – independent in individual medical organizations, 1.7 ± 0.9% is a single register for the Russian Federation and 2.5 ± 1.1% are not aware of this. Among respondents, 81.9 ± 2.8% noted that the electronic database is an effective tool for recording children with cancer, while as an advantage, 15.1 ± 2.6% noted an increase in the reliability of statistical data, 9.2 ± 2.1% – reduction of time for searching patient information, 4.4 ± 1.5% – optimization of working time, 71.3 ± 3.3% – a combination of the above options.Conclusion. A medical and social study showed the feasibility of introducing an electronic database of children with cancer into the clinical practice of pediatric oncologists.

44. Reevaluation of copy number variant (CNV) classifications in the clinical laboratory setting: challenges, insights, and experiences with a laboratory-initiated process

Reevaluation and reanalysis of previously performed genomic tests is becoming more commonplace, through laboratory-initiated processes, clinician and even patient requests. According to recent ACMG policy statements, laboratories share the duty to recontact when variants or gene-disease relationships are reclassified. Establishing processes for reanalysis and recontact represents a significant challenge for clinical laboratories, particularly cytogenetics laboratories with microarray and interpretive data which often predate implementation of more sophisticated databases. We share our experiences from a first attempt at establishing a process for reevaluation of copy number variant (CNV) classifications in an academic reference laboratory, where access to clinical information and clinician-patient recontact represent notable obstacles. Approximately 4000 CNVs identified through microarray testing were reviewed, including CNVs classified as variants of uncertain significance (VUS) or likely benign (LB) and overlapping genes and regions with established haploinsufficiency/triplosensitivity by ClinGen Dosage Sensitivity Map curations (DS Score=3, DS3). Of 45 VUS/LB CNVs overlapping DS3 genes, 10 were reclassified to pathogenic (P) or likely pathogenic (LP) based on new evidence in the literature. Amended reports and verbal communication of the updated result was provided in all cases. In some, updated clinical history obtained during reevaluation aided in re-interpretation of the variant. Additionally, 12/45 CNVs involving DS3 genes remained classified as VUS, 9 of which only partially overlap the gene of interest, the functional effect of which is difficult to predict by microarray. We also identified 44 multiply-encountered CNVs (close-match: ≥99% overlap/size similarity) involving 244 cases with discordant classifications, many represented recurrent CNVs with reduced penetrance or deletions overlapping recessive-disease genes. Such discordances illustrate the need for better standards of classification of CNVs, which likely require refinement beyond the current 5-tier classification system. Although challenges remain, this CNV reevaluation process has informed our evolving curation and data sharing processes, with the overarching goal of improved patient care.

Design and implementation of graft database on MSME information system using Neo4j

This study aims to implement a database of information systems for small and medium enterprises (MSME) using database graphs. In the conducted application development, the used database mostly uses the relational database. With the development of large amounts of data, the tendency of ever increasing data volume has an impact on the increasingly large table size and the number of merging data on the query (JOIN) has an impact on the time of accessing the query. This data speed is a problem in the relational database, and one solution is to use the noSQL database. In this research, the implementation of noSQL used a graph database and used the Neo4j application. The research methodology and database development carried out in this study is by collecting and analyzing, conceptual, logical, physical level databases on data related to the needs of MSME information systems such as MSME locations, MSME actors and MSME products. The data is then carried out conceptual level database design and proceed with logical level database design. This research resulted in a graft database that stored the MSME data. The results of the node from the graph database implementation were the nodes of city, sub-district MSME, and product and connector of the sub-district_entrance node which connecting the MSME location (sub-village) with the sub-district, the node connector of industrial_typed_entrance which connecting the MSME actors with the industry types.

Conception and Implementation of Geographical Database for Cultural Heritage Management—Case of Historical Jeddah, KSA

Conception and Implementation of Geographical Database for Cultural Heritage Management—Case of Historical Jeddah, KSA

Automation of Maintaining a Smart Reference Book of Tool Setups for the Development of Control Programs for CNC Machine

The article is devoted to the problems of increasing the efficiency of technological preparation production through the development and implementation of an electronic database of tool setups. In the paper describes the advantages and disadvantages of the existing process for the development of NC-programs, and a methodology for automating the process of conducting tool setups, allowing to reduce the laboriousness of designing manufacturing processes for machining of parts on CNC machines. And also, the calculation results are given the economic efficiency of the project and the prospects for its development.

How Does Private Firm Disclosure Affect Demand for Public Firm Equity? Evidence from the Global Equity Market

We investigate the relationship between private firms’ disclosures and the demand for the equity of their publicly traded peers. Using data on the global movement of public equity, we find that a one standard deviation increase in private firm disclosure transparency – proxied by the number of disclosed private firms’ financial statement line items – reduces global investors’ demand for public equity by 11% to 12% or $174 million to $190 million in dollar terms. These findings are consistent with private firm disclosures generating negative pecuniary externalities – global investors reallocate their capital away from public firms to more transparent private firms – and less consistent with these disclosures creating positive information externalities that would benefit public firms. Consistent with this interpretation, we find that the reduction in demand for public equity is offset by a comparable increase in capital allocation to more transparent private firms. Using staggered openings of the Bureau van Dijk database offices and implementation of electronic business registers in investee countries as plausibly exogenous shocks to private firm transparency, we conclude that the negative relationship between private firm disclosures and public equity demand is likely causal.

Features of the database implementation for materials for industry and medicine

The paper discusses issues related to the creation of a database of materials for industrial and medicine applications. This database is developed to accumulate information about the mechanical and other properties of materials under study and the corresponding sources of information. The paper mainly focused on organizing the change log of the described database. The change log allows one to store, display and analyse all changes made in the database. The technical solutions are presented allowing to implement universal models for logging changes that are invariant with respect to the composition and structure of the tables used.