Docstoc

Business Requirement Statement

Document Sample
 Business Requirement Statement Powered By Docstoc
					   Universal Postal Union International Bureau           POC EXG 2004.4 Doc 11 Annex 1

   l

Business Requirements Document – LDM/Standards Online Access System.


Table of Contents

   1. Business Needs Statement

   2. Rationale for Development

   3. System Requirements

   4. Maintenance Responsibility

   5. Access Requirements

   6. Pricing Considerations

   7. Other considerations for the development phase




4/19/2010                         Prepared by David Chamberlin                   Page 1 of
17
   Universal Postal Union International Bureau           POC EXG 2004.4 Doc 11 Annex 1

   l
Business Needs Statement

The LDM Survey project has validated the need for new systems development. This
would be a system to access specific Standards documents and files over the internet.

This system is intended to provide the user with online access to:

   1. The normalized portion of the LDM available as machine-readable data-
      definition-language (DDL) files and native ERWIN ER1 files for use with
      database design software.
   2. All current active Technical and EDI Messaging UPU standards as PDF
      documents.

This system should be web-based and integrate in with the current UPU home page and
current access to existing Standards products and information.

The system will be independent of the production of the Standards documents and files.
Document and file production will continue to be the responsibilities of the Standards
Programme.

Access to the system should be subscription-based. Users wishing to download
documents and files will have User IDs and Passwords assigned. Access policy will have
to be developed by the IB.

Pricing for this subscription is an issue to be determined. It should be priced accordingly
along with other existing Standards Programme products. This is another policy issue that
needs to be developed.

The first version of the new system should be regarded a prototype system. If possible
access statistics by user(s) should be collected. User involvement in testing is needed
also. The IB should solicit help from a major administration in testing.




4/19/2010                         Prepared by David Chamberlin                   Page 2 of
17
   Universal Postal Union International Bureau               POC EXG 2004.4 Doc 11 Annex 1

   l
Rationale for Development.
In Phase 1 of the LDM project, the IB and the consulting staff conducted a survey with
the PTC and most of the major Postal Administrations. The survey asked respondents if
there would be value in having the LDM in machine-readable format and would it be
useful to have the UPU messaging and technical standards available for online access on
the Web. The responses to both these inquiries was positive. 62% of the respondents
wanted having the LDM available in machine-readable formats. A larger percentage,
85% wanted to access all or some of the Technical and Message Standards from the
Internet.
                    Respondents for a Machine-Readable LDM




                 38%
                                                              Answ ering Yes
                                                              Answ ering No
                                           62%




                   Online Access to Standards Documents



                       15%



                                                     Would Like Online Access
                                                     Don't Need



                                     85%




Administrations wanting machine-readable access to LDM files specified a variety of
formats; data definition language (DDL), flat files, and XML. The respondents had
various systems requirements from mainframes to desktop personal computers. Nearly
all administrations were using relational database systems for data capture and storage.
The two major relational database products for international systems are ORACLE and
Microsoft SQL Server. IBM’s DB-2 is also used by several administrations. Any
generation of DDL from the LDM should include files for these products. In addition, at
the October 2004 SB meeting in Amsterdam, it was decided that the native ER1 files
(import to ERWIN and other database design software) would be added to the list of
available files.

4/19/2010                         Prepared by David Chamberlin                       Page 3 of
17
   Universal Postal Union International Bureau                                                              POC EXG 2004.4 Doc 11 Annex 1

   l
System Requirements

The following flowchart shows the new relevant HTM pages for accessing the LDM and
online standards.



                                                                                        UPU Home
                                                                                          Page

                                                        WWW.UPU.int - Universal Postal Union UPU WorldWide Organization.htm




                                                         General

                                                                                        Standards
                                                    WhatweDoGeneral.htm
                                                                                               WhatweDoStandards.htm
                                   Online Access to UPU Messaging
             MessageOptions                   Standards                                                       Online Access to UPU Technical
                     Message                                                           Publications                     Standards
                    Publication            LOGICAL DATA MODEL Software Files
                   Logical Data
                      Model                                                          publications2.htm

                                                                                                                            Technical
                                                                                                                           Publications
                           EDI                                                                                               Page 1
                         Messaging                                                                                                               PDF files
                         Standard                                                                                   UPUOnlineStandards1b.htmTechnical Standards
         PDF Files        Page 1
       EDI Standards             LDMOptionPage1                                                                             Technical
                                                                                                                           Publications
                           EDI                                                                                               Page 2
                         Messaging                                                                                                                  PDF files
                         Standard                                                                                                                   Technical
                                                                                                                     UPUOnlineStandardsPage1.htm
         PDF Files        Page 2                                                                                                                    Standards
       EDI Standards                                                                                                        Technical
                                 LDMOptionPage2b                    LDM Data
                                                                      Files                                                Publications
                           EDI                                                                                               Page 3
                         Messaging                                                                    M84-1 LDM
                         Standard                                              LDMSelectionlist.htm                  UPUOnlineStandardsPage2.htm    PDF files
                          Page 3                                                                                                                    Technical
     PDF Files                                                                                                                                      Standards
   EDI Standards         LDMOptionPage3b



                                                            ORACLE                SQL Server               DB2 DDL
                                    ERWIN files
                                                            DDL files              DDL files                Files

                              LDM_Erwinfiles.htm       LDM_Oraclefiles.htm                                LDM_DB2files.htm
                                                                       LDM_SQLServerfiles.htm




                                                            DDL Files for            DDL Files for         DDL Files for
                                    ER1 Files for
                                                              different                different             different
                                      different
                                                             Message                   Message              Message
                                     Message
                                                               Groups                  Groups                Groups
                                      Groups
                                                              (Oracle)               (SQL Server)             (DB2)

                                  Figure 1 - Navigation for Accessing new Standards Options - Only the new options shown




