Database Answers Click for vision of Databases everywhere

Home Ask a Question Best Practice Careers Clients Data Models Search Site Map About Us Contact Us
The Proof-of-Concept for BMEWS with Microsoft  Tools 
  Specifications for the Proof-of-Concept using the Microsoft Toolset
 
This is our Vision of the Future
Implementation Options
Ubiquitous Generic Data Platform with Events, XML Messages, Msg Broker and RSS Feeds

Our Vision of the Future
Our Vision presents some very interesting challenges, and this Proof-of-Concept explores them with the aim of building a State-of-the-Art demonstration to show what can be achieved in late 2010.

Microsoft Software Tools
Microsoft might provides some useful facilities :-
  • A Mashup Center
  • A Spatial extention to SQL Server.
    The UK Government has started an Open Data Initiative
    (with the help of Tim Berners-Lee), which includes Mashups from Talis.



    Microsoft has developed two interesting facilities :-
  • PivotViewer Data Visualisation Tool
  • Single View of the Government

    Status :-
    1. About to get started.
  • This is our Vision of the Data Architecture for the Future
    Implementation Options
    Dashboards, Widgets, Messages,Web Services, Object Formats, Publication Methods and RSS Feeds

    Data Architecture of the Future
    This Architecture provides a wide range of Digital Assets of different formats with an indication of how the different Media can be processed.






    Status :-
    1. Definition of the Data Architecture is in progress.
    This is the kind of data that a typical Family will be interested in.
    Implementation Options
    Widgets, Web Services, Publish and Subscribe Facilities and RSS Feeds

    3-D Streets
    User Scenarios
    User Scenarios are a very powerful technique.
    In this case, let's imagine a typical Family planning to move to London.England.

    They would like to find good schools, compare crime statistics, hospitals, the price of houses and so on. The underlying Data Model is shown on another page.

    Here is a Vision of the Future of Databases, and you can check out our Presentations.

    This Vision brings up some very interesting challenges, and this Proof-of-Concept explores them with the aim of building a State-of-the-Art demo.

    Status :-
    1. Microsoft Products to be determined, eg SQL Server GeoSpatial extensions.

    This shows a BI approach, with Traffic Lights showing Red, Amber or Green depending on the situation for three types of data - Cleanliness, Vandalsim and Ethnic Origin.
    Implementation Options
    Data Marts, Generic Design with Data Wrappers, KPIs, Dashboards and Web Services

    Traffic Lights (Red-Amber-Green)


    Microsoft Software Tools used here :-
    1. SSIS

    Status :-
    1. About to get started.
    This is the underlying Data Platform
    Implementation Options
    Global Data Platform, MDM and Web Services

    Data Platform (Click for large image)


       

    Microsoft Software Tools used here :-
    1. Single View Platform

    Status :-
    1. About to get started.

    This shows the POC SOA Middleware Layer with an Enterprise Service Bus and so on.
    Implementation Options
    Generic Data Marts, MDM, Common Data Model, Enterprise Svc Bus and Web Services

    POC SOA Architecture (Click for separate Page)

       
       

    Microsoft Software Tools used here :-
    1. SSIS
    2. Master Data Management (MDM)
    3. SQL
    4.
    Enterprise Service Bus

    Status :-
    1. About to get started.

    About Us Contact Us