The Application of Data Warehouse in Enterprise Resource Planning

PurposeThe need for an integrated enterprise‐wide approach to management information pronounced data warehousing (DW) the “hot topic” of the early‐to‐mid‐1990s. However, it became unfashionable in the late 1990s, with the widespread implementation of enterprise resource planning (ERP) systems. With ERP managers were led to believe that they would derive informational as well as operational benefits from the introduction of integrated enterprise‐wide systems. However, the recent re‐emergence of DW, to address the limitations and unrealised benefits of ERP systems, provides a new, more complex integration challenge. The main objective of this paper is to present the concept of organisational prerequisites for enterprise‐wide integration projects as a means to help managers preparing for and managing their ERP/DW projects.Design/methodology/approachThis paper draws on existing literature on ERP and DW implementations. It puts forward a model to be further tested and validated by ERP researchers.FindingsThe proposed model has the potential to solve the problems experienced in ERP implementations and, more generally, in projects leading to large‐scale enterprise integration.Originality/valueExisting ERP research indicates that the intelligence phase of most ERP projects is ignored both in practice and in research. This paper lays the foundation for a framework that addresses this problem.

As an efficient data management and analysis technology, the data warehouse realizes centralized storage and management of data by integrating data scattered in educational institutions. It can dig out the laws and trends hidden behind the data and provide more accurate and comprehensive data support for educational evaluation. In the educational evaluation system, the application of data warehouses is embodied in data integration and management, multidimensional evaluation, personalized learning support, and educational decision optimization. Through a multidimensional evaluation model, the school can comprehensively evaluate students' academic performance and comprehensive quality and provide strong support for personalized teaching. Data warehouses can also record and analyze students' learning trajectory and provide customized learning materials and exercises for each student, which significantly improves learning efficiency.

Advances in data warehousing and Internet technology have spurred ERP development, but these systems still need some improvements. The information era has dramatically changed the business environment, and keen competition puts tremendous demands on companies to reduce total cost and maximize return on investment. This is why more businesses are seeing systems for enterprise resource planning (ERP) as key to remaining competitive. To keep pace, ERP systems themselves have undergone considerable change in the past 10 years (1990-2000). To help your organization make the right ERP choices, it is helpful to know how two key technologies: data warehousing and the Internet, are transforming these complex systems.

Data warehousing is emerging as one of the hottest areas of growth in global business and the critical component and tool for business intelligence. In the data warehouse environment, the level of summarization plays an important role. Some Data Warehouse applications, directly account for the uncertainty and vagueness often associated with time-series and enterprise-wide decision making. In this paper, we enhance the concept of summarization using fuzzy technology, keeping in view the time-series and enterprise-wide data. This enhancement, which extends the aggregation process used in data warehouse, provides insightful information intelligently and allows greater facility for modeling human decision making.

The purpose of this research is to assist in providing information to support decision-making processes in sales, purchasing and inventory control at PT Tatamas Pelita Jaya. With the support of data warehouse, business leaders can be more helpful in making decisions more quickly and precisely. Research methodology includes analysis of current systems, library research, designing a data warehousing schema using bintang. The result of this research is the availability of a data warehouse that can generate information quickly and precisely, thus helping the company in making decisions. The conclusion of this research is the application of data warehouse can be a media aide related parties on PT Tatamas Pelita Jaya in decision making.

How to build a data warehouse and data mining is constantly worth exploring and optimization, not only technically, in commercial applications as well. This article discusses the introduction of new technologies and concepts, the traditional method of data warehouse technology has changed dramatically, based on data warehouse applications are a new development. Each enterprise data warehouse based on the characteristics of different companies, you can use a very flexible method of selection and design selection, implementation. According to some relatively new technical features, talk about data warehousing and data mining architecture.

The worldwide installed base of Enterprise Resource Planning (ERP) systems has increased rapidly in size over the past 10 years now comprising tens of thousands of installations in large- and medium-sized organizations and millions of licensed users. Similar to traditional Information Systems (IS), ERP systems must be maintained and upgraded. It is therefore not surprising that EPP maintenance activities have become the largest budget provision in the IS departments of ERP-adopting organizations. Yet, there has been very limited study conducted on ERP maintenance activities. Are they simply instances of traditional software maintenance activities to which traditional software maintenance research findings can be generalized? Or are they fundamentally different activities, such that new research, specific to ERP maintenance, is required to help alleviate the ERP maintenance burden? This paper reports a case study of a large organization that implemented ERP (an SAP system) two years ago. From the case study and data collected, we observe that (1) an ERP-employing organization does not only maintain user change request but also implement maintenance introduced by the vendor; (2) request for user-support. concerning the ERP system usage, and training constitutes a main part of ERP maintenance activities; and (3) configuration is a major ERP maintenance component. We find that ERP maintenance activities are indeed different from traditional in-house software maintenance in a way that these maintenance activities cannot be sufficiently described by existing taxonomies used to classify traditional software maintenance activities. We propose a benefits-oriented taxonomy that better represents ERP enhancement maintenance activities.

