International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
|
Volume 37 - Issue 7 |
Published: January 2012 |
Authors: Suja Ramachandran, S. Rajeswari, S.A.V. Satya Murty |
![]() |
Suja Ramachandran, S. Rajeswari, S.A.V. Satya Murty . Dimensional Modeling of Indian Materials Database. International Journal of Computer Applications. 37, 7 (January 2012), 1-8. DOI=10.5120/4617-4834
@article{ 10.5120/4617-4834, author = { Suja Ramachandran,S. Rajeswari,S.A.V. Satya Murty }, title = { Dimensional Modeling of Indian Materials Database }, journal = { International Journal of Computer Applications }, year = { 2012 }, volume = { 37 }, number = { 7 }, pages = { 1-8 }, doi = { 10.5120/4617-4834 }, publisher = { Foundation of Computer Science (FCS), NY, USA } }
%0 Journal Article %D 2012 %A Suja Ramachandran %A S. Rajeswari %A S.A.V. Satya Murty %T Dimensional Modeling of Indian Materials Database%T %J International Journal of Computer Applications %V 37 %N 7 %P 1-8 %R 10.5120/4617-4834 %I Foundation of Computer Science (FCS), NY, USA
The Indian Materials Database (IMDB) is a national project aiming to develop a database through compilation of materials property data available in different laboratories in India. The database contains data on mechanical, corrosion, nondestructive evaluation, thermal and optical properties of a wide variety of materials. Selecting the appropriate data modeling technique is crucial for the successful deployment of such a database. Dimensional modeling is a logical design technique to present data in a standard, intuitive framework that allows for high-performance access. Dimensional modeling of data results in a ‘Star Schema’, where the data constitutes a central fact table surrounded by dimension tables. This paper discusses the model and architecture of the material database using a ‘Snowflake Schema’, which is a variation of ‘Star Schema’, where some of the dimensions are normalized into multiple related tables. The database contains a central fact table linked to multiple dimensions namely, 1) Materials 2) Properties of materials 3) Details of experiments conducted on materials and 4) Source from which data is obtained.