Warehousing the Dental Materials Data: A Prototype


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.


  1. 1.

    W. J. O’Brien, Dental materials and their selection, 3rd edition, Quintessence Publishing Co. Inc., Carol Stream, IL (2002).

  2. 2.

    R. G. Craig and J. M. Powers, Restorative Dental Materials, 11th edition, Mosby, St. Louis (2002).

  3. 3.

    K. J. Anusavice , Phillips’ science of dental materials, 11th edition, Saunders, St. Louis, Missouri (2003).

  4. 4.

    J. F. McCabe, Anderson’s applied dental materials, 6th edition, Blackwell Scientific Publications, Oxford, UK (1985).

  5. 5.

    R. G. Craig, J. M. Powers and J. C. Wataha, Dental Materials: Properties and Manipulation, 8th edition, Mosby, St. Louis (2004).

  6. 6.

    R. W. Wassell, A. W. G. Walls and J. G. Steele, British Dental Journal, 12: 199–211 (2002).

    Google Scholar 

  7. 7.

    U.S. Department of Health (2004) [online] http://www.health.gov/environment/amalgam1/selection.htm. Accessed on 11/7/2005

  8. 8.

    W. H. Inmon, Building the data warehouse, 3rd edition, John Wiley & Sons, New York (2002).

  9. 9.

    Y. Li, Adv. Eng. Mater 6, 92 (2004).

    Article  Google Scholar 

  10. 10.

    S. R. Gardner, Communications of the ACM 41, 52 (1998).

    Article  Google Scholar 

  11. 11.

    B. K. O’Neil, J. Dakin, M. Schrader, M. Townsend, M. Whitme and K. Hardy, Oracle data warehousing unleashed. Sams Pub., Indianapolis, IN (1997).

  12. 12.

    University of Michigan (1997) [online] http://www.lib.umich.edu/dentlib/Dental_tables/intro.html. Accessed on 11/7/2005

  13. 13.

    T. K. Schleyer, Adv Dent Res., 17, 9 (2003).

    CAS  Article  Google Scholar 

  14. 14.

    K. J. Anusavice, Adv Dent Res., 17, 43(2003)

    CAS  Article  Google Scholar 

  15. 15.

    M. Jarke, M. Lenzerini, Y. Vassiliou and P. Vassiliadis, Fundamentals of data warehouse, Springer, Berlin, Germany (1998).

  16. 16.

    Microsoft online documents (2000) [online] http://www.microsoft.com/sql/evaluation/features/english.asp. Accessed on 11/7/2005

  17. 17.

    M. F. Ashby, Materials selection in mechanical design, 3nd edition, Butterworth Heinemann, Oxford, UK, 2005.

  18. 18.

    Cambridge Engineering Selector (2000) [online] http://www.aeat.co.uk/mcpa/ces.htm. Accessed on 11/7/2005

Download references

Author information



Corresponding author

Correspondence to Yong Li.

Rights and permissions

Reprints and Permissions

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

Download citation