<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "normalizing database tables"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "normalizing database tables"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>normalizing database tables</title>
				<description><![CDATA[ Hi,

I was wondering why the featureCodes database has a multi-part field for the codes?  Why are the class and code not separated into different fields?  I see that there is a code "null" that does not appear at all in the geonames table.  I'd appreciate a description of the logic.  Thanks.]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1765.page#7173</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1765.page#7173</link>
				<pubDate><![CDATA[Wed, 10 Feb 2010 02:41:22]]> GMT</pubDate>
				<author><![CDATA[ arctos]]></author>
			</item>
			<item>
				<title>Re:normalizing database tables</title>
				<description><![CDATA[ You can store it in you database as you like depending on your needs. Normally it is not a good idea to fully normalize a database, but this is up to you and depends on your requirements and what you want to achieve.
A feature code of 'null' means that it is not known.

Best


Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1765.page#7178</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1765.page#7178</link>
				<pubDate><![CDATA[Wed, 10 Feb 2010 22:52:20]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
			<item>
				<title>Re:normalizing database tables</title>
				<description><![CDATA[ Merci Marc, I wanted to separate the feature class from the feature code, which are joined in a single field in the featureCodes.txt table, as well as removing the "null" in that table because it doesn't appear in the other tables.  Will this cause troubles in future updates of the source database?  Thanks.]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1765.page#7179</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1765.page#7179</link>
				<pubDate><![CDATA[Thu, 11 Feb 2010 00:39:16]]> GMT</pubDate>
				<author><![CDATA[ arctos]]></author>
			</item>
			<item>
				<title>Re:normalizing database tables</title>
				<description><![CDATA[ 'null' is the database null, not the value 'null'.
The featureCodes.txt file is just a file. In the geonames database there is no such table. 

Best

Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1765.page#7185</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1765.page#7185</link>
				<pubDate><![CDATA[Thu, 11 Feb 2010 20:21:42]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
	</channel>
</rss>