Building an Effective Data Warehousing for Financial Sector

Ferreira, Joana; Almeida, Fernando; Monteiro, José

doi:10.12691/acis-3-1-4

Cited by 3 publications

(6 citation statements)

References 17 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…It follows that the OLAP cube provides superior performance, since this difference is also highly statistically significant. [5] Donia Ali Hamed et. All (2019) Testing the Data Warehouse Environment may be done in a few different ways, including Data Quality Testing, Database Testing, and ETL Testing.…”

Section: ) Decision Making and Processing In Real Timementioning

confidence: 99%

“…The technical design, the data design, and the hardware and software design are all areas where DW architecture shines. [5] The design space of DW architecture may be broadly classified as either enterprise DW design or design related to data marts. Combining these progressive data warehouses is what we call "enterprise DW."…”

Section: Figure: 1 Data Warehouse Architecturementioning

confidence: 99%

See 1 more Smart Citation

The Transformational Impact of Modern Data Warehousing on the Banking System

Dibouliya,

Jotwani

2023

IJRASET

View full text Add to dashboard Cite

The banking industry is undergoing a significant transformation driven by technological advancements, and modern data warehousing has emerged as a critical component in this evolution. This review paper examines how modern data warehousing is transforming the banking system, highlighting its impact on data management, analytics, real-time processing, regulatory compliance, customer insights, personalization, scalability, and cost efficiency. By synthesizing the existing literature and industry practices, this review aims to provide a comprehensive understanding of the role of modern data warehousing in reshaping the banking landscape.

show abstract

Section: ) Decision Making and Processing In Real Timementioning

confidence: 99%

Section: Figure: 1 Data Warehouse Architecturementioning

confidence: 99%

The Transformational Impact of Modern Data Warehousing on the Banking System

Dibouliya,

Jotwani

2023

IJRASET

View full text Add to dashboard Cite

show abstract

“…Both private and public institutions need to carry out more informed and complex data analysis to support the decision-making process. Consequently, as the traditional database systems, mainly used to support daily transactions and basic querying operations, are not able to offer the required tools to properly analyze information, DW systems represent appropriate tools to answer the demands of different decision-makers (Ferreira et al , 2017). Likewise, the main problem with e-government systems is the growing need for an accurate repository of data to support managerial and analytical requirements.…”

Section: Data Warehouse and E-governancementioning

confidence: 99%

“…Various e-government projects worldwide have made usage of data warehousing and business intelligence techniques in diverse fields such as agriculture (Sonali et al , 2010), education (Bhanti et al , 2011; ElFangary, 2009), public heath (Ewen and Smith, 1999), citizen grievance (Sangeetha and Manjunatha, Rao, 2016), finance (Ferreira et al , 2017) and public security (Syvajarvi and Stenvall, 2010). Indeed, there exist various practices depicted in kinds of literature to increase the efficiency of e-government systems, where data warehousing techniques were used, however, to the best of our knowledge the use of DWs for assessing governance locally or nationwide was not covered so far.…”

Section: Data Warehouse and E-governancementioning

confidence: 99%

A data warehouse hybrid design framework using domain ontologies for local good-governance assessment

Chakiri

Mohajir

Assem

2020

View full text Add to dashboard Cite

Purpose Most local governance assessment tools are entirely or partially based on stakeholders’ surveys, focus groups and benchmarks of different local governments in the world. These tools remain a subjective way of local governance evaluation. To measure the performance of local good-governance using an unbiased assessment technique, the authors have developed a framework to help automate the design process of a data warehouse (DW), which provides local and central decision-makers with factual, measurable and accurate local government data to help assess the performance of local government. The purpose of this paper is to propose the extraction of the DW schema based on a mixed approach that adopts both i* framework for requirements-based representation and domain ontologies for data source representation, to extract the multi-dimensional (MD) elements. The data was collected from various sources and information systems (ISs) deployed in different municipalities. Design/methodology/approach The authors present a framework for the design and implementation of a DW for local good-governance assessment. The extraction of facts and dimensions of the DW’s MD schema is done using a hybrid approach, where the extraction of requirement-based DW schema and source-based DW schema are done in parallel followed by the reconciliation of the obtained schemas to obtain the good-governance assessment DW final design. Findings The authors developed a novel framework to design and implement a DW for local good-governance assessment. The framework enables the extraction of the DW MD schema by using domain ontologies to help capture semantic artifacts and minimize misconceptions and misunderstandings between different stakeholders. The introduction and use of domain ontologies during the design process serves the generalization and automation purpose of the framework. Research limitations/implications The presently conducted research faced two main limitations as follows: the first is the full automation of the design process of the DW and the second, and most important, is access to local government data as it remains limited because of the lack of digitally stored data in municipalities, especially in developing countries in addition to the difficulty of accessing the data because of regulatory aspects and bureaucracy. Practical implications The local government environment is among the public administrations most subject to change-adverse cultures and where the authors can face high levels of resistance and significant difficulties during the implementation of decision support systems, despite the commitment/engagement of decision-makers. Access to data sources stored by different ISs might be challenging. While approaching the municipalities for data access, it was done in the framework of a research project within one of the most notorious universities in the country, which gave more credibility and trust to the research team. There is also a need for further testing of the framework to reveal its scalability and performance characteristics. Originality/value Compared to other local government assessment ad hoc tools that are partially or entirely based on subjectively collected data, the framework provides a basis for automated design of a comprehensive local government DW using e-government domain ontologies for data source representation coupled with the goal, rationale and business process diagrams for user requirements representations, thus enabling the extraction of the final DW MD schema.

show abstract

“…The central purpose of PL/SQL is to provide a portable, fast, easy way to write and execute SQL against an Oracle database. Oracle PL/SQL has been used in several applications that require data-intensive analysis [27][28][29]. P o l j a k, P o s c i c and J a k s i c [30] identify some of the main advantages of an Oracle database when compared to other relational databases, unleashing its robustness, reliability and performance optimization for large data volume.…”

Section: Optimization Techniques In Oracle Pl/sqlmentioning

confidence: 99%

Performance Analysis and Optimization Techniques for Oracle Relational Databases

Almeida

Araújo

2019

Cybernetics and Information Technologies

Self Cite

View full text Add to dashboard Cite

Databases provide an efficient way to store, retrieve and analyze data. Oracle relational database is one of the most popular database management systems that is widely used in a different variety of industries and businesses. Therefore, it is important to guarantee that the database access and data manipulation is optimized for reducing database system response time. This paper intends to analyze the performance and the main optimization techniques (Forall, Returning, and Bulk Collect) that can be adopted for Oracle Relational Databases. The results have shown that the adoption of Forall and Bulk Collect approaches bring significant benefits in terms of execution time. Furthermore, the growth rate of the average execution time is lower for Bulk Collect than Forall. However, adoption of Returning approach doesn’t bring significant statistical benefits.

show abstract

Building an Effective Data Warehousing for Financial Sector

Cited by 3 publications

References 17 publications

The Transformational Impact of Modern Data Warehousing on the Banking System

The Transformational Impact of Modern Data Warehousing on the Banking System

A data warehouse hybrid design framework using domain ontologies for local good-governance assessment

Performance Analysis and Optimization Techniques for Oracle Relational Databases

Contact Info

Product

Resources

About