Difference between revisions of "SQL Database for Points"
(New page: {{WCS Glossary |TermDesc=Currently the datafed WCS for points supports one kind of point data: Fixed locations and regular intervals. Point data is often stored in SQL databases. There's...) |
(No difference)
|
Revision as of 11:17, September 2, 2010
< Back to Glossary | Edit with Form
SQL_Database_for_Points Description: Currently the datafed WCS for points supports one kind of point data: Fixed locations and regular intervals.
Point data is often stored in SQL databases. There's no standard schema, like CF-1.0 convention for NetCDF files, so it is not possible to just connect and start serving. You have to create the configuration description.
One of the most powerful ideas in relational database design is the concept of a view. You don't need to change the existing data tables, creating a view that makes your DB to look like the one needed is enough.
The Simplest Case: Configure with SQL Views
Location Table/View
The common thing between different databases is, that they need to have a location table. The current implementation is based on time series from stationary locations.
table/view location +----------+-------+---------+-------+
Glossary Domain: {{{Glossary Domain}}}"{{{Glossary Domain}}}" is not in the list (WCS, HTAP, AQInfrastructure) of allowed values for the "Glossary Domain" property.
Related Links
Links to this page
No Links
Contributors
No Contributors
History
No History Available