New Mexico's Evolving Water RIGHTS Information System

New Mexico’s Evolving

Water Rights Information System

Information Technology Systems Bureau New Mexico Office of the State Engineer

( ITSB NMOSE )

OSE: IT 1993




Paper Records (90+ years)



Limited Technology



No Enterprise Vision



No Project Coordination



No Integration



No Basic IT Services



No IT Funding



Two IT Employees

1993

Paper

OSE: IT 1993




Paper Records (90+ years)



Limited Technology



No Enterprise Vision



No Project Coordination



No Integration



No Basic IT Services



No IT Funding



Two IT Employees

1993

Paper


Core Development Tools



None

(APPLICATIONS)

OSE: IT 1993




Paper Records (90+ years)



Limited Technology



No Enterprise Vision



No Project Coordination



No Integration



No Basic IT Services



No IT Funding



Two IT Employees

1993

Mainframe


Network, Server, Desktop



Novell (one file &print server)



3270 Terminals

(INFRASTRUCTURE)

WATERS

(4GL & telnet)

1993

WRATS

Paper

1997

Imaging





Database



4GL Client/Server Apps


(telnet sessions)



IT Services



IT Funding



Project Coordination



Enterprise Vision



Integration



Seven

IT Employees

OSE: IT 1997


Core Development Tools



IBM Informix 4GL & C



MS Access



MS Visual Basic

(APPLICATIONS)

ETHERNET

1993

INFORMIX

1997

HP Server





Database



4GL Client/Server Apps


(telnet sessions)



IT Services



IT Funding



Project Coordination



Enterprise Vision



Integration



Seven

IT Employees

OSE: IT 1997


Network, Server, Desktop



Novell/Ethernet CAT 3/5
-
10BaseT



3270 Terminals



OpenMail (email)



Netscape Enterprise Server (Web)



HP 9000
-
H70/HP
-
UX 9



IBM Informix RDBMS 7.13



Desktop PCs (Windows 3.1/95)

Windows 95

Mainframe

(INFRASTRUCTURE)

1993

WRATS

Paper

iWATERS I

(javascript)

Imaging

2001

WATERS

(4GL & telnet)

1997

OSE: IT 2001





Database



4GL Client/Server Apps


(telnet sessions)



IT Services



IT Funding



Enterprise Vision (first web app)



Project Coordination



Limited Integration



Nine

IT Employees


Core Development Tools



IBM Informix 4GL & C



MS Access



NetConnect (server
-
side javascript)



BEA Webgain Studio



Merant PVCS



MS Visual Basic

(APPLICATIONS)

OSE: IT 2001





Database



4GL Client/Server Apps


(telnet sessions)



IT Services



IT Funding



Enterprise Vision (first web app)



Project Coordination



Limited Integration



Nine

IT Employees


Network, Server, Desktop



Ethernet (
CAT 5
-
100BaseT
)



OpenMail (email)



Netscape Enterprise Server (Web)



Apache Web Server



HP 9000
-
L2000
/HP
-
UX
10



IBM Informix RDBMS
9.21



Desktop PCs

(Windows NT)



Servers
(Windows NT)


ETHERNET

1993

INFORMIX

1997

HP Server

Windows 95

Mainframe

Windows NT

2001

Server Upgrades

Network Upgrades

(INFRASTRUCTURE)




Database



n
-
tier Web Apps



IT Services



IT Funding



Enterprise Capability (eGIS & eWATERS)



Project Coordination



Integration



Open Source Tools



Sixteen

IT Employees

eGIS

1993

WRATS

Paper

2003

iWATERS I

(javascript)

Imaging

2001

Litigation Support

iWATERS II

(MVC)

eWATERS

(J2EE)

WATERS

(4GL & telnet)

1997

OSE: IT 2003


Core Development Tools



IBM Informix 4GL



MS Access



NetConnect
Java Servlets (MVC)



J2EE (EJBs/Servlets/JDBC/Applet)




BEA Webgain Studio
Eclipse IDE



