ARIZONA CRIMINAL JUSTICE INTEGRATION PROJECT Request for Information by myr60070

VIEWS: 12 PAGES: 22

									ARIZONA CRIMINAL JUSTICE INTEGRATION P ROJECT

           Request for Information

             FEBRUARY 23, 2000




             2425 East Camelback Road
                     SUITE 950
              PHOENIX, ARIZONA 85016
                   602-381-2585

           ACCOUNT EXECUTIVE: ALICE S AFFORD
             ALICE.SAFFORD@INFORMIX.COM
                                                                    Table of Contents


I.      EXECUTIVE SUMMARY................................................................................................................................................1

II.     PROPOSED INTEGRATION ARCHITECTURE....................................................................................................3

        ARCHITECTURE DESCRIPTION...............................................................................................................................4

III. PROPOSED PILOT ARCHITECTURE.......................................................................................................................7

        PILOT ARCHITECTURE DESCRIPTION................................................................................................................8

IV. PRODUCT OVERVIEW...................................................................................................................................................9
        DATABASE SERVERS .............................................................................................................................................................. 9
          Informix Internet Foundation.2000............................................................................................................................... 9
          Informix Extended Parallel Server................................................................................................................................ 9
          Informix Red Brick Decision Server.......................................................................................................................... 10
        TOOLS..................................................................................................................................................................................... 10
             Informix DataStage........................................................................................................................................................ 10
             Informix Visionary ........................................................................................................................................................ 10
             Informix MetaCube ....................................................................................................................................................... 10
          Informix i.Sell................................................................................................................................................................. 11
        COMMERCE QUEST ENABLENET SOLUTION OVERVIEW ................................................................................................. 11
        COMMERCE QUEST E -A DAPTER™ SUITE DETAILED DESCRIPTION .............................................................................. 12
        MQSERIES® DETAILED DESCRIPTION ............................................................................................................................. 13

V.      KEY TOPICS......................................................................................................................................................................15

VI.     VENDOR INFORMATION............................................................................................................................................20
                                                                      Arizona Criminal Justice Integration Project RFI




I. Executive Summary
Informix has developed a uniquely flexible and cost-effective solution for the challenges faced by Arizona in
integrating the various existing and future criminal justice systems. This solution leverages existing Informix-based
criminal justice systems with the power of secure, message-oriented middleware operating via the Internet using
standards such as XML.
The proposed Informix architecture places messaging software at each source system. As data is entered into the
source system it is converted to an XML format, placed into a message object, and sent via the Internet to
CommerceQuest’s enableNet system. enableNet then applies appropriate transformations and rules on the data
before forwarding it along to target systems, including other agencies and data repositories.

Information Access
Under this architecture, data would be delivered to other criminal justice agencies and to data repositories at both a
regional and state level. Justice agencies at the receiving end would specify what data they want and what format the
data should be in. Data repositories would receive the data in a load-ready format so that the data can be loaded in an
efficient, automated manner.
Users wishing to see integrated data at either a regional or state level would normally use the appropriate data
repository, although the repositories can be configured to appear as a single, monolithic data source if desired.
Several different types of user access to the repositories can be accommodated; Informix believes that most access
will be done via intranet or internet.
Several different classes of users are explicitly supported with this solution, although there is certainly no limit on
the number or types of users that can be accommodated. Business analysts who need a completely unstructured view
of the data can use the Informix MetaCube relational online analytical processing tool (ROLAP) for sophisticated
statistical analysis. Higher-level executives who need a more structured, visual representation of data can use the
Informix Visionary tool, which is designed for rapid development of highly visual applications. Standard reports can
be run either through MetaCube or any ODBC-compliant tool such as Crystal Reports. Most other users can easily
be accommodated through the Informix i.Sell e-commerce package, which is used for development of web
applications.

Data Repository
The data repositories will be flexible and extensible to accommodate different classes of users and applications.
They will also be extremely scalable to meet higher demands and data rates as the integration project grows and
becomes more complete. The architecture proposed by Informix has two classes of data repositories – data
warehouses and data marts. It is important to note that the data processing needs of warehouses and marts are
significantly different from the needs of on online transaction processing system (OLTP). In fact, warehouses also
have different processing needs than marts. Informix offers three different classes of database servers targeted
specifically at the differing processing requirements of OLTP systems, data warehouses, and data marts.
Under the proposed Informix solution all repositories have the ability to share data transparently using Informix’s
distributed data technology. With this technology, different repositories can transparently share data. The
information access tools described above can also access any repository directly (or multiple repositories
simultaneously), provided network access is in place. Types of repositories proposed include:
•      Regional repository – The regional repository is a local repository that resides at the county or city level. This
       repository would meet local data needs and requirements, and be under local control. Regional repositories can
       be networked with other repositories to act as part of a unified, transparent network of databases.
•      Special-interest repository – The special interest repository is a repository for a particular group of users of
       subject area. A good example is the JUSTIS warehouse, which houses data from the courts system. Another
       example might be a fingerprint repository for fingerprint matching, or a geospatial repository for geospatial
       analysis of judicial data relating to gang activity.




- 1-                                                                                                   Informix Software, Inc.
                                                                     Arizona Criminal Justice Integration Project RFI


•      Statewide repository – The statewide repository is a repository of data from all agencies involved in the
       integration project. It would provide a single, unified view of all data collected statewide.
•      Data marts – Data marts are actually subject-specific repositories which receive data from a data warehouse (the
       regional, special-interest, and statewide repositories are data warehouses). Data marts are used for high-
       performance access and analysis of a particular subject area (e.g. case, charge, orders of protection).

Network and Messaging Infrastructure
CommerceQuest’s enableNet is a business-to-business messaging infrastructure service, providing assured end-to-
end information transformation, delivery and integration. enableNet for business-to-business or agency-to-agency
internet application integration (IAI), and e-Adapter™ and IBM MQSeries® for enterprise application integration
(EAI), provides an end-to-end solution and a single technology infrastructure for integrating the entire justice
community.
enableNet provides assured delivery once and only once, security and encryption, any-to-any data transformation,
process and workflow controls, application integration, scalability and performance, and end-to-end status reporting
while minimizing the impact to existing legacy and operational systems. The enableNet infrastructure supports all
major transmission methods including push or pull, event-driven, publish and subscribe, and request-reply
transmission methods.
enableNet is effectively an outsourcing service for management of all rules, message routing, and data
transformation. By outsourcing this component, the state avoids many technical, political, and budgetary issues
which would otherwise need to be addressed.

