The Swedish Road Administration wants to compile all the national road database data from The Swedish Mapping, Cadastral and Land Registration Authority using a Geographical Information System compiler in order to increase the efficiency of data flow between their respective databases. The objective of this master’s thesis has been to build a software solution containing changed private road data input from The Swedish Mapping, Cadastral and Land Registration Authority and processing it into the OpenTNF standard format. This would enable automatic processing and of private road data to the national road database at the Swedish Road Administration. The work is divided into four parts; 1. Researching standards for databases and version control. 2. Plan the methodology using different resources. 3. Development of a software solution. 4. Analysis. The chosen software is FME by Safe Software. A number of shortcomings such as lack of information on the practical input for the future ANDA system were discovered, therefor some assumptions and simplifications had to be made. Using the assumptions and examples, a functioning solution was created according to the OpenTNF and INSPIRE standards. The examples to fills that gap in knowledge and provide a greater understanding of the usage of the INSPIRE and OpenTNF standards for transport networks. An analysis and a discussion about the existing solution, bottlenecks, faults with the existing database and version management between the databases related to found research is presented. Workflows on different examples for the software solution can be seen in the results. The national road database suffers from low implementation rate and creates issues for making new applications and the ability to adapt to ever-changing nature of planning. Creating a software for automatic update on network data is crucial for the Swedish Road Administration for implementing technologies that are dependent on frequent updates, such as self-driving vehicles.

The object of the thesis is streaming data change capture. The purpose of the work is to analyze the methods for building a streaming data change capture system and implement the best method selected during the analysis. Research methods: theoretical analysis, testing, programming. The result of the work is the successful implementation and testing of a streaming data change capture system based on Kafka Connect in conjunction with the Debezium connector for MySQL and ClickHouse Kafka Connect Sink for ClickHouse, the solved problem of the latter's limitation on processing remote records from the data source, as well as obtaining the current state of data from the source. The scope of the obtained results is data engineering and artificial intelligence. The significance of the work lies in the possibility of its practical implementation at the place of work, as well as in the flexible approach to solving the problem under the conditions of tool limitations. / Цель работы – анализ методов построения потокового захвата изменений данных и реализация лучшего метода, выбранного в ходе анализа. Методы исследования: теоретический анализ, тестирование, программирование. Результатом работы является успешная реализация и тестирование системы потокового захвата изменений данных на базе Kafka Connect в связке с коннектором Debezium для MySQL и ClickHouse Kafka Connect Sink для ClickHouse, решённая проблема ограничения последнего на обработку удалённых записей из источника данных, а также получение актуального состояния данных из источника. Область применения полученных результатов – инженерия данных и искусственного интеллекта. Значимость работы заключается в возможности её практической реализации по месту работы, а также в гибком подходе к решению поставленной задачи в условиях ограничений инструментария.

<p>This report includes a development presentation of an information system for managing the staff data within a small company or organization. The system as such as it has been developed is called Employee Management System. It consists of functionally related GUI (application program) and database.</p><p>The choice of the programming tools is individual and particular.</p>

<p>Databaser och databassystem är grunden för en stor del av de verksamheter som företag och organisationer sysslar med idag. Att utnyttja moderna databasteknologier kan medföra ett säkrare och smidigare system vilket i sin tur kan leda till konkurrens-fördelar för de som använder dem.</p><p>I detta arbete undersöks i vilken omfattning ett antal olika moderna databasteknologier används inom företag och organisationer i Sverige och huruvida kostnaden är det största hindret för vidareutvecklingar av befintliga system.</p><p>Inledningsvis beskrivs ett antal moderna databasteknologier för att ge en uppfattning om vilka möjligheter som finns på databasområdet. Därefter redovisas den under-sökning som gjorts med hjälp av telefonintervju som metod för att samla in material.</p><p>Resultatet visar att vissa teknologier, som exempelvis databaser kopplade mot Internet, utnyttjas och i stor utsträckning kommer att användas i ännu högre grad i framtiden. Av undersökningen framkom ett flertal olika hinder för utveckling av databassystem där kostnaden endast är ett av dessa.</p>

Many small enterprises in Lithuania don’t use information systems in their accounting. This is because almost all of already developed accounting software is quite complex, expensive and has many additional features, witch aren’t useful for a small enterprises. This is why it has been decided to develop own specific software for a goods accounting. User interface and data structure should be adapted to the specific functions of the small optical enterprise. The purposes of the developed information system are to increase work and accounting quality, to decrease time needed for accounting, to avoid saving redundant information, to automate and simplify the process of creating analytical reports, to avoid mistakes in accounting and make accounting more efficient. In the process of developing this information system there was analyzed functional and nonfunctional, manage mental and common requirement issues. The models of dataflow, data structure, and applications were used in the requirement specification. Architecture of components and software structure is also provided in this project. The realization of this project was accomplished by means of Microsoft Access 2000. There was created database, graphical user interface, and integrated Microsoft Visual Basic for Applications was used to perform programming tasks. Abilities of this software are fully sufficient for these tasks. Selected design techniques and tools had proved themselves in solving software for small... [to full text]