Merant PVCS

Subversion



MS Visual Basic

(APPLICATIONS)

OSE: IT 2003


Network, Server, Desktop



Ethernet (CAT 5 &
1GB Fiber
)



OpenMail (email)



Apache Web Server



DNS & Firewall



HP 9000
-
L2000 HP
-
UX 10



Informix RDBMS
9.3



PCs
(Windows 2000 Pro)



Servers

(Windows 2000 Adv Server)

ETHERNET

1993

INFORMIX

1997

HP Server

Windows 95

Mainframe

Windows NT

2001

Server Upgrades

Network Upgrades

Windows 2000

2003

More Upgrades

(INFRASTRUCTURE)




Database



n
-
tier Web Apps



IT Services



IT Funding



Enterprise Capability (eGIS & eWATERS)



Project Coordination



Integration



Open Source Tools



Sixteen

IT Employees




Database



n
-
tier Web Apps



IT Services



IT Funding



Enterprise Capability



Project Coordination



Integration



Open Source Tools



Sixteen IT Employees

eGIS

1993

WRATS

Paper

iWATERS I

(javascript)

Imaging

2001

Litigation Support

iWATERS II

(MVC)

eWATERS

(J2EE)

WATERS

(4GL & telnet)

1997


Core Development Tools



IBM Informix 4GL



MS Access



Java Servlets (MVC)



J2EE (EJBs/Servlets/JDBC/Applet)



Eclipse IDE w/

MyEclipse plug
-
ins



Subversion w/
Apache+mod_dav_svn



MS Visual Basic

OSE: IT 2006

2003

2006

(APPLICATIONS)




Database



n
-
tier Web Apps



IT Services



IT Funding



Enterprise Capability



Project Coordination



Integration



Open Source Tools



Sixteen IT Employees


Network, Server, Desktop



Ethernet (Cat 5 & 1GB Fiber)



Enterprise email (MS Exchange)



Radio & MPLS Link to GSD
-
IT



DNS, Firewall,
FTP Server



HP 9000
-
RP4440
/HP
-
UX
11i



Informix RDBMS
9.4



PCs (Windows 2000 Pro/
XP
)



Servers (Windows 2000/
2003 Server
)

OSE: IT 2006

ETHERNET

1993

INFORMIX

1997

HP Server

Windows 95

Mainframe

Windows NT

2001

Server Upgrades

Network Upgrades

Windows 2000

2003

More Upgrades

2006

DNS & Firewall

(INFRASTRUCTURE)




Database



n
-
tier Web Apps



IT Services



IT Funding



Enterprise Capability



Project Coordination



Integration



Open Source Tools



Sixteen IT Employees

eGIS

1993

WRATS

Paper

iWATERS I

(javascript)

Imaging

2001

Litigation Support

iWATERS II

(MVC)

eWATERS

(Java EE)

WATERS

(4GL & telnet)

1997


Core Development Tools



Informix 4GL
Java



MS Access



Java Servlets (MVC)



J2EE (EJBs/Servlets/JDBC/Applet)



Java EE, EJB 3, Web Services, SOA




Eclipse IDE + MyEclipse
Pro

plug
-
ins



Subversion w/ Apache+mod_dav_svn



Visual Basic
Java

OSE: IT Future

2003

2006

Future

(APPLICATIONS)

(NEAR)

OSE: IT

Future

1993

INFORMIX

HP Server

Mainframe

Windows NT

2001

Server Upgrades

Network Upgrades

Windows 2000

2003

More Upgrades

2006

DNS & Firewall

Future




Database



n
-
tier Web Apps



IT Services



IT Funding



Enterprise Capability



Project Coordination



Integration



Open Source Tools



Sixteen IT Employees

ETHERNET

1997

Windows 95


Network, Server, Desktop



Ethernet (Cat 5 & 1GB Fiber)



Enterprise email (MS Exchange)



Radio & MPLS Link to GSD
-
IT



DNS, Firewall, FTP Server