Key Elements of enableNet Include:
•      Complete, outsourced business-to-business (B2B) messaging infrastructure
•      Assured delivery messaging middleware platform (MQSeries®)
•      Complete any-to-any data transformation services
•      Comprehensive security infrastructure

enableNet Delivers:
•      Integrated business information across state and local justice agencies within a hub and spoke architecture
•      24x7x52 dependable operation, with massive scalability
•      Assured information delivery, exactly once
•      Single-point management status of business information
•      End-to-end reliability, integrity and security
•      Major transmission methods including push or pull, event-driven, publish and subscribe, and request-reply
       transmission methods

Why Consider Outsourcing?
The any-to-any managed messaging infrastructure service solution permits state and local justice agencies to
effectively use their time, money, and resources by alleviating the burdened of funding and managing IT
departments and support personnel and further eliminate the requirement for significant software and hardware
purchases and investments. In general, a managed outsourced solution provides:
•      Rapid Deployment
•      Ease of Implementation
•      Minimal Personnel Resources
•      Very Low Cost of Ownership
•      Very High Quality of Service
•      Centralized Management



- 2-                                                                                                 Informix Software, Inc.
                                                                                 Arizona Criminal Justice Integration Project RFI




II. Proposed Integration Architecture

                                                                                                   Informix


                                                                                                                             Informix
                                                                                                                             Subject-specific
                                                                                                                             Data Marts

                                                                                                                                    Informix




                                                                                                                     Informix




                                                                                  Informix
                                                                                  Subject-specific
                                                                                  Data Marts


                                     End-user repository and mart access via web
                                     or client-server. Reports, statistical analysis,
                                     analytical applications, judicial and executive
                                     dashboards, etc.




 Figure 1: Proposed architecture for statewide criminal justice integration.
 Messages are passed via Internet to a central hub for application of rules, routing, and transformation. The hub passes transformed data back
 out based on publish/subscribe rules. Regional and state repositories provide an integrated view of data to end users via web or client-server
 based applications.




- 3-                                                                                                                      Informix Software, Inc.
                                                                       Arizona Criminal Justice Integration Project RFI


Architecture Description
The Arizona Criminal Justice Integration Project requires components in the following areas.
•      Data capture
•      Messaging
•      Data transformation to a format acceptable by the target systems
•      Inter-system networking
•      Rule-based routing of messages
•      Statewide repositories of integrated criminal justice data
•      Regional repositories of integrated criminal justice data
•      Special-interest repositories of integrated criminal justice data
•      Regional and state data marts for analytical processing
•      Data access tools and applications for end-users

The architecture shown above not only addresses each of these areas, it also provides extremely robust and flexible
components at each critical point.

Data capture
The specific data capture mechanism will vary by system. A customized piece of e-Adapter™ software must be put
on each source system to enable the extraction of necessary data on either an event or time-driven basis . A
combination of screen scrapers, triggers, API calls, or extracts may be used for this process, depending on the
flexibility of the source application/database. Once extracted, e-Adapter™ will take the data and send it to
enableNet.

Messaging
IBM’s MQSeries ® is used as the underlying messaging product. MQSeries ® allows applications to communicate
across a network indirectly by using message queues. Using a combination of enableNet and MQSeries ®, this
architecture allows agencies to transmit data via the internet. The alternative would be to require every system
involved to have a dedicated network connection either to a hub or to every other system. The requirement of a
dedicated network connection raises a number of budgetary and logistical issues that are avoided through the use of
enableNet.
enableNet includes a product called e-Adapter™. e-Adapter™ operates in conjunction with MQSeries ® to provide
services such as data integration, file transfer, customization of process flow, management tools, security, and
monitoring.

Data transformation to a format acceptable by the target system
This solution includes the conversion of source-system data to an XML format. Once that data is received by
enableNet, it is translated to a system-specific format intended for a particular target system. Data transformation
happens inside the enableNet system. This eliminates the need for either the regions or the state of Arizona to create
and maintain the centralized hub, transformation procedures, and messaging rules.

Inter-system networking
By using the Internet, agencies will be able to bypass costly network infrastructure requirements. If the Internet was
not used, every agency would be required to have a dedicated network connection to the central hub. Creation and
maintenance of new network lines is a time-consuming and costly process that the Informix solution does not
require.




- 4-                                                                                                 Informix Software, Inc.
                                                                     Arizona Criminal Justice Integration Project RFI


Rule-based routing of messages
Routing rules reside inside enableNet, and are applied as messages enter the system. Rules may be updated at any
time by any target system, and may follow any model desired (e.g. publish and subscribe, batch, semi real-time,
synchronous, asynchronous, etc).
enableNet is effectively an outsourcing service for management of all rules, message routing, and data
transformation. By outsourcing this component, the state avoids many technical, political, and budgetary issues
which would otherwise need to be addressed. For example, which state agency would otherwise host and manage
these services, where would their budget for this operation come from, how long would it take to put the systems
and people in place, how secure would the facility be, and how would other agencies connect to this central agency?

Informix Statewide Repository Server
The Informix Statewide Data Repository will receive and store all data which the source systems publish through
enableNet. This repository will hold at a minimum all the Arizona Criminal Justice Integration (ACJI) data as
defined in appendix E of the Request for Information. This repository will not only provide efficient analysis of state
wide data, it will also perform disaster recovery functions for regional and specialized repositories. Queries through
the Statewide Repository and it’s respective data marts would be able to provide information such as:
•      A particular defendant’s consolidated record. This record would include all convictions, sentences and
       defendant history regardless of what jurisdiction they occurred in.
•      The average number of days from filing to disposition that all similar court cases took on a statewide level.
•      The number of currently open cases on a statewide, county, regional or city level.
•      Number of Department of Economic Security or Dependant Child Care children that appear in the adult judicial
       system.
•      Orders of protection that have been served against any individual through any Arizona court.

