Šiais laikais, kai praktiškai visų sričių „popieriniai“ duomenys jau baigia išnykti, didelę dalį IT visuomenėje sudaro vienokio ar kitokio tipo duomenų bazės. Paprastam vartotojui, kuris naudojasi tik vartojamojo tipo programomis, SQL užklausų mokėjimas nėra reikalingas, tačiau bet kuris programuotojas, kuris dirba su duomenimis, savo darbo ko gero nebeįsivaizduoja be duomenų bazių ir SQL užklausų. SQL užklausa (SQL Query) – tai užklausa, atliekama SQL kalbos komandų pagalba. SQL (Structured Query Language) kalba – struktūrizuota užklausų kalba, skirta duomenų, esančių duomenų bazėje apdorojimui. SQL kalba dirba tik su reliacinėmis DB. Vartotojas SQL pagalba kreipiasi į DBVS, kuri apdoroja užklausą, randa reikalingus duomenis ir pateikia juos vartotojui. SQL nėra nei DBVS, nei atskiras programinis produktas, tai yra neatsiejama DBVS dalis, instrumentas, kurio pagalba realizuojamas vartotojo ryšys su DBVS. SQL kalbos lankstumas ir nepriklausomumas nuo kompiuterinių technologijų specifikos, o taip pat jos palaikymas pagrindiniais lyderiais reliacinių duomenų bazių technologijų srityje padarė SQL kalbą pagrindine standartine duomenų bazių programavimo kalba [1]. SQL užklausos yra naudojamos visose dabartinėse duomenų bazėse, tokiose kaip MsSQL, MySQL, Firebird ir kitose. SQL sakiniai gali būti įterpiami į programas, sudaromas bazine programavimo kalba. Taigi SQL užklausos yra naudojamos visur, kur yra naudojamos ir duomenų bazės. Tą pačią SQL užklausą... [toliau žr. visą tekstą] / Nowadays, when “paper” data practically from all the scopes is on the edge of extinction, big part of IT society is made of one or another type of databases. SQL queries are used to work with database information. SQL (Structured Query Language) is designed for database information processing. For fast systems, related with databases operation, it is necessary to correctly write and optimize SQL queries. To learn write SQL queries correctly and optimize them, only the theoretical knowledge is not enough, it is necessary to do a lot of practical tasks. When learning to write SQL queries, basic problem is poor choice of practical tasks, and non-existence of good testing system, which allows writing SQL queries easily. On the job the existent SQL learning systems and learning materials analysis were performed, all found systems has its own problems, full freedom to write SQL queries for user is not granted. During designing, methods allowing for learner easily write various types of queries, view executed queries results and get the result if a written query is correct, were designed. Designed methods were used in remote SQL queries learning system design and implementation. Aim: The algorithms which are developed and implemented allows to test sql queries based on simple syntax and allows to execute queries of the different types. The object of research: Execution of various SQL queries.

Midroc automation uses databases for many different projects, both internally and in customer projects. At present, they are mainly using relational databases. There is an interest in researching different types of databases not based on the relational model. Midroc automation wants to know if there are any advantages of using a non-relational database. This project will compare two different databases. To make this comparison Microsoft SQL and MongoDB has been selected. MongoDB is a document type database which belongs to the category of non-relational databases commonly referred to as NoSQL. An application with a GUI and CRUD operations for each database has been implemented. This implementation was done using C# .NET in Visual Studio. The result of the comparison shows that MongoDB is more flexible while developing a database. It is also easier to make changes to an existing database while working with MongoDB. It is however harder to find information and support online when working with MongoDB. / Midroc Automation använder databaser till många olika projekt, både internt och mot sina kunder. Idag använder de främst databaser baserade på relationsmodellen. De är intresserade av att utreda om det finns några andra typer av databaser som inte är baserade på relationsmodellen och också om dessa skulle innebära några fördelar. I detta projekt kommer man att jämföra två olika databaser. För att göra denna jämförelse har man valt att undersöka Microsoft SQL och MongoDB. MongoDB är en databas av dokumenttyp som tillhör de moderna icke-relationella databaserna kallade NoSQL. För att göra jämförelsen har en applikation med tillhörande GUI och CRUD-operationer implementerats för varje databas. Implementationen har gjorts med hjälp av C# .NET i utvecklingsverktyget Visual Studio. Resultatet av jämförelsen visar att MongoDB är mer flexibelt vid utveckling av databasen. Det är också enklare att göra ändringar till en befintlig databas med MongoDB. Det är dock svårare att hitta information och hjälp online då man utvecklar en Mongo databas.

