Skip to main content

2023 | OriginalPaper | Buchkapitel

Improve Quality of Data Management and Maintenance in Data Warehouse Systems

verfasst von : Sakshi Hooda, Suman Mann

Erschienen in: Proceedings of the 6th International Conference on Advance Computing and Intelligent Engineering

Verlag: Springer Nature Singapore

Aktivieren Sie unsere intelligente Suche, um passende Fachinhalte oder Patente zu finden.

search-config
loading …

Abstract

Data warehouses bring an organization’s data together in one place for reporting and analysis. Top-level management receives key performance metrics, middle-level management receives analytical strength and bottom-level management receives consistent and accurate data based on analytical system information. Despite the numerous domain-specific challenges, data warehouses must be financially viable to be successful. We conducted a comprehensive literature review and read case studies of organizations that have successfully implemented data warehousing solutions in order to compile a list of best practices that can serve as guidelines for new practitioners and organizations new to this technology.

Sie haben noch keine Lizenz? Dann Informieren Sie sich jetzt über unsere Produkte:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Literatur
1.
Zurück zum Zitat Gosain, A., & Mann, S. (2012). An object-oriented multidimensional model for data warehouse. In Fourth international conference on machine vision (ICMV 2011): computer vision and image analysis; pattern recognition and basic technologies, 8350, pp. 83500I. Gosain, A., & Mann, S. (2012). An object-oriented multidimensional model for data warehouse. In Fourth international conference on machine vision (ICMV 2011): computer vision and image analysis; pattern recognition and basic technologies, 8350, pp. 83500I.
3.
Zurück zum Zitat Gosain, A., Khatri, S. K., & Mann, S. (2014). Multidimensional modeling for data warehouse using object oriented approach. In Proceedings of 3rd international conference on reliability, infocom technologies and optimization, pp. 1–6. Gosain, A., Khatri, S. K., & Mann, S. (2014). Multidimensional modeling for data warehouse using object oriented approach. In Proceedings of 3rd international conference on reliability, infocom technologies and optimization, pp. 1–6.
4.
Zurück zum Zitat Winter, R., & Strauch, B. (2003). A method for demand-driven information requirements analysis in data warehousing projects. In Proceedings of HICSS. pp. 1359– 1365. Winter, R., & Strauch, B. (2003). A method for demand-driven information requirements analysis in data warehousing projects. In Proceedings of HICSS. pp. 1359– 1365.
5.
Zurück zum Zitat Mazón, J. N., Trujillo, J., Serrano, M., & Piattini, M. (2005). Designing data warehouses: From business requirement analysis to multidimensional modeling. In Proceedings of int. work. on requirements engineering for business needs and IT alignment. Mazón, J. N., Trujillo, J., Serrano, M., & Piattini, M. (2005). Designing data warehouses: From business requirement analysis to multidimensional modeling. In Proceedings of int. work. on requirements engineering for business needs and IT alignment.
6.
Zurück zum Zitat Giorgini, P., Rizzi, S., & Garzetti, M. (2005). Goal-oriented requirement analysis for data warehouse design. In Proceedings of DOLAP, pp. 47–56. Giorgini, P., Rizzi, S., & Garzetti, M. (2005). Goal-oriented requirement analysis for data warehouse design. In Proceedings of DOLAP, pp. 47–56.
7.
Zurück zum Zitat SAP (2000). Multi-dimensional modeling with BW. Technical report, SAP America Inc. and SAP AG SAP (2000). Multi-dimensional modeling with BW. Technical report, SAP America Inc. and SAP AG
8.
Zurück zum Zitat Prashant, R., Suman, M., & Eashwaran, R. (2021). Efficient data cube materialization. Advances in communication and computational technology, lecture notes in electrical engineering, 668. Springer, Singapore. Prashant, R., Suman, M., & Eashwaran, R. (2021). Efficient data cube materialization. Advances in communication and computational technology, lecture notes in electrical engineering, 668. Springer, Singapore.
9.
Zurück zum Zitat Mann, S., & Siwach, M. (2020). Data model quality metrics of data warehouse: A survey. In Proceedings of the international conference on innovative computing communications (ICICC-2020). Mann, S., & Siwach, M. (2020). Data model quality metrics of data warehouse: A survey. In Proceedings of the international conference on innovative computing communications (ICICC-2020).
10.
Zurück zum Zitat Mann, S., & Phogat, A. K. Dynamic construction of lattice of cuboids in data warehouse. Journal of Statistics and Management Systems, 971–982. Mann, S., & Phogat, A. K. Dynamic construction of lattice of cuboids in data warehouse. Journal of Statistics and Management Systems, 971–982.
11.
Zurück zum Zitat Wixom, B. H., & Watson, H. J. (2001). An empirical investigation of the factors affecting data warehousing success. MIS Quarterly, 25(1), 17–41.CrossRef Wixom, B. H., & Watson, H. J. (2001). An empirical investigation of the factors affecting data warehousing success. MIS Quarterly, 25(1), 17–41.CrossRef
12.
Zurück zum Zitat Jarke, M., Jeusfeld, M. A., Quix, C., & Vassiliadis, P. (1999). Architecture and quality in data warehouses: An extended repository approach. Information Systems, 24(3), 229–253.CrossRef Jarke, M., Jeusfeld, M. A., Quix, C., & Vassiliadis, P. (1999). Architecture and quality in data warehouses: An extended repository approach. Information Systems, 24(3), 229–253.CrossRef
13.
Zurück zum Zitat Panigrahi, C. R., Tiwary, M., Pati, B., & Das, H. (2016). Big data and cyber foraging: future scope and challenges. In Techniques and environments for big data analysis. Studies in big data, 17, pp. 75–100. Springer Panigrahi, C. R., Tiwary, M., Pati, B., & Das, H. (2016). Big data and cyber foraging: future scope and challenges. In Techniques and environments for big data analysis. Studies in big data, 17, pp. 75–100. Springer
14.
Zurück zum Zitat Eder, J., Bebel, B., Koncilia, C., Morzy, T., & Wrembel, R. (2004). Creation and management of versions in multi version data warehouse. In Proceedings of ACM SAC, pp. 717–723. Eder, J., Bebel, B., Koncilia, C., Morzy, T., & Wrembel, R. (2004). Creation and management of versions in multi version data warehouse. In Proceedings of ACM SAC, pp. 717–723.
15.
Zurück zum Zitat Serrano, M., Calero, C., Trujillo, J., Luján-Mora, S., & Piattini, M. (2004).Empirical validation of metrics for conceptual models of data warehouses. In Proceedings of CAiSE, pp. 506–520. Serrano, M., Calero, C., Trujillo, J., Luján-Mora, S., & Piattini, M. (2004).Empirical validation of metrics for conceptual models of data warehouses. In Proceedings of CAiSE, pp. 506–520.
16.
Zurück zum Zitat Lechtenbörger, J., & Vossen, G. (2003). Multidimensional normal forms for data warehouse design. Information Systems, 28(5), 415–434.CrossRefMATH Lechtenbörger, J., & Vossen, G. (2003). Multidimensional normal forms for data warehouse design. Information Systems, 28(5), 415–434.CrossRefMATH
17.
Zurück zum Zitat Sarkar J.L., Panigrahi C.R., Pati B., and Das H. (2016) A novel approach for real-time data management in wireless sensor networks. In Proceedings of 3rd international conference on advanced computing, networking and informatics. Smart innovation, systems and technologies, 44, pp. 599–607. Springer. Sarkar J.L., Panigrahi C.R., Pati B., and Das H. (2016) A novel approach for real-time data management in wireless sensor networks. In Proceedings of 3rd international conference on advanced computing, networking and informatics. Smart innovation, systems and technologies, 44, pp. 599–607. Springer.
18.
Zurück zum Zitat Curtis, M. B., & Joshi, K. (1998). Lessons learned from the implementation of a data warehouse. Journal of Data Warehousing, 3(2), 12–18. Curtis, M. B., & Joshi, K. (1998). Lessons learned from the implementation of a data warehouse. Journal of Data Warehousing, 3(2), 12–18.
19.
Zurück zum Zitat Hartwick, J., & Barki, H. (1994). Explaining the role of user participation in information system use. Management Science, 40(4), 440–465.CrossRef Hartwick, J., & Barki, H. (1994). Explaining the role of user participation in information system use. Management Science, 40(4), 440–465.CrossRef
20.
Zurück zum Zitat Maish, A. M. (1979). A user’s behavior toward his MIS. MIS Quarterly, 3(1), 39–52.CrossRef Maish, A. M. (1979). A user’s behavior toward his MIS. MIS Quarterly, 3(1), 39–52.CrossRef
21.
Zurück zum Zitat Goodhue, D. L., Wybo, M. D., & Kirsch, L. J. (1992). The impact of data integration on the costs and benefits of information systems. MIS Quarterly, 16(3), 293–311.CrossRef Goodhue, D. L., Wybo, M. D., & Kirsch, L. J. (1992). The impact of data integration on the costs and benefits of information systems. MIS Quarterly, 16(3), 293–311.CrossRef
22.
Zurück zum Zitat Rist, R. (1997). Challenges faced by the data ware-housing pioneers. Journal of Data Ware-housing, 2(1), 63–72. Rist, R. (1997). Challenges faced by the data ware-housing pioneers. Journal of Data Ware-housing, 2(1), 63–72.
23.
Zurück zum Zitat Hooda, Sakshi, & Mann, Suman. (2019). Distributed synthetic minority oversampling technique. International Journal of Computational Intelligence Systems, 12(2), 929–936.CrossRef Hooda, Sakshi, & Mann, Suman. (2019). Distributed synthetic minority oversampling technique. International Journal of Computational Intelligence Systems, 12(2), 929–936.CrossRef
24.
Zurück zum Zitat Hooda, S., & Mann, S. (2020). Examining the effectiveness of machine learning algorithms as classifiers for predicting disease severity in data warehouse environments. Argentina de Clínica Psicológica. Hooda, S., & Mann, S. (2020). Examining the effectiveness of machine learning algorithms as classifiers for predicting disease severity in data warehouse environments. Argentina de Clínica Psicológica.
25.
Zurück zum Zitat Gosain, A., & Mann, S. (2010). Object oriented multidimensional model for a data warehouse with operators. International Journal of Database Theory and Application, 3(4). Gosain, A., & Mann, S. (2010). Object oriented multidimensional model for a data warehouse with operators. International Journal of Database Theory and Application, 3(4).
Metadaten
Titel
Improve Quality of Data Management and Maintenance in Data Warehouse Systems
verfasst von
Sakshi Hooda
Suman Mann
Copyright-Jahr
2023
Verlag
Springer Nature Singapore
DOI
https://doi.org/10.1007/978-981-19-2225-1_60

Neuer Inhalt