Informix Regional Repository Server
The Informix Regional Repository Servers will receive predefined data that meets the query needs of the regional
users and will normally be defined as a subset of the state repository in structure and content. This data may contain
information that is not found in other regional or special interest data repositories. This is due to the fact that
statewide and regional requirements tend to differ. These Informix Regional Repository Servers will get their data
from enableNet in a predefined format which allows for automatic import into the server. This type of repository
would also have the capability to act as an operational data store, which will be able to respond to web-based query
requests. These repositories can be administered and maintained by the specific department or region which
requested the need for the information.

Informix Special Interest Repository Server
The Informix Special Interest Repository Server may contain statewide data that meets specific guidelines for
agencies and legislative groups. They will only host data that meets specific subject matter requirements. For
instance, a special interest repository may hold data about people convicted of domestic violence crimes at a
statewide level. Unlike Regional repositories, these special interest repositories may have very dissimilar schemas
from the statewide repository. As with the regional repositories, these special interest repositories can be owned and
maintained by the requesting party.

Regional and state data marts for analytical processing
For analytical data processing and trend analysis, data will be extracted from one or more repositories and loaded
into an Informix data mart server. The data will be extracted from the repositories via the Informix DataStage
product. This product will transform the data into a de-normalized fashion so that it can be loaded into a
dimensional model warehouse and fed to dimensional data marts which offer extremely high performance for
analytical processing and statistical reporting.




- 5-                                                                                                  Informix Software, Inc.
                                                                  Arizona Criminal Justice Integration Project RFI


Data access tools and applications for end-users
All user access to these repositories will be web-based. The Informix solution includes three products, but can easily
accommodate any ODBC-compliant product. The majority of end users will use their web-browsers to access
applications created with Informix i.Sell product. i.Sell will be responsible for enforcing any applicable security or
data sensitivity requirements. Once connected to the repositories, the user can request data from a number of
different sources (depending on that user’s privilege level). The i.Sell product will be responsible for propagating a
user request into several independent server queries. This way the end user does not need to be aware of how many
data repositories are being looked at, where the data came from or what format the data is stored in. i.Sell will
handle those duties.
For users needing a highly structured, visual environment for viewing data, the Informix Visionary product would
be used to create graphical, web-based applications. A prototype of a Visionary application accessing the JUSTIS
data warehouse is available for demonstration.
The third access tool is for business analysts. Informix MetaCube provides a highly flexible, unstructured means of
navigating through large amounts of complex data. It is designed for statisticians and business analysts, but can also
be used to create standard reports.




- 6-                                                                                               Informix Software, Inc.
                                                                                  Arizona Criminal Justice Integration Project RFI




III. Proposed Pilot Architecture

       Flagstaff                                   Flagstaff                                 Flagstaff
       Justice                                     Municipal                                 Superior
                                                                                                                                      Coconino County
       Informix                                    Informix                                  Informix
                                                                                                                                      Attorney
       Database                                    Database                                  Database

                                                                                                                                      e-Adapter™
       e-Adapter™                                  e-Adapter™                                e-Adapter™




                                               enableNet
                                               • Transformation
   E-ADAPTER™                                  • Rules based routing
   •     Extract                               • Cleansing
   •     Encrytion                             • Security
   •     Decryption                            • Encryption
   •     Load                                  • Decryption



                                                                                               e-Adapter™

                                                                                           Informix Extended
                                                                                             Parallel Server

                                                                                      JUSTIS Data Warehouse
                                                                                         (Court Repository)



                            Informix                                                    Informix
                            DataMart                                                    DataMart


                                                                                                                    Advantage:
                                                                                                    •     Re-use of JUSTIS Warehouse
                                                                                                    •     Automated Integration
                                                                                                    •     Assured Delivery
                                                       Repository User                              •     Seamless open connectivity
                                                      Web or Client Server                          •     Scalability
                                                                                                    •     Flexibility


 Figure 2: Proposed architecture for pilot judicial integration project.
 This architecture matches the one proposed for the statewide project, with some important details filled in. First, the extract, transform, and
 load programs written for the JUSTIS warehouse are used as the model for the enableNet system for the FACTS5 courts in Coconino.
 Second, the hardware and software from the JUSTIS warehouse is reused, along with the existing modeling, design, and data from JUSTIS.
 These important details would create a significant cost and time savings for the pilot project.



- 7-                                                                                                                       Informix Software, Inc.
                                                                  Arizona Criminal Justice Integration Project RFI


Pilot Architecture Description
The Informix approach to the pilot project utilizes the highly successful Arizona Judicial Statewide Information
Service (JUSTIS) Data Warehouse as the foundation of the repository architecture. It also re-uses past successful
relationships with Coconino County technology and user groups, and augments current data transfer methodologies
with state-of-the-art techniques and protocols while providing an open approach to extract and load
methodologies. Figure 2 provides a high level architectural view of the Arizona Criminal Justice Integration (ACJI)
Pilot Project
Using our proven FastStart methodology, Informix would conduct interviews and collect information requirements
from various sources within Coconino County and other state agencies. Informix would then extend the JUSTIS
logical and physical models to incorporate any new conditions that may be called for by expansion to an integrated
criminal justice system.
Informix would install and configure the enableNet messaging solution which will provide transportation , security,
and monitoring of data transactions as they pass from system to system.
Using the JUSTIS repository to represent “a typical repository” in our solution as described in previous sections,
Informix would implement e-Adapter™ technology on the JUSTIS system. This would update this “typical
repository” data model with subscribed data obtained from the enableNet hub. Subscription rules would be
implemented in the hub which would publish transactions obtained from appropriate Coconino source systems. The
Coconino county Superior, Municipal, and Justice court systems, along with the Coconino County Attorney’s data
management system, would be fitted with e-Adpaters appropriate to the data model. Appropriate triggers, extraction
methods, and scheduled operations would be implemented to allow the enableNet solution to feed the publication
process.
This approach establishes a proof of concept for sharing data amongst source systems. After completion of this pilot
project, the Coconino county Superior, Municipal, and Justice court systems, along with the Coconino County
Attorney would have near-real-time access to each other’s data as designated in the subscription rules, as well as the
ability properly place data within a repository. The reusable, open, object oriented nature of this methodology will
demonstrate the data sharing capability of our system. The success at the JUSTIS Repository will reflect the ability
to create future repositories at remote locations, whether they be state, central, regional, or agency specific.
Informix believes that this approach provides the fastest, most reliable, cost efficient implementation for the pilot
project. It utilizes existing architectures, relationships, and data sources, augments them with new, open, scalable
technology, and demonstrates the proof of concept with minimum disruption to any of the source or target systems,
and will minimize the pilot costs.




