|
Client
A UK government organization responsible
for management of various government schemes
relating to promotion of sports activities
in the country.
Business Need
The client required a single authoritative
database of sports facilities in England
called Active Places, in place of the current
system, where in many organizations having
an interest in sports, collected and separately
maintained information at varying levels
of currency, quality and accuracy using
completely inconsistent formats. Active
Places would allow:
 |
Auditing
of existing sports facilities |
|
Identification of
priorities and gaps in the current
system |
|
Planning for future
investments |
|
Uniform information
dissemination to the general public |
A consortium of Landmark Information Group,
RMSI and The Leisure Database Company won
the bid to create a complete system for
data collection, cleaning and synchronization
and development and implementation of Active
Places.
Solution
Active Places application development was
based on a three-tier architecture with
presentation, business logic and the data
tier as the three logical layers. Some of
the key activities undertaken included development
of an associated sports metadata catalog,
a robust client based system architecture
and efficient DBMS and a two-way interface
for management of spatial and non-spatial
data contained in the database. The system
provided for extensive tools for selection,
analysis and presentation of spatial data
for different types of system users.
Data model development was based on reviewing
the existing data sets available from multiple
sources and studying the user requirements
in detail. The end product in the XML sports
schema can be used by all vendors for publishing
and executing sports data.
A customized software application was used
for automatic data matching, whereas data
cleansing was done manually, using an interactive
software application for support.
Benefits
The client received a single database holding
‘high interest’ core information
with regard to all sports facilities in
England, which would assist in its executive
decision making. As a result of extensive
automation and customisation of processes
the client benefited in terms of reduced
system and data model development costs.
Technologies
|
Microsoft
SQL server 2000 Enterprise Edition
(Service pack 3) |
|
ArcSDE 8.3, ArcIMS
4.0.1 Application Server, ArcIMS 4.0.1
Spatial Server |
|
Microsoft Internet
Information Server 5.0 |
|
Microsoft Visual
Studio 6 |
|
Microsoft XML 3.0 |
|