Investments on multimedia technology enable us to store many more reflections of the real world in digital world as videos. By recording videos about real world entities, we carry a lot of information to the digital world directly. In order to store and efficiently query this information, a video database system (VDBS) is necessary. In this thesis work, we propose a structural, event based and multimodal (SEBM) video data model for VDBSs. SEBM video data model supports three different modalities that are visual, auditory and textual modalities and we propose that we can dissolve these three modalities with a single SEBM video data model. This proposal is supported by the interpretation of the video data by human. Hence we can answer the content based, spatio-temporal and fuzzy queries of the user more easily, since we store the video data as the way that s/he interprets the real world data. We follow divide and conquer technique when answering very complicated queries. We have implemented the SEBM video data model in a Java based system that uses XML for representing the SEBM data model and Berkeley XML DBMS for storing the data based on the SEBM prototype system.

A evolução das ferramentas computacionais, aliada à tecnologia da informação (TI) e ao ambiente web possibilitam a realização de projetos colaborativos, com maior integração de procedimentos, visando à comunicação, à coordenação e à cooperação da equipe multidisciplinar. O estudo de caso, realizado para o projeto de produto edificação, foi desenvolvido com a aplicação de um questionário nos escritórios de projeto em Porto Alegre e apontou para uma situação diversa da efetiva utilização destas ferramentas. O desafio do trabalho está no fato de se estabelecer os requisitos das equipes de projeto, para o desenvolvimento de um sistema de gestão do conhecimento, com a utilização da estrutura de metadados para conceber um mecanismo de busca das informações. O desenvolvimento do processo de investigação apresentou a influência da TI no setor de projetos; a adoção de um modelo de referência para gerenciamento do processo de projeto integrado de edificações (GPPIE) e a possibilidade de integração eficaz com um SGBD. / The evolution of computational tools, along with information technology (IT) and the web environment allow for collaborative projects, with a greater integration of procedures for communication, coordination and cooperation of the multidisciplinary team. The case study was conducted for the building design product, was developed with a questionnaire in the design offices in Porto Alegre, and pointed to a situation different from the effective use of these tools. The challenge of the work is to establish the requirements of the design team, developing a management system of Knowledge, using the metadata structure designing a search engine information. The development of the research showed the influence of IT in the design, the adoption of a reference model for building integrated design process management (BIDPM) and the possibility of effective combination with a DBMS.

A evolução das ferramentas computacionais, aliada à tecnologia da informação (TI) e ao ambiente web possibilitam a realização de projetos colaborativos, com maior integração de procedimentos, visando à comunicação, à coordenação e à cooperação da equipe multidisciplinar. O estudo de caso, realizado para o projeto de produto edificação, foi desenvolvido com a aplicação de um questionário nos escritórios de projeto em Porto Alegre e apontou para uma situação diversa da efetiva utilização destas ferramentas. O desafio do trabalho está no fato de se estabelecer os requisitos das equipes de projeto, para o desenvolvimento de um sistema de gestão do conhecimento, com a utilização da estrutura de metadados para conceber um mecanismo de busca das informações. O desenvolvimento do processo de investigação apresentou a influência da TI no setor de projetos; a adoção de um modelo de referência para gerenciamento do processo de projeto integrado de edificações (GPPIE) e a possibilidade de integração eficaz com um SGBD. / The evolution of computational tools, along with information technology (IT) and the web environment allow for collaborative projects, with a greater integration of procedures for communication, coordination and cooperation of the multidisciplinary team. The case study was conducted for the building design product, was developed with a questionnaire in the design offices in Porto Alegre, and pointed to a situation different from the effective use of these tools. The challenge of the work is to establish the requirements of the design team, developing a management system of Knowledge, using the metadata structure designing a search engine information. The development of the research showed the influence of IT in the design, the adoption of a reference model for building integrated design process management (BIDPM) and the possibility of effective combination with a DBMS.

This report includes a development presentation of an information system for managing the staff data within a small company or organization. The system as such as it has been developed is called Employee Management System. It consists of functionally related GUI (application program) and database. The choice of the programming tools is individual and particular.

A evolução das ferramentas computacionais, aliada à tecnologia da informação (TI) e ao ambiente web possibilitam a realização de projetos colaborativos, com maior integração de procedimentos, visando à comunicação, à coordenação e à cooperação da equipe multidisciplinar. O estudo de caso, realizado para o projeto de produto edificação, foi desenvolvido com a aplicação de um questionário nos escritórios de projeto em Porto Alegre e apontou para uma situação diversa da efetiva utilização destas ferramentas. O desafio do trabalho está no fato de se estabelecer os requisitos das equipes de projeto, para o desenvolvimento de um sistema de gestão do conhecimento, com a utilização da estrutura de metadados para conceber um mecanismo de busca das informações. O desenvolvimento do processo de investigação apresentou a influência da TI no setor de projetos; a adoção de um modelo de referência para gerenciamento do processo de projeto integrado de edificações (GPPIE) e a possibilidade de integração eficaz com um SGBD. / The evolution of computational tools, along with information technology (IT) and the web environment allow for collaborative projects, with a greater integration of procedures for communication, coordination and cooperation of the multidisciplinary team. The case study was conducted for the building design product, was developed with a questionnaire in the design offices in Porto Alegre, and pointed to a situation different from the effective use of these tools. The challenge of the work is to establish the requirements of the design team, developing a management system of Knowledge, using the metadata structure designing a search engine information. The development of the research showed the influence of IT in the design, the adoption of a reference model for building integrated design process management (BIDPM) and the possibility of effective combination with a DBMS.