In this study, the safety of using ETL processes to migrate geographical data between heterogeneous data sources was investigated, as well as whether certain data structures are more prone to integrity loss during such migrations. Geographical data in various vector structures was migrated using ETL software, FME, from a legacy data source (Oracle 11g with integrated Esri geodatabases) to another (PostgreSQL 14.10 with the PostGIS extension) in order to explore the aforementioned challenges. The maintenance of data integrity post-migration was assessed by comparing the difference between the geodata housed in Oracle 11g (the source) and PostgreSQL 14.10 (the destination) using ArcGIS Pro's built-in tools and a Python script. Further evaluation of the role of ETL processes in geographical data migration included conducting interviews with specialists in databases, data migration, and FME both before and after the migration. The study concludes that different vector structures are affected differently. Whereas points and lines maintained 100% data integrity across all datasets, polygons achieved 99.95% accuracy in one out of the three tested datasets. Managing this issue can be addressed by implementing a repair process during the Transform stage of an ETL process. However, such a process does not guarantee an entirely successful outcome; although the affected area was significantly reduced post-repair, the polygons contained a higher amount of mismatches. / I denna studie undersöktes om ETL-processer kan användas på ett säkert sätt för att migrera geografiska data mellan heterogena datakällor, samt om vissa datastrukturer är mer benägna att förlora integritet under sådana migrationer. Geografiskt data i olika vektorstrukturer migrerades med hjälp av ETL-programvaran FME, från en föråldrad datakälla (Oracle 11g med integrerade Esri geodatabaser) till en annan (PostgreSQL 14.10 med PostGIS-tillägget) för att utforska de ovannämnda frågorna. Dataintegritet mättes genom att jämföra skillnaden mellan geodatan på Oracle 11g (källan) och PostgreSQL 14.10 (destinationen) med hjälp av ArcGIS Pro's inbyggda verktyg och ett Python skript. För att ytterligare utvärdera rollen av ETL-processer i migrering av geografiskt data genomfördes intervjuer med specialister inom databaser, datamigration och FME, både före och efter migrationen.  Studien konstaterar att olika vektorstrukturer påverkas olika. Medan punkter och linjer bibehöll 100% datatillförlitlighet över alla dataset, uppnådde polygoner 99,95% noggrannhet i ett av de tre testade dataseten. Hantering av detta problem kan adresseras genom att implementera en reparationsprocess under Transform-steget av en ETL-process. Dock garanterar inte en sådan process ett helt lyckat resultat; även om den påverkade arean minskades avsevärt efter reparationen, innehöll polygonerna ett högre antal avvikelser.

O incentivo ao uso racional de medicamentos fator importante na melhoria das condições de saúde. A efetivação desta racionalidade, no entanto, esbarra tanto em fatores culturais como em fatores de escassez ou mesmo ausência de informação confiável. Os farmacêuticos, membros indispensáveis de qualquer equipe multidisciplinar de saúde, cumprem papel preponderante na disseminação deste conhecimento especializado. Com o objetivo de suprir as lacunas existentes quanto a qualidade da informação farmacológico-terapêutica existente no Brasil, este trabalho desenvolve um sistema de informações sobre medicamentos cardiovasculares aliado a um Sistema de Suporte a Decisão Baseado em Alertas, utilizando uma arquitetura que combina bases de dados relacionais com Medical Logical Modules. O sistema desenvolvido proporciona, a farmacêuticos e outros profissionais da área da saúde, não apenas consultas a informação, mas também sugestões e alertas contextuais referentes ao uso correto de medicamentos, contribuindo, assim, para o treinamento no próprio trabalho destes. / The rational use of drugs is an important factor to the health conditions improvement. The pharmacists are responsible for advising customers about the rational use of drugs, but this professional effort is limited by cultural factors, absence or lack of reliable infomation. The aim of this work is to support pharmacists through a cardiovascular medicine Information System attached to an Alert-based Decision Support System whose structure combines Medical Logical Modules and relational databases. The developed system not only provides the health professional and pharmacist with drug information, but also suggests or alerts them about the proper use of drugs as well it contributes to their in site training.

