current dbms based activities at ncst, juhu sandhya desai national centre for software technology...
TRANSCRIPT
Current DBMS Based Activities at NCST, Juhu
Sandhya DesaiNational Centre for Software Technology
Juhu, Mumbai
© National Centre for Software Technology
DBMS WorkShop
Objective
Introduce the nature of activities at the centre
Share our experience in developing applications
Get new ideas and better solutions Possibilities for future Collaborations
© National Centre for Software Technology
DBMS WorkShop
Present group members at NCST, Juhu
Urjaswala Vora Gauri Rendalkar Lakshana Pant Amarish Choubal Vishal Mehrotra Satish Rane Sudhin Deshpande Sandhya Desai
Salim Sayyed Amit Vaidya
© National Centre for Software Technology
DBMS WorkShop
Projects Under progress
Computerization of Mumbai University Exam centre.
MTNL Directory Service. TIFR Payroll. Supporting NCST office functions. Advanced PGDST DBMS module Database design review for TEC
© National Centre for Software Technology
DBMS WorkShop
Research Interests
Data Warehousing System Architecture Internet and databases Workflow systems
© National Centre for Software Technology
DBMS WorkShop
MTNL- Web dictionary Service
Started as prototype for Mumbai node Dictionary services Delivered operational system at Both Delhi and Mumbai URL: mumbaihelp1.mtnl.net.in URL: delhihelp1.mtnl.net.in
© National Centre for Software Technology
DBMS WorkShop
System Configuration
Oracle 8 on Unix server Java application server on Windows NT Web browsers on clients
© National Centre for Software Technology
DBMS WorkShop
Application Server
Coded in Java Manages pool of connections to Oracle Uses threads to serve each request parses client requests and formulates
equivalent SQL query Formats result set creating dynamic HTML
pages
© National Centre for Software Technology
DBMS WorkShop
Issues
Performance security Usage log 50hits/min, 20,000 hits on first day extensions to the dictionary service
© National Centre for Software Technology
DBMS WorkShop
Mumbai University project
SRS document proposed duration one year team of 6 members
© National Centre for Software Technology
DBMS WorkShop
System Profile
Complex requirements of exam centre around 1,50,000 students every year around 600 exams with time varying structure,
revised exams around 15,000 examiners around 10,000 papers and, revised papers around 150 colleges around 150 degrees, diplomas, certificates
© National Centre for Software Technology
DBMS WorkShop
Customer Profile
Distributed No centralized authority Not very demanding Not too committed to project Overloaded with operations
© National Centre for Software Technology
DBMS WorkShop
System Configuration
SQLserver Powerbuilder for client software Power Designer Windows NT server
© National Centre for Software Technology
DBMS WorkShop
Design Issues
Analysis of exam patterns Complexities in exam schemas Difficult to get complete domain knowledge Work flow understanding Tracking the actions Reengineering
© National Centre for Software Technology
DBMS WorkShop
What we learnt?
Trivial things are not at all trivial– report formats– identifiers– data entry forms and formats– collation of data – verifying the data– checking consistency of data
© National Centre for Software Technology
DBMS WorkShop
At Cross Roads
Software engineering Quality Assurance Project management
© National Centre for Software Technology
DBMS WorkShop
Retrospection
Transaction processing and performance Selection of Software selection of hardware platforms and
networking Bottlenecks in the system
© National Centre for Software Technology
DBMS WorkShop
Success of the System
User involvement User feedback User training Constant support after implementation Extensions to the system
© National Centre for Software Technology
DBMS WorkShop
What is lacking?
Documentation Vigorous testing and inspection Process engineering Serious analysis of applications and
improvement in the data design Online help feature Security issues
© National Centre for Software Technology
DBMS WorkShop
Summary
Limitations of NCST kind of organization in handling and maintaining application software
Project management- one time vs often done activity
Process engineering team spirit
© National Centre for Software Technology
DBMS WorkShop
Client infrastructure
Proper support– staff– resources– work culture
Able to make the system operational Staff should bale to cope up with new
technology Long term planning
© National Centre for Software Technology
DBMS WorkShop
Issues.
Web for accessing the application 3 layer architecture Security with Web technology performance after fully operational Component technology