Designing a Master Data Architecture Case Study

Excerpt from Case Study :

BJ's Wholesale Enterprise Architecture

It is necessary to develop a business environment that shelters all applications under one roof. As such, the business environment will minimize the average cost of running a business and ensure that systems are not redundant. A desirable business environment is one that merges I.T orientations to a business environment without the two contradicting each other. Subsequent effort to improvise this system has seen software developers come up with responsive system, ERP systems, or Point of Sales amongst others. However, these systems fail to provide a comprehensive business approach. After all, quality counts than quantity and having many systems does not denote proper service orientation. For this reason, researchers affiliated to IBM developed the MDM to ensure that various business systems are well and fully managed and thus, eliminating the occurrence of redundancy.

Part One: Business model

List of acronyms


Enterprise Resource Planning. This business management software is integrated into the application and obliged to collect, store, manage and interpret data in a business environment.


Master Data Management is a technology discipline that integrates I.T in a real business environment. The core focus includes; accountability, accuracy, consistency, uniformity, and stewardship.

BJ Wholesale

This is a brand name of an American company that operates discounted department stores. The firm operates in United States East Coast and Ohio


Java 2, Platform, Enterprise Edition. This is a widely used Java platform designed for mainframe scale computing whose design facilitates the service of large enterprises and organizations. J2EE includes vital components of the Java language, which are Java 2 Platform and Standard J2SEE.


Commonly referred as Enterprise Architecture as established IBM, it is vital in the analysis of a system, designing, planning, and implementation. EA applies certified principles and practices utilizing various aspects of the enterprise.


International Business Model is a software and hardware development company that offers enterprise solutions.


The Open Group Architecture Framework, TOGAF, is an established standard framework that responds planning, implementing, designing, and governing enterprise information architecture. TOGAF provides an appropriate approach in establishing reliable stands for Business, application, data, and technologies.

Project manager

Matthew James +190-725-44XXX

Business department

The coordination department is entitled to conduct close functional requirements for Point of Sale and ERP system. Otto (2012, pp. 337) argues that the application functions include diagrams and their descriptions. Diagrams show the basic information flow among processes included in the multidisciplinary analysis and the overall optimization framework. Diagrams show the basic information, which allows the principal passes of data. In other words, this department specifies; models of the business activities that BJ must undertake. The model data should meet global requirements. Alternatively, the model demonstrates the application and requirements types to be realized. This specifies requirements were pertaining technological expectations and characteristics. As such, the department specifies goals based on various phases of project development.

Definition of application

The application provides an open channel of communication. There are four systems being pursued by BJ including Point of Sale, Gas (BJs sells gas at some of its clubs), warehouse management, and Payroll, which are all part of the MDM. This application seeks to dispense decision-making processes based on the organizational choices. Individual members of the organizational process communication item channel. Communication is dispensed in bottom-top and top-bottom channels where four systems are followed in the collection of phases. With time, BJ objectives will be understood by all people.

Supported business functions

The above businesses functions have been integrated successfully. Nonfunctional consideration provides promotion efforts and of the product and services, being pursued by BJs. BJ enjoys a higher status system, which is planning, and proper operations. These abilities are achieved by the development of pitch. As such, customers can achieve this through the provision of pitch. Lamolle, Menet and Duc (2013, pp. 22) argued that the pitch establishes a framework where customers and suppliers can view the product and services with ease. In addition, the organization pursues proof of objective metrics, and this ensures that customers and suppliers to confirm its position. Finally, BJ systems propose performances in which the firm delivers on the pitch.

Business Budgeting and application

The IS personnel facilitates the various system development and deployment while costing provides an analysis on product development. The organization has allocated human resources, which determine the process production or the service drive work performed. Discrepancies in costing assignments determine activity and traditional costing which common in most departments. Costing of the application provides product determination of the ABC system (Nedumov, 2013). BJ system life cycle specifies hardware components, which should be applied. In addition, the monthly maintenance cost requests system hardware facilities, which are applied alternatively. Secondly, BJ personnel specify preventive maintenance cost of computer system hardware. Thirdly, BJ is corrective maintenance cost of the computer system hardware.

