|
MG>(hopefully quick) comments below.. > From: subscriber@xxxxxxxxxxxxxx > CC: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: metadata development > > Dara Olson wrote: > > > > Happy spring. MG>Happy Spring.. > > > > I am new to postgres/postgis and am trying to figure out the best way > > to approach documenting metadata within postgres. Has there been > > anything developed to add FGDC or Dublin Core standard metadata > > records into postgres for each table within the database? Is there > > any program that can access postgres to insert metadata based on a > > standard or any other way to document metadata for a postgres > > database? Any help, suggestions or advice from prior experiences > > would be greatly appreciated. > > > > Thanks in advance. > > > > Dara > > > I'm curious how this would be useful. Why would you want to associate > that sort of information with tables as metadata? Dublin core is a > metadata standard for "information resources" like documents (Tile, > Creator, Publisher, Author, Rights, etc), and FGDC is Geographic data. I MG>In that case you would want to look at PostGIS which will create/geo-encode/address-MG>decode GIS Spatial entities contained within polygon/sphere/circle MG>http://postgis.refractions.net MG>As the postgis library covers volumes of information please feel free to email me offline > can easily imagine wanting to store such information in your database > using actual tables, as information about "entities" represented in your > database schema, but I don't think attaching it as metadata to a table > is really an appropriate solution. But I don't understand the scenario > you have in mind, and perhaps you could explain the scenario where this > makes sense. MG>Thus the reason for accessing Database information schema MG>http://www.alberton.info/postgresql_meta_info.html > I suspect you are reaching for database metadata simply because these > standards are often described as metadata; but these are usages of the > word "metadata" in very different contexts. What is called metadata in > many contexts is simply becomes data from the context of using a > relational database to represent it. MG>metadata means the Data which represents the structure of the referring entity MG>in a PostGIS system metadata would be SpatialID, ESRI codes and so forth MG>In a document centric system you would need to understand Templates,Formats MG>and or stylesheets (to apply to a renderer to produce the document) MG>In a Secure Enterprise System a document might require specific permissions MG>such as what a Clinical Investigator might require for a drug study MG>An example of a comprehensive secure enterprise system please refer to MG>http://www.oracle.com/industries/life_sciences/oracle-clinical.html > Eric MG>Martin > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general Quick access to Windows Live and your favorite MSN content with Internet Explorer 8. |