The aim of this Master Thesis named Transformation from OCL into SQL is to explore possibilities of enhancing Enterprise Architect by the ability of generating SQL code that implements OCL constraints of a Platform Independent Model, and to create a working prototype that demonstrates this capability. The thesis contains a brief introduction to the problem of Model Driven Architecture, why it would be useful to implement the specified constraints directly in the database, a description of the interaction with Enterprise Architect along with analysing how to get the needed data, the way OCL can be mapped onto SQL, and finally it describes the implementation of the OCLtoSQL plugin from its analysis and chosen architecture to its documentation.

Currently two major database management systems are in use for dealing with data, the Relational Database Management System (RDBMS) also knows as standard SQL databases and the NoSQL databases. The RDBMS databases deal with structured data and the NoSQL databases with unstructured or semi-structured data. The RDBMS databases have been popular for many years but the NoSQL type is gaining popularity with the introduction of the internet and social media. Data flow from SQL to NoSQL or vice versa is very much possible in the near future due to the growing popularity of the NoSQL databases. The goal of this thesis is to analyze the data structures of the RDBMS and the NoSQL databases and to suggest a Graphical User Interface (GUI) tool that migrates the data from SQL to NoSQL databases. The relational databases have been in use and have dominated the industry for many years. In contrast, the NoSQL databases were introduced with the increased usage of the internet, social media, and cloud computing. The traditional relational databases guarantee data integrity whereas high availability and scalability are the main advantages of the NoSQL databases. This thesis presents a comparison of these two technologies. It compares the data structure and data storing techniques of the two technologies. The SQL databases store data differently as compared to the NoSQL databases due to their specific demands. The data stored in the relational databases is highly structured and normalized in most environments whereas the data in the NoSQL databases are mostly unstructured. This difference of the data structure helps in meeting the specific demands of these two systems. The NoSQL DBs are scalable with high availability due to the simpler data model but does not guarantee data consistency at all times. On the other hand the RDBMS systems are not easily scalable and available at the same time due to the complex data model but guarantees data consistency. This thesis uses CouchDB and MySQL to represent the NoSQL and standard SQL databases respectively. The aim of the iii research in this document is to suggest a methodology for data migration from the RDBMS databases to the document-based NoSQL databases. Data migration between the RDBMS and the NoSQL systems is anticipated because both systems are currently in use by many industry leaders. This thesis presents a Graphical User Interface as a starting point that enables the data migration from the RDBMS to the NoSQL databases. MySQL and CouchDB are used as the test databases for the relational and NoSQL systems respectively. This thesis presents an architecture and methodology to achieve this objective.

Stuttgart, Univ., Diplomarb., 2003.

Stuttgart, Univ., Diplomarb., 2005.

This thesis deals with the development of the program, which is used for sale of medication. The theoretical part is divided into five parts. First, there is an introduction of object-oriented programming globally as a whole. The following section concerns with Java programming language. The emphasis is put on specific features of this language and basic syntax. The chapter also includes objects and their basic principles of use. Next part specializes in SQL. and describes the basic clauses. Chapter UML is mentioned just partially. The main focus is on different perspectives of UML. In last part there is a division of companies based on legal form, including the description of each type. The basis of the practical part is to create a program code according to the assignment. Initially, a profile of the company, for which the program has been created, is introduced including the specifications and their requirements. Then the proposed solution is described. In the technical part a preparation of development environment is elaborated, which is followed by a detailed description of the functioning of the program. The end of the practical part is dedicated to a description of individual classes, in which their functionality is gradually explained. The result of the thesis is the output data written to the file. This file is used by the company to promote sales.