HP 9000
-
RP4440/HP
-
UX
12



Informix RDBMS
10



PCs (Windows XP/
Vista
)



Servers (
Windows 2003 Server

+ AD
)

(INFRASTRUCTURE)

(NEAR)

OPEN SOURCE & ITSB

(A PRAGMATIC APPROACH)

Information Technology Systems Bureau New Mexico Office of the State Engineer

( ITSB NMOSE )

OPEN SOURCE & ITSB

(A PRAGMATIC APPROACH)

THE 3 Ps
:


1.
Priorities

Does an open source solution address priorities?


2.
Possibilities

What open source solutions are available?


3.
Practicalities

Which open source solutions are practical?



OPEN SOURCE & ITSB

(A PRAGMATIC APPROACH)

THE 6 Ps:


P
roper
P
lanning
P
revents
P
iss
P
oor
P
erformance


ALIGNING IT PRIORITIES TO OPPORTUNITIES

ITSB Priorities
:

1.
Maximize Productivity

(rabidly avoiding technology churn & thrash)


2.
Minimize Risk

(carefully choosing & targeting technologies)


Jan 9, 2006: Peter Quinn
-

CIO who brought

OpenOffice to Massachusetts resigns


3.
Save Money

(leveraging open source solutions)


4.
Save Time

(empowering resources)


ITSB Opportunities
:

1.
Business Needs Focus

(as opposed to technology desires focus)


2.
Robust Toolkits

(as opposed to flakey OTS behemoths)


3.
Minimal Cost

(as opposed to expensive per
-
seat licensing)


4.
Automation

(as opposed to error
-
prone manual drudgery)

LOW
-
RISK OPEN SOURCE OPTIONS

PHASE I
–

Software Development Life Cycle
:


1.
Requirements & Issue Management

•
Bugzilla

•
Tracker

•
>Track+


2.
Test Automation

•
>junit

•
>jwebunit

•
>httpunit

•
>cactus

•
>FIT


3.
Team Training & Collaboration

•
>Website (Eclipse/XM)

•
>JSPWiki


Opportunities Realized
:


More Focused on Business Needs • More Robust Toolkits • Continued


Minimal Cost • Automated Testing • Improved Communication


MEDIUM
-
RISK OPEN SOURCE OPTIONS

PHASE II
–

Development Environment
:


1.
Software Change Management

•
CVS

•
RCS

•
>Subversion & Apache + mod_dav_svn


2.
Automated Build Management

•
Shell Script

•
Make

•
>ANT


3.
Integrated Development Environment

•
>Eclipse Platform & Plug
-
ins

•
^ NetBeans & Plug
-
ins


Opportunities Realized
:

Robust Toolkits • Minimal Cost • Automated Builds & Deployments

• SDLC

Optimized

HIGH
-
RISK OPEN SOURCE OPTIONS

PHASE III
–

Runtime Environment
:


1.
Web Application Server

•
>Apache Tomcat

•
?
Jboss AS





2.
Operating System

•
?
LINUX

•
?
Open Solaris

Possible Opportunities
:

M i n i m a l C o s t

MyEclipse

plug
-
ins

XM

plug
-
in

SubClipse

plug
-
in

FIT

plug
-
in

Subversion Repository


(Berkley DB/FSFS)


changes

(http
-
WebDav)

Tortoise

Project Workspace

Track+ Repository

(firebird)

Track+

Web App

files & folders

dev

ops

issues

(http)

USER

ANALYST

DEVELOPER

MANAGER

changes

(Windows Explorer)

dev

work

eWATERS

Web App

JUNIT

test,

run,

debug

Weblogic Server 9.x

(JRockit 1.4.x)

deploy & debug

ECLIPSE

APP SERVER

WINDOWS 2000/2003 Server

WINDOWS 2000 PRO SP4 or WINDOWS XP PRO SP2

WATERS Filesystem

HP/UX

data & sp

text &

ksh

NMOSE/ITSB



Dev Tools &

Dev Environment



Relationship

