Developing a MySQL database for the provenance of black tiger prawns (Penaeus monodon)

dc.contributor.authorGopi, Ken_AU
dc.contributor.authorMazumder, Den_AU
dc.contributor.authorCrawford, Jen_AU
dc.contributor.authorGadd, PSen_AU
dc.contributor.authorTadros, CVen_AU
dc.contributor.authorAtanacio, AJen_AU
dc.contributor.authorSaintilan, Nen_AU
dc.contributor.authorSammut, Jen_AU
dc.date.accessioned2024-12-06T00:00:31Zen_AU
dc.date.available2024-12-06T00:00:31Zen_AU
dc.date.issued2023-07-11en_AU
dc.date.statistics2024-12-06en_AU
dc.description.abstractAs the demand for seafood increases, so does the incidence of seafood fraud. Confirming provenance of seafood is important to combat fraudulent labelling but requires a database that contains the isotopic and elemental “fingerprints” of authentic seafood samples. Local isotopic and elemental databases can be scaled up or combined with other databases to increase the spatial and species coverage to create a larger database. This study showcases the use of isotopic and elemental fingerprints of the black tiger prawn (Penaeus monodon) to develop a database that can be used to securely store the data necessary for determining provenance. The utility of this database was tested through querying and building seven different datasets that were used to develop models to determine the provenance of P. monodon. The models built using the data retrieved from the database demonstrated that the provenance of P. monodon could be determined with >80% accuracy. As the database was developed using MySQL, it can be scaled up to include additional regions, species, or methodologies depending on the needs of the users. Combining the database with methods of determining provenance will provide regulatory bodies and the seafood industry with another provenance tool to combat fraudulent seafood labelling. © 2023 The Authors. Licensee MDPI, Basel, Switzerland. This article is an open access article distributed under the terms and conditions of the Creative Commons Attribution (CC BY) license (https:// creativecommons.org/licenses/by/4.0/)en_AU
dc.description.sponsorshipThis research is a part of the collaboration between Australian Nuclear Science and Technology Organisation (ANSTO), the University of New South Wales, Macquarie University, National Measurement Institute, and Sydney Fish Market (SFM). The nuclear analyses of samples were conducted at ANSTO labs, and the cost associated with these analyses were covered by ANSTO. This research was supported by an Australian Government Research Training Program Scholarship. This work was also supported by the Australian Institute of Nuclear Science and Engineering (AINSE)—Residential Student Scholarship. Prawn samples for this research were provided by SFM.en_AU
dc.format.mediumElectronicen_AU
dc.identifier.articlenumber2677en_AU
dc.identifier.citationGopi K, Mazumder D, Crawford J, Gadd P, Tadros CV, Atanacio A, Saintilan N, Sammut J. Developing a MySQL database for the provenance of black tiger prawns (Penaeus monodon). Foods. 2023; 12(14):2677. doi:10.3390/foods12142677en_AU
dc.identifier.issn2304-8158en_AU
dc.identifier.issue14en_AU
dc.identifier.journaltitleFoodsen_AU
dc.identifier.urihttp://dx.doi.org/10.3390/foods12142677en_AU
dc.identifier.urihttps://apo.ansto.gov.au/handle/10238/15797en_AU
dc.identifier.volume12en_AU
dc.languageEnglishen_AU
dc.language.isoenen_AU
dc.publisherMDPIen_AU
dc.subjectData base managementen_AU
dc.subjectSeafooden_AU
dc.subjectFooden_AU
dc.subjectFish productsen_AU
dc.subjectFrauden_AU
dc.subjectLabellingen_AU
dc.subjectProduct labelingen_AU
dc.subjectDataen_AU
dc.titleDeveloping a MySQL database for the provenance of black tiger prawns (Penaeus monodon)en_AU
dc.typeJournal Articleen_AU
dcterms.dateAccepted2023-07-07en_AU
Files
Original bundle
Now showing 1 - 2 of 2
Loading...
Thumbnail Image
Name:
Developing a MySQL Database for the Provenance of Black Tiger Prawns (iPenaeus monodoni).pdf
Size:
1.11 MB
Format:
Adobe Portable Document Format
Description:
Published version
Loading...
Thumbnail Image
Name:
foods-12-02677-v2.pdf
Size:
1.11 MB
Format:
Adobe Portable Document Format
Description:
License bundle
Now showing 1 - 1 of 1
Loading...
Thumbnail Image
Name:
license.txt
Size:
1.66 KB
Format:
Plain Text
Description:
Collections