4/19/2010                                                Prepared by David Chamberlin                                                               Page 4 of
17
   Universal Postal Union International Bureau                     POC EXG 2004.4 Doc 11 Annex 1

   l
The new system can also be distributed also as a stand-alone CD which users can
interactively pull the documents or files they need onto their workstations or PCs.
For now the Standards Group will distribute these stand-alone CDs like before, one for
Technical Standards and the other for Message Standards.

There will be no changes required for the Technical Standards CD, but the Message
Standards CD will contain the software developer files for the Erwin Database Design
software and Data Definition files for Oracle, SQL Server, and DB-2 Relational Database
systems. The following are the directory structures for both CDs. Individual files are not
shown.

Technical Standards CD Directory
   Figure 2 Interactive CD
    Directory Structure -
 Technical Standards Manual
             Interactive
                 CD


                 Technical Standards




                                       CD Contents
                                                       Technical
                                                       Standards
                                                        Manuals

                                                        Order Forms



EDI Messaging Standards CD Directory
    Figure 3 Interactive CD
   Directory Structure - EDI
    Messaging Standards
            Manual
             Interactive
                 CD


                Messaging Standards




                                       CD Contents

                                                      EDI Messaging
                                                       Standard files
                                                     Message Pairs DB2
                                                     Oracle SQL Server
                                                            Software
                                                         developer files
                                                        Order Forms



4/19/2010                          Prepared by David Chamberlin                            Page 5 of
17
   Universal Postal Union International Bureau           POC EXG 2004.4 Doc 11 Annex 1

   l

For the Web implementation:
Access to the system should be through the Internet. The major portal should be the
UPU’s main web site, WWW.UPU.INT.




The recommended access to the new features will be made through the Standards link
under [What we do] grouping.




4/19/2010                         Prepared by David Chamberlin                   Page 6 of
17
   Universal Postal Union International Bureau           POC EXG 2004.4 Doc 11 Annex 1

   l
Access to the new features Online Access to UPU Technical Standards and Online
Access to UPU Messaging Standards document access are as new options under the
Publications selection in the What we do Standards.htm web page.




Note the two new access options under publications:




4/19/2010                         Prepared by David Chamberlin                   Page 7 of
17
   Universal Postal Union International Bureau           POC EXG 2004.4 Doc 11 Annex 1

   l
The following three sample screens – are prototypes for:

   Access to Technical Standards Manuals (as PDF files)


This is the draft prototype screen for access to the Technical Standards Manuals.




4/19/2010                         Prepared by David Chamberlin                   Page 8 of
17
   Universal Postal Union International Bureau           POC EXG 2004.4 Doc 11 Annex 1

   l




This is page 2 for selecting the Technical Standard Publications
under Online Access to UPU Technical Standards.




This is page 3.


4/19/2010                         Prepared by David Chamberlin                   Page 9 of
17
   Universal Postal Union International Bureau           POC EXG 2004.4 Doc 11 Annex 1

   l
By selecting the link to Online Access to UPU Messaging Standards the user will have
access to choose between EDI Messaging Standards (PDF files) or Logical Data Model
Software files (Developer files in a variety of formats).




4/19/2010                         Prepared by David Chamberlin                   Page 10 of
17
   Universal Postal Union International Bureau           POC EXG 2004.4 Doc 11 Annex 1

   l

By selecting EDI Messaging Standards the user can access any of the current EDI
Messaging Standards using Adobe Acrobat – The three pages for Messaging Standards
selection are shown.




Page 2




4/19/2010                         Prepared by David Chamberlin                   Page 11 of
17
   Universal Postal Union International Bureau           POC EXG 2004.4 Doc 11 Annex 1

   l

and Page 3




             Example of Accessing a Messaging Document – M10-5.




4/19/2010                         Prepared by David Chamberlin                   Page 12 of
17
   Universal Postal Union International Bureau           POC EXG 2004.4 Doc 11 Annex 1

   l

When the User Selects Logical Data Model Software File(s)




They will get an Option Screen to select files in Erwin format (ER1), plus ORACLE,
SQL Server, and DB2 DDL (SQL) files. In addition, the M84-1 Logical Data Model
Report(s) is available here. It is also available in EDI Messaging Publications, on page 3.




