Database Answers Customer Service
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Operational Support Services for Small and Medium Enterprises (SMEs) 
An Access Database is available on demand.
Apex provides the Service Delivery Platform.

If you are new to Data Models, this page of my new Tutorial will help you understand the Data Model.
There might also be a design for a Data Mart, which is very useful for providng data for Reports and Business Intelligence.
In late September, The New York Times announced that for over $8billion SAP had acquired Concur, a supplier of Services to manage employees’
invoices, travel and expenses, (but not Timesheets or Event Management).
Here's a comment on the high price that SAP paid and here is a Guide to PSA Software
Our House Style will be simple, somewhat like BidSync, Concur, Quick Timeseheets and Nicola Askham and using Oracle Apex.

We plan to get started by developing a Timesheet Service, followed by Services for related functions like Expenses and Invoices ...
This page is a good idea for our OSS Home Page, as it is now and as it will be

Our OSS Services for SMEs to be released in Phase 1 :-
  • Expenses
  • Invoices
  • Timesheet
    Then
  • Reservations
  • Professional Services
  • Event Planning (Check out Cvent)
  • Travel
  • an Event-based Service Delivery Platform that anybody can use to build their own applications.
    Features in PSA Software, according to Software advice include :-
  • Billing & Invoicing
  • Core Accounting
  • Help Desk
  • Knowledge & Document Management
  • Procurement & Inventory
  • Project Accounting
  • Project Management
  • Resource Management
  • Sales & Account Management
  • Time & Expense Tracking
  • Step 1. This is our Canonical Data Model ...


    Step 2. This Conceptual Data Model
    shows how it applies to Professional Services :-

    Conceptual Data Model for OSS for SMEs
    Step 3. Then we create this Model from the Subject Areas...

    Logical Data Model for DBA Packaged Services
    Step 4. And these are the Subject Areas :-
  • Clients and Fees
  • Customers and Events
  • Customers (Generic)
  • Documents
  • Payments and Events
  • Payments Subject Area
  • Staff
  • Suppliers
    Step 5. These are the Entities we plan for Phase 1 - "Service Requests" ...
  • Documents
  • Events
  • Offices
  • Services
  • Service Requests
  • Staff
  • Suppliers
  • Master Data includes :-
  • Clients, Services, Staff, Suppliers.
  • Reference Data includes :-
  • Types of Documents, Events and Services.
  • Max Workspace
    Workspace is A13674, user baryw@dba.org, with m123.

    Data loaded so far includes :-
  • Reference Data
  • Master Data
  • Transaction Data

    Barry Williams
    Principal Consultant
    Database Answers Ltd.
    London, England
    December 21st. 2014


  • © DataBase Answers Ltd. 2014
    Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map