WINDOWS 2000 Adv Server SP4

JBoss 3.x

Apache 2.x

DEV SERVER

DEV WORKSTATION

DATA/LEGACY SERVER

FIT

JWebUnit

http

http

FIT test, run, debug

tables & fixtures

WRATS Database

(SQL Server)

WATERS/FEITH Database

(informix)

(
WIN2K
)

LEGAL

SERVER

data

(view)

OSE/ISC

Web Site

HTML

Maximizing Productivity
–

Leveraging IDE for Agile Development


CONSTRUCTION & BUILDING

Maximizing Productivity
–

Leveraging IDE for Agile Development


DEPLOYMENT

Maximizing Productivity
–

Leveraging IDE for Agile Development


APPLICATION SERVER

MANAGEMENT

Maximizing Productivity
–

Leveraging IDE for Agile Development


UNIT TESTING (JUNIT)

Maximizing Productivity
–

Leveraging IDE for Agile Development

INTEGRATION TESTING (FIT plug
-
in)

Maximizing Productivity
–

Leveraging IDE for Agile Development


SERVER
-
SIDE DEBUGGING

Maximizing Productivity
–

Leveraging IDE for Agile Development


CLIENT
-
SIDE DEBUGGING

SUCCESSFUL USE OF OPEN SOURCE

Priorities Satisfied
:

1.
Productivity Maximized

(automating build, deploy, and test cycles of SDLC)


2.
Risk Minimized

(using process
-
proven, robust open source tools)


September, 2006: Joe Summars
-

Manager who brought

open source to ITSB/NMOSE still on the job



3.
Money Saved

(zero
-
cost licensing)


4.
Time Saved

(through optimized SDLC)


Opportunities Realized
:

1.
Focus on Business Needs

(using tools that fit SDLC)


2.
Toolkits are Robust

(not struggling with tools)


3.
Cost is Minimal

(zero
-
cost licensing)


4.
Automation

(build, deploy, and test automated)

EVOLVING NMOSE/ITSB PEOPLE

IT APPLICATIONS DEVELOPMENT

IT SUPPORT

Nancy Knouse

GIT

Gar Clark

Stephen Hayes

Lisa

Barela

John

Buchser

Jon

Lemasters

Chris

Lopez

Rodney

McKnight

Tarmo

Sutt

Joe

Summars

Mercedes

Ortega

Michael

Mackenzie

Jina

Lindsay

Diana

Hardy

Daniel

Harris

DIVISION

CHIEF

Brent

Pearce

vacant

Contractor: Thirumaleswara Thiruveedula

Contact Information

Information Technology Systems Bureau New Mexico Office of the State Engineer

( ITSB NMOSE )

Joe Summars

Applications Development Group


Information Technology Systems Bureau

New Mexico Office of the State Engineer

407 Galisteo Street

Bataan Memorial Bldg., Ste. 130

Santa Fe, NM 87501


(505) 827
-
3833

joe.summars@state.nm.us

http://www.ose.state.nm.us



Open Source Resources

Information Technology Systems Bureau New Mexico Office of the State Engineer

( ITSB NMOSE )

Track+:

Ant:

Eclipse:

MyEclipse:

Subversion:

Subclipse:

Tortoise SVN:

junit:

FIT:

Httpunit:

jwebunit:

Cactus:

XM:

JBoss:

JSPWiki:

http://www.trackplus.de/

http://ant.apache.org/

http://eclipse.org/

http://www.myeclipseide.com/

http://subversion.tigris.org/

http://subclipse.tigris.org/

http://tortoisesvn.tigris.org/

http://www.junit.org/index.htm/

http://fit.c2.com/

http://httpunit.sourceforge.net/

http://jwebunit.sourceforge.net/

http://www.ananas.org/xm/

http://jakarta.apache.org/cactus/

http://labs.jboss.com/portal/

http://jspwiki.org/

Questions?

Information Technology Systems Bureau New Mexico Office of the State Engineer

( ITSB NMOSE )