1 / 36

OGBD “Veterans” State-wide database on veterans Revision: 1.0

OGBD “Veterans” State-wide database on veterans Revision: 1.0. 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.

matteo
Download Presentation

OGBD “Veterans” State-wide database on veterans Revision: 1.0

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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 Operators Users 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 query (SQL) view operation user role 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 Controller View (web interface) 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 passportis 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 <!ELEMENT format record+ checkFormat? processPassport?> <!ATTLIST format name CDATA #REQUIRED type (fixed|dbf|mix) #REQUIRED > <!ELEMENT record attribute+> <!ATTLIST record name CDATA #REQUIRED type (fixed|dbf|mix) #REQUIRED action (import|link) #REQUIRED > <!ELEMENT attribute> <!ATTLIST attribute name CDATA #REQUIRED type CDATA #REQUIRED action (assign|link|validate|tmp) #REQUIRED columnName CDATA positionFrom CDATA positionTo CDATA ><!ELEMENT checkFormat (#PCDATA)> <!ELEMENT processPassport (#PCDATA)>

  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. Report example – table view

  26. Report example – bar chart view

  27. Report example – pie chart view

  28. Analytical reports builder

  29. Example of report generated by analytical report builder

  30. Informational system OGBD “Veterans” - development process • 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 mile stones

  31. Social Population Register Russian Federation - Irkutsk Region • 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 Corporate Information System

  32. 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

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

More Related