For BJ, the heart of the four systems usually is strongly influenced by the ultimate design of the DWC system. Alur (2009) establishes that cost evaluations are applied to provide optimum design. These are process, which examines successive cost vs. benefits of the application. Additional capabilities of the system examine the overall design results, and this analysis achieves the maximum desired benefits at a reasonable cost. Increased budgeting is vital the development information system. Business requirements must stay within budgeting, be completed on time, and managed effectively. Planning and project management provide the system BJ system on the costing blueprint, which is vital in mitigating overhead cost evolved in the various stages of the product development. In fact, issues are managed lucidly at this point, through initiating budgeting and scheduling issues.

EA Principles relevant with BJ



Improvise positive communication skills, which are open and clear


BJ will benefit from an expanded resource sharing mechanism. MDM version 11.0 will ensure that there is proper delivery of good, and this means that enhanced agility at the storage area. The principle program is the Point of Sale and warehouse management. BJs proof points include reduced time of reconciliation, greater financial and accuracy control, problem transaction and reduced financial losses and significant cost saving through automation of manual tasks. Point of sale and warehouse management will be seconded by a payroll system, which remunerates employees. For this reason, the program is important since Matthew James will be in a position to monitor the acquisition and dispensation of the program.


MDM version 11.0 will coordinate software system named in the above statement. The goal is to enhance activities through communication of a common system and minimize cost and time used. The system is congruent with requirements of the organization since each transaction will be registered on the MDM server. This system will affect Matthew's activities because he will not be required to check in by phone to various program supervisors. The program will ensure that clients are principally served at a minimal cost as possible.

Part Two:

System Technical Aspects

Year implemented, 2013

Master Data Management (MDM) version 10.1 has been revised with the current version being 11.0. This version has adopted various components from its predecessor version 10.0. Similarly, the system can operate on a standalone server or a web-server. Additionally, MDM has been developed from J2EE perspective in RSA right clicking to an import an EAR file. IBM has further provided users with specifically with legacy MDM and MDS. Additionally, the system provides a virtual hub, which is easier to either applying the centralized style or hybrid. Critical features include; enhances Expanded Patient Hub features for medical applications. Finally, enhanced MDM and Data-Stage integration specifically developed for the provision of more server room (Haug, 2011, pp. 288).

Bath and Online

Both, MDM can operate online or as primarily batch. Version 11 enables the processing system and data be collected in groups. Processing enables the interactive of different groups. Online processing is used for interactive business system, and this enhances immediate data input and output. Alternatively, in version 11, batch processing enables the development of a large amount of data to provide for routine scheduling like integration of credit card transactions on employee salaries. Additionally, the online version enables proper assess and more so; Smartphone companies are provisioning for the development of apps, which can operate on the phone while facilitating ease of assessment. In summary, batch and online system enables the development of the 1000 records to run the program in version 11 (Nedumov, 2013, pp. 119).

Daily Frequency

The frequent nature of data updates requires system administrators monitor the system on a day-to-day basis. Admin logs can be authenticated at either offline or online sourcing. The system applies Architecture Development Method that meets business and information needs of the organization. Haug (2011, pp. 289) establishes that the TOGAF approach is appropriate since it enables the MDM to meet requirements the business. A desirable system is one that does not change business objective, but seeks to encourage the development of an information system that meets decisive goals of the business. In addition, the system encourages the development of an Architecture Repository.…

Cite This Case Study:

"Designing A Master Data Architecture" (2014, May 31) Retrieved January 19, 2018, from

"Designing A Master Data Architecture" 31 May 2014. Web.19 January. 2018. <>

"Designing A Master Data Architecture", 31 May 2014, Accessed.19 January. 2018,