No description available.

Sistemos veikimo logika – mazgo pasirinkimo semantika, pasinaudojant sukurtais dokumentų standartais aprašytais XML kalba (DTD, XSD). Problema iškyla, kai kuriant dinaminių dokumentų analizės įrankius laikomasi griežtų taisyklių, tai reiškia negalima sulaužyti statinio tipo dokumento struktūros ir jo logikos. Problemos sprendimui yra panaudojama XPath technologija. Tokiu būdų yra sukuriamos statinio tipo užklausos ir išrenkamas dokumentų turinys, kuris vėliau atvaizduojamas vartotojo ekrane. Pagrindinis darbas yra sukurti įrankį, kurio pagalba galima atlikti statinę dokumento analizę. Dokumento duomenimis galima migruoti į pasirinktą reliacinę duomenų bazę ar kitą pasirinktą (PDF, XSL) dokumento formatą. Tokie įrankiai - analizatoriai leidžia sutaupyti daug laiko apdorojant, išrenkant, išsaugant ir analizuojant turimus duomenis. / Nowadays, there is a lot of information in the internet, personal computer, mobile phone and everywhere around us. How we exchange this information? There are many decisions, but the most popular exchange form is using XML document standards. What is more, it will be everything good, but people are, who wants to use them, often faced with certain problems. They are trying get this information from these documents, but they cannot read it or very hard without any special software. Some people do not trust XML documents, because they didn’t use any time of them. Where is the problem? Some people could not understand XML document methodology; others did not use special software for special XML documents. It is software for storing and migrating signed XML documents. Special tools can save us time. People can quickly access the documents and information they need. It can help people work together in ways that are most effective for them.

Lönsamheten för konsultbolag är beroende av antalet timmar konsulter arbetar vad gäller leveranser i kunduppdrag. Att timmar ej levereras på grund av sjukdom eller överbeläggning påverkar resultatet för bolaget. Konsultbolag där konsulter samma vecka arbetar mot olika kunder och uppdrag, kan ha svårt att synliggöra och följa upp leveranserna vilket kan resultera i inkomstbortfall och försenade leveranser. Hypotesen för detta examensarbete är att visualisering och uppföljning minskar risken till inkomstbortfall och försenade leveranser. Författarna har tillsammans med företaget aRway AB testat denna hypotes genom att utveckla ett verktyg för att visualisera prognos och utfall för konsulter på företaget. Rapporten beskriver processen för framtagandet av en lösning för leveransplanering, prognostisering och uppföljning för ett mindre konsultbolag. Rapporten innehåller även en teoretisk bakgrund till arbetet. Resultatet av detta arbete är en lösning som används för att visualisera och följa upp företagets leveranser, vilket har gett en ökad leveransprestation och minskat inkomstbortfall. / Profitability for a consultant company is dependent of the actual consultant hours delivered by consultants in customer projects. The company result will be affected if the consultant hours couldn’t be delivered because of illness or over-allocation. In consultant company’s where consultants work with different projects and customers it can be hard to visualize and follow-up the actual forecast. This could affect the company’s result and also delay the service delivery in projects. The hypothesis for this thesis is that visualization and follow-up of the actual result will reduce the risk for loss of income and delayed projects. The authors in corporation with aRway AB have tested this hypothesis by developing a tool that visualizes the forecast and performance for consultants working at aRway AB. This work have resulted in a report that describes the process for developing a solution that will help smaller consultant companies with delivery planning, forecasting and performance follow up. In the report is also a theoretical background included. Outcome of this work is a tool for visualizing and follow up the company’s deliveries which has given the company an enhanced service delivery and increased result.