隨著全球資訊網（World Wild Web，簡稱WWW或Web）的日趨普及，我們發現愈來愈多的資料是直接從網路上呈現與存取的。不同於過去關聯式資料庫(Relational Database Management Systems，RDBMS)的結構式資料(Structured Data)。現今許多資料都是直接以HTML(Hypertext Markup Language)格式呈現，然而HTML 的標籤只是在做資料的呈現。為了讓網際網路上的資料可真正順利傳達於組織間，新興的XML逐漸受到重視。相較於HTML，XML標籤是在做資料的定義，讓定義好的資料直接透過網際網路傳達於組織間，具有在組織間再使用(Reuse)的能力，因此現在逐漸成為組織間資料整合與轉換時一個好的解決方式。但面對傳統的關連式資料庫又該如何與XML文件整合(Data Integration)的動作，讓兩種不同來源的資料能夠相互運算(Interoperability)，達成異質性資料的同質化(Homogeneous)的功效。使不同來源的資料可雙向的互相溝通，是目前急欲被探討的問題。因此本研究便發展了對關聯式資料庫與XML文件兩種來源相互轉換的溝通機制，讓資料能在這兩種來源間相互交換與利用。 / With the popularity of WWW( World Wild Web or Web )，we have seen large volume of data is available on the Web. Different from the data stored in traditional RDBMS (Relational Databases Managements Systems) which is structured data, huge data now is stored directly in the form of HTML (Hypertext Markup Language) pages. For representing data and interchange data between multiple data sources on the Web, XML (Extensible Markup Language) is a fast emerging as the dominant standard. Like HTML, XML is a subset of SGML. However, whereas HTML tags serve the primary purpose of describing how to display a data item, XML tags describe the data itself. The initial impetus for XML may have been primarily to enhance this ability of remote applications to interpret and operate on documents fetched over the Internet, so it has become the best solution now to solve the problems with data exchange and translation between the multiple sources. But XML also raises a problem: how to integrate XML documents with data stored in the traditional RDBMS. The objective is to communicate bi-directional data sources between RDBMS data and XML documents, and has the ability to interoperate data between multiple data sources. Finally, reach the purpose of heterogeneous data become homogeneous. In this research, we try to develop a translation model between RDBMS data and XML documents, in order to exchange and reuse data between different sources.

It is not revolutionary to say that repetition and practical experience is a very important aspect in learning about and understanding a topic. This is especially true for languages, particularly from the point of view of vocabulary.Like in many other processes that deal with gaining knowledge, studying foreign words involves a lot of side work: For instance the selection of words, or their presentation for the actual training.The purpose of this thesis is to automate the study of vocabulary. To do so, an intelligent software package was developed. Divided into three parts the project takes into account the aspects from the language point of view, from the studying point of view, and from the computer science point of view.The fundamental idea to accomplish the goal is a relational database system. It is utilized by software programs that solve their tasks in respect to data management, data manipulation, storage and retrieval, in an efficient way.The system is developed for English speaking persons studying German as a foreign language. And with every language having its own nature, it naturally influences all levels and aspects of design and utilization of the database.l: / Department of Computer Science

This Thesis addresses how Semantic Web representations, in particular RDF, can enable flexible and scalable preservation, recreation, and querying of databases. An approach has been developed for selective scalable long-term archival of relational databases (RDBs) as RDF, implemented in the SAQ (Semantic Archive and Query) system. The archival of user-specified parts of an RDB is specified using an extension of SPARQL, A-SPARQL. SAQ automatically generates an RDF view of the RDB, the RD-view. The result of an archival query is RDF triples stored in: i) a data archive file containing the preserved RDB content, and ii) a schema archive file containing sufficient meta-data to reconstruct the archived database. To achieve scalable data preservation and recreation, SAQ uses special query rewriting optimizations for the archival queries. It was experimentally shown that they improve query execution and archival time compared with naïve processing. The performance of SAQ was compared with that of other systems supporting SPARQL queries to views of existing RDBs. When an archived RDB is to be recreated, the reloader module of SAQ first reads the schema archive file and executes a schema reconstruction algorithm to automatically construct the RDB schema. The thus created RDB is populated by reading the data archive and converting the read data into relational attribute values. For scalable recreation of RDF archived data we have developed the Triple Bulk Load (TBL) approach where the relational data is reconstructed by using the bulk load facility of the RDBMS. Our experiments show that the TBL approach is substantially faster than the naïve Insert Attribute Value (IAV) approach, despite the added sorting and post-processing. To view and query semi-structured Topic Maps data as RDF the prototype system TM-Viewer was implemented. A declarative RDF view of Topic Maps, the TM-view, is automatically generated by the TM-viewer using a developed conceptual schema for the Topic Maps data model. To achieve efficient query processing of SPARQL queries to the TM-view query rewrite transformations were developed and evaluated. It was shown that they significantly improve the query execution time. / eSSENCE

