Peter Pavkovič (2011) Comparison of time complexity of SQL querries by IBM DB2 database on z/OS operating system. EngD thesis.
Abstract
For my thesis I used special information system to show means of elapse time to selected data and the importance of hardware and software on data growth. Today information system is the core of every company. In my work I used information system that is based on IBM hardware and software. It is important to know that a reliable and quick operation system is most important for achieving successful results of the company In my thesis I have presented the architecture of the operation system, the use of products by the means and by the quantity of used data. I have learned about tools and technologies used in my work. I have used professional hardware and software equipment from IBM for the measurements made in my thesis as well as programming language C and Java I have know during the time of my study. Information system I have used is based on IBM Mainframe Z-series system and on database DB2. Considering these are technologies that are now very well known I have described the use and development of each specific technology. In my measurements and comparisons I have used information system with great performances. The type of programming language used for developing applications has a great influence on the speed of implementation of the application. For the development of the desktop application I have used programming language Java and SQL. I have optimized the speed of implementing SQL query in programming language Java with stored procedures and by using SQLJ technology. In the database of my work I have stored following information: • integer • varchar • BLOB (binary large object) • character • XML • decimal number • boolean In the end I have showed comparison of the data, graph of the used CPU time, memory usage, time used for executing SQL query by the information system used, programming language and technology.
| Item Type: | Thesis (EngD thesis) |
|---|
| Keywords: | • Auxillary table – every LOB table need own auxillary table, • BLOB – data type (Bineary large object), • Boolean – data type which store logical value, • Bufferpool – frequently sought data stored in bufferpool, • Char – data type which store character, • CPU – Central process unit, • DB2 – IBM database, • DDL – data structure, from which DB2 build database, • Float – data type which store decimal number, • IBM – international business machine, • Index – index make faster access to data, • Int – data type which store number, • JDBC – Java library for database access, • Mainframe- central computer, • MIPS – Million instruction per second, • SQL – Structured query language, • Stored procedure – data procedures which running on server, • Table space – physical location where we sotre data , • Varchar – data type which store string, • XML – Extensible Markup Language, • zAAP – Application assist processor, • ZIIP – Integrated information processor, • Z-series – mainframe system. |
|---|
| Number of Pages: | 35 |
|---|
| Language of Content: | Slovenian |
|---|
| Mentor / Comentors: | | Name and Surname | ID | Function |
|---|
| prof. dr. Saša Divjak | 233 | Mentor |
|
|---|
| Link to COBISS: | http://www.cobiss.si/scripts/cobiss?command=search&base=50070&select=(ID=00008483924) |
|---|
| Institution: | University of Ljubljana |
|---|
| Department: | Faculty of Computer and Information Science |
|---|
| Item ID: | 1442 |
|---|
| Date Deposited: | 07 Jul 2011 12:12 |
|---|
| Last Modified: | 13 Aug 2011 00:40 |
|---|
| URI: | http://eprints.fri.uni-lj.si/id/eprint/1442 |
|---|
Actions (login required)
![[img]](http://eprints.fri.uni-lj.si/style/images/fileicons/application_pdf.png)
