Dimensional issues in agricultural data warehouse designs

Computers and Electronics in Agriculture

Volumn 60, Issue 2, 2008, Pages 263-278

  Nilakanta, Sree ^a   Scheibe, Kevin ^a   Rai, Anil ^b  

^a IOWA STATE UNIVERSITY   (United States)

^b ICAR INDIAN AGRICULTURAL STATISTICS RESEARCH INSTITUTE   (India)

Author keywords

Agriculture; Data warehouse; Dimensional model; Warehouse architecture

Indexed keywords

AGRICULTURE; DATA STRUCTURES; GOVERNMENT DATA PROCESSING; INFORMATION SYSTEMS; REGIONAL PLANNING;

DIMENSIONAL MODELS; INDIA; WAREHOUSE ARCHITECTURE;

DATA WAREHOUSES;

AGRICULTURAL DEVELOPMENT; DESIGN; PLANNING THEORY;

EID: 38149039260     PISSN: 01681699     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.compag.2007.09.009     Document Type: Article

References (51)

1. Abdullah A., Brobst S., Umer M., and Khan M.F. The Case for an agri data warehouse: enabling analytical exploration of integrated agricultural data. Proceedings of the IASTED International Conference on Databases and Applications (DBA 2004). Innsbruck, Austria (2004)
2. Agosta, L., December 13 2001. "Top 10 Data Warehousing Challenges," Forrester Research.
3. Agosta L. Data warehouse size depends on the size of the business problem. DM Rev. 13 16 (2003) 16-17
4. Armstrong, R., 1997. A Rebuttal to the Dimensional Modeling Manifesto.
5. Azad A.N., Erdem A.S., and Saleem N. A framework for realizing the potential of information technology in developing countries. Int. J. Com. Manage. 8 2 (1998) 121-133
6. Berenguer G., Romero R., Trujillo J., Serrano M., and Piattini M. A set of quality indicators and their corresponding metrics for conceptual models of data warehouses. Data Warehousing and Knowledge Discovery (2005) pp. 95-104
7. Bieber, M., 1998. Data Warehousing in Government, DM Rev.
8. Bouguettaya A., Benatallah B., and Elmagarmid A.K. Interconnecting Heterogeneous Information Systems (1998), Kluwer, Boston, MA
9. Chaudhuri S., and Dayal U. An Overview of Data Warehousing and OLAP Technology. ACM SIGMOD Record 26 1 (1997) 64-74
10. Chen L.-d., Soliman K.S., Mao E., and Frolick M.N. Measuring user satisfaction with data warehouses: an exploratory study. Info. Manage. 37 (2000) 103-110
11. Feijoo S.R., Caro A.R., and Quintana D.D. Methods for quarterly disaggregation without indicators; a comparative study using simulation. Comput. Statist. Data Anal. 43 1 (2003) 63-78
12. Ghosh M., and Rao J.N.K. Small area estimation: an appraisal. Statist. Sci. 9 1 (1994) 55-76
13. Government of India, 2003. Lok Sabha Unstarred Question No. 3669, http://164.100.24.208/lsq/quest.asp?qref=57381.
14. Government of India, 2007. India Image, http://indiaimage.nic.in/.
15. Hackney, D., 2002. Architectures and Approaches for Successful Data Warehouses, Oracle White Paper.
16. Harper F.M. Data warehousing and the organization of governmental databases. Digital government: Principles and Best Practices (2004), IGI Publishing pp. 236-247
17. Hoffer J.A., Prescott M.B., and McFadden F.R. Modern Database Management (2005), Pearson Education, Inc., Upper Saddle River, New Jersey
18. Hollihan M. The Relationship between Inflation and Relative Prices. Stud. Econ. Finance 6 1 (1982) 29
19. India, N.I.C., 2004. Districts of India: A Gateway to Districts of India on the web, http://www.districts.nic.in.
20. Inmon W. What is a Data Warehouse?. PRISM Tech Topic 1 1 (1995)
21. Inmon W. BI in the Government. DM Rev. 13 8 (2003) 26-27
22. Inmon W. Data Warehousing for Government (2005)
23. Inmon W.H. Building the Data Warehouse (2002), John Wiley & Sons, Inc.
24. Iowa Division of Criminal & Juvenile Justice Planning, 2007. Justice Data Warehouse (JDW), http://www.state.ia.us/government/dhr/cjjp/jdw/index.html.
25. Kelly S. Data Warehousing in Action (1997), John Wiley & Sons, Chichester
26. Kimball R. The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (2002), John Wiley & Sons, Inc.
27. Langseth, J., 2004. Real-Time Data Warehousing: Challenges and Solutions, DSSResources.COM, http://dssresources.com/papers/features/langseth/langseth02082004.html.
28. Lenzerini M. Data integration: a theoretical perspective. Proceedings of the Twenty-first ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems. Madison, Wisconsin (2002) 233-246
29. Maheshwar C., and Chanakwa T.S. Postharvest losses due to gaps in cold chain in India-a solution. Proceedings of the IV International Conference on Managing Quality in Chains - The Integrated View on Fruits and Vegetables Quality. Bangkok, Thailand (2006) 777-784
30. Marakas G.M. Modern Data Warehousing, Mining, and Visualization (2003), Prentice Hall, Upper Saddle River, NJ
31. Marco D. Independent Data Marts: Stranded on Islands of Data, Part 1. DM Rev. 13 4 (2003) 30-33
32. Modi, A., 2007. Export of agri goods up 9%, Business Standard, http://www.business-standard.com/common/storypage.php?autono=288679&leftnm=3&subLeft=0&chkFlg=.
33. Nelson R.R., Todd P.A., and Wixom B.H. Antecedents of information and system quality: an empirical examination within the context of data warehousing. J. Manage. Info. Systems 21 4 (2005) 199-235
34. Oliveira P., Rodrigues F., Henriques P., and Galhardas H. A taxonomy of data quality problems. Proceedings of the International Workshop on Data and Information Quality (2005)
35. Rahm E., and Do H. Data cleaning: problems and current approaches. IEEE Data Eng. Bull. 23 4 (2000) 1-11
36. Rob P., and Coronel C. Database Systems: Design, Implementation, and Management (2006), Course Technology
37. Sen A., and Sinha A.P. A comparison of data warehousing methodologies. Commun. ACM 48 3 (2005) 79-84
38. Serrano M., Calero C., and Piattini M. An experimental replication with data warehouse metrics. Int. J. Data Warehousing Mining 1 4 (2006) 1-21
39. Shankaranarayanan G., Watts S., and Even A. The role of process metadata and data quality perceptions in decision making: an empirical framework and investigation. J. Info. Technol. Manage. 17 1 (2006) 50-67
40. Sheth A., and Kashyap V. So far (schematically) yet so near (semantically). Proceedings of the IFIP WG 2.6 Database Semantics Conference on Interoperable Database Systems (DS-5). North-Holland (1993) 283-312
41. Tribune News Service, 2001.Rs 70,000 cr food 'wastage' a year, The Tribune.
42. U.S. Department of Health and Human Services, 2007. Geospatial Data Warehouse, U.S. Department of Health and Human Services, http://datawarehouse.hrsa.gov/default.htm.
43. van Vlymen J., de Lusignan S., Hague N., Chan T., and Dzregah B. Connecting medical informatics and bio-informatics. Proceedings of the MIE2005 - The XIXth International Congress of the European Federation for Medical Informatics (2005) 1010-1015
44. Waichler S.R., and Wigmosta. Development of hourly meterological values from daily data and significance to hydrological modeling at H.J. Andrews Experimental Forest. J. Hydrometerol. 4 2 (2003) 13
45. Watson H.J., Gerard J.G., Gonzalez L.E., Haywood M.E., and Fenton D. Data warehousing failures: case studies and findings. J. Data Warehousing 4 1 (1999) 44-55
46. Watson H.J., and Haley B.J. Data warehousing: a framework and survey of current practices. J. Data Warehousing 2 1 (1997) 10-17
47. Whiting, R., 2003. The Data-Warehouse Advantage, pp. 63-66.
48. Widom J. Research problems in data warehousing. Proceedings of the Fourth International Conference on Information and Knowledge Management. Baltimore, MD (1995) 25-30
49. Winkler W.E. Methods for evaluating and creating data quality. Info. Systems 29 7 (2004) 531-550
50. Wixom B.H., and Watson H.J. An emperical investigation of the factors affecting data warehousing success. MIS Quarterly 25 1 (2001) 17-41
51. Yost M. Data warehousing and decision support at the National Agricultural Statistics Service. Soc. Sci. Computer Rev. 18 4 (2000) 434-441