Using px web with CNMM database

[Victoria Pitetta]

 I have a question about the metadata. Is there a tool or interface to load the metadata without doing the inserts directly on the database? I'm not sure if that's achievable with px edit or another tool. 

[Stefan Jul Gunnersen]

Hi Victoria,

As far as I know there are various applications around the world doing just that, but they are tailored for each specific setup. In Statistics Denmark we have a bunch of applications that manipulates the database content and have adapted the data model accordingly to support more or different functionality. In Statistics Sweden they have a program called PX Meta that does much the same, but in different ways. 

It would be handy to have a generalized application that can help automate creation of metadata (and handle data tables) in the database, but I do not believe there is a "one fits all" approach. Else, I would love to hear more about such a tool.

And even if we could share our application you would not be able to use it for various reasons, the most important being that is it implemented for our specific use of databases and our handling and dissemination of data.

I am sure other people in the group can supply you with further information and I would like to get different angles on this.

Kind regards,

Stefan Jul Gunnersen

Chief adviser, IT, Statistics Denmark