ERP and data warehouse for decision support | |
| Author | Mia, Md. Badruddozza |
| Call Number | AIT Thesis no.IM-02-11 |
| Subject(s) | Data warehousing Decision support systems Enterprise resource planning |
| Note | A thesis submitted in partial fulfillment of the requirements for the degree of Master of Science, School of Advanced Technologies |
| Publisher | Asian Institute of Technology |
| Series Statement | Thesis ; no. IM-02-11 |
| Abstract | This thesis contains illustrative descriptions of inconveniences of analyzing data in ERP system to provide decision-support and planning information with a comparison of doing this in data warehouse. It describes the circumstances where data warehouse works better than ERP for analyzing data. A case study has been made to see the data arrangement in ERP and data warehouse from the decision-support point of view. An enterprise information system model containing ERP and data warehouse has been proposed in order to optimize the utilization of operational data for strategic use for large and information driven organizations. Problems of transforming data from ERP along with other internal and external sources to data warehouse have been identified. Data transformation framework architecture for resolving the problems of transforming data from heterogeneous sources has been proposed in this thesis. Prototype implementation of data transformation tool has been developed on client/server architecture using SQL Server and Visual FoxPro in a thin client approach of development. Resolving mechanisms of different types of conflicts occur during data transformation are described in this thesis. |
| Year | 2002 |
| Corresponding Series Added Entry | Asian Institute of Technology. Thesis ; no. IM-02-11 |
| Type | Thesis |
| School | School of Advanced Technologies (SAT) |
| Department | Department of Information and Communications Technologies (DICT) |
| Academic Program/FoS | Information Management (IM) |
| Chairperson(s) | Vatcharaporn Esichaikul; |
| Examination Committee(s) | Voratas Kachitvichyanukul;Bechter, Clemens; |
| Scholarship Donor(s) | PROSHIKA;Asian Institute of Technology (Partial Scholarship); |
| Degree | Thesis (M.Sc.) - Asian Institute of Technology, 2002 |