Mega-SED of the Moscow government migrates from Oracle to Postgres

Since 2011, the Moscow government has been developing an electronic document management system based on the Practice product, connecting departments and budgetary institutions to it.

The SED allows civil servants to exchange information among themselves and work with citizens' appeals. Executive heads also have the ability to view and view documents outside the office walls using the mobile version.

2016: Migration from Oracle to Postgres

In May 2016, the Electronic Moscow IT contractor controlled by the Moscow government decided to migrate the array of information from the Moscow government's electronic document management system "in order to switch to a new technological platform and increase the level of fail-safe storage of system information from electronic document management."

As of May 2016, the Moscow SED is based on Oracle 11g Enterprise Real Application Cluster. The target system has chosen PostgreSQL, the documentation says.

The executor of the work was the company "Document Management Systems-Technical Center"^[1]. The amount of the contract is 41.8 million rubles.

The price includes "ensuring the ability to quickly restore operability," for which the contractor must place the components of the hardware and software complex with all information from the SED in at least two geographically spaced data centers for a period of 8 months.

Migration of the application system from one DBMS to another in the case of large amounts of data and phased switching implies the parallel existence of two systems for the transition period, "says Ivan Panchenko, Deputy General Director of Postgres Professional. - In one of the migration projects carried out by Postgres Professional, we, together with the developers of electronic document management, managed to significantly reduce the period of parallel operation of the two systems. However, in this case, the volume of data is significant and a large number of users, so for a long time the systems will work in parallel

According to the TA, 66 thousand users were connected to the Moscow SED as of May 2016, 100 million documents with a volume of 110 TB are stored in it.

2014: Development of SED implementation project

In April 2014, the DIT of Moscow reported that as a result of the development of the project, all executive authorities of the city and 1.8 thousand state institutions (polyclinics, schools, etc.) were connected to the SED. The number of users of electronic document management exceeded 46 thousand people. According to DIT employees, this is the largest state document management system in Russia.

According to officials, the exclusion of paper from business correspondence and the refusal of the services of paramedics, coupled with the transition to electronic document management, save the city about 100 million rubles a year.

2013: Translation of regulations into SED

After the implementation of the SED in 2012, the Moscow Department of Information Technology planned to develop and add modules with expanded functionality to the system, primarily for the creation and movement of regulatory legal acts, head of the department Artem Ermolaev told TAdviser.

Artem Ermolaev sees modular development of the SED of the capital

In his opinion, the modularity of the future system will allow you to more clearly formulate the needs of the IT systems of the city.

As of 2013, with the help of SED, it was impossible to put a resolution on any other document, all this was done on paper. "One of the key problems of transferring regulatory documents to the SED is a decrease in the number of approvals between departments, which can number up to a hundred," Ermolaev said.

One of the first regulatory documents in the SED was planned to translate the decisions of the city government.

At the same time, Ermolaev was sure that absolutely all the documents in the SED could not be translated. "Another problem is documents with labels" secret "and" for internal "use," he continued. "There are also quite a few of them and the main task facing us is to prevent their leaks."</blockquote>

As of 2013, about 12 thousand metropolitan officials were connected to the document management system. "By the end of the year, we will connect the rest. There are 21 thousand of us in total, "he said. The remaining unconnected people are people who will work with the system according to the "receive-send" scheme of documents and do not take a decisive part in the creation of documents.

2011-2012: Everyone will move to the cloud

With the new SED based on the "Practice" decision, the Moscow government began working in April 2011. At first, its use was carried out in pilot mode by a small number of people. In September 2011, a tender was held for 40 million rubles to provide Moscow executive authorities with access to the SED, which was won by Electronic Moscow, after which the number of users of the system went sharply up.

In February 2012, another state contract was concluded with Electronic Moscow - in the amount of about 145 million rubles. As part of it, it was planned to connect about 10 thousand more users to the SED. According to the director of the information technology department of Moscow Artem Ermolaev, in the same year another competition was to be held to cover the SED of the remaining users. "The second contract is essentially a prolongation of the first. It would be difficult to win him another company now, "Ermolaev said.

According to April 2012, about 4 thousand users were connected to the electronic document management system of the Moscow government. This included employees of the office of the mayor and government of Moscow, as well as over a dozen executive authorities. The total number of users in the city government exceeded 25 thousand people, and all of them over time had to switch to the use of SED.

According to Ermolaev, the SED made it possible to transfer about 75% of the document flow into electronic form. The reduction in costs on paper, printers and cartridges for them saved the city government over 16.5 million rubles a year. The delivery time of documents between executive authorities was reduced from three days (when delivered by the Russian Post) and half a day (delivery by courier) to 3 seconds.

For the work of the heads of the executive authorities of Moscow with the new SED, DIT purchased tablets iPad 2. Another major purchase of similar tablets was conducted for prefectural leaders.

DIT also said that for use in the Moscow government, the Practice solution was significantly revised.

"Zoo" Luzhkov

The DIT said that before the start of the use of SED on the basis of "Practice" in the Moscow government there was a whole "zoo" of different solutions: in total, there were 5-6 systems that were poorly integrated with each other. The creation of the SED for the city government began under the previous mayor of Moscow, Yuri Luzhkov, as part of the Electronic Moscow program. Her first round started in 2003 and was designed for five years. Then the program was extended until 2011.

In mid-2011, the Chamber of Control and Accounts published the results of its audit of the expenditure of funds on the informatization of Moscow for 2008-2010 and the first half of 2011. They spoke about the identification of financial violations in the amount of 282 million rubles and the amount of inefficiently used funds over 4 billion rubles. It also noted that the planned SED was never created.

Artem Ermolaev said that the first SED were an attempt to at least somehow automate the work of the city government. They extended to only a few departments of the government apparatus - the total number of users did not exceed 1 thousand people, and the functionality of these systems affected only the document flow (the current SED also allows for the organization of office work). One of these decisions in 2008 was introduced by the Envizhn Group, which won the corresponding contract in the amount of over 100 million rubles.

After the change of mayor of Moscow to Sergei Sobyanin, it was decided to abandon the old SED and switch completely to a new decision. According to Artem Ermolaev, the DIT considered it inappropriate to develop disparate systems left by their predecessors, and decided to create a centralized citywide solution.

Ermolaev said that it was necessary to transfer the government to electronic document management in a short time frame, for which it was difficult to calculate all the risks and deploy a solution on his side with all the infrastructure, so it was decided to follow the path of outsourcing SED as a service. In 2012, the old SED was practically not used^[2].

Notes