The Small&Medium steel enterprises is relatively weak on information technology, and the information management personnel lack the urgent need for information integration. According to the actual needs of the Small&Medium steel enterprises information management, three-tier architecture of information integration systems is proposed in this paper. By using SQL Server to implement database and data warehouse, data mining models is built and the design of information integration system is completed. The system covers the steel purchase, inventory, sale, distribution, contracts, finance, statistical analysis, decision support and other management functions. The proposed system can meet the Small&Medium steel enterprises scientific and orderly management for information resources, and the needs of managers forecasting, decision-making. Data warehouse and data mining applications can give an excellent support to the implementation of business intelligence in the future.

This publication is devoted to the problem of informatization and automation of management at the enterprise. The study found that the use of innovative systems is becoming increasingly popular in the Ukrainian market. Automation plays a crucial role in ensuring the growth of efficiency indicators of economic activity, but among domestic enterprises, there is a problem in choosing the use of a particular information system. This article describes the main advantages and disadvantages of ERP and CRM systems. Approaches to definitions are defined, and the concepts of ERP and CRM as methodologies of effective resource planning and system of automation of interaction with clients are revealed. A comparative analysis of ERP and CRM systems is carried out. The main functions of CRM systems are studied, among which: are the formation of a single information client base; working time management; optimization of communications within the company; sales planning. The place of the customer in the customer relationship management system is determined. The main modules of the ERP system are analyzed, namely: finance, personnel, sales, procurement, production, logistics, service, research and development, and assets. A detailed description of the functional solution when using the resource management system is given. The main tools of ERP and CRM systems are identified. As a result of the analysis of the modern market of information systems the main suppliers of software products and their weight in the given market segment are defined. A number of software products of ERP and CRM systems popular in Ukraine have been studied. The level of implementation of CRM systems by industry structure is determined. It is established that the maximum result from the implementation of CRM systems is possible only when they are implemented together with the integrated internal ERP system.

The data warehouse is based on the development of relational databases, parallel processing and distributed processing technologies, as well as online analytical processing technologies. SAP BW is widely used in many enterprise data warehouses. It can issue reports of enterprises at the group level, manage the group's business operations, help find the laws and trends behind the performance of corporations and ultimately provide decision-making support for decision makers of enterprises. Therefore, how to use the SAP BW model architecture to better realize enterprise data warehouses is one of the hot topics in the data warehouse industry today. For a large corporation, its branches and subsidiaries have deployed multiple sets of enterprise data warehouses. At the same time, because there are multiple sets of data warehouse systems, when the data model needs to be modified at the group level, the data model of the branch also needs to be modified accordingly, and the flexibility of maintenance is poor. Finally, every time the corporation needs to upgrade the version of the data warehouse, it needs to maintain and upgrade the version of the data warehouse of each branch and the maintenance cost is high. Therefore, how to integrate multiple sets of data warehouses distributed in various subsidiaries into a corporation enterprise data warehouse by designing the model hierarchy, so as to ensure the reliability of data, enhance the flexibility of model modification and reduce the cost of data warehouse. This paper completes the design of an enterprise data warehouse of a large corporation, which can be used for the summary and collation of data from multiple branches such as finance and sales of a corporation, effectively improving the efficiency of data utilization and ensuring the authenticity of data. At the same time, through hierarchical design, the problems of poor flexibility in model modification and high system maintenance costs are solved.

Unfortunately, IT shops in many organizations lack data warehousing expertise because they have deployed existing IT staff resources to address operational source systems and enterprise resource planning (ERP) systems. Because many strategic business solutions depend heavily on a solid data warehouse foundation, many organizations will find themselves lagging behind or out of business, if they do not implement a data warehouse. The paper discusses the benefits and disadvantages of data warehousing. It considers the keys to implementation success along with a few real world examples.

