Hostname: page-component-8448b6f56d-dnltx Total loading time: 0 Render date: 2024-04-25T01:32:28.127Z Has data issue: false hasContentIssue false

Warehousing the Dental Materials Data: A Prototype

Published online by Cambridge University Press:  26 February 2011

Yong Li*
Affiliation:
y.yongli@gmail.com, University of California, Irvine, 37 Altezza, Irvine, CA, 92606, United States
Get access

Abstract

This paper presents a preliminary investigation on the effectiveness of the new data management technique of data warehousing in organizing dental materials data in order to provide the efficient information services such as data retrieval and materials selection. A scaled-down version of the data warehouse for dental materials is constructed and an English Query application, which allows the end users to formulate their queries in natural English language, is developed on top of the data warehouse. The data warehouse supports five types of queries from basic practice of data retrieval to more advanced information service of materials selection. The results have demonstrated that the data warehousing technique is of a great potential in storing, processing and managing dental materials data.

Type
Research Article
Copyright
Copyright © Materials Research Society 2006

Access options

Get access to the full version of this content by using one of the access options below. (Log in options will check for institutional or personal access. Content may require purchase if you do not have access.)

References

REFERENCES

1. O'Brien, W. J., Dental materials and their selection, 3rd edition, Quintessence Publishing Co. Inc., Carol Stream, IL (2002).Google Scholar
2. Craig, R. G. and Powers, J. M., Restorative Dental Materials, 11th edition, Mosby, St. Louis (2002).Google Scholar
3. Anusavice, K. J., Phillips’ science of dental materials, 11th edition, Saunders, St. Louis, Missouri (2003).Google Scholar
4. McCabe, J. F., Anderson's applied dental materials, 6th edition, Blackwell Scientific Publications, Oxford, UK (1985).Google Scholar
5. Craig, R. G., Powers, J. M. and Wataha, J. C., Dental Materials: Properties and Manipulation, 8th edition, Mosby, St. Louis (2004).Google Scholar
6. Wassell, R. W., Walls, A. W. G. and Steele, J. G., British Dental Journal, 12: 199–211 (2002).Google Scholar
7. U.S. Department of Health (2004) [online] http://www.health.gov/environment/amalgam1/selection.htm. Accessed on 11/7/2005Google Scholar
8. Inmon, W. H., Building the data warehouse, 3rd edition, John Wiley & Sons, New York (2002).Google Scholar
9. Li, Y., Adv. Eng. Mater 6, 92 (2004).Google Scholar
10. Gardner, S. R., Communications of the ACM 41, 52 (1998).Google Scholar
11. O'Neil, B. K., Dakin, J., Schrader, M., Townsend, M., Whitme, M. and Hardy, K., Oracle data warehousing unleashed. Sams Pub., Indianapolis, IN (1997).Google Scholar
12. University of Michigan (1997) [online] http://www.lib.umich.edu/dentlib/Dental_tables/intro.html. Accessed on 11/7/2005Google Scholar
13. Schleyer, T. K., Adv Dent Res., 17, 9 (2003).Google Scholar
14. Anusavice, K. J., Adv Dent Res., 17, 43(2003)Google Scholar
15. Jarke, M., Lenzerini, M., Vassiliou, Y. and Vassiliadis, P., Fundamentals of data warehouse, Springer, Berlin, Germany (1998).Google Scholar
16. Microsoft online documents (2000) [online] http://www.microsoft.com/sql/evaluation/features/english.asp. Accessed on 11/7/2005Google Scholar
17. Ashby, M. F., Materials selection in mechanical design, 3nd edition, Butterworth Heinemann, Oxford, UK, 2005.Google Scholar
18. Cambridge Engineering Selector (2000) [online] http://www.aeat.co.uk/mcpa/ces.htm. Accessed on 11/7/2005Google Scholar