OGBD

1
OGBD Veterans State-wide database on
veteransRevision 1.0
2

• State-wide database on veterans and corporate
  informational analytical system.
• Installed in all regions of Russian Federation
  (89 regions)
• Integrates all information on federal level at
  Moscow.
• Contingent 6 800 000 persons, including
• Veterans of World War II (1 300 000 )
• Workers of the home front (4 600 000)
• Veterans of other wars (900 000)
• Integrates information on 120 attributes supplied
  by 6 ministries and state departments
• Stores history of all attributes.
• Current size 100 GB.

3

• The database was developed as part of government
  contract to allow targeted social aid
• Contract was won in alliance with several
  companies
• Design Technological Institute of Digital
  Techniques main contractor responsible for
  hardware and documentation
• ITC and DOTE development of information system
  and database structure
• Institute of Social Strategic Investigations
  requirements definition
• Siberian Center of Security systems firewalls
  configuration and data protection
• Developed under direct supervision of Ministry of
  Health and Social Development of Russian
  Federation.

4

• Topology
• Architecture
• Database layer IBM DB2 UDB v.8.2,
• Application logics - Bean Explorer EE
• Main concepts
• Social passport
• Data import, import schemes
• Reports
• Reports defined by government
• Report builder

5
Topology of informational system OGBD Veterans
Federallevel
Central server
Backup server
Users on federal level
DB
Backup DB
Regional level
Users of regional level
Region 89
Region 1

• Main data sources
• Pension fund
• Departments of peoples social protection
• Fund of medical insurance
• Fund of social insurance- Ministry of Defense

...
Server
DB
server
DB
.....
Regional level
Users
Operators
Uses
6
Architecture of OGBD Veterans
Regional server
Client
Application server (Tomcat)
VIPNet
VIPNet
Servlet container
Administrator
BeanExplorer Enterprise Edition
Data exchange with federal server
TCP/IP
VIPNet
Operator
VIPNet
JDBC
Database server - IBM DB2
User
Database
Meta-information
7
BeanExplorer Enterprise Editionmain concepts
entity
view
operation
query (SQL)
role
user
entity corresponds to object concept in
object-oriented approach. view subset of data
presented to the user. Entity can have several
different views. query view is defined by SQL
query used for automated view generation by
BeanExplorer EE. role during authorization each
user will get corresponding role(s) which defines
a set of views and operations available for the
user. operation operation for data
manipulation, generally presented as a button
(for example Insert, Edit, Delete, and
Filter buttons). Operation can be executed
independently (for example Insert operation) or
can be applied to a selected set of records (for
example Delete operation).
8
Architecture of BeanExplorer Enterprise Edition
Model
View (web interface)
Controller
Problem domain data Veterans

• Menu
• entity 1
• view 1
• view 2
• entity 2
• - view 1
• - view 2

Title (entity) view
insert
filter

BeanExplorer EE

• Meta information
• entity
• view
• role
• operation

data
Input form
Search form (filter)
Customization - CSS - JavaScript - HTML - Color
schemes
field 1
value1
field 1
value1
field 2
value2
field 2
value2
field 3
value3
field 3
value3
9
Social passport is defined as a dynamic set of
attributes
10
Social passport user can add and edit attributes
11
View of social passport for a single veteran
12
Editing of social passport
13
Data import general scheme (simplified)
Import scheme
Veteran social passport(Java object)
Dataparsing
Data file
update
import
Logging
loading of previous data
filter
???? ? ?? ????????? ???????
Semantic rules
Data control
Legend
Automated generation of SQL queries for data
insert/update
data
OGBD Veterans
processes
14
Import scheme DTD
lt!ELEMENT format record checkFormat?
processPassport?gt lt!ATTLIST format name
CDATA REQUIRED type (fixeddbfmix) REQU
IRED gt lt!ELEMENT record attributegt lt!ATTLIST
record name CDATA REQUIRED
type (fixeddbfmix) REQUIRED
action (importlink) REQUIRED gt lt!ELEMENT
attributegt lt!ATTLIST attribute
name CDATA REQUIRED type CDATA REQUI
RED action (assignlinkvalidatetmp) REQUIRED
columnName CDATA positionFrom CDATA
positionTo CDATA gt lt!ELEMENT checkFormat
(PCDATA)gt lt!ELEMENT processPassport (PCDATA)gt
15
Import scheme example for data supplied by
Pension Fund
16
Web interface for data import
17
Data import filters
18
Semantic rules for data validation
19
Application of semantic rules for attributes of
social passport
20
Log of data import
21
Log of data import detailed statistics
22
Log of data import - errors
23
Statistics on attributes fullness
24
Reports

• 50 reports defined by government
• Possibility to show reports in following forms
• HTML table
• Ready for print Excel table
• Bar chart
• Pie chart
• Analytical reports builder

25
(No Transcript)
26
Report example table view
27
Report example bar chart view
28
Report example pie chart view
29
Analytical reports builder
30
Example of report generated by analytical report
builder
31
Informational system OGBD Veterans -
development process
mile stones

• 2005, March-April spike solution
• 2005, May tender
• 2005, June government contract was signed
• 2005, August initial version was installed in 2
  pilot regions
• 2005, October initial version was installed in
  all regions of Russian Federation
• 2005, November initial data was loaded from all
  data sources
• 2005, December OGBD Veterans was officially
  launched
• 2005, December letter of prime-minister M.E.
  Fradkov to president V.V. Putin about
  OGBD Veterans
• 2006, January-current improvements, data
  validation and control

32
(No Transcript)
33
Social Population Register Russian Federation -
Irkutsk Region
Corporate Information System

• An application for Irkutsk Region Administration
  for implementing targeted social aid
• Integrates information from 18 regional data
  sources
• Contingent 900 000 persons
• Includes 200 attributes.
• Similar architecture with OGBD Veterans
• 3-tier architecture
• Application logics - Bean Explorer EE
• Social passport
• Data import, import schemes

34
Architecture of CIS Social register of Irkutsk
region
???????????? ??????
??????
Applications server (Tomcat)
Servlet container
Administrator
BeanExplorer Enterprise Edition
TCP/IP
Operator
JDBC
Database server (MS SQLserver)
User
Database
Meta-information
35
(No Transcript)
36

• For further information, please call 1 978 287
  4855 or
• visit our website at
• www.itcsoftware.com