We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [database-model]

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 is the relational model.

Filter by
Sorted by
Tagged with
5
votes
3answers
615 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
2k 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
1k 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 ...
3
votes
2answers
825 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 ...