This thesis investigates embedded databases and graphical interfaces for the MicroBaseJ project. The project aim is the development of an integrated database and GUI user interface for a typical 3G, or 2.5G, mobile phone with Java MIDP2 capability. This includes methods for data acquisition, mobile data and information communication, data management, and remote user interface. Support of phone delivered informatics will require integrated server and networking infrastructure research and development to support effective and timely delivery of data for incorporation in mobile device-based informatics applications. A key research and development (R&D) challenge is to support effective and timely delivery of data for incorporation in mobile device-based informatics applications. Another important aspect of the project is determining how to develop efficient graphics for the small mobile screen. The research investigates and analyses the architecture of a mobile monitoring system. The project developed a generic solution that can be implemented in a number of commercial sectors, such as horticulture, building management and pollution/water management. The developed concept is tested using data relevant to the horticultural area of application. The system also addresses the main issues related to mobile monitoring, including real-time response, data integrity, solution cost, graphical presentation, and persistent storage capabilities of modern mobile devices. Four embedded databases based on J2ME have been investigated. Two of the four have been evaluated and analysed. The Insert function, Sequence Search, and Random Search of Perst List and RMS (Record Management System) databases have been tested. The size of the processed data was limited to 20,000 records when using the wireless toolkit simulator, and 11,000 records when using a mobile phone. Perst Lite reflects good performance and has out-performed RMS in all tests. User interface software such as J2ME Polish for mobile phones has been investigated. Custom J2ME class for graphical interface is developed. This provides the graphical presentation of the data collected from the sensors; including temperature, wind speed, wind direction, moisture, and leaf wetness. The graphical interface, bar charts, and line charts with trace ball for collected data have been designed and implemented. The embedded database performance and project performance have been investigated and analysed. The performances of Perst Lite and RMS are evaluated in terms of the insert, sequence search, and random search functions based on simulation and real devices. The record numbers vary from 1,000 to 20,000. The project performance contains data receiving and storage, and data presentation and configuration. The performance of data storage and configuration can be negated due to the running mode and the response time. Thus, data presenting performance is the key focus in this project. This performance was divided into the categories of initial, data search, data selection, and charting. The initial performance includes the initialisation of the project parameters, and the reaching of the welcome interface. Data search performance refers to the retrieval of the specified data from the embedded database, measured on 48 data points, which only can be presented on the mobile screen from the retrieved data. These four performance types are measured in thousands of record numbers, varying from 1,000 to 18,000 record numbers, with the retrieved data range varying from 1 day to 30 days.

This thesis investigates embedded databases and graphical interfaces for the MicroBaseJ project. The project aim is the development of an integrated database and GUI user interface for a typical 3G, or 2.5G, mobile phone with Java MIDP2 capability. This includes methods for data acquisition, mobile data and information communication, data management, and remote user interface. Support of phone delivered informatics will require integrated server and networking infrastructure research and development to support effective and timely delivery of data for incorporation in mobile device-based informatics applications. A key research and development (R&D) challenge is to support effective and timely delivery of data for incorporation in mobile device-based informatics applications. Another important aspect of the project is determining how to develop efficient graphics for the small mobile screen. The research investigates and analyses the architecture of a mobile monitoring system. The project developed a generic solution that can be implemented in a number of commercial sectors, such as horticulture, building management and pollution/water management. The developed concept is tested using data relevant to the horticultural area of application. The system also addresses the main issues related to mobile monitoring, including real-time response, data integrity, solution cost, graphical presentation, and persistent storage capabilities of modern mobile devices. Four embedded databases based on J2ME have been investigated. Two of the four have been evaluated and analysed. The Insert function, Sequence Search, and Random Search of Perst List and RMS (Record Management System) databases have been tested. The size of the processed data was limited to 20,000 records when using the wireless toolkit simulator, and 11,000 records when using a mobile phone. Perst Lite reflects good performance and has out-performed RMS in all tests. User interface software such as J2ME Polish for mobile phones has been investigated. Custom J2ME class for graphical interface is developed. This provides the graphical presentation of the data collected from the sensors; including temperature, wind speed, wind direction, moisture, and leaf wetness. The graphical interface, bar charts, and line charts with trace ball for collected data have been designed and implemented. The embedded database performance and project performance have been investigated and analysed. The performances of Perst Lite and RMS are evaluated in terms of the insert, sequence search, and random search functions based on simulation and real devices. The record numbers vary from 1,000 to 20,000. The project performance contains data receiving and storage, and data presentation and configuration. The performance of data storage and configuration can be negated due to the running mode and the response time. Thus, data presenting performance is the key focus in this project. This performance was divided into the categories of initial, data search, data selection, and charting. The initial performance includes the initialisation of the project parameters, and the reaching of the welcome interface. Data search performance refers to the retrieval of the specified data from the embedded database, measured on 48 data points, which only can be presented on the mobile screen from the retrieved data. These four performance types are measured in thousands of record numbers, varying from 1,000 to 18,000 record numbers, with the retrieved data range varying from 1 day to 30 days.

