New Mexico's Evolving Water RIGHTS Information System

indexadjustmentInternet and Web Development

Nov 13, 2013 (3 years and 10 months ago)

80 views

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 )