current dbms based activities at ncst, juhu sandhya desai national centre for software technology...
Post on 28-Dec-2015
230 Views
Preview:
TRANSCRIPT
Current DBMS Based Activities at NCST, Juhu
Sandhya DesaiNational Centre for Software Technology
Juhu, Mumbai
sandhya@saathi.ncst.ernet.in
© 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
sandhya@saathi.ncst.ernet.in
© 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
sandhya@saathi.ncst.ernet.in
© 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
sandhya@saathi.ncst.ernet.in
© National Centre for Software Technology
DBMS WorkShop
Research Interests
Data Warehousing System Architecture Internet and databases Workflow systems
sandhya@saathi.ncst.ernet.in
© 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
sandhya@saathi.ncst.ernet.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
sandhya@saathi.ncst.ernet.in
© 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
sandhya@saathi.ncst.ernet.in
© 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
sandhya@saathi.ncst.ernet.in
© National Centre for Software Technology
DBMS WorkShop
Mumbai University project
SRS document proposed duration one year team of 6 members
sandhya@saathi.ncst.ernet.in
© 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
sandhya@saathi.ncst.ernet.in
© National Centre for Software Technology
DBMS WorkShop
Customer Profile
Distributed No centralized authority Not very demanding Not too committed to project Overloaded with operations
sandhya@saathi.ncst.ernet.in
© National Centre for Software Technology
DBMS WorkShop
System Configuration
SQLserver Powerbuilder for client software Power Designer Windows NT server
sandhya@saathi.ncst.ernet.in
© 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
sandhya@saathi.ncst.ernet.in
© 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
sandhya@saathi.ncst.ernet.in
© National Centre for Software Technology
DBMS WorkShop
At Cross Roads
Software engineering Quality Assurance Project management
sandhya@saathi.ncst.ernet.in
© 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
sandhya@saathi.ncst.ernet.in
© 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
sandhya@saathi.ncst.ernet.in
© 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
sandhya@saathi.ncst.ernet.in
© 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
sandhya@saathi.ncst.ernet.in
© 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
top related