[comp.databases] info on facilities management database

erickson@scout.macc.wisc.edu (Alice Erickson) (01/24/91)

I am submitting this for a user who does not have access to the
net. Please direct responses to me and I will forward them.
Thanks,
 
Alice Erickson



Space Management's plans for Facilities Management System:
 
          Our objective is to phase implementation of an
     integrated computer-based Facilities Management Information
     System (FMIS), utilizing our existing building/room-record
     database files (14MB+) on a mainframe and the AutoCADD
     building files we have been developing on stand-alone 386
     PC's.   The FMIS should, for example, be capable of
     supporting linkages to Physical Plant preventive maintenance
     functions and ultimately to a GIS application.  Currently,
     database queries are non-interactive and reports are
     generated from batch files.  Planned implementation options
     must permit gradual and step-wise integratability as funds
     and staffing become available over a 5 year period.  We seek
     ideas and suggestions regarding the selection of a database
     (such as INGRES), GIS software, hardware and network
     issues, and any recommendations or problems encountered by
     other space &/or facilities management personnel.  As
     stated, any alternative selected must take into account our
     anticipated future expanded uses as well as data security.
 
 
 
 
 

attila@breeze.bellcore.com (01/25/91)

In article <ERICKSON.91Jan24083217@scout.macc.wisc.edu> erickson@scout.macc.wisc.edu (Alice Erickson) writes:
> I am submitting this for a user who does not have access to the
> net. Please direct responses to me and I will forward them.
> Thanks,
>  
> Alice Erickson
> 
> 
> 
> Space Management's plans for Facilities Management System:
>  
>           Our objective is to phase implementation of an
>      integrated computer-based Facilities Management Information
>      System (FMIS), utilizing our existing building/room-record
>      database files (14MB+) on a mainframe and the AutoCADD
>      building files we have been developing on stand-alone 386
>      PC's.   The FMIS should, for example, be capable of
>      supporting linkages to Physical Plant preventive maintenance
>      functions and ultimately to a GIS application.  Currently,
>      database queries are non-interactive and reports are
>      generated from batch files.  Planned implementation options
>      must permit gradual and step-wise integratability as funds
>      and staffing become available over a 5 year period.  We seek
>      ideas and suggestions regarding the selection of a database
>      (such as INGRES), GIS software, hardware and network
>      issues, and any recommendations or problems encountered by
>      other space &/or facilities management personnel.  As
>      stated, any alternative selected must take into account our
>      anticipated future expanded uses as well as data security.
>  


You might like to know that Symbolics, Inc. specialises in this sort of
thing.  They produce many software tools including Statice,
object-oriented dbms, Joshua, an expert system shell.  Joshua is highly
integrated with Statice and can reason over Statice object instances.
Pretty fancy.

Various consultants, researchers, as well as Symbolics itself have
written planing, scheduling, and GIS systems using Statice or Statice +
Joshua together.

For planning and physical plant scheduling/operations see last fall's
issue of Release One!  It describes a system built using Symbolics
Statice and other SMBX tools.  The customer was Houston Power and Light
and the consultant is
	Tom Shepard,
	713/861-9269
Shepard@mckenzie.s&c.dialnet.symbolics.com (Tom Shepard)

and if I recall correctly Bill Gooch also worked on it.
	William Gooch
	6429 Spicewood Springs Road
	Austin, TX 78759
	512/346-3868

Other relevant consultants available by asking for a catalog from
	slug-consulting@ai.sri.com

Symbolics itself has built a system for Lufthansa.  It is quite
sophisticated.  The reasoning services are provided by Joshua and the
large data volumes are managed by Statice. 
	Symbolics, Inc.		
	Eight New England Executive Park, East
	Burlington, MA 01803
	617/221-1000
	Telex: 948686
	FAX: 617/221-1099

There is a commercial GIS called GeoFlavors from
	Ball System Engineering
	Suite 500
	9605 Scranton Road
	San Diego, ca 92121
	619/457-5550
They are not really a software house, so they do not actively market
this.  However the system is very nice.

I built (and am building) a GIS using Statice for Gbyte sized complex
problems.  The system is currently implemented in two different oodbms,
Statice and another, and will be implemented using a third oodbms later
this year.  One of our objectives is to compare the various oodbms.
It is my impression so far that very few dbms can actually handle Gbyte
sized GIS and produce a flexible data model.  Statice is one of the
select few.
[I am *not* a consultant, do *not* sell software.]

Leslie A. Walko
Bell Communications Research
Database and System Research Group
attila@bellcore.com