Den här rapporten hanterar ett uppdrag från företaget Logica gjort som ett examensarbete på utbildningen Högskoleingenjör inom Datateknik, programmet Webbutveckling/Programmering och datanät, på Tekniska Högskolan i Jönköping. Uppdraget gick ut på att kontrollera om ett system skrivet i programmeringsspråket PL/SQL går att konvertera till Java. Programmet i fråga var ett reskontrasystem. Syftet med projektet var att företaget skulle kunna konvertera deras system på ett så kostnadseffektivt och tidsbesparande sätt som möjligt. Frågor som rapporten har tagit upp är huruvida det finns konverteringsverktyg som kan göra detta och om i så fall det finns några “Best-practises” angående detta. Vi har undersökt detta genom informationssökning om olika verktyg samt om de båda språken. För att verifiera de olika verktygens funktionalitet har ett antal olika tester med konvertering utförts. De tester som har genomförts visar på att en konvertering mellan PL/SQL och Java kan fungera, men då under standardiserade former. Till denna kategori hörde dock inte Logicas applikation, som förlorade all sin funktionalitet under processen i ett av testen och genereringen av användbar kod var minimal. Vi kom fram till att i det här fallet var en konvertering ej möjlig att rättfärdiga i ett kostnadsperspektiv.

Att ha ett väl fungerande automatiskt testsystem är allt viktigare inom mjukvaruutveckling. Tyvärr är det fortfarande vanligt med företag som framförallt förlitar sig på manuell testning i olika former vilket för med sig en rad problem. Extra svårt blir det för de ovanligare programmeringsspråken, som inte har samma historia av automatisk testning som andra språk. Genom att implementera enhetstestning på liten skala på ett riktigt system i PL/SQL och mäta resultaten, kan flera slutsatser dras om enhetstestnings duglighet. Enhetstestning tar betydligt kortare tid att exekvera än motsvarande tester manuellt och kan lätt återupprepas. De kan även testa kombinationer som är omöjliga eller mycket svåra att utföra manuellt, och de minskar tiden det tar att rätta buggar. Att skriva enhetstester tar initialt mycket tid och kräver en viss kunskap. Det kan även dröja innan enhetstester börjar ge resultat och de behöver underhållas allt eftersom att koden ändras.

This work discuses complex rule systems, integrity constraints implementation issues. It describes all integrity constraints and their types. Showed their representation in UML concepts also ORACLE PL/SQL system code. Analysed realization possibilities of integrity constraints. Realized in database system and enforced testing process in this database of integrity constraits. Introduces users helpfull methodology about peration issues, possibilities and methods. Managed system of integrity constains creating templates. In some ways program generates PL/SQL code by users defined variables.

Today information is very expensive and useful. If you want to get wanted information when you need it, get information in wanted form and get information which you expected, you need an information system. The main purpose of this project is to create web-based information system of patients with heart disease, which let store, modify information about patients and their medical testing. There will be a possibility to generate reports for the period you want or for the wanted patient. The point of this information system is to store information, process necessary information faster, to facilitate and make faster personnel work. Medical testing results can be put into the database in two ways: from specific file or from interface. Other part of master‘s work is research named „SQL performance speed in Java and PL/SQL stored procedures“. PL/SQL is the procedural language extension to SQL and it encapsulates SQL statements in procedural logic. Starting with Oracle8i, Oracle supports Java in the database. Java stored procedures also can encapsulate SQL statements that run within the database via procedural logic. In this paper you can find the answer for the question, where do I have to put the SQL, Java or PL/SQL stored procedures.

Project dedicated for the united information base creation and storage of the cardiovascular reabilitation patients. Using this reabilitation it is necessary to watch the test results of the patient, analyse and systematize them. Besides collected information can be used for the later treatment of the patient. Thus having a huge storage it is hard to find record if it is on paper, in that case invoking information technology, which will ease storage of the big information quantity, quick it processing and analysis. Besides selection of that organization bussines reorganization will sharply increase workers work efficiency. Nowadays test equipment deliver results which a specialist have to transform into understandable form that these results could be used for analysis about patient health status.

This work deals with consume of webservice provided by Information system of Dormitories and Refectories at BUT, through BUT's Central database environment. Thesis discuses some Java frameworks used to consume webservices. It also discuses design and implementation of micropayements billing interface based on chosen framework with respect to maxiumum security.

This thesis deals with the domain indexes in Oracle Database 11g. It describes the database architecture and discusses the available methods of indexing. There are explained concrete ways of the implementation and use of domain indexes, also discussed ways of indexing spatio-temporal data especially the TB-tree structure, which is then implemented as a domain index. Along with the domain index operators are also implemented by means of which the index is subsequently used and tested.

This work treats the representation of moving objects and operations over these objects. Intro­duces the support for spatio-temporal data in Oracle Database 10g and presents two designs of moving objects database structure. Upon these designs a database was implemented using the user-defined data types. Sample application provides a graphical output of stored spatial data and allows us to call an implemented spatio-temporal operations. Finally, an evaluation of achieved results is done and possible extensions of project are discussed.

This project is concerned with problems of knowledge discovery in databases, in the concrete then is concerned with an association rules, which are part of the system of data mining. By that way we try to get knowledge which we can´t find directly in the database and which can be useful. There is the description of SQL/MM DM, especially then all user-defined types given by standard for association rules as well as common types which create framework for data mining. Before the description of implementation these types, there is mentioned the instruments which are used for that - programming language PL/SQL and Oracle Data Mining support. The accuracy of implementation is verified by a sample application. In the conclusion, achieved results are evaluated and possible continuation of this work is mentioned.