- 8-                                                                                               Informix Software, Inc.
                                                                   Arizona Criminal Justice Integration Project RFI




IV. Product Overview

Database Servers
The Arizona Criminal Justice Integration Project will require database servers to perform a variety of specialized
functions. Those functions will include acting as data marts, operational data stores, and data warehouse
repositories. While it is possible for a single, general-purpose database server to perform these tasks, it is much more
effective to utilize specialized database servers where called for.
Using specialized database servers can result in a number of benefits and cost savings. Specifically, specialized
database servers will perform significantly faster than generalized servers in their area of specialization. This
performance difference will significantly increase the price/performance effectiveness of both the software and
hardware, and can make the difference between an application being perceived as either “fast” or “slow”. In addition
to improved performance, specialized database servers are able to perform tasks that may be impractical, if not
impossible, with generalized database servers.
Informix envisions the use of two or three different database servers for the Arizona Criminal Justice Integration
Project. For general use and Internet access we recommend Informix Internet Foundation.2000. For the regional and
state data warehouse repositories, we recommend the use of Informix Extended Parallel Server. Subject-specific
data marts may require the use of a data mart server, in which case we would recommend either the Red Brick
Decision Server or the Informix Extended Parallel Server, depending on the specific requirements.


Informix Internet Foundation.2000
Informix Internet Foundation.2000 (Foundation.2000) combines the best features of Informix’s industry-leading
relational database management system technology with the flexibility and power of Informix’s advanced object-
relational technology to produce a first-in-its-class data engine for the next generation of computing.
Foundation.2000 supports all Internet programming standards such as Java and ActiveX. In addition, the
extensibility of Foundation.2000 allows the creation of application and user-specific data types and routines, and the
use of DataBlade modules. DataBlade modules which may be applicable to the Criminal Justice Integration Project
may include XML, Text, Image, and Geospatial.
At the core of Foundation.2000 is Informix Dynamic Server 2000, Informix’s powerful, multi-threaded data engine
designed to deliver breakthrough database scalability, management, and performance. Informix Dynamic Server
2000 is based on a parallel database architecture, which has been built from the ground up to provide core internal
parallelism, enabling all major database operations, such as I/O, complex queries, index builds, log recovery, and
backups and restores to execute in parallel across all available system resources. This parallel database architecture
provides the unique ability to intelligently optimize performance and fully exploit the inherent processing power of
any hardware.


Informix Extended Parallel Server
Informix Extended Parallel Server (XPS) is used by customers in all industries – including justice, retail, healthcare,
government, telecommunications, finance, and transportation – to support some of the world’s largest and most
heavily utilized business intelligence environments.
XPS takes the risk out of deploying and managing comprehensive, multiterabyte data warehouses by imposing “no
limits” to support the demands of the data warehousing technology. Unlike traditional transaction-focused systems,
a data warehouse is an environment that requires flexibility and scalability, along with the ability to quickly query
vast amounts of information.




- 9-                                                                                                Informix Software, Inc.
                                                                    Arizona Criminal Justice Integration Project RFI


“No limits” means that your data warehouse can grow to meet your changing business requirements, no matter how
much information you need to manage.
•        You can expand available hardware as needed, without sacrificing price/performance;
•        You can update your data warehouse even as you are running queries;
•        You can add processors or reconfigure your hardware to address high-demand periods without having to
         reinitialize;
•        You can move between the most cost effective open system platforms and a wide variety of SMP and parallel
         (NUMA, Cluster, and MPP) architectures; and
•        You can manage your data from anywhere that you can access a Web browser.

Informix Red Brick Decision Server
The distinction between an “enterprise data warehouse” and a “data mart” is important because each application
exploits a different set of data features. The enterprise data warehouse functions as the central repository or staging
area for all the data in the decision support environment. Generally, the data represents many subject areas and is
organized in a relational format, typically normalized. A data mart is a subject or application-specific data store.
Examples of subject-specific data marts from the JUSTIS warehouse include case, charge, and sentence.
Informix Red Brick Decision Server (Red Brick) is a specialized server technology that has been designed and
optimized to meet the demanding requirements of data mart applications.


Tools

Informix DataStage
Informix DataStage is an integrated set of tools designed to simplify and automate the extraction, transformation,
load, and maintenance of data from multiple operational sources into Informix data mart and data warehouse targets.
Informix DataStage’s visual design tool enhances productivity by enabling users to design the data movement
process using a direct visual model. It allows developers to add more data sources, targets, and transformation
routines without rebuilding applications, thereby reducing cost, time, and resources.


Informix Visionary
Informix Visionary is a powerful business visualizer that allows users to graphically explore the business enterprise
and obtain immediate analysis of trends and situations. Visionary provides a low cost implementation and rapid
solution development environment. The JUSTIS “Judicial Dashboard” prototype/demo was built using Visionary,
with actual coding taking less than two days.


Informix MetaCube
Informix MetaCube is a relational on-line analytical processing (ROLAP) solution. MetaCube represents the leading
edge in decision-support technology and the most flexible and powerful solution for accessing, identifying, and
analyzing the key information elements that drive a business.
MetaCube provides an intuitive, easy-to-navigate multidimensional view of warehouse data while allowing data to
be stored and managed within any of Informix’s database servers. MetaCube includes a complete suite of advanced
tools designed to automate and simplify installation, administration, and tuning. MetaCube also delivers the most
comprehensive Web-based ROLAP solution available, allowing users to perform even the most advanced ROLAP
functions from a Web browser.




- 10 -                                                                                               Informix Software, Inc.
                                                                        Arizona Criminal Justice Integration Project RFI



Informix i.Sell
i.Sell is built on a Java-based, open, scalable component architecture that can be extended and modified easily. i.Sell
includes:
•        i.Sell Application Server – i.Sell Application Server is a 100% Java-based application engine. The foundation
         for the i.Sell solution, this multi-tier server meets the performance, reliability, extensibility, and scalability
         requirements of large-scale e-commerce systems.
•        i.Sell Personalizer – i.Sell Personalizer enables business users to create business rules that target specific
         content to a particular group of users. For example, content can be targeted to specific agencies such as DPS,
         County Attorney, etc. Content can also be targeted at specific terminals or logons, such as library kiosks. This
         provides a high degree of application-level security for enforcing particular views into a given data repository
