fermilab-accelerator-ai / meetings

Meeting notes and information
2 stars 0 forks source link

Web accessible SQL server for offline data access #31

Open gnperdue opened 4 years ago

gnperdue commented 4 years ago

Folks at PNNL, especially @schr476 identified a desire for the ability to access historical data for offline training purposes through an SQL server.

We need to talk to FNAL DB teams about how to put together and manage such a server (e.g., how to expose it to PNNL for training), and set up scripts to populate the database.

gnperdue commented 4 years ago

Update from @jasonstjohn from 16 March:

I opened a ticket with the database group; we'll try to make a automatic process which makes all our files available via db connection on one their enormous servers.  My goal is to get the security down to knowing a machine, a port, and a password.... We'll see if they can do it for us.

@jasonstjohn - put notes from the ticket here if/when you get a chance and they're "news worthy".