Collaboration and Content Customer solution case study The Yaroslavl region Government creates knowledge base of public authorities of the Yaroslavl region вЂњDIAramaвЂќ Alexander Elin, CEO firstname.lastname@example.org About the client пЃµ Department of information and analytical support of the state government of Yaroslavl region (DIA) is an executive authority and is responsible for the preparation and analysis of various information, necessary for the activity of public authority of the Yaroslavl region. пЃµ The authority of the Department includes the task of forecasting the economic situation, the development and modernization of information systems and resources, the introduction of electronic document circulation between public authorities of the Yaroslavl region and etc. пЃµ Information and analytical Department is also responsible for keeping the Register of state information resources of the Yaroslavl region. Situation пЃµ There was a significant amount of information systems and the databases developed both by employees of public authority of the Yaroslavl region and external developers at the end of 2008. пЃµ These decisions were developed on various platforms and had various storages of data. Besides, some systems couldn't be modernized due to the lack of initial codes or the termination of support from developers. пЃµ Administration of disparate systems is also a major limitation in their use. пЃµ These factors greatly reduce the efficiency of government employees, which significantly affected the timing of the various administrative decisions. пЃµ Besides the impossibility of operative, analysis and use of various information reduced its value. ClientвЂ™s needs: пЃµ for integration of different information resources in a common information knowledge base; пЃµ for creating of powerful data storage and search engine; пЃµ for creating comfortable environment administration and development, with a high level of security. пЃµ In addition to this system were presented serious requirements on the subject of opportunities for joint use of the documents, the publication of resources in the public domain and opportunities not only the organization of the backup storage, but rapid data recovery in case of emergence of critical situations. Tasks of the project пЃµ Design and development of a common platform for storage, processing and search of the necessary information using only the subtle client; пЃµ Migration of the existing system to the new platform; пЃµ Use of available IT infrastructure of the customer; пЃµ Implementation of a search engine to search through the documents and their contents; пЃµ Migration of different information systems and resources of the created platform; пЃµ Development of additional functionality; пЃµ Introduction of technologies of display the contents; пЃµ Increase of efficiency of joint work of employees; пЃµ The ability to reduce costs through the use of modern technology. Solution Considering the needs of customers, the ALAN Company proposed implementation of a solution for building a knowledge base on the platform of Microsoft SharePoint Server 2010 certified by Federal service for technical and export control of Russia, and the search engine Microsoft Fast Search Server 2010 for SharePoint, which will be designed to: пЃµ The modernization and expansion of existing systems and adding new information resources and technologies; пЃµ Organization of a unified data storage; пЃµ Provide through search of documents and their contents; пЃµ Integration with other information systems and resources devoted to the work of public authorities of the Yaroslavl region. Solution Main page Solution State reference data base of legal acts Solution Significant advantage of this solution is the ability to integrate and use the following functional above products: пЃµ Microsoft Lync Server 2010 - notification of the presence of the users and the organization of conferences and use of the service corporate telephony, will allow efficient organization of business communication and operational work with documents; пЃµ Microsoft Exchange Server 2010, exchange of electronic messages, letters, documents, organization of meetings, appointments, contacts, and calendars will ensure the effective development, introduction and analysis of data stored in the knowledge base; пЃµ Microsoft SQL Server 2008 R2 - use of the possibilities of the reservation information, clustering in the Active-Passive mode, will provide the knowledge base in the event of failure of the primary equipment; пЃµ Microsoft System Center Data Protection Manager 2010 - the possibility of organizing not only the backup storage of data, but also compute their recovery, will allow to organize an uninterrupted work of a knowledge base and restore the information accidentally damaged or deleted by users. The reasons of our choice are the following indicators: The main reasons for which the ALAN Company chose solution based on Microsoft SharePoint Server 2010 and Search Engine Microsoft Fast Search Server 2010 for SharePoint are: пЃµ Reduction of expenses; пЃµ Simplicity of ensuring high availability and emergency restoration; пЃµ Simplicity of administration and smaller dependence on a support service; пЃµ Convenient access to information; пЃµ Increase of efficiency of users; пЃµ Observance politician of preservation; пЃµ Information is protected from viruses. Microsoft SharePoint Server 2010 helps to protect the stored information due to the fact that the built-in protection from spam and support for a wide range of anti-virus products of exterior developers. We faced with following difficulties: пЃµ Full or partial lack of source code migrated products and solutions; пЃµ Lack of carriers of knowledge about available solutions and technologies that were previously implemented by the Customer; пЃµ Termination of the support of the existing decisions on the part of foreign developers; пЃµ The presence of the encrypted content in some migrated products; пЃµ The absence of direct mechanisms of migration data, the need to develop additional software for migration; пЃµ Limited time period. The main components of the architecture of the knowledge base В«DIAramaВ» are: пЃµ The domain controller; пЃµ The database server Microsoft SQL Server 2008 R2 is used to store the database on Microsoft SharePoint Foundation; пЃµ The farm consisting of three Microsoft SharePoint Server 2010 SP1 servers. It is used for the access and display. On these servers roles are placed: Web service Web Analytics, SharePoint Server search, service of data processing of Web Analytics, service of profiles of users, service of the timer of working processes of Microsoft SharePoint Foundation, administration center, service PowerPoint, service Word Viewing, service of parameters of sites and inquiries of search, service of calculations of Excel; пЃµ Server farm FAST Search Server 2010 for SharePoint SP1 is used for indexing and organizations search by content; пЃµ Microsoft Data Protection Manager 2010 is used for backup and recovery; пЃµ Microsoft System Center Operations Manager 2012 is used for the monitoring of the system; пЃµ Microsoft System Center Virtual Machine Manager 2012 is used for placement and administration of the virtual machines. Advantages пЃµ Single sign and authorized user access, full integration with a directory service; пЃµ The possibility of the effective administration; пЃµ Ability to index and search not less than 100 million documents; пЃµ Possibility to use the media library; пЃµ Possibility of opening the users of the knowledge base of Microsoft Word documents, Microsoft Excel, Microsoft PowerPoint, Microsoft OneNote using the browser; пЃµ New search engine on the basis of Fast Search Server 2010 for SharePoint; пЃµ Secure communications between all parts of the knowledge base; пЃµ Reduction of the level of the overall costs of maintenance of the knowledge base В«DIAramaВ»; пЃµ New functional module of knowledge base В«DIAramaВ»: State reference data base of legal acts of public authority of the Yaroslavl region; пЃµ New functional module of knowledge base В«DIAramaВ»: the Base of data of the statistical information; пЃµ New functional module of knowledge base В«DIAramaВ»: В«InfotekaВ», intended for the input, accumulation, content-analysis and monitoring of mass media messages, as well as for monitoring and analysis of the socio-political situation in the Yaroslavl region, implemented in the framework of the knowledge base В«DIAramaВ» пЃµ Integration with the system of electronic document circulation В«DirectumВ»; пЃµ Integration with the regional information-analytical system of the Yaroslavl region; пЃµ Integration with the analytical systems В«X-filesВ» and В«Analytical courierВ» Close corporation В«I-TecoВ». Results of the project The developed solution allowed: пЃµ to consolidate in one place a few scattered earlier systems and sources; пЃµ to provide centralized storage; пЃµ to provide search and retrieval of unstructured and semistructured data. Using this solution will significantly: пЃµ to reduce time costs; пЃµ to improve productivity; пЃµ to improve quality of decisions made both by individual employees of state power of the Yaroslavl region, and the regional administration in general. Thanks for your attention!