A database model is the theoretical foundation of a database and fundamentally determines in which manner data can be stored, organized, and manipulated in a database system. It thereby defines the infrastructure offered by a particular database system. The most popular example of a database model ...

learn more… | top users | synonyms

5
votes
2answers
282 views

Adding transportation schedules to a network dataset

How do I add transportation schedules to a multimodal network dataset? For example, Bus 1 runs between 08:00 and 16:00, and Bus 2 between 14:00 and 23:00. If a passenger wants to solve for a route ...
8
votes
3answers
723 views

Which tool is recommended for a PostGIS design?

I need to create a design for a spatial database. I've found this list http://wiki.postgresql.org/wiki/GUI_Database_Design_Tools, but it seems to me that this software is orientated towards a regular ...
1
vote
3answers
968 views

ArcSDE & Oracle & Database Model — Best diagram the system

Having Oracle dbms with ArcSDE and ArgGIS Pipeline Database Model (APDM), I would like to best describe the system with a diagram. In MS SQL each db is autonomous, I think, meaning ArcSDE(using dbo ...
2
votes
3answers
642 views

What is the maximum, allowable field length for a FacilityID field in a Cityworks geodatabase?

Over the past couple of months, I have seen a few esri-geodatabases and they seem to be either a text field with a length of 20 or 30. Is 30 the maximum field length? Clarification: The answer I'm ...
6
votes
5answers
1k views

What are convenient uml tools to create geodatabase models?

I used to model databases with Microsoft Office Visio, then export the model to xml and import geodatabase schema to GDB with ArcGIS tools. Since Microsoft no longer support Visio export to xml, what ...