Summary of Version Updates
Version 1.0 - Released 2003
- All data in Version 1.0 were audited prior to publication.
Version 2.0 - Released 2004
- An error in the units for riboflavin and folic acid for some of the datasets was corrected and electronic software for screening future datasets was developed to eliminate a similar reoccurrence.
Version 3.0 - Released 2006
- Additional conventional corn, cotton and soybean composition data were added.
Version 4.0 - Released 2010
- The database was restructured for increased functionality, speed and efficiency; and was migrated to a new platform which required that all raw data files be reexamined for compliance with the ILSI data acceptance criteria and reentered into the database. Only raw data files meeting all acceptance criteria were included in v4.0. Performance, security, availability and scalability were improved. Amino acid and fatty acid data became available in multiple units of measure, including % FW, % DW, % Total, and mg/g. To aid in the interpretation of data output, data summaries were enhanced to include the number of values for analytes below the LOQ and report output as Excel and PDF files became available. No new data were incorporated into the database in this release.
Version 4.1 - Released December 2010
- Additional secondary Units of Measure were added for some of the vitamins.
- Unit of measure conversion errors (mg/g FW to mg/g DW and mg/g FW to % DW) were corrected.
- A unit of measure conversion error for inositol (ug/g to ppm) was corrected.
- The functionality of the data preview tool was corrected to eliminate inadvertent doubling of all sample numbers (i.e., N).
Version 4.2 - Released June 2011
- Eight data points incorrectly entered as asparagine in cotton acid-delinted seed were corrected to aspartic acid. This did not alter the minimum aspartic acid value in cotton acid-delinted seed, but the maximum value was increased from 26.1 to 27.3 mg/g FW. The mean was also increased from 21.96 to 22.15 mg/g FW and the total number of samples was updated to 143.
- A Captcha was added to the registration page.
Version 5.0 - Released October 2014
- Version 5.0 has seven times more data points than the previous version. New data includes nutritional data from new crops canola, corn sweet and rice and additional data on existing crops (corn field, soybean and cotton). New crops required the addition of new analytes that are specific to the crops.
- In previous versions of the database (Version 3.0 and before) data was uploaded manually by a Data Curator, who inspected the data files received from the data providers and ensured data integrity and consistency before depositing it in the database. Version 5.0 features improvements to the database software including implementation of a Data Provider tool for automated upload and validation of data and a Data Curator tool that allows the Data Curator to manage the database. These tools automate the process of data upload and validation to increase the efficiency of data upload and reduce the potential for errors.
- Version 5.0 implements an important feature for standardization and consolidation of existing analytical methods along with an optimized process for the addition of methodology associated with new data. In the past, as new or updated methods were employed for nutritional analysis, the method references were assigned codes for internal use within the database. The assignment of the method codes was sequential and sometimes resulted in multiple codes for methods that were essentially identical. For example, some method codes for Association of Analytical Communities (AOAC) or American Association of Cereal Chemists (AACC) methods differed only by the year of publication although the analytical methodology was unchanged. To achieve greater clarity in the relationship between existing data and the associated method references, a standardized format for scientific literature references was adopted. Defining standardized formats facilitates faster data upload, data retrieval and ensures data integrity. The references for all existing data were converted to this format, and then all data of identical crop, tissue, analyte, and analytical methodology were combined. This eliminated duplication of method references, thus, providing a more realistic view of the number of data points associated with any particular method. For simplification and as an aid to prevent duplication in future data submissions, a new numbering system was created. Within this system, the new method code is comprised of six alpha-numeric placeholders with the first two characters being letters that represent the analyte category (e.g. AA for amino acids, BA for bioactives, VT for vitamins, etc.) and the remaining four characters representing a sequentially assigned number within each category. After consolidation based on literature references, all existing methods were assigned codes based on this system, as were new methods required for submission of data to be published in Version 5.0. New method codes for data submissions are requested of, and generated by, the database curator, and are assigned in consultation with an analytical expert.
Version 5.1 - Released October 2015
- The primary units of measure displayed in the Summary of Search Results table have been changed from Fresh Weight (FW) to Dry Weight (DW). Fresh Weight units of measure may be selected in the Create Report from Search Results table, if so desired.
Version 6 - Released October 2016
- The Version 6.0 update included nutritional data from two new crops, potato (Solanum tuberosum) and sorghum (Sorghum bicolor) and additional data on the following existing crops: canola, cotton, field corn, and soybean. Additionally, two units of measure conversion errors for alpha tocopherol were corrected.
Version 6.1 - Released December 2018
- Some canola data sets were temporarily removed from Version 6.0 for correction of method codes. These data sets were unavailable from November 3, 2018 through November 29, 2018.
- The Version 6.1 update includes all canola data sets with changes made to correct the method codes for some analytes in the category Bio Actives and Glucosinolates. These changes had no effect on data values, ranges or reported units of measurement.
- For all canola sinapine data with method code BA0015, the method code was changed to BA0018.
- For all canola total tannins data with method code BA0015, the method code was changed to BA0019.
- For all canola total glucosinolates, total alkyl glucosinolates and total indolyl glucosinolates data with method code BA0015, the method code was changed to BA0017.
Version 7.0 - Released January 2019
- The Version 7.0 update includes compositional data from a new crop, apple (Malus domestica), with data for three apple varieties (Golden Delicious, Granny Smith and Fuji), which are categorized as tissue types in the database.
- The size of the data sets for the existing crops canola, cotton, field corn, potato, rice and soybean were increased.
- Rice compositional data was added for the tissue type bran.
- It was determined that the inositol data should be classified as free inositol or total inositol based on the analytical method. In version 7.0 all the 4714 inositol data points from version 6.1 were recoded. 1612 data points associated with method code ME0006 were recoded from inositol to free inositol, and 3102 data points associated with method code ME0001 were recoded from inositol to total inositol.