Manual

Database Menu System:

Database:

These functions provide access to the SQL database modules of UltraScan. Many UltraScan functions can import data such as peptide sequences, nucleic acid sequences, buffer definitions, as well as all experimental sedimentation and wavelength data from the SQL database associated with UltraScan. By default, UltraScan utilizes the MySQL database engine, but other engines such as Oracle can also be used. Database parameters and login information, as well as which database engine is used, is defined in the configuration module. These functions here control database storage and retrieval of information.

1. Commit Data to Database [Investigator] [Buffer] [Peptide] [Nucleotide Sequence] [Experimental Data]

   

   These functions allow you to commit various data types to the database. For more information click on the link below:

   1. Investigator contact information
   2. Buffer composition files for hydrodynamic corrections
   3. Peptide sequence files
   4. Nucleotide sequence files
   5. Experimental data (entire runs with associated data)

2. Retrieve Experimental Data from Database [Investigator] [Date] [Description] [Edit Type]

   

   These functions allow you to retrieve experimental data from the database using various criteria, such as the investigator name, the date of the experiment, an experimental description or the type of data (run type, optical system, etc). More information on each option can be found in the list below:

   1. Retrieve by Investigator Name
   2. Retrieve by Date
   3. Retrieve by experimental description
   4. Retrieve by experimental data type and optical system used

3. Initialize Database Template
   This function allows you to initialize a new database with the appropriate table structure. If the selected database already exists, it will be overwritten with an empty version. Use with caution! More information for this function is available here.