O uso de técnicas de replicação de dados em dispositivos móveis permite que uma aplicação móvel compartilhe dados com um servidor e possa atuar sobre tais dados durante períodos de desconexão. Embora essa característica seja fundamental em diversos domínios, a reconciliação das transações que foram aplicadas sobre a réplica móvel dos dados apresenta-se como um desafio a ser superado. O uso de bloqueios apresenta-se impraticável em determinados domínios de aplicação. Por outro lado, ao permitir a execução de operações de escrita em diversas réplicas sem uma sincronização a priori, o sistema se torna suscetível a conflitos de atualização, sendo necessário a implementação de um mecanismo de resolução de conflitos. Resolver conflitos é uma tarefa complexa e propensa a erros, em especial nos casos em que há a necessidade de intervenção humana. Diante desse cenário, foi desenvolvido um modelo para controle de transações em bancos de dados autônomos que faz uso de metadados e multiversão de banco de dados de forma a permitir a auditoria e retificação de resoluções de conflitos. Isso torna a resolução de conflitos uma operação não destrutiva, reduzindo, assim, o impacto de uma resolução de conflito incorreta. Neste trabalho é apresentado também um arcabouço para reconciliação de transações que implementa o modelo proposto. Como estudo de caso, o arcabouço desenvolvido foi utilizado para implementar a integração entre dois sistemas reais que possuem necessidades de replicação de dados e atualizações desconectadas. / The use of data replication techniques on mobile devices allows a mobile application to share data with a server and to work on such data while disconnected. While this feature is crucial in some application domains, the reconciliation of transactions applied to the mobile replica of data proves to be challenging. The use of locking is not feasible in some application domains. However, allowing write operations to be applied on several replicas without \\emph{a priori} synchronization makes the system susceptible to update conflicts, requiring a conflict resolution mechanism. Conflict resolution is a complex and error prone task, specially when human intervention is involved. Given this scenario, we developed a transactions control model for autonomous databases that uses metadata and database versioning to provide auditing and rectification of conflict resolutions. This turns the conflict resolution into a nondestructive operation, thus reducing the impact of an incorrect conflict resolution. This work presents also a framework for transaction reconciliation that implements the proposed model. As a case study, the developed framework was used to integrate two real systems that needed data replication and disconnected updates.

O uso de técnicas de replicação de dados em dispositivos móveis permite que uma aplicação móvel compartilhe dados com um servidor e possa atuar sobre tais dados durante períodos de desconexão. Embora essa característica seja fundamental em diversos domínios, a reconciliação das transações que foram aplicadas sobre a réplica móvel dos dados apresenta-se como um desafio a ser superado. O uso de bloqueios apresenta-se impraticável em determinados domínios de aplicação. Por outro lado, ao permitir a execução de operações de escrita em diversas réplicas sem uma sincronização a priori, o sistema se torna suscetível a conflitos de atualização, sendo necessário a implementação de um mecanismo de resolução de conflitos. Resolver conflitos é uma tarefa complexa e propensa a erros, em especial nos casos em que há a necessidade de intervenção humana. Diante desse cenário, foi desenvolvido um modelo para controle de transações em bancos de dados autônomos que faz uso de metadados e multiversão de banco de dados de forma a permitir a auditoria e retificação de resoluções de conflitos. Isso torna a resolução de conflitos uma operação não destrutiva, reduzindo, assim, o impacto de uma resolução de conflito incorreta. Neste trabalho é apresentado também um arcabouço para reconciliação de transações que implementa o modelo proposto. Como estudo de caso, o arcabouço desenvolvido foi utilizado para implementar a integração entre dois sistemas reais que possuem necessidades de replicação de dados e atualizações desconectadas. / The use of data replication techniques on mobile devices allows a mobile application to share data with a server and to work on such data while disconnected. While this feature is crucial in some application domains, the reconciliation of transactions applied to the mobile replica of data proves to be challenging. The use of locking is not feasible in some application domains. However, allowing write operations to be applied on several replicas without \\emph{a priori} synchronization makes the system susceptible to update conflicts, requiring a conflict resolution mechanism. Conflict resolution is a complex and error prone task, specially when human intervention is involved. Given this scenario, we developed a transactions control model for autonomous databases that uses metadata and database versioning to provide auditing and rectification of conflict resolutions. This turns the conflict resolution into a nondestructive operation, thus reducing the impact of an incorrect conflict resolution. This work presents also a framework for transaction reconciliation that implements the proposed model. As a case study, the developed framework was used to integrate two real systems that needed data replication and disconnected updates.

This diploma work deals with proposal and implementation GPS navigation system. Work includes described basic types of cement quarry and proposal to create mathematical and software model of quarry. Then work is devoted to possibilities of basic described algorithms for searching the shortest way in graph and two algorithms are described. They are Floyd-Warshall and Dikjstra algorithms. The work describe implementation of Dijkstra algorithm to model of quarry and description of the programs Autec RouteEditor and AQL Control Library. MINÁČ, J. GPS navifgation system for cement for cement technology. Brno: Brno university of technology, Faculty of electrical engineering and communication, 2009. 90 p. Supervisor prof. Ing. František Zezulka, CSc.