Michal Kubenka

13 reputation

	13 reputation	bio	website		visits	member for	1 year, 2 months
2 badges		location			seen	Mar 27 at 23:46

6 Actions

Apr 11	awarded	Scholar
Apr 11	accepted	How to design a database for continents, countries, regions, cities and POIs?
Apr 9	comment	How to design a database for continents, countries, regions, cities and POIs? @Russell Actually what we need is some hierarchical base for relationship between countries, cities, regions, etc. Main goal of the application will be collecting tourist data from many sources about specific cities, regions, countries and so on, and store it in database. Let's say we will have city Rome, we collect some info about this city into database from couple sources. And we need to know that Rome is in province Rome, sub-region Lazio in region Lazio, country Italy. So system should be flexible to allow create such relation from real world.
Apr 9	comment	How to design a database for continents, countries, regions, cities and POIs? In our model we can consider city as point not as polygon, so it won't be in same table. Our main goal is mining data about elements (from continents to POIs), but we need have it in some hierarchical tree which can handle most common situations of organization.
Apr 9	awarded	Student
Apr 9	asked	How to design a database for continents, countries, regions, cities and POIs?