•        i.Sell Merchandiser – i.Sell Merchandiser addresses the entire creation of the front-end of a web site, including
         catalog creation (for reports, queries, or views of the data), etc.


CommerceQuest enableNet Solution Overview
enableNet is comprised of a comprehensive product solution set delivering key information integration enabling
technologies. enableNet employs technologies such as CommerceQuest’s XML solution toolkit and e-Adapter™
Suite, IBM MQSeries® and Data Interchange, VeriSign PKI, RSA encryption, DB2 and Lotus Notes Domino.
These technical components provide assured delivery of messages with secure end-to-end DES/DES3 encryption
and RSA-based digital signatures.
With the solution set provided by enableNet combined with MQSeries® and e-Adapter™ Suite, state and local
justice agencies can achieve total end-to-end information integration.
•        enableNet unleashes the full potential of the Internet by making it secure, reliable, and manageable. enableNet
         can accelerate and maximize business integration and reduce operating costs by exploiting and using the
         Internet for data integration among state and local justice agencies.
•        enableNet securely moves business critical information over the Internet in real time with assured delivery once
         and only once based on IBM’s MQSeries® market leading asynchronous messaging technology. It further
         guarantees security using PKI technology with RSA-based digital signatures and end-to-end DES/DES3
         encryption required for exchanging information over the Internet. CommerceQuest is a VeriSign approved
         Level 2 LRA and provides X.509 certificate authentication.
•        enableNet accepts and translate any-to-any EDI (X12 and EDIFACT standards), XML, HTML combinations
         and legacy, proprietary and private formats as well as database extraction-to-message. enableNet provides each
         state and local justice agency the ability to send transactions in their native format and receive transactions
         transformed and formatted to directly integrate into their operational and informational systems.
•        State and local justice agencies can loosely couple, but tightly integrate applications and new processes using e-
         Adapter™ Suite for EAI. If enableNet is coupled with e-Adapter™ Suite and MQSeries® an end-to-end
         solution from justice agency system to justice agency system integration is realized. The e-Adapter™ Suite
         provides integration and management tools required enabling seamless integration of processes and applications
         over virtually any application, platform, and network. e-Adapter™ Suite is proven integration technology used
         by many Fortune 500 global companies.
•        enableNet runs on a highly scalable, highly reliable, full parallel SYSPLEX IBM OS/390 mainframe in an
         Exodus data center. Exodus has world class Internet data centers providing hosting facilities for Microsoft,
         Yahoo and many other leading Internet centric businesses.
•        enableNet provides end-to-end status reporting including real time status of transaction, delivery reply, and
         custom status messages centralized at the enableNet hub accessible via a web based interface.
In summary, enableNet is built from the ground up as an industrial-strength business-to-business messaging
infrastructure to provide a managed, secure, assured delivery service for business quality messaging (BQM) over the
Internet.



- 11 -                                                                                                   Informix Software, Inc.
                                                                    Arizona Criminal Justice Integration Project RFI


CommerceQuest e-Adapter™ Suite Detailed Description
e-Adapter™ is a software suite that enables applications to share business-critical information – regardless of
content – across all major computer platforms and network protocols. e-Adapter™ provides end-to-end operations
management, tracking, logging and status reporting, while automating much of the work required in the integration
of information across state and local justice agencies.
One reason e-Adapter™ Suite is substantially superior to other information integration solutions is because it
operates in conjunction with IBM’s powerful MQSeries® messaging and queuing platform and effectively leverages
the MQSeries® reliability and security attributes.
To deliver a complete information integration solution, the e-Adapter™ Suite incorporates a broad range of
technologies and processes. Key components are:

1. Integration Engine
        The core of the e-Adapter™ Suite is an information integration engine designed to extract business data
        from various sources and transmit it across the network for integration with other information. The engine
        is responsible for the overall reliability and integrity of the information integration process. The engine
        also manages connectivity and communication with various network layers, while providing flexibility and
        scalability.
           The e-Adapter™ integration engine uses message-queuing technology to transfer information across the
           network. The engine transforms native source business information into a series of messages, transmits
           them across the network using IBM’s MQSeries® messaging engine and then builds the target business
           information structures on the receiving end.

2. File transfer
         Not every file transfer is mission critical. However, mission critical file transfers, where the risk of not
         getting the right information to the right place at the right time may be significant. Because this class of
         file transfers exists, e-Adapter™ implements an enterprise-strength file transfer across a highly reliable,
         high-performance and cost-effective message-queuing communications backbone.

3. Exits
           e-Adapter™ offers a set of customizable exit points that enable the non-intrusive, flexible, customization of
           process flow. These exit points are strategically located throughout the information-integration process,
           providing maximum flexibility in customizing the specifics of business process flows.

4. Management Tools
       Complementing the basic functionality of the e-Adapter™ information-integration engine is a set of
       management tools:
           Expert/MQ – For operational configuration, management and visibility of the information flows.
           e-Handler – A rules-driven software component that triggers business process events in response to
           message arrivals within a specific message queue.
           e-Scheduler – A fully automated scheduling tool for coordinating, scheduling, and executing business
           transactions from MQSeries®-enabled applications.
           Directory Monitor – A daemon process, dirmon, initiates e-Adapter™ events based on the detection of a
           file.




- 12 -                                                                                              Informix Software, Inc.
                                                                     Arizona Criminal Justice Integration Project RFI


5. Security
            e-Adapter™ features e-Secure to guarantee the confidentiality and integrity of information flowing between
            various business processes. It also provides extensive audit trails for all activities conducted by each host
            participating in the transfer of information.

6. Status Subsystem
        e-Adapter™ also provides robust end-to-end status monitoring of traffic flows, forwarding status records,
        as messages, to MQSeries® queues. The status records provide detailed information on data transfers, not
        simply a completion code. The e-Adapter™ status subsystem has a GUI interface that runs in a Microsoft
        Management Console interface to view message status.
The e-Adapter™ Suite lets users seamlessly exchange information between dissimilar networks, operating systems,
databases, and applications. It provides a fail-safe, reliable transfer solution for existing file-based applications;
eases the transition from current file-based legacy applications to new message-enabled applications; and permits
the transfer of data not stored in files, including relational database tables, ODBC data stores, and MQSeries®
messages.