4/19/2010                         Prepared by David Chamberlin                   Page 13 of
17
   Universal Postal Union International Bureau           POC EXG 2004.4 Doc 11 Annex 1

   l

In addition to the whole model there are an additional seven message groups available for
each software file option:




Selecting an option under Choose the Desired EDI Message Group will prompt the user
to save the selected file to a location on their PC or workstation.




4/19/2010                         Prepared by David Chamberlin                   Page 14 of
17
   Universal Postal Union International Bureau           POC EXG 2004.4 Doc 11 Annex 1

   l



Selecting a SQL File (ORACLE Shown) will open a window in text window with the
selected DDL (SQL) file. The user can save it or paste it into the relational database
query software.




All Messages Entire Model selected. The following DDL file is available as text for use
in their local systems.




4/19/2010                         Prepared by David Chamberlin                   Page 15 of
17
   Universal Postal Union International Bureau            POC EXG 2004.4 Doc 11 Annex 1

   l
Implementation Considerations


Access to the new options will be through the UPU portal WWW.UPU.INT and through
the Standards URL selection. The new options will placed under the Publications link;
Online Access to UPU Technical Standards and Online Access to UPU Messaging
Standards.

Maintenance Responsibilities
The additional modifications to the Standards Link will need to be developed and
maintained by the PTC Web development group. Access and delivery of the documents
and the logical data model files will have to be also programmed as part of the web
interface. However, providing the documents and LDM files to the system will continue
to be the responsibilities of the Standards Programme. The details on how these are
maintained and made accessible will have to be developed in the final phase of this
project. The most important aspect of web applications’ development is the content
management of the underlying information structures and files. Particular care needs to
applied to this area. It is critical in applications that specialize in providing information,
either in document or file format, which is exactly what this system will be doing.

Access Requirements:
 Access will be given to authorized users only with an assigned password. This new set
of users will have to be maintained by the IB. Procedures for User ID requests will have
to be developed. These should be integrated in with current procedures. The Standards
Programme and IB will need agreement on how this works.


Pricing Considerations
Currently the LDM and Standards documents are available for purchase. They can be
either purchased in hard-copy or on CD. With the development of online-access to these
same products, a policy will need to be developed to determine how much to charge for
these new options. One option is to develop subscription pricing. Pricing will need to be
balanced against the cost of providing the documents and files online in the same manner
current prices reflect the cost of hard-copy publication. UPU membership can be a factor
in this decision.
If the cost of providing the products online is going to be significantly less than hard-
copy then incentives to get users to use the online system should be an option. In addition
to the web, there is also the option to produce a CD for distribution with all the needed
files. This could be a lower-cost option to start with.
This is one of the most critical areas for consideration and the policy needs to be
developed before development can begin.




4/19/2010                         Prepared by David Chamberlin                    Page 16 of
17
   Universal Postal Union International Bureau            POC EXG 2004.4 Doc 11 Annex 1

   l
As further information on pricing and billing the following is a description of the
Standards Programme current practices:

UPU Standards subscribers’ data base

Currently there are approximately 200 active subscribers to both UPU Technical
Standards and UPU EDI Messaging Standards publications.

The detail that are being registered of the subscribers are: name, address and whether the
subscriber is a postal organisation, i.e. a member of the UPU, or a private organisation.
The subscribers’ database is separated into subscribers for either Technical Standards or
Messing Standards, but if they subscribe to the two publications they are send one bill for
both publications. The date of the order and subscription are kept along with the number
of copies. A note is also made if the subscriber requires paper and/or CD-Rom or a PDF
version via e-mail.
The bills are normally sent out in January.
Reminders for unpaid bills are send out as often as three times a year, or when necessary.
Each subscriber is given a subscriber number for ease of reference.
Billing detail that are being registered are: the bill number, date of the bill, amount for TS
or MS, date of payment, billing address if different, any comments necessary, despatch
details of the publication.

When an updated is published and ready for despatch a query is run for paid-up
subscribers and the definitive despatch list is produced.

Billing procedures for the new web-based product access should follow current practices.

Other Considerations
For any new system or new functionality to exist it is important that the first phase be
kept manageable. In other words a fixed set of deliverables need to be agreed upon for
the initial release, and additional functionality deferred until the first set has been
completed.
Specifically, in this first draft we are not specifying deliverable files in XML. User
involvement from the beginning is also a good idea. By having a major post working with
the development effort to look at different parts the developers can get immediate
feedback on the ease of use. Having real users as part of the testing and acceptance
process will provide the IB with a more robust product, one that will help guarantee the
system meets the needs of the user community. The look, feel, and navigation of using
the system is the critical factor for determining the success of the system. Easy-to-use
systems that provide the users what they need will always be successful, whereas
difficult-to-access web interfaces will go unused, even when there is demand for the
underlying content.




4/19/2010                         Prepared by David Chamberlin                     Page 17 of
17

				
DOCUMENT INFO