Acorn Solutions Inc Selected Project Details Don Rich

Acorn Solutions, Inc. Selected Project Details Don Rich Chief Executive Officer June 1, 2003 Selected Project Details - Acorn Solutions Proprietary

Selected Projects • • Mobidoc M-Com Delivery Confirmation IMAS KPNC Intranet SSII ATP Reviewer’s Application Acorn Solutions, Inc. Selected Project Details - Acorn Solutions Proprietary 2

Mobidoc Overview • A prototype to research the use of ambulance locations to automatically trigger hospital preparation actions Acorn Solutions, Inc. Selected Project Details - Acorn Solutions Proprietary 3

Mobidoc Functions • Process and store AVL (automated vehicle location) data feed • Estimate ambulance’s arrival & departure times using location • Display ambulance location, estimated & actual times on PDAs & hospital workstations • Send alphanumeric pages to doctors, nurses, & staff with ambulance status Acorn Solutions, Inc. Selected Project Details - Acorn Solutions Proprietary 4

Mobidoc Architecture • • Microsoft IIS MS SQL Server Active Server Pages VB custom objects HTML display pages Java-based paging objects Palm Query Application display pages AVL data passed via XML messaging over HTTP Acorn Solutions, Inc. Selected Project Details - Acorn Solutions Proprietary 5

M-Com Overview • A consumer information device to provide locationaware data services via wireless data network Location-Based Service Requests During Field Trial Acorn Solutions, Inc. Selected Project Details - Acorn Solutions Proprietary 6

M-Com Example Services • Find nearest – Shopping, Entertainment, ATM, Gas Stations, Hospitals, Hotels, Restaurants, Special Events, Subway/Bus Stations, Museums • Call a cab to current location • Maps / turn-based directions Acorn Solutions, Inc. Selected Project Details - Acorn Solutions Proprietary 7

M-Com Architecture • Mobile handheld client communicating to multiple servers via wireless Internet • Server responds with data relevant to client request using current device position Acorn Solutions, Inc. Selected Project Details - Acorn Solutions Proprietary 8

M-Com Clients • Hardware – Palm VII PDA wirelessly connected to the Internet via Palm. net – Custom-made GPS hardware • Software – Custom C software for data request & display – Palm Query Applications Acorn Solutions, Inc. Selected Project Details - Acorn Solutions Proprietary 9

M-Com Server Infrastructure • VB for data ingest, data filtering, maps and turn-based directions generation • Custom Active Server Pages for messaging • Windows NT, 2000 • Microsoft IIS • MS SQL Server Acorn Solutions, Inc. Selected Project Details - Acorn Solutions Proprietary 10

Delivery Confirmation Overview • A web-database application and infrastructure for tracking equipment deployment and problem resolution • A large-scale problem: – – 50 states 300, 000 devices 20, 000 sites 20+ step process Acorn Solutions, Inc. Selected Project Details - Acorn Solutions Proprietary 11

Delivery Confirmation Features • Search and retrieval – – Scheduled completion date ZIP code or region Network addresses Task or milestone status • Data entry – Configuration changes – Status changes – Repair orders • Status display – Color-coded maps – Pie / bar charts – Summary and detailed reporting Acorn Solutions, Inc. Selected Project Details - Acorn Solutions Proprietary 12

Delivery Confirmation Technologies • • • Windows NT Microsoft IIS Active server pages HTML & Javascript Oracle database Map. Info image server • 3 rd-party charting image server Acorn Solutions, Inc. Selected Project Details - Acorn Solutions Proprietary 13

Delivery Confirmation Samples Acorn Solutions, Inc. Selected Project Details - Acorn Solutions Proprietary 14

IMAS Overview • A network and computer monitoring system to automatically detect problems and then generate the appropriate help desk trouble-tickets • Most common problems handled: – Over-utilization: disk, CPU, or memory – Failures: RAID, NT service, nightly backup – Security: virus detected, account lockouts – Other: UPS trip, custom applicationgenerated Acorn Solutions, Inc. Selected Project Details - Acorn Solutions Proprietary 15

IMAS Features • Highly scalable – 100, 000+ node network of Windows NT, Novell Netware, and Unix servers and workstations • Fully automated – no end-user call or help desk support required until after a ticket is created and assigned • Fault-tolerant – redundant server design to support automated recovery from server failures • Intelligent – event correlation reduces common-mode failures to a single trouble-ticket Acorn Solutions, Inc. Selected Project Details - Acorn Solutions Proprietary 16

IMAS Process • • Detect undesired event on client Convert event to SNMP trap Send trap event to IMAS server Correlate and filter related trap events to reduce event cascades • Convert filtered traps to troubletickets and assign to appropriate staff Acorn Solutions, Inc. Selected Project Details - Acorn Solutions Proprietary 17

IMAS Technologies • • Windows NT Novell Netware HP-UX Solaris MS SMS HP Openview Remedy ARS Custom software in VB & Korn shell • Seagate Nerve Center Pro Acorn Solutions, Inc. Selected Project Details - Acorn Solutions Proprietary 18

KPNC Intranet • A suite of Intranetbased business applications, document content, and required supporting infrastructure to support the NC regional business offices Acorn Solutions, Inc. Selected Project Details - Acorn Solutions Proprietary 19

KPNC Intranet Content • Document library – HTML, MS Word, PDF, and flowchart files for internal and patient use • Databases / applications – Phone numbers & addresses – Pharmacy formulary – Network outage schedules & events – Patient treatment protocols Acorn Solutions, Inc. Selected Project Details - Acorn Solutions Proprietary 20

KPNC Intranet Technolgies • • • Windows NT Microsoft IIS HTML & Javascript Active server pages SQL server Acorn Solutions, Inc. Selected Project Details - Acorn Solutions Proprietary 21

SSII Application • A Web- and VB-based laptop data acquisition and display system • Features: – Configurable data thresh-holds & collection filtering – Configurable map display with audible alarms – Data logging & replay capability Acorn Solutions, Inc. Selected Project Details - Acorn Solutions Proprietary 22

SSII Technologies • Hardware – Laptop – Sensor radio receiver • Software – – – Win 95 MS Access database Personal web server Active server pages Custom VB application for data collection – HTML, Javascript for display and configuration Acorn Solutions, Inc. Selected Project Details - Acorn Solutions Proprietary 23

ATP Reviewer’s Application • A web-database application for online evaluation of research proposals • Features: – Survey-oriented interface – Drop-down navigation menus – Automatically saves intermediate results – Spell-checking and correction Acorn Solutions, Inc. Selected Project Details - Acorn Solutions Proprietary 24

ATP Reviewers Application Technologies • • Windows NT Microsoft IIS SQL Server Oracle HTML Javascript Active server pages Acorn Solutions, Inc. Selected Project Details - Acorn Solutions Proprietary 25

Thank You! Acorn Solutions, Inc. Selected Project Details - Acorn Solutions Proprietary 26

Contact Information • Acorn Solutions can be reached by any of the following: E-mail: Phone: Web: Surface: Acorn Solutions, Inc. info@acorn-solutions. com 919 -85 -Acorn http: //www. acorn-solutions. com 306 Camden Branch Drive Cary, NC 27511 Selected Project Details - Acorn Solutions Proprietary 27