Hardware Specs and OS
e-Adapter™ supports MQSeries® for Open Systems version 2 and higher and MQSeries® for OS/390 version 1.1.4
or higher. The machine must meet the minimum hardware requirements specified by IBM for MQSeries®. e-
Adapter™ is available for OS/390, AS/400, TPF, AIX, HP-UX, Solaris, DEC UNIX, OS/2 and Windows NT.


MQSeries® Detailed Description
IBM’s MQSeries® products provide connectivity in a heterogeneous computing and network environment. With
MQSeries®, applications communicate by putting messages onto queues via a simple interface, the MQI.
Messaging and queuing allows programs to communicate across a network without having a private, dedicated,
logical connection to link them. Applications do not talk directly across the network, but indirectly by putting
messages on message queues. Since there is no direct communication between applications, the applications don’t
have to be running at the same time and once a message is placed in a queue, the application is no longer involved
with the delivery of the message and is free to continue processing. This loosely coupled design eases constraints on
application architecture. Most importantly, the loosely coupled nature of MQSeries® allows the application to be
separated from network dependencies.
The entire process of communication is entirely transparent to the application and therefore to the application
developer. MQSeries® takes care of establishing and managing the network connection, any necessary protocol
conversions, and the safe delivery of the message across the network.
An MQSeries® implementation has the following components:
1.       Queue Managers
            Queue managers provide administration functions such as installation, customization, storage management,
            security management, object definition, performance management and distributed queue management.
            Queue managers also provide interfaces to commands.
2.       Queues
            Queues are owned by the queue manager and are the principal objects for MQSeries®. There are different
            types of queue definitions. A local queue resides on the same queue manager as the connected process and
            may be used for input, output or both.




- 13 -                                                                                               Informix Software, Inc.
                                                                      Arizona Criminal Justice Integration Project RFI


3.       Process Definitions
             Process definitions define an application to a queue manager. A process definition object is used for
             defining the path to an application that is started by a trigger monitor. A trigger monitor monitors a queue
             for messages, when a message is placed in the queue, the trigger monitor starts an application specified in
             the process definition.
4.       Channels
             Message channels are the channels that carry messages from one queue manager to another. A Message
             Channel Agent (MCA) is a program that controls the sending and receiving of messages. There is one
             MCA at each end of a channel – a sender and a receiver.
Applications connect to a local queue manager and read and write messages to and from the queues. The queue
manager uses the defined channels to send and receive messages with the appropriate destination queue manager.
The queue manager guarantees the message will be sent once and only once.
MQSeries® is the industry leading, application integration product. MQSeries® provides applications a simple and
consistent API (the MQI), comprehensive support for all the major computing platforms, guaranteed once- and-
only-once message delivery, and network transparency.

Hardware Specs and OS
MQSeries® is available on over 35 platforms including OS/390, AS/400, TPF, AIX, HP-UX, Solaris, DEC UNIX,
OS/2 and Windows NT.

Customization Requirements
Scripts are provided with the enableNet boarding kit to configure IBM MQSeries® to run the enableNet client
software. There is one set of scripts for each enableNet queue manager you are creating. Scripts are provided with e-
Adapter™ to create the required MQSeries® queues for use of MQSeries® with e-Adapter™. Message channels
must be defined between the queue managers.




- 14 -                                                                                                 Informix Software, Inc.
                                                                      Arizona Criminal Justice Integration Project RFI




V. Key Topics
Responses involving database technology, including data repositories and end-user access tools are provided by
Informix. Responses involving messaging and routing, including enableNet, e-Adapter™, and MQSeries ® are
provided by CommerceQuest.

1.       How data will be extracted and posted to sending and receiving systems. Discuss adapters available and means
         of integration to applications (e.g. screen-scraping, API-calls).
             e-Adapter™ software portals will be used to extract data from the judicial source systems. e-Adapter™
             software portals support a variety of database products, including DB2, Oracle, Informix, and Lotus Notes.
             Both SQL and ODBC are supported. AS/400 physical files, MVS OS/390 partitioned data set (PDS),
             physical sequential (PS) and Generation Data Group (GDG) files, UNIX, and Windows-based files systems
             also are supported. Other e-Adapter™ software portals are available for specific industry systems such as
             IBM TPF. In addition, various message broker products are supported, including IBM MQSeries
             integrator, Neon Copernicus, and TSI Mercator. e-Adapter™ software portals can be designed to interface
             with third-party packages through APIs, permitting the integration with ERP systems.
             e-Adapter™ then transforms the native source business information into a series of messages, transmits
             them across the network using IBM’s MQSeries® messaging engine and inserts the messages into the
             target message queues on the enableNet client. The enableNet client transmits the messages to the
             enableNet service for data transformation, routing and delivery to the appropriate receiving systems.
             enableNet transmits the transformed and formatted data to message queues residing on the receiving
             enableNet client. e-Adapter™ transmits the messages across the network using IBM’s MQSeries®
             messaging engine and transforms the series of messages into native source business information for
             integration into the receiving system using e-Adapter™ application portals.

2.       How can transformation of the data can be accomplished.
             Any-to-any data transformation including EDI (X12 and EDIFACT formats), XML, HTML, Legacy,
             database, proprietary and private formats is accomplished within the enableNet service using several
             transformation technologies including IBM Data Interchange, e-Adapter™, and our XML enabled
             XMSeries products.

3.       How the transactions will be sent to receiving systems.
             Please refer to question #1.

4.       How or whether both synchronous and asynchronous communications are supported.
             Asynchronous communications are supported by IBM’s MQSeries® asynchronous messaging technology.
             However, MQSeries® and e-Adapter™ may be optionally configured to communicate synchronously.

5.       How the identity of systems to which transactions are routed is maintained.
             Identity is maintained and routing of transactions are performed as an integral part of the enableNet service.
             enableNet uses X.509 digital certificates for authentication. The Queue Manager, who initiates a
             connection with enableNet, is authenticated by the enableNet service, and the enableNet Queue Manager is
             authenticated by the initiating Queue Manager. When a channel connection is established, an exit on each
             end of the connection is invoked. Digital certificates, exchanged between the two Message Channel Agents
             (MCA), perform mutual authentication. Security parameters are exchanged between the two MCA’s which
             negotiate to determine whether integrity and confidentiality will be used for communication. Test
             messages are then exchanged between the two systems to ensure the identity of each end point.




