Aplana’s company has prepared an extensive review of usage scenarios for Windows Azure platform services. We are pleased to share with you this interesting document, which will be useful for any individual developers and companies involved in creating applications and considering the Windows Azure cloud as a platform for their solutions.
This manual consists of three parts, this is the final third part, in which you will learn about decision scenarios for state organizations. The first and second parts of the document are available on this and this links.

Solutions for state organizations
The cloud platform is a convenient platform for creating solutions for government organizations. Examples of such solutions can be a portal for government organizations and a content management system for publishing open data.
Portal for state organizations
The portal for state organizations is a solution based on the Microsoft Windows Azure cloud platform, which allows publishing various materials for public access to the web.
')
Content Management System (CMS) allows you to manage the publication of various resources on the websites of public authorities
The system is implemented on the Microsoft Windows Azure platform and is highly scalable, affordable, and fault tolerant.
The system allows you to manage website content at the level of 4 main types of resources - documents, services (online services for the public), data and multimedia.
The system is implemented as a web application with an interface that allows you to easily and visually manage various types of resources.
When working with documents, the system supports the following functionality:
- Document publishing
- Creating and editing a document card (metadata)
- Search for related documents and other types of resources
- Control of publication (workflow)
When working with multimedia data, the system supports the following functionality:
- Publication of multimedia data (photo, audio, video)
- Creating and editing metadata
- Placing video in Azure Media Services - streaming, quality optimization, depending on the characteristics of communication channels
- Search for related documents and other types of resources
- Control of publication (workflow)
When working with data, the system supports the following functionality:
- Data loading
- Visual presentation of data
- Data publication
- Providing access to data
- Search for related documents and other types of resources
- Control of publication (workflow)
When working with services, the system supports the following functionality:
- Placing services in Windows Azure
- Publishing a web interface to the service
- Publishing Software Service Access (API)
- Creating and editing the service description
- Search for related documents and other types of resources
The system supports the ability to collect and analyze data related to the use of resources published with its help.
- Number of hits
- Number of downloads
- Number of views
- Technical data about users (type of browser, type of abundant device)
Technical implementation of the system
- Services and data are available through program interfaces (API)
- Services - hosting (web / worker role)
- Data - Storage / Access, BLOB Storage
- Documents and multimedia are accessible via the web interface.
- Documents - CMS, SQL DB
- Multimedia - Azure Media Services, BLOB Storage
Platform for publishing open data
Solution “Platform for publication of open data” is a content management system (CMS, Content Management System) for open data
The solution is intended for IT departments of city administrations.
The solution can be used to load, visualize, publish and provide access to open data.
The solution is implemented on the Microsoft Windows Azure platform and is highly scalable, affordable, and fault tolerant.
In general, the process of publishing open data consists of the following steps:
- Data loading
- Data presentation
- Data publication
- Providing access to data
Before the data is directly downloaded by the data owner
- Data set definition
- Data cleansing
- Preparing data for loading
- Converting data to one or more formats supported by the platform
- Loading, displaying data in a tabular form for preview
- Ability to delete downloaded data - in cases where additional cleaning, transformation, etc.
- Metadata task — description of the loaded data set, filling in additional fields — category, type, update frequency, etc.
The visual presentation of the data is used in the publication process as a visual tool for checking the correctness of the loaded data and as a means for selecting one of several possible data representations.
In the process of data consumption, visualization is used to visually familiarize with the data, to obtain summary information, to find aggregated data and their representations for publication on websites.
The system supports the following options for visual presentation:
- Charts
- Mapping (with automatic creation of KML files)
- Widgets (for publishing on websites)
- Elements of infographics
Data publishing completes the data cycle and makes it available for consumption. After publication, data is available in the following views:
- Machine Readable (CSV)
- Tabular
- Cartographic
- The visual
Note The system supports automatic creation of meta tags for SEO.
Upon completion of the publication of data, a report is created, which specifies such parameters as the name and amount of published data, metadata, date and time of publication, the author of the publication, options for accessing the data, ways of their visualization, etc. - such a report may, for example, be published on the website to inform potential users of this data set.
Data access is implemented in the form of "layers". Each layer represents the data in a predefined form:
- "Lower layer" - data in machine-readable and / or table view
- "Middle layer" - data, in the form of a set of graphical representations
- “Top layer” - data presented in the form of aggregates, widgets, infographic elements - i.e. in statistically processed form
It is assumed that the transition from between layers will be supported - i.e. users will be able to go from the top to the bottom level, thus revealing the data sets in their entirety.
Platform Usage Examples
- Integration with city services
Platform as a provider and consumer of data from online urban services
- Single portal of the city
Platform as an interface to the city’s single portal
Platform as a means of creating and publishing infographics
Possible platform extensions
- Ability to automatically generate programmatic interfaces (APIs) to provide online data access
- The means of collecting data created by the population (crowd-sourcing). By analogy with open311
- Example: urban transport work
- Example: work online city services
- Use of mixed data (open data from other sources)
- Example: city-level data + region-level data
The system supports the collection of the following data about its use:
- Number of visits
- Most Popular Data Sets
- Most Popular Data Views
About Aplana
The company “Aplana” specializes in the development, testing and maintenance of software created in accordance with the specific requirements of customers and provides services for the implementation and integration of applications for corporate clients in the Russian and foreign markets. The company “Aplana” is a member of the Group of Companies “IT”, has representative offices in Russia, the USA and the UK.
Aplana is the official partner of Microsoft and has a number of Microsoft Partner Awards in the field of software development ... in 2013, Aplana received the Partner of the Year award in nominations ...
Aplana was the first Russian company to become a member of Azure Circle, a program that brings together Microsoft's leading partners who perform a full range of work on creating applications on the Windows Azure platform for corporate clients. Participation in this program allows Aplana to expand the range of services provided, raise the technical level and quality of projects implemented, and also provides the opportunity to attract Microsoft resources when searching for solutions to emerging issues and offering optimized design solutions.
The company employs developers who have passed the Designing and Developing Windows Azure Applications exam, confirming their qualification in the field of Microsoft platform and cloud technologies. In addition, Aplana has implemented a number of successful projects for Russian and foreign customers, including the Telegraph Media Group, UBM Medica, Sheremetyevo Airport and a number of other companies.