120 likes | 287 Views
Purdue University CS 406 - Senior Project. David Wentland Senior Software Engineer. Who Is Tivoli? . A division of IBM’s Software Group
E N D
Purdue UniversityCS 406 - Senior Project David Wentland Senior Software Engineer
Who Is Tivoli? • A division of IBM’s Software Group • Tivoli’s mission is to be the driving force in the changing role of technology by providing management solutions that allow its customers to unlock the power of technology • Since 1989, Tivoli has become the world’s largest provider of systems management software. Our goal is to reach $25 billion in sales in 2005. Sales today total about $2.5 billion • Tivoli has approximately 5,000 employees worldwide
What Does Tivoli Do? • Tivoli provides the industry’s leading open, highly scalable, and cross-platformIT management solutions that span networks, systems, applications, and business-to-business commerce, security management, storage management, pervasive management, Internet business solutions and service provider solutions
Where is Tivoli Located? A Global Technology Management Company Europe North America Tivoli WHQ Latin America Asia Pacific Development &Support Center Sales/Marketing Office
Who Are Some of Tivoli’s Customers? 96% of the top Fortune 100 companies are Tivoli Customers!
TIVOLI SERVICE DESK ARCHITECHTURE CLIENT RDBMS DB/2, DB/2 MAINFRAME, ORACLE, SQL SERVER, INFORMIX, OR SYBASE SERVER DATABASE Senior Project - Explanation • TSD (Tivoli Service Desk) supports the use of 6 database platforms. Each of these platforms require a different set of scripts to build the database • This project would generate platform specific scripts based on a single document
Senior Project - Technical Exposure • OOAD/OOP • Database structure and design • Various RDBMS platforms • Java • XML (if chosen to describe the database schema) • SQL • UML (Unified Modeling Language)
Senior Project - Tools • Tivoli Database Build Utility (TDAC) • SQL Tools for various database platforms • Java Development Kit 1.2.x (Java 2) • Java Integrated Development Environments • CMVC version control system • Rational Rose
Senior Project - Issues/Challenges • Analyzing the subtle differences in all supported RDBMS platforms • A determination would have to be made in the requirements phase as to which scripts would be addressed • Create Tables • Drop Tables • Create Views • Drop Views • Create Triggers • Create Indexes
XML XML TEMPLATE JAVA PARSER DATABASE SCRIPTS: DB/2,DB/2 MAINFRAME, ORACLE, SQL SERVER, INFORMIX, SYBASE TDAC RDBMS Senior Project - Potential Direction • Define the database schema in XML • Create a Java utility to parse the XML and then generate the appropriate platform-specific database scripts
Senior Project - Student Benefits • Database design • Enterprise scale product • Real world development life cycle process • Tools required to do large scale collaborative development
Senior Project - Tivoli Benefits • Eliminate a significant source of development and testing effort that recurs for each release of the product • Defects introduced by redundant platform specific script changes would be significantly reduced