- 15 -                                                                                                 Informix Software, Inc.
                                                                      Arizona Criminal Justice Integration Project RFI


6.       How delivery once and once only is assured.
             MQSeries® provides the reliability and assured delivery of messages. The queue manager guarantees
             once-and-only-once message delivery.

7.       How rollback is accomplished when an uncompleted process fails.
             When a data transfer request fails and the e-Adapter™ Receiver mode is set to Create or Replace, the
             Receiver component deletes the data. If the data transfer request fails before the e-Adapter™ Receiver
             starts processing, a rollback is not required. However, if the mode is set to Create or Replace and the e-
             Adapter™ Receiver has starting writing data to the target and the data transfer request fails, the e-
             Adapter™ Receiver deletes the data.
             Data will not be extracted from the source systems until after the related work has been committed to that
             source database. Once committed, the extract process will take that data and send it to the local e-Adapter
             for data propagation.

8.       What the scalability of the product is and what hardware and software incremental upgrades are directly
         related to increased volumes.
             enableNet provides the most scalable environment running on IBM S/390 parallel enterprise servers. Each
             S/390 host provides multiple execution environments known as logical partitions or LPARs. Each acts like
             a separate machine. IBM’s Global Resource Serialization (GRS) product is used to enable sharing of disk
             and data among the LPARs. The Workload Manager product provides load balancing among the LPARs
             based upon predefined performance criteria. enableNet employs F5 Networks’ 3DNS product to load
             balance traffic among the enableNet data centers and logical systems within each data center. The 3DNS
             product augments DNS by allowing for multiple sites to coordinate responses to DNS queries to resolve a
             host name to an address. As a result, heavily loaded systems see less traffic and lightly loaded systems
             more until the situation changes.
             Since enableNet is a managed B2B messaging infrastructure service there are no hardware and software
             incremental upgrades required by the customer as volumes increase.
             There are Informix Servers already processing multiple terabytes of information without any scalability
             issues. Informix Servers meet the performance requirements of industry-leading data warehouses by
             utilizing extensive performance-enhancing technologies such as table partitioning, exceptional optimizer
             technology and innovative indexing strategies. Obviously, as more data needs to be processed, additional
             hardware resources will be needed to accommodate the additional overhead.
             Informix Sever upgrades occur while the system is offline and can take as little as a few seconds before the
             system can be brought back up again.




- 16 -                                                                                                 Informix Software, Inc.
                                                                      Arizona Criminal Justice Integration Project RFI


9.       What the network bandwidth requirements are.
             enableNet is housed in an Exodus data center. Exodus manages its own redundant fiber-optic backbone
             network running at OC-3c/OC-12c speeds (155.52 and 622.08 Mbps) and has plans to upgrade to OC-48 in
             the near future. In addition, Exodus has signed private peering relationships with dozens of major Internet
             providers with networks running at DS-3 (44.736 Mbps) and above. The local network partitions dedicated
             to enableNet at the Exodus facilities operate at speeds up to 100Mb/sec, with expansion capabilities to
             400Mb/sec. The internal network access to the enableNet host features redundant interconnections among
             the components at every level
             Redundant access from the vendor’s dual backbones to the Internet are provided by numerous peer
             agreements with other ISPs and connections with Internet Network Access Points (NAPs). The Internet
             data center is connected to two backbones. Inside the building, SONET rings ensure redundancy. Dual
             Cisco Catalyst 5505 Switches dedicated to enableNet are connected to the SONET rings via two separate
             paths. Each switch is connected to the two Raptor firewalls. The firewalls are dual connected to the two
             Cisco 7206 routers. The 7206s are each dual channel connected to the S/390 for a total of four channels.
             The S/390 provides two different channel interfaces with each of the two 7206s connected to each
             interface. Every step along the way from the Internet to the S/390 has redundant paths.

10. What effort and resources are required to add another source and/or destination of information from existing
    systems already sending and/or receiving transactions (additional hardware, software, programming, or
    administrative and management tasks)
             To add a new enableNet client CommerceQuest would be notified. The new client is required to complete
             the enableNet Boarding Requirements Document. Once the boarding requirements document is submitted
             a CommerceQuest Implementation Manager coordinates the integration and Professional Services install
             and configure the boarding and integration software, MQSeries®, e-Adapter™ and software portals. The
             CommerceQuest Implementation Manager and Solutions Architect along with the new client further
             determines and documents the send and receive data transfer and transformation requirements. These
             requirements are published to the CommerceQuest enableNet development team for development and
             configuration in enableNet.

11. What effort and resources are required to add another system which is a source and/or destination of
    information (additional hardware, software, programming, or administrative and management tasks)
             Please refer to question #10.
             In order to add another repository there first must enough hardware resources to store and process the data.
             The enableNet systems must be configured to send data to the new repository. And finally the Informix
             i.Sell product must be configured to view the new data. Many repositories can exist on the same machine
             assuming that appropriate resources are available on that machine.

12. A description of the routine maintenance tasks required to administer and manage the integration system.
             No routine maintenance tasks are required to administer or manage the messaging portions of the system.
             Data backup and recovery, engine performance tuning, disk space management, and user access
             maintenance functions would be required tasks in this category for the State, Regional and Special Interest
             repositories.

13. What the skill level of those tasked with performing system administration and management should be.
             System administration staff members are not required for the messaging portions of the system.
             A Database Systems Administrator (DBA) charged with responsibility for a State, Regional, or Special
             Interest repositories would require training and experience in administration of the Informix products
             selected for the system. This person additionally would require skills and knowledge in UNIX, SQL, and
             hardware architecture. This training is readily available on various dates and at training locations
             throughout the world, including the Phoenix area.


- 17 -                                                                                                Informix Software, Inc.
                                                                   Arizona Criminal Justice Integration Project RFI


14. What the ability of the proposed product to create, transmit and/or use XML data tags.
          enableNet is fully XML enabled to create, transform, and transmit XML DTDs using CommerceQuest’s
          XMSeries products.

