WINTER SCHOOL ON IBM - DB2

Dronacharya College of Engineering, Gurgaon organized a Winter School on the “IBM DB2” from 14th to 18th, January 2016. IBM - DB2 winter school program is organized with aim to help student learn about Data Base Administration and System Administration. Winter school prepare the students for the further competitive and skill enhancing tests and exams in field of system and Data Base administration. This winter school program was attended by the students of CSE / IT/ ECS department.

Winter School Program :

Winter School program on DB2 was conducted by Assistant Prof. Sarita (CSE,Dept), who explained the basics of relational database management system (RDBMS) products from IBM that serve a number of different operating system platforms & it leads in terms of database market share and performance.

She laid emphasis on knowledge of DB2 products ( z/OS vs LUW vs Pure scale ). z / OS is a 64 - bit operating system for IBM mainframes, produced by IBM. It derives from and is the successor to OS/390, which in turn followed a string of MVS versions. LUW (Linux / Unix / Windows) in DB2, is a database server product developed by IBM. Sometimes called DB2 LUW for brevity, it is part of the DB2 family of database products. DB2 pureScale is a tightly integrated database clustering solution using IBM DB2 for Linux, UNIX and Windows.

She further discussed Data Base workloads & DB2 product to use (OLTP vs Warehousing). OLTP (Online Transaction Processing) database is used for day - to - day business operations which refers to a class of systems that facilitate and manage transaction-oriented applications, typically for data entry and retrieval transaction processing. On the other hand, a data warehousing is a repository (collection of resources that can be accessed to retrieve information) of an organization's electronically stored data, designed to facilitate reporting and analysis.

Ms. Sarita further explained about non –relational data concept (XML data, LOB data). Extensible Markup Language (XML) is used to describe data, XML standard is a flexible way to create information formats and electronically share structured data via the public Internet, as well as via corporate networks. On the other hand LOB(Large Object Byte) is used to store large amount of data that is they can store large blocks of unstructured data such as graphics, image, video clips etc.

Database Associate Certification DB2 10.1

The Database Associate Certification is an entry level exam for user of DB2 family of products. The individual is knowledgeable about the fundamental concepts of DB2 10.1 through either hands on experience or formal and informal education. The database associate should have an in-depth knowledge of the basic to intermediate tasks required in day - to - day administration, basic SQL (Structured Query Language), understand which additional products are available with DB2 10.1, understand how to create databases and database objects, and have a basic knowledge of database security and transaction isolation.

The winter school program on DB2 was highly informative and interactive as students got chance to clear their doubts. This program further helped to inculcate basic knowledge regarding IBM - DB2 and its uses in real life.