| Literature DB >> 26554836 |
Annabel K Clancy1, Kaitlyn Woods1, Anne McMahon1, Yasmine Probst1.
Abstract
This study aimed to investigate the needs of Australian food composition database user's regarding database format and relate this to the format of databases available globally. Three semi structured synchronous online focus groups (M = 3, F = 11) and n = 6 female key informant interviews were recorded. Beliefs surrounding the use, training, understanding, benefits and limitations of food composition data and databases were explored. Verbatim transcriptions underwent preliminary coding followed by thematic analysis with NVivo qualitative analysis software to extract the final themes. Schematic analysis was applied to the final themes related to database format. Desktop analysis also examined the format of six key globally available databases. 24 dominant themes were established, of which five related to format; database use, food classification, framework, accessibility and availability, and data derivation. Desktop analysis revealed that food classification systems varied considerably between databases. Microsoft Excel was a common file format used in all databases, and available software varied between countries. User's also recognised that food composition databases format should ideally be designed specifically for the intended use, have a user-friendly food classification system, incorporate accurate data with clear explanation of data derivation and feature user input. However, such databases are limited by data availability and resources. Further exploration of data sharing options should be considered. Furthermore, user's understanding of food composition data and databases limitations is inherent to the correct application of non-specific databases. Therefore, further exploration of user FCDB training should also be considered.Entities:
Mesh:
Year: 2015 PMID: 26554836 PMCID: PMC4640668 DOI: 10.1371/journal.pone.0142137
Source DB: PubMed Journal: PLoS One ISSN: 1932-6203 Impact factor: 3.240
Descriptive data of total sample of participants (n = 20).
| Characteristics | Focus Groups | Interviews |
|---|---|---|
|
| 14 | 6 |
|
| ||
|
| 3 | 0 |
|
| 11 | 6 |
|
| ||
|
| 9 | 2 |
|
| 2 | 1 |
|
| 3 | 3 |
| Highest Level of Education: | ||
|
| 4 | 1 |
|
| 6 | 1 |
|
| 4 | 4 |
| Current Area of Practice | ||
|
| 4 | 1 |
|
| 3 | 2 |
|
| 1 | 0 |
|
| 5 | 0 |
|
| 1 | 1 |
|
| 0 | 2 |
| Geographical distribution | ||
|
| 12 | 5 |
|
| 2 | 0 |
|
| 1 | 1 |
Summary of five major format related themes identified from schematic analysis of 24 dominant themes, extracted from focus groups and interviews.
| Major themes (definition) | Sub-categories (definition) | Exemplary quote |
|---|---|---|
| Database use (Current use of FCDB) | -type (which FCDB are used) | “Two of our reference databases NUTTAB 2006 and NUTTAB 2010, as well as two of our service specific databases AUSNUT 2007 and the more recent one related to the Australian Health Survey…AUSNUT 2011–13.” (Interview 2) |
| -purpose (what are FCDB and data used for) | “I mean to a large extent the nutrient databases are linked to what we know about nutrient requirements …. the components that we think are important for health ……….then you need to have the composition database to be able to assess diets against those things” (Focus group 2) | |
| -usability (ease of use, intuitiveness and learnability for tertiary educated individuals including how they interpret descriptors and use the data) | “So say you’ve finished doing a research project, and then you’re only using it …. a couple of times a year ……..you do get worse at it and forget the detail, and yeah it’s a little bit more difficult…….. but what it does mean to me is that it’s not intuitive” (Focus group 2) | |
| -database choice (reasons for choosing a FCDB) | “I’m pretty inexperienced in deciding which one to use… I think I normally use AUSNUT …for most of my purposes …. but to be honest … I don’t really know the pros or cons of either one” (Focus group 3) | |
| Framework (Presentation of data including design, layout, structure, food labelling as well as technological components including software, applications and functions of the data) | "I know a standard format at the moment is Excel……as a researcher I’m much more comfortable with that, than I am with any other format because otherwise you have to modify it to… your system….. I’ve never had a problem, I’ve never really thought of it as a problem even if it’s in a format that you don’t really like. Anyone with a, well, I, anyone who’s working in databases probably can manipulate it however they want” (Interview 5) | |
| Food classification (How foods are grouped and named in relation to database format and use) | “I’ve watched a lot of, a lot of students use the …. FoodWorks software… which uses AUSNUT and watching the challenges …. on being able to just follow names or find those foods …. because it’s just so difficult to navigate …. I think that’s….. going to be a challenge with any database, let alone an Australian databases, uh in naming in an easy way” (Focus group 1) | |
| Accessibility and Availability (Ability to retrieve data related to location, ownership and resources) | -central repository (a centralised system for all food composition data to be located and collaborated) | “Pooling that data is a valuable, is a power in numbers if you like and at the moment that’s what we need to get this momentum in terms of volume of information but having said that I think um we need to ensure that around that there are certain standards” (Focus group 3) |
| Data derivation (Analytical techniques used to obtain food composition data, including standardised techniques) | “Conscious of trying to ensure the quality of the numbers, and so they’re not always very ready to accept data that, particularly published data unless they’re really confident in the sampling and the analytical methodologies that are used” (Focus group 2) |
Desktop analysis and examination of six key food composition databases format.
| Background information | Name of database | NUTTAB | AUSNUT | USDA National Nutrient Database for Standard Reference | NZ FOOD files (unabridged) | UK Composition of Foods Integrated dataset | Canadian Nutrient file |
|---|---|---|---|---|---|---|---|
|
| 2010 | 2011 | 2014 | 2013 | 2015 | 2010 | |
|
| Australia | Australia | USA | New Zealand | UK | Canada | |
|
| FSANZ | FSANZ | USDA | Plant & Food research (ltd) & Ministry of Health | FSA | Health Canada | |
|
| 2668 | 5644 | 8618 | 2580 | 3423 | 5807 | |
|
| 245 | 51 | 150 | 360 | 186 | 150 | |
|
| Some carotenoids | No | No | Some carotenoids | Yes-phytosterols | Some carotenoids | |
|
|
| Reference | Survey | Reference | Reference | Reference | Reference |
|
| Provide analysed nutrient data for Australia | Nutritional analysis of NHS | Major source of food composition data for the US | Major source of food composition data for NZ | Major source of food composition data for the UK | Major source of food composition data for Canada | |
|
|
| Tables | Tables | Tables | Tables | Tables | Tables |
|
| FoodWorks 7 | FoodWorks 7 | FoodWorks 7 | FoodWorks 7 | WISP | Nutribase professional | |
|
| Txt. | Excel. | Access | ASCII | Excel. | DBF | |
|
|
| 20 | 23 | 25 | 22 | 23 | 25 |
|
| Based on COFA | 2011–2013 AHS classification system | Langual food description | INFOODS | Not specified**** | INFOODS | |
|
| Yes | Yes | Yes | Yes | Yes- limited | Yes | |
|
|
| Primarily analysis | Compilation | Compilation | Primarily analysis | Compilation | Compilation |
|
| Yes | Yes | Yes | Yes | Yes | Yes | |
|
|
| Yes | No | Yes | No | No | Yes |
|
| FSANZ | FSANZ | USDA |
| FSA | Health Canada |
a Food Standards Australia and New Zealand,
b United States Department of Agriculture,
c Food Standards Agency,
d Separate databases for flavonoids, carotenoids, proanthocyanidins and isoflavones,
e Eurofir EBASIS contains bioactive data for UK and Europe,
f National Health Survey,
g https://www.xyris.com.au/foodworks/fw_pro.html,
h http://www.nutribase.com/highend.html,
i http://www.foodresearch.ca/wp-content/uploads/2013/06/candat-features-1.pdf,
j Tinuviel Software,
i Downlees Systems,
k Forestfield Software,
l Kelicomp,
m http://www.tinuvielsoftware.com/faqs.htm,
n http://www.dietsoftware.com/canada.html,
o Text file: a file that only contains text,
p A file containing tables of information stored in columns and separated by tabs (can be exported into almost any spreadsheet program),
q Microsoft Excel spreadsheet,
r Microsoft Access Database file: is a database file with automated functions and queries,
s American Standard Code for Information Interchange (a standard file type that can be used by many programs),
t Database File Format (this file type can be opened with Microsoft Excel and Access),
u information to create Excel or PDF available,
v Composition of Foods, Australia,
w International Network of Food Data System,
x Users guide states food name is most descriptive & recognisable of food referenced
y http://www.foodstandards.gov.au/science/monitoringnutrients/nutrientables/nuttab/Pages/NUTTAB-2010-electronic-database-files.aspx,
z http://www.foodstandards.gov.au/science/monitoringnutrients/ausnut/ausnutdatafiles/Pages/default.aspx,
aa http://ndb.nal.usda.gov/ndb/search/list,
bb http://tna.europarchive.org/20110116113217/ http://www.food.gov.uk/science/dietarysurveys/dietsurveys/,
cc http://webprod3.hc-sc.gc.ca/cnf-fce/index-eng.jsp