15. What the management monitoring and reporting capabilities are.
          Monitoring and reporting functions are performed using the Informix OnMonitor, Onstat, ISA, and IECC
          tools. These tools are bundled with the appropriate Informix products.
          enableNet provides a status subsystem that tracks, monitors, and reports on the status of all transactions.
          Status reporting and monitoring is provided via a secure web based browser accessible on the Internet.
          Standard reports will be provided through a publish/subscribe paradigm in the status sub system in a
          future release.

16. How security will be assured. What encryption and authentication is employed.
         enableNet uses RSA Technology and PKI infrastructure for encryption and authentication. Security
         between Queue Managers is achieved by combining private and public key infrastructure (PKI). When
         clients register with enableNet, they receive installation software that generates a key pair (public +
         private) unique to the customer. Customers send a certificate service request (CSR) to CommerceQuest via
         e-mail. CommerceQuest then assigns a digital certificate to the customer. Both public keys and private
         keys are stored securely in a customer’s file system, and only the MCA Security Exit has access to the
         information. PKI infrastructure maximizes communications confidentiality and privacy by using both
         asymmetric (public) and symmetric (private) key encryption. Symmetric key encryption simply means that
         both the sending (encrypting) and receiving (decrypting) parties use the same key. Asymmetric key
         encryption uses two keys. A sending party encrypts data with a public key for the receiving party. The
         receiving party decrypts the data using a private key. The receiver’s private key is the only way that data
         encrypted with the receiver’s public key can be decrypted. Therefore, anyone can obtain and use a
         receiver’s public key, but only the receiver possesses the private key to decrypt with.
         The MCA at a client’s site uses a random-number-generation algorithm to construct a unique private
         (symmetric) key, which is used as a message key. This key is generated every time a message is sent. The
         message key is used to encrypt the body of the message. Either the Single DES (DES-64) or Triple DES
         (DES-192) algorithm with Cipher Block Chaining (CBC) may be used for encryption of the message body.
         enableNet employs a secure hash function that ensures that messages have not been tampered with during
         transit between MCAs. Also employed are digital signatures, which provide for non-repudiation, ensuring
         that the sender is the one initiating the communication. A digital signature is constructed using the sender’s
         private key and the output of a secure hash function (MD5) from the message (encrypted message key +
         encrypted message content). The digital signature is then inserted into the message before transmission.
         Access to the repositories will be handled through the Informix I.Sell product. Users will be given specific
         accounts they must use in order to view the repositories. These accounts also restrict what the user can
         view within each data repository. Data can be transferred to the web-browser using standard 128 bit
         encryption.

17. How proprietary the proposed solution is. Does it adhere to industry standards such that other agencies can
    select different products and send to and receive from the proposed one? What would we be excluding by
    selecting your solution?
         By adhering to industry and de facto standards, including business quality messaging (BQM), enableNet
         maximizes the interoperability of applications. BQM is a set of specifications that lay out a set of standards
         for business-to-business communications. CommerceQuest is a leader in industry organizations such as
         RosettaNet and BQM Forum.
         All Informix Database Servers adhere to the ANSI standard SQL language for data access. Furthermore
         any application which follows the Open Database Connectivity (ODBC) standard should also work against
         Informix Servers.



- 18 -                                                                                              Informix Software, Inc.
                                                                 Arizona Criminal Justice Integration Project RFI


18. What integration standards are incorporated into your integration solution/products and which you have
    worked with (i.e. EDI, EDIFACT, HL7, XML, etc.)
         enableNet supports all standards including EDI standards X12 ( ANSI ASC X12) and EDIFACT,
         EDI/XML, XML, HTML, and industry standards such as HL7 for healthcare, IATA for transportation, TDI
         for retail distribution, etc.

19. What segment(s) of the integration industry your products/proposed solution represent. (ETL (extract,
    transform, load), EAI (enterprise application integration), MOM (message orientedmiddleware), MB (message
    broker), IAI (Internet application integration), MW (middleware), Platform Middleware, Database Middleware,
    etc.)
         Our solution represents EAI, IAI, and MOM integration segments. Moreover, enableNet represents the IAI
         integration segment, our e-Adapter™ Suite represents the EAI segment and MQSeries® represents MOM
         segment.

20. Whether your solution is a total solution or if we will need to bring in other vendors and products to provide
    other needed utilities and functions.
         Informix has decided to partner with CommerceQuest and their enableNet service and e-Adapter solution
         suite. We believe a partnered approach with Informix providing the foundation and infrastructure for the
         State and Regional data repositories and CommerceQuest providing the product, services and infrastructure
         for the secure messaging delivery of data provide the most comprehensive solution for Arizona. No other
         vendors, products, utilities or functions will be required outside of the Informix solution to this project.




- 19 -                                                                                            Informix Software, Inc.
                                                                 Arizona Criminal Justice Integration Project RFI




VI. Vendor Information
Informix Software, Inc. response to the Arizona Criminal Justice Integration Project RFI is a proposed partnering
approach.
Informix is the leading provider of technology solutions for Data Warehousing, supplying the infrastructure of
people, products and support for successful Data Repositories. We have chosen to partner with CommerceQuest,
Inc. to provide the Internet Application Integration (IAI) messaging infrastructure for our solution.
We believe with the product, solution and services provided by both our organizations can provide the best approach
to a successful Arizona Justice Integration project.
Informix - Informix is a global company that pioneered advanced database technology almost 20 years ago.
Informix has focused its data warehousing efforts on delivering end-to-end, business-critical solutions based upon
advanced analytical engines. Informix provides a database engine designed specifically for companies specific data
warehousing needs. We have also added a complete set of powerful and scaleable tools for extracting, transforming,
and loading the right data into the warehouse or mart and uncovering business insights with the industry’s most
advanced analytic and executive information application tools.
Commerce Quest - Founded in 1992 CommerceQuest began delivering a comprehensive set of packaged and
tailored services for enterprise application integration (EAI). We developed a suite of products to enable
applications to share business critical information regardless of content or format across all major computer
platforms and network protocols based upon IBM MQSeries® market leading messaging and queuing technology.
Our product suite enabled the business enterprise to rapidly, securely and seamlessly exchange information between
dissimilar applications within the enterprise. CommerceQuest is a privately held company with headquarters in
Tampa Florida and branch offices throughout the United States, Europe and Australia with approximately 400
employees worldwide.




- 20 -                                                                                           Informix Software, Inc.

								
To top