We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

PostgreSQL experience in Russian Parliament

Formal Metadata

Title
PostgreSQL experience in Russian Parliament
Subtitle
Success story of PostgreSQL in Russian State Duma
Title of Series
Number of Parts
31
Author
Contributors
License
CC Attribution 3.0 Unported:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Identifiers
Publisher
Release Date
Language
Production PlaceOttawa, Canada

Content Metadata

Subject Area
Genre
Abstract
In 2010 Russian State Duma (lower chamber of parliament) renewed its web site. That was the first step in modernization towards open data and e-goverment in further years. PostgreSQL took a central place in data integration between intranet systems and open web services. During recent years many new open data systems were launched powered by PostgreSQL. This talk covers the issues of PostgreSQL integration into State Duma intranet systems, which were mostly running Oracle Database as well as implementation of many open data systems. Data between intranet systems and PostgreSQL databases are mostly synchronized using ora2pg. Full synchronization was used for small databases as well as incremental synchronization for large databases. Open data systems implemented on PostgreSQL including: Law and draft law search systems Open vote system Verbatim system Using PostgreSQL database allows to save license const as well as achieve great performance and features.