Key organizational factors in data warehouse architecture selection

Decision Support Systems

Volumn 49, Issue 2, 2010, Pages 200-212

  Ariyachandra, Thilini ^a   Watson, Hugh ^b  

^a XAVIER UNIVERSITY   (United States)

^b UNIVERSITY OF GEORGIA   (United States)

Author keywords

Archictecture selection; Bus architecture; Data warehouse architecture; Data warehousing; Enterprise data warehouse; Federated; Hub and spoke; Independent data marts

Indexed keywords

BUS ARCHITECTURE; DATA MART; DATA WAREHOUSE ARCHITECTURE; DATA WAREHOUSING; ENTERPRISE DATA WAREHOUSE; HUB AND SPOKE;

DECISION THEORY;

DATA WAREHOUSES;

EID: 77951142634     PISSN: 01679236     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.dss.2010.02.006     Document Type: Article

References (90)

1. Agarwal R., Sambamurthy V., and Stair R. The evolving relationship between general and specific computer self-efficacy. Information Systems Research 11 4 (2000)
2. Allen B., and Andrew C. Information architecture: in search of efficient flexibility. MIS Quarterly 15 4 (1991)
3. Anandarajan M., and Arinze B. Matching client/server processing architectures with information processing requirements. Information & Management 34 5 (1998)
4. Andres H.P., and Zmud R. A contingency approach to software project coordination. Journal of MIS 18 3 (2001)
5. Armstrong R. Data warehousing. The fallacy of data mart strategies (2003), NCR
6. Babbie E. The Practice of Social Research (2000), Thompson Learning, Belmont, CA
7. Baron R., and Kenny D. The moderator-mediator variable distinction in social psychological research. Journal of Personality & Social Psychology 51 (1986)
8. Benbasat I., and Taylor R. The impact of cognitive styles on information systems design. MIS Quarterly 2 2 (1978)
9. Bradshaw-Camball P., and Murray V.V. Illusions and other games: a trifocal view of organizational politics. Organization Science 2 4 (1991)
10. Breslin M. Data warehousing battle of giants: comparing the basics of the Kimball and Inmon models. Business Intelligence Journal 9 4 (2004)
11. Broadbent M.P., and Weill P. Management by maxim: how business and IT managers can create IT infrastructures. Sloan Management Review 38 3 (1997)
12. Brohman M.K. Explaining Variation in Data Warehouse Usage (2000), Richard Ivey School of Business, The University of Western Ontario, London, Ontario
13. Campbell D. Task complexity: a review and analysis. Academy of Management Review 13 (1988)
14. Cavaye A., and Christiansen J. Understanding IS implementation by estimating power of subunits. European Journal of Information Systems 4 (1996)
15. Chen L., and Gillenson M. A Framework for Data Warehousing Research (2000), Americas Conference on Information Systems, Boston
16. Chen H., and Sheldon P. Destination information systems: design issues and directions. Journal of Management Information Systems 14 2 (1997)
17. Comrey A.L., and Lee H. A First Course in Factor Analysis (1992), Erlbaum, New Jersey
18. Cooper B., Watson H.J., Wixom B., and Goodhue D.L. Data warehousing supports strategy at First American Corporation. MIS Quarterly 24 4 (2000)
19. Damanpour F. Organizational innovation: a meta analysis of effects of determinants and moderators. Academy of Management Journal 34 3 (1991)
20. Devlin B.A. Data Warehouse: From Architecture to Implementation (1997), Addison Wesley, Reading, Massachusetts
21. Duncan N. Capturing flexibility of information technology infrastructure. Journal of Management Information Systems 12 2 (1995)
22. Eckerson W. Smart companies in the 21st century (2003), TDWI Research Report
23. Eckerson W. Gauge your data warehouse maturity. DM Review 14 11 (2004)
24. Ein-Dor P., and Segev E. Organizational context and the success of management information systems. Management Science 24 (1978)
25. Eisenhardt K., and Bourgeois L. Politics of strategic decision-making in high-velocity environments. Academy of Management Journal 31 4 (1988)
26. Fichman R.G., and Kemerer C. The assimilation of software process innovations: an organizational learning perspective. Management Science 43 10 (1997)
27. Fornell C., and Larcker D. Evaluating structural equation models with unobservable variables and measurement error. Journal of Marketing Research 18 (1981)
28. Francalanci C., and Piuri V. Designing information technology architectures: a cost-oriented methodology. Journal of Information Technology 14 4 (1991)
29. Galbraith J. Organizational design: an information processing view. Interface 4 3 (1974)
30. Gefen D., Straub D., and Boudreau M. Structural equation modeling and regression: guidelines for research practice. CAIS 4 7 (2000)
31. Gibson C. Do they do what they believe they can? Group efficacy and group effectiveness across tasks. Academy of Management Journal 42 2 (1999)
32. Goodhue D., and Thompson R. Task-technology fit and individual-performance. MIS Quarterly 19 2 (1995)
33. Goodhue D., Quillard J., and Rockart J. Managing the data resource - a contingency perspective. MIS Quarterly 12 3 (1988)
34. Goodhue D., Wybo M., and Kirsch L. The impact of data integration on the costs and benefits of information-systems. MIS Quarterly 16 3 (1992)
35. Goodhue D., Wixom B., and Watson H.J. Realizing business benefits through CRM: hitting the target in the right way. MIS Quarterly Executive 1 2 (2002)
36. Gray P., and Watson H.J. Decision Support in the Data Warehouse (1998), Prentice-Hall, New Jersey
37. Griffin J. Information strategy: mart vs. data warehouse. DM Review 12 3 (2001)
38. Grover V., and Segars A. The relationship between organizational characteristics and information system structure. International Journal of Information Management 16 (1996)
39. Gully S., Incalcaterra K., Joshi A., and Beaubien J. A meta-analysis of team-efficacy and performance. Journal of Applied Psychology 87 5 (2002)
40. Hackney D. Architecture of architectures: warehouse delivery. DM Review 12 4 (1998)
41. Hackney D. Architecture anarchy and how to survive it: God save the queen. Enterprise Systems Journal 15 4 (2000)
42. Haley B. Implementing the Decision Support Infrastructure: Key Success Factors in Data Warehousing, in: Management (1988), University of Georgia, Athens
43. He X., and Frey C. Three class ROC analysis: a decision theoretic approach under the ideal observer framework. IEEE Transactions on Medical Imaging 25 (2006)
44. Hinkin T. A review of scale development practices in the study of organizations. Journal of Management 21 5 (1995)
45. Hosmer D., and Lemeshow S. Applied Logistic Regression (2000), Wiley, New York
46. Hsieh F.Y., Block D.A., and Larsen M.D. Simple method of sample size calculation for linear and logistic regression. Statistics in Medicine 17 (1998)
47. Inmon W., Imhoff C., and Sousa R. Corporate Information Factory (2001), Wiley, New York
48. Jasperson S., Carte T., Saunders C., Butler B., Croes H., and Zheng W. Review: power and IT research. MIS Quarterly 26 4 (2002)
49. Jindal R., and Acharya A. Federated data warehouse architecture. White Paper for ITtoolbox Data Warehouse (2008). http://research.ittoolbox.com/white-papers/datamgt/dw/federated-data-warehouse-architecture-3309 [http://research.ittoolbox.com/white-papers/datamgt/dw/federated-data-warehouse-architecture-3309 accessed 5/14/2008]
50. Joshi K., and Curtis M. Issues in building a successful data warehouse. Information Strategy. The Executive's Journal 4 1 (1999)
51. Kelly S. Data marts: the latest silver bullet. DM Review 7 2 (1997)
52. Kimball R., Reeves L., Ross M., and Thornthwaite W. The data warehouse lifecycle toolkit: expert methods for designing, developing, and deploying data warehouses (2003), Wiley, New York
53. Kleinbaum D. Logistic Regression: A Self Learning Text (1994), Springer-Verlag, New York
54. Laney D. Warehouse factors to address for success. HP Professional 14 5 (2000)
55. Langley A., Mintzberg H., Pitcher P., Posada E., and Saintmacary J. Opening up decision making: the view from the stool. Organization Science 6 3 (1995)
56. Lee K., and Koval J. Determination of the best significance level in forward stepwise logistic regression. Communication in Statistics, B 26 (1997)
57. Lindsley D., and Brass D. Efficacy-performance spirals: a multilevel perspective. Academy of Management Review 20 3 (1995)
58. Mannino M., and Walter Z. A framework for data warehouse refresh policies. Decision Support Systems 42 (2006)
59. Marakas G.M., Yi M., Johnson R., and Research I.S. The multilevel and multifaceted character of computer self-efficacy. Information Systems Research 9 2 (1998)
60. Markus M.L. Power, politics and MIS implementation. Communications of the ACM 26 6 (1983)
61. Matheson C. Rationality and decision-making in Australian federal government. Australian Journal of Political Science 33 1 (1998)
62. McFarlan W., and McKenney J. Corporate information systems management: the issues facing senior executives (1983), Homewood, Irwin
63. Miller D., and Friesen P. Innovation in conservative and entrepreneurial firms: two models of strategic momentum. Strategic Management Journal 3 1 (1983)
64. Mimno P. How to avoid mart chaos using hybrid methodology (2002), TDWI Flash point
65. Pfeffer J. Power in Organizations (1981), Pitman Publishing, Marshfield
66. Ravichandran T. Innovation Assimilation in the Presence of Knowledge Barriers and Technology Uncertainty (2001), Academy of Management, Washington DC
67. Rockart J.E., Earl M., and Ross J. Eight imperatives for the new IT organization. Sloan Management Review 38 1 (1996)
68. Sen A., and Atish S. Toward developing data warehousing process standards: an ontology-based review of existing methodologies. IEEE Transactions on Systems, Man and Cybernetics 37 1 (2007)
69. Sethi V., and King W. Construct measurement in information systems research: an illustration in strategic systems. Decision Sciences 22 3 (1991)
70. Specht P.H. Job characteristics as indicants of CBIS data requirements. MIS Quarterly 10 3 (1986)
71. Sprague R.H., and Carlson E.D. Building Effective Decision Support Systems (1982), Prentice-Hall, Inc., Englewood Cliffs, NJ
72. Strange K.F. Making BI strategic. The key issues, LE-19-4691 (2003), Gartner Group
73. Straub D., Boudreau M., and Gefen D. Validation guidelines for IS positivist research. Communications of the AIS 13 24 (2004)
74. Swanson E.B. Information systems innovation among organizations. Management Science 40 9 (1991)
75. Tait P., and Vessey I. The effect of user involvement on system success: a contingency approach. MIS Quarterly 12 1 (1988)
76. Thompson J.D. Organizations in Action (1967), McGraw-Hill
77. Tractinsky N., and Jarvenpaa S. Information systems design decisions in a global versus domestic context. MIS Quarterly 19 4 (1995)
78. Triandis H. Values, attitudes, and interpersonal behavior. Nebraska Symposium on Motivation: Beliefs, Attitude, and Values (1979), University of Nebraska Press
79. Tushman M.L., and Nadler D. Information processing as an integrating concept in organizational design. Academy of Management Review 3 3 (1978)
80. Vail E.F. Causal architecture: bringing the Zachman framework to life. Information Systems Management. 19 3 (2002)
81. Volonino L., Watson H.J., and Robinson S. Using EIS to respond to dynamic business conditions. Decision Support Systems 14 (1995)
82. Walter T. Teradata's real-time enterprise reference architecture: a blueprint for the future of IT. Teradata Magazine 5 1 (2005)
83. Watson H.J. Real time: the next generation of decision-support data management. Business Intelligence Journal 10 3 (2005)
84. Watson H.J., Watson R., Singh S., and Holmes D. Development practices for EIS: findings of a field-study. Decision Support Systems 14 2 (1995)
85. Watson H.J., Wixom B., and Buonamici J. Creating intelligence across the supply chain. Communications of the AIS 5 9 (2001)
86. Watson H.J., Goodhue D.L., and Wixom B. The benefits of warehousing: why some firms realize exceptional payoffs. Information & Management 39 6 (2002)
87. Weill P., and Broadbent M. Leveraging the New Infrastructure (1998), Harvard Business School, Boston
88. Willcocks L., and Sykes R. Enterprise resource planning: the role of the CIO and IT function in ERP. Communications of the ACM 43 4 (2000)
89. Wybo M.D., and Goodhue D.L. Using interdependence as a predictor of data standards: theoretical and measurement issues. Information & Management 29 6 (1995)
90. Zmud R., and Boynton A. Survey measures and instruments in MIS. In: Kraemer K.L. (Ed). The Information Systems Research Challenge (1991), Harvard Business School Press, Cambridge