In the preceding issues of this newsletter, we have considered the basics of data modelling, data types, connections, identifiers and many other things. One point we have kept returning to is a fundamental rule of data modelling: Don’t make anything any more complex than you have to. Or to put it another way: Don’t store [...]
Last week in our modelling case study we walked a little farther down the path of providing a database in which we could store the information from an EPANET input file. This week, we finish our look at this example, but before we tie off the threads, let’s remember that the EPANET analysis is a [...]
EPANET Network Components – Database tables and rows, Part 3 (#20) In this case study we are going through the process of designing a database for storing the information contained in an input file for EPANET, software which can analyse water supply distribution networks. Well, it has been hard work going through our simple EPANET [...]
EPANET Network Components – Database tables and rows, Part 2 (#19) In this case study we are going through the process of designing a database for storing the information contained in an input file for EPANET, software which can analyse water supply distribution networks. The last post in our continuing case study modelled the spring [...]
In this case study we are going through the process of designing a database for storing the information contained in an input file for EPANET, software which can analyse water supply distribution networks. The last post waded through the definition of the physical data of our spring-tunnel-pool model. We put all the information into an [...]