Every business or government agency needs to track information regarding their finances, their employees, and the items or assets they own and manage. Software applications that track this type of information are called enterprise resource planning (ERP) systems. Managing these assets in an integrated application allows an organization to have a consistent view across the entire enterprise. This enterprise-wide view allows ERP systems to go beyond the traditional transaction-based accounting systems maintained at the organization level and deliver fully integrated financial and human capital management based on industry-derived best practices across organizations. In response to the pressures of global competition, enterprises today are forging ahead with the mission of integrating information systems across corporate boundaries to unite customers, suppliers and any other business partners with which they interact. And in the mean time, with the development of the society, more and more people have to go many places because the job makes them and working at home also becomes more and more popular. Those people who are not at the place of their company also want to continue their work in other places even at home. The old style ERP system is in C/S model and cannot satisfy with the needs. So it is very necessary to upgrade the ERP system. This paper will go to figure out the application of the Web service in the upgrading of ERP system. In this paper, we focus on that how to upgrade or renew a C/S ERP system to an ERP system with B/S model and the application of Web service. We use the J2EE architecture and XML technology to provide Web service and upgrade/renew the former ERP system. UML tools play a very important role in the upgrading procedure. We use UML to analysis and design the B/S ERP system, which based on the C/S version. We use JSP to act as the view of the system because of its flexibility. In the Web service, the XML is necessary. So the XML technology is also used. In the end of the paper, we will figure out how these technologies to be used through a concrete example.

Currently, the shipping company's statistical data on cargo is usually obtained through the complex operation of the business database. The statistical items are also very limited. To improve the competitiveness of shipping company and optimize its ship scheduling business, this paper mainly researches on technology and application of data warehouse in oceangoing ship scheduling business. According to the customer's actual and objective needs, the ship scheduling data warehouse is designed. Based on Microsoft SQL Server 2008 platform and ship scheduling data of a shipping company, the ship scheduling data warehouse for cargo loading/discharging analysis in global ports is established in this paper, which can offer data deeply analysis and multidimensional display.

E-government allows governments to service citizens in a more timely, effective, and costefficient method. E-Government services focus on four main customers: citizens, the business community, government employees, and government agencies. E-government can provide four types of services, which are Government-to-Citizen (G2C), Government-toBusiness (G2B), Government-to-Employee (G2E), and Government-to-Government (G2G). E-government system has already been very popular all over the world, because Egovernment helps to disseminate information. Further, it aids in the collection of information that helps decision makers serve citizens more effectively. E-Government allows government agencies to centralize decision making. China have started first E-Government program in the late 1980s, in which the governments both at central and local levels built up office automation (OA) systems and established an intranet, subsequently the Central Government of China had formally launched five Golden Projects (Golden Bridge Project, Golden Customs Project, Golden Card Project, Golden Tax Project and Government online Project) aimed at building E-Government in China ever since 1990s. After realizing five Golden Projects, Chinese government has set ambitious visions in the implementation of E-Government: quicken the pace of change in government functions to suit the requirement of reform, opening up and modernization policies, improve the performance of government operation, introduce new government measures in a scientific manner and more effective mechanisms to monitor the economic activities, place a greater emphasis on central co-ordination and transparency of government work, carry out administrative functions in accordance with law and provide better service for the public. To meet above ambitious visions, the Central Government of China have programmed to establish four governance information resource databases in next five years, governance information resource databases consist of four databases: population basic information database, judicial entity basic information database, natural resource and geography basic information database, and macroscopically economy database. A data warehouse has been defined as a collection of data in support of management decisions which is: subject oriented, integrated, nonvolatile, time variant. Data warehouse, as a collection of database or data management technologies, emerged in the early 1990s. The data warehouse has now been more generally seen as a strategy to bring heterogeneous 19

Power transformers' failures carry great costs to electric companies since they need resources to recover from them and to perform periodical maintenance. To avoid this problem in four working 40 MVA transformers, the authors have implemented the measurement system of a failure prediction tool, that is the basis of a predictive maintenance infrastructure. The prediction models obtain their inputs from sensors, whose values must be previously conditioned, sampled and filtered, since the forecasting algorithms need clean data to work properly. Applying data warehouse (DW) techniques, the models have been provided with an abstraction of sensors the authors have called virtual cards (VC). By means of these virtual devices, models have access to clean data, both fresh and historic, from the set of sensors they need. Besides, several characteristics of the data flow coming from the VCs, such as the sample rate or the set of sensors itself, can be dynamically reconfigured. A replication scheme was implemented to allow the distribution of demanding processing tasks and the remote management of the prediction applications. VCs and the modular architecture proposed make the system scalable, reconfigurable and easy to maintain.