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.
This is a preview of subscription content, access via your institution.
Buy single article
Instant access to the full article PDF.
Tax calculation will be finalised during checkout.
W. J. O’Brien, Dental materials and their selection, 3rd edition, Quintessence Publishing Co. Inc., Carol Stream, IL (2002).
R. G. Craig and J. M. Powers, Restorative Dental Materials, 11th edition, Mosby, St. Louis (2002).
K. J. Anusavice , Phillips’ science of dental materials, 11th edition, Saunders, St. Louis, Missouri (2003).
J. F. McCabe, Anderson’s applied dental materials, 6th edition, Blackwell Scientific Publications, Oxford, UK (1985).
R. G. Craig, J. M. Powers and J. C. Wataha, Dental Materials: Properties and Manipulation, 8th edition, Mosby, St. Louis (2004).
R. W. Wassell, A. W. G. Walls and J. G. Steele, British Dental Journal, 12: 199–211 (2002).
U.S. Department of Health (2004) [online] http://www.health.gov/environment/amalgam1/selection.htm. Accessed on 11/7/2005
W. H. Inmon, Building the data warehouse, 3rd edition, John Wiley & Sons, New York (2002).
Y. Li, Adv. Eng. Mater 6, 92 (2004).
S. R. Gardner, Communications of the ACM 41, 52 (1998).
B. K. O’Neil, J. Dakin, M. Schrader, M. Townsend, M. Whitme and K. Hardy, Oracle data warehousing unleashed. Sams Pub., Indianapolis, IN (1997).
University of Michigan (1997) [online] http://www.lib.umich.edu/dentlib/Dental_tables/intro.html. Accessed on 11/7/2005
T. K. Schleyer, Adv Dent Res., 17, 9 (2003).
K. J. Anusavice, Adv Dent Res., 17, 43(2003)
M. Jarke, M. Lenzerini, Y. Vassiliou and P. Vassiliadis, Fundamentals of data warehouse, Springer, Berlin, Germany (1998).
Microsoft online documents (2000) [online] http://www.microsoft.com/sql/evaluation/features/english.asp. Accessed on 11/7/2005
M. F. Ashby, Materials selection in mechanical design, 3nd edition, Butterworth Heinemann, Oxford, UK, 2005.
Cambridge Engineering Selector (2000) [online] http://www.aeat.co.uk/mcpa/ces.htm. Accessed on 11/7/2005
About this article
Cite this article
Li, Y. Warehousing the Dental Materials Data: A Prototype. MRS Online Proceedings Library 894, 08940906 (2005). https://doi.org/10.1557/PROC-0894-LL09-06