Data management
Download
1 / 24

Data Management - PowerPoint PPT Presentation


  • 76 Views
  • Uploaded on

Data Management. Provide quality data and data products to our users as quickly as possible. Becky Olson Database Administrator Web programmer. Web Presentation. How to give our users access to all our data? Correction files Data products Quality control codes. New design.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Data Management' - urielle-salinas


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Data management
Data Management

Provide quality data and data products to our users as quickly as possible

Becky Olson

Database Administrator

Web programmer

Becky Olson/UVB Radiation Project


Web presentation
Web Presentation

  • How to give our

  • users access to

  • all our data?

  • Correction files

  • Data products

  • Quality control codes

Becky Olson/UVB Radiation Project


New design

Changing only

Climatalogical Network



Choose data type

first, then location


All data will be viewed as a

plot with option to download

plot or actual data


Database design

Database Design

Have a 3 minute raw voltage come in for

every site for every hour of every day. Currently operating 30 sites, 90 instruments.

How to manage that volume of data and provide quick access to our users through our web page and by data requests.

Using the Oracle database.

Becky Olson/UVB Radiation Project


Database design channel data
Database Design- Channel Data

Oracle database

Key access fields: site_code,date, or serial number

Store the channel data in temporary tables until the quality

Control process has completed. Then once a month, move

previous month into our production database.

Also store all calibration files as well as a history of heads at

the sites, and geographic information about a site.


Database design documentation data
Database Design- Documentation data

quality_control_codes- list of our current quality control code, with rules and description

*people_info- current contacts for our UVB program

*requestlog_info- history of people, and the data they have requested

service_tracking- historical record of our sites


Data capture and quality

Data Capture and Quality

Have a 3 minute raw voltage come in for

every site for every hour of every day. Currently operating 30 sites, 90 instruments.

How to get the data from the instruments at the sites and verify its quality and put it in our database tables?

Becky Olson/UVB Radiation Project



Data capture and quality polling process
Data capture and qualityPolling process


Data capture and quality polling process1
Data capture and qualityPolling process


Data capture and quality quality control flags auxiliary
Data capture and qualityQuality Control flags: auxiliary


Data capture and quality quality control flags channel
Data capture and qualityQuality Control flags: Channel


Data capture and quality quality control flags channel gap records
Data capture and qualityQuality Control flags: Channel/Gap Records

Quality Control flags: Descriptive


In conclusion

In conclusion:

Recognize the dynamic nature of our project and be adaptable to the constant changes that will occur in our software and database design.

We will try to predict what our users want and what the technology will be, but allow the capability for change.

Becky Olson/UVB Radiation Project


ad