Comparison of time complexity of SQL querries by IBM DB2 database on z/OS operating system

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