Transcript tivoli-talk - Purdue University

Purdue University
CS 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-platform IT management solutions
that span networks, systems, applications, and businessto-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
Asia Pacific
Latin America
Development &
Support Center
Sales/Marketing
Office
Who Are Some of Tivoli’s Customers?
96% of the top Fortune 100 companies are Tivoli Customers!
Senior Project - Explanation
TIVOLI SERVICE DESK ARCHITECHTURE
• 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
CLIENT
RDBMS
DB/2,
DB/2 MAINFRAME,
ORACLE,
SQL SERVER,
INFORMIX,
OR SYBASE
SERVER
DATABASE
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
Senior Project - Potential Direction
XML
• Define the database
schema in XML
• Create a Java utility to
parse the XML and then
generate the appropriate
platform-specific
database scripts
XML TEMPLATE
JAVA PARSER
DATABASE SCRIPTS:
DB/2,DB/2 MAINFRAME, ORACLE,
SQL SERVER, INFORMIX, SYBASE
TDAC
RDBMS
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