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