Topic
Data mart
About: Data mart is a research topic. Over the lifetime, 559 publications have been published within this topic receiving 8550 citations.
Papers published on a yearly basis
Papers
More filters
•
06 Jul 2017TL;DR: In this paper, the authors present techniques for generating and deploying a computer model with relatively few inputs from a user, and for creating a data mart that multiple computer models may leverage in order to decrease the time required to generate subsequent computer models.
Abstract: Techniques are provided for generating and deploying a computer model with relatively few inputs from a user. Techniques are also provided for creating a data mart that multiple computer models may leverage in order to decrease the time required to generate subsequent computer models.
4 citations
•
23 Oct 2007-World Academy of Science, Engineering and Technology, International Journal of Computer, Electrical, Automation, Control and Information Engineering
TL;DR: The capability of DTS as a database solution for automatic data transfer and update in solving business problem is demonstrated to be attractive.
Abstract: Trends in business intelligence, e-commerce and remote access make it necessary and practical to store data in different ways on multiple systems with different operating systems. As business evolve and grow, they require efficient computerized solution to perform data update and to access data from diverse enterprise business applications. The objective of this paper is to demonstrate the capability of DTS (1) as a database solution for automatic data transfer and update in solving business problem. This DTS package is developed for the sales of variety of plants and eventually expanded into commercial supply and landscaping business. Dimension data modeling is used in DTS package to extract, transform and load data from heterogeneous database systems such as MySQL, Microsoft Access and Oracle that consolidates into a Data Mart residing in SQL Server. Hence, the data transfer from various databases is scheduled to run automatically every quarter of the year to review the efficient sales analysis. Therefore, DTS is absolutely an attractive solution for automatic data transfer and update which meeting today's business needs.
4 citations
••
01 Jan 2020TL;DR: This paper analyzes the work implemented in the education domain focusing on DW concepts in detail and concludes that usage of data warehouse in education will give a great benefit to the government/private educational officers by obtaining a single version of the truth of school information.
Abstract: Data warehouse, otherwise known as DW, is a central repository to hold the history of data which will be created by the integration or consolidation of data from several external sources and from the operational and transactional data stores of the organization. This data repository will be majorly used by the firms to analyze the data for empowering ideal business decisions to get decided. It performs the role of a system for decision support (DSS), to obtain conclusion based on the analyzed pattern of data to the decision maker(s) of the organization. Usage of data warehouse in education will give a great benefit to the government/private educational officers, by obtaining a single version of the truth of school information. This paper analyzes the work implemented in the education domain focusing on DW concepts in detail.
4 citations
••
01 Jan 2012
TL;DR: This chapter describes the concepts and building blocks of classic business intelligence systems, such as central data warehouse, data mart, operational store, ETL, and replication, and lists the limitations of those classic systems in regard to the support of modern-day user requirements.
Abstract: To clearly explain what the difference is between a business intelligence system that does deploy data virtualization and one that doesn’t, this chapter describes the concepts and building blocks of classic business intelligence systems, such as central data warehouse, data mart, operational store, ETL, and replication. It also lists the limitations of those classic systems in regard to the support of modern-day user requirements. Also, the reasons why some of these data stores were introduced, are being reinvestigated. This is necessary for explaining why data virtualization can be beneficial.
4 citations