Thesis (M.S.)--State University of New York at Binghamton, Department of Computer Science, Thomas J. Watson School of Engineering and Applied Science, 2006. / Includes bibliographical references.

O incentivo ao uso racional de medicamentos fator importante na melhoria das condições de saúde. A efetivação desta racionalidade, no entanto, esbarra tanto em fatores culturais como em fatores de escassez ou mesmo ausência de informação confiável. Os farmacêuticos, membros indispensáveis de qualquer equipe multidisciplinar de saúde, cumprem papel preponderante na disseminação deste conhecimento especializado. Com o objetivo de suprir as lacunas existentes quanto a qualidade da informação farmacológico-terapêutica existente no Brasil, este trabalho desenvolve um sistema de informações sobre medicamentos cardiovasculares aliado a um Sistema de Suporte a Decisão Baseado em Alertas, utilizando uma arquitetura que combina bases de dados relacionais com Medical Logical Modules. O sistema desenvolvido proporciona, a farmacêuticos e outros profissionais da área da saúde, não apenas consultas a informação, mas também sugestões e alertas contextuais referentes ao uso correto de medicamentos, contribuindo, assim, para o treinamento no próprio trabalho destes. / The rational use of drugs is an important factor to the health conditions improvement. The pharmacists are responsible for advising customers about the rational use of drugs, but this professional effort is limited by cultural factors, absence or lack of reliable infomation. The aim of this work is to support pharmacists through a cardiovascular medicine Information System attached to an Alert-based Decision Support System whose structure combines Medical Logical Modules and relational databases. The developed system not only provides the health professional and pharmacist with drug information, but also suggests or alerts them about the proper use of drugs as well it contributes to their in site training.

O incentivo ao uso racional de medicamentos fator importante na melhoria das condições de saúde. A efetivação desta racionalidade, no entanto, esbarra tanto em fatores culturais como em fatores de escassez ou mesmo ausência de informação confiável. Os farmacêuticos, membros indispensáveis de qualquer equipe multidisciplinar de saúde, cumprem papel preponderante na disseminação deste conhecimento especializado. Com o objetivo de suprir as lacunas existentes quanto a qualidade da informação farmacológico-terapêutica existente no Brasil, este trabalho desenvolve um sistema de informações sobre medicamentos cardiovasculares aliado a um Sistema de Suporte a Decisão Baseado em Alertas, utilizando uma arquitetura que combina bases de dados relacionais com Medical Logical Modules. O sistema desenvolvido proporciona, a farmacêuticos e outros profissionais da área da saúde, não apenas consultas a informação, mas também sugestões e alertas contextuais referentes ao uso correto de medicamentos, contribuindo, assim, para o treinamento no próprio trabalho destes. / The rational use of drugs is an important factor to the health conditions improvement. The pharmacists are responsible for advising customers about the rational use of drugs, but this professional effort is limited by cultural factors, absence or lack of reliable infomation. The aim of this work is to support pharmacists through a cardiovascular medicine Information System attached to an Alert-based Decision Support System whose structure combines Medical Logical Modules and relational databases. The developed system not only provides the health professional and pharmacist with drug information, but also suggests or alerts them about the proper use of drugs as well it contributes to their in site training.

The Web Based Query Optimization Simulator (WBQOS) is a software tool designed to enhance understanding of query optimization with a Relational Database Management System (RDBMS). WBQOS allows the user to visualize and participate in query optimization, which enhances the learning process.

Whenever one designs a new database system, an Entity-Relationship Diagram (ER diagram) is always needed to present the structure of this database. Using the graphically well-arranged ER Diagram helps you to easily understand the entities, attributes, domains, primary keys, foreign keys, constraints, and relationships inside a database. This data-modeling tool is an ideal choice for companies and developers.