Data Model for Layered Service Delivery Platforms
Back to the Data Model

Below we show details of our first Platform, which is Everyday Events.
We are planning to go live with this on October 6th., which is Barry's birthday, if our offshore team delivers.

Cloud Services Delivery Platforms

Generic Platform Architecture


Some Typical KPIs


Platform Architecure
EE is target for October 6th Deliverable Plan

Ocober 6th. Plan

Add Logistics, Hotel and Bank for POC by Friday, Nov 6th. for validation.

This table shows the Generic Services used in selected Vertical Applications.

  EE Bank Hotel Log
Move Yes     Yes
Pay Yes Yes Yes Yes
Reserve     Yes Yes
Service Yes Yes Yes Yes


This is the Logical Data Model for the October 6th. Development Platform for Everyday Events
for the Plan shown above and to the right.



Reference Data (eg Document Definitions, Platforms) and Master Data (eg Addresses, Customers, Documents ,Document Definitions, Locations, Services and Staff) will be pre-loaded.

Transaction Data (eg Payments and Service Requests) will be entered by the User through the Apex Application.

This is data that has been created for demonstration as an Apex Report on October 6th. thanks to Robertson's hard work ;-0)
The numbers are ID Record identifiers in the corresponding Apex Table in the Data Model above
Max Workspace is A13674, user baryw@dba.org, with m123.

The Report will look like this :-


Service Requests On September 10, 2015 Norma drives to the BP Gas Station. On September 10, 2015 Norma drives to the Westfield Shopping Centre. On September 10, 2015 Barry eats at Tapas Revolution in the Westfield Shopping Centre. On September 10, 2015 Norma goes to see The Commitments in the Palace Theatre. On September 26, 2015 Barry stayed at the Radisson Blu Hotel in Heathrow. On September 26, 2015 Norma goes to see the Jersey Boys in the Piccadilly Theatre. On October 6, 2015 Barry goes to see Memphis in the Shaftesbury Theatre. On October 6, 2015 Barry stayed at Claridges Hotel in London.
The next Section shows the demo data that will produce the Report show above.
The initial SQL looks something like this :-
SELECT Customer_ID
FROM   Customers
ORDER  BY Customer_ID

For some strange reason, this perfectly good SQL produces an error message :-
ORA-00942: table or view does not exist
Service Requests (each SEervice Request has 3 parameters, each with an ID)
10 On September 10, 2015 Norma (Customer ID=11) drives to (Service ID=10) the BP Gas Station (Location ID=16)
11 On September 10, 2015 Norma (11) drives to (10) the Westfield Shopping Centre (14)
12 On September 10, 2015 Barry (10) eats at (11) Tapas Revolution in  the Westfield Shopping Centre (13)
13 On September 10, 2015 Norma (11) goes to see (12) The Commitments in the Palace Theatre (11)
14 On October   10, 2015 Barry (10) stayed at (13) the Radisson Blu Hotel in Heathrow (17)
15 On October   10, 2015 Norma (11) goes to see (12) the Jersey Boys in the Piccadilly Theatre (13)
16 On October   12, 2015 Barry (10) goes to see (12) Memphis in  the Shaftesbury Theatre (12)
17 On October   12, 2015 Barry (10) stayed at (13) Claridges Hotel in London (15)
Services
10 drives to
11 eats at
12 goes to see
13 stayed at
Customers
10 Barry
11 Norma
Locations
10 the Commitments in the Palace Theatre
11 the Jersey Boys in the Piccadilly Theatre
12 Memphis in the Shaftesbury Theatre
13 the Tapas Revolution in Westfield
14 the Westfield Shopping Centre
15 Claridges Hotel in London
16 the local BP Gas Station
17 the Radisson Blu Hotel in Heathrow



© Database Answers Ltd. 2015