Enterprise Infrastructure Evaluation for Sakila DVD Store Analysis

This report provides a detailed evaluation of the enterprise infrastructure of Sakila DVD store, a DVD rental company, focusing on the potential implementation of Business Intelligence (BI) to enhance its competitive advantage. The report is divided into two main sections: non-technical and technical infrastructure assessments. The non-technical assessment covers standards, service level agreements, project quality assurance, supporting services, and customer care. It also examines the process for merging projects, enterprise data integration, and data quality measures. The technical assessment delves into servers, client workstations, operating systems, middleware, customer interfaces, network components, database management system (DBMS) functionalities, development tools, access and analysis tools, and metadata repositories. Furthermore, the report includes a section on MySQL execution and concludes with a summary of the findings, providing a comprehensive analysis of the company's infrastructure for BI implementation.

usiness Intelligence Modeling and Analys
Enterprise Infrastructure Evaluation

Table of Contents
1. Introduction............................................................................................................................2
2. Assessment Report on Non-Technical Infrastructure........................................................2
2.1 Standards.........................................................................................................................2
2.2 Process for merging project...........................................................................................4
2.3 Enterprise Data Integration...........................................................................................4
2.4 Data quality measures....................................................................................................5
3. Assessment Report on Technical Infrastructure.................................................................5
3.1 Servers..............................................................................................................................6
3.2 Client workstations.........................................................................................................6
3.3 Operating systems...........................................................................................................6
3.4 Middleware......................................................................................................................7
3.5 Customer Interfaces........................................................................................................7
3.6 About the usage of Network components and bandwidth...........................................8
3.7 Required Functionalities of DBMS...............................................................................8
3.8 Development tools...........................................................................................................8
3.9 Access and analysis tools................................................................................................8
3.10 Meta-data repository...................................................................................................9
4. MySQL Execution................................................................................................................12
5. Conclusion.............................................................................................................................13
References.....................................................................................................................................14
1

1. Introduction
The main objective of this report is to evaluate an enterprise Infrastructure of the given
case study. The case study is about Sakila DVD store which is a DVD rental company. This
report has to investigate the process of company for possible BI implementation, and to enhance
its advantage towards its growth over competitive world. The infrastructure evaluation will be
carried out in two sections that they are assessment report on Non-technical infrastructure and
Assessment report has investigation about technical infrastructure. In first section, the standards,
process involved in the merging project, data integration and measuring the quality of data. In
second section, the server and client workstations, OS to be used, Middleware, interfaces,applied
network components, functionalities of DBMS, tools required for project development, data
analytics tools and Meta data repository functionalities will be investigated.
2. Assessment Report on Non-Technical Infrastructure
A foundation should be instituted to keep the BI choice help condition from getting to be
as divided as the operational and conventional choice help situations, from which cross-
hierarchical inquiries can't be replied. Making this foundation includes cross-authoritative
exercises. So, the following sections will provide the report about these non-technical
infrastructure of the organization which is given in the case.
2.1 Standards
a) Service Level Agreements
A SLA is an understanding amongst you and your customer (two gatherings) that
characterizes how an administration is to be given(Ballard, 2012). Around those definitions,
quantitative measures must be set up to judge if the administration is being given effectively or
not. The key components of SLA are listed below.
 Setting data
 Depiction of administrations
 Administration benchmarks
 Administration following/revealing
 Intermittent survey
2

 Change process
The initial three components involve the key administration components of a SLA. They
depict the administration setting and the terms and states of administration conveyance that you
require or anticipate. The following three components involve the key administration
components of a SLA. They depict how benefit adequacy will be estimated and issues will be
settled. The two arrangements of components are basic to a successful SLA. The adaptability of
Service Level agreement is verified for this project and it incorporates the highlights to be noted
and on request the level of administrations to be changed to offer to the undertaking.
b) Admitting Project Quality Assurance
 The proposed Project should has 97% of information quality in every segment. The
nature of budgetary information, HR records, client records et cetera ought to be
dissected.
 The proposed project should be used in numerous appearances and necessities might be
altered amid the procedure relying upon request from customer.
c) Supporting services provided by the company
 Periodic help to physical framework
 Up-degree strengthen
 Storage and reinforcement administration
 Performance and announcing of guaranteeing administrations are up and running.
d) Customer care Services
 Reporting and execution administration
 Any time client help following 3 level prioritization of issues.
 Monitoring and issue report
 Secure instalment door (outsider) utilizing exceptionally secured encoded principles.
 Storage and reinforcement administration
 Server and gadget organization
3

2.2 Process for merging project
For the given organization named Sakila Private Limited has been picked Talend as a
coordination device apparatuses which performs ETL tasks on existing value-based databases
and change into measurement tables, which sits on the information stockroom, as value-based
databases are no good for investigation utilizing BI device without outlining (Dimensions)
(Blake, 2013). Incorporation of articles is finished amid procedure of mapping heterogeneous
source databases. This mapping merges the two information sources into single information
volume on which investigation could be made by chosen BI apparatus.
2.3 Enterprise Data Integration
Figure 1Sakila Private Company Enterprise Data Warehouse Architecture
A graphical procedure is used by Sakila Private Limited. This procedure is used to
display perspective information coordination for outline must be proficient and the procedure to
be advanced for blending venture. Particularly, it is used to display legitimate information
models into the endeavour consistent information show (Bringer and Rodgers, 2011). According
4

to Giordano's Data Integration Blueprint and Modelling, this strategy has been modified. The
chart beneath demonstrates the abnormal state legitimate information joining model as a
structure to show unmistakable information coordination forms all together.
2.4 Data quality measures
Sakila Private Limited Company has been assessed the following measurements adjusted
in view to estimate their information quality; the data quality evaluation is used to give the
information clients. The correct numbers and criteria will be determined by the information
clients.
Subject level information quality is favoured while performing purifying activity on
information (Dimitroff, 2011). Essential capacities did while cleaning information incorporates
Accessibility, Accuracy, culmination, convenience, uprightness, legitimacy, consistency and
importance. The articles for the most part thought are:
 Validating the Sakila Database
 Validating the Sales information in DV Sales Database
 Exchanging the information of Sakila into institutionalized way
 Exchanging the details about DV deals and agreements in institutionalized way
Similarly as an advancement of programming application including variation innovations,
actualizing a BI device incorporates a pivotal testing procedure of individual part and joining an
entirety. In any case, the testing capacity for this exceedingly powerful innovation territory is at
an extremely beginning phase of development (Noergaard, 2017). Testing for this undertakings
begins from picking necessities took after by the prioritization of parallel process are made,
highlights than to be tried are considered. Hazard and possibilities are assessed before picking an
approach of testing. Testing is completed as a unit testing and reconciliation testing on the test
expectations, in different terms testing is done at each phase of advancement of BI apparatus as a
consequent foundation process.
3. Assessment Report on Technical Infrastructure
In this section, the assessment carried out based on the analysis process of technical
infrastructure of Sakila Private Limited Company. The following criteria are assessed and
reported below.
5

3.1 Servers
The BI project execution will be finished to utilize the SQL Server. This method is
popularly used for the organization's needs. As a feature of the specialized foundation
examination, it was distinguished that Sakila Private Limited as of now has this server as a
component of its system that furnishes the stores and the representatives with the database get to.
MySQL server is chosen to store the data. It will be the most suitable one to store and retrieve
easily(Reynolds and Wright, 2010). Because, the creating relationship among tables is very easy
and integrating the data will become an easy process of business intelligence solution.
3.2 Client workstations
Figure 2 Client Workstation Architecture
This section depicts the suggested equipment necessities for the Enterprise Service
Manager.
 4 CPU Cores or more
 8 GB RAM or more
 RAID10 or RAID 0+1 disc setup
 Windows x86 64-bit with 800 MB
 MySQL server (Compatible version to the processor)
3.3 Operating systems
 Client side OS: Windows 7, 8, 8.1 and 10
 Server side OS: Window Server 2008 RT
6

3.4 Middleware
To provide the account guide to access the databases, this type of middleware is used,
giving direct connection them. There are more number of database entryways and availability
alternatives. You essentially need to identify which is best for your important arrangement. This
model is mainly used and well known type of middleware. SQL database programming is also
incorporated.
Figure 3 Middleware
The BI server and the ODBC drivers will cross approximately as the middleware. The BI
server will give the logical outcomes and dashboard functionalities to special customers by way
of passing on the client request to the fundamental records sources and expelling the outcomes
from it(Roldán, 2010) . This is the component that a BI server does in a BI course of action by
way of abstracting the purposes of enthusiasm of the extraction of data via using an ETL for the
gain of the end users and the usage of MySQL connectors and ODBC and JDBC drivers and
bring comes to fruition for the clients to peer and use.
3.5 Customer Interfaces
Dashboard is a BI perception instrument. The Dashboard BI solution will be obtained
generally through a web program, which is Java and Flash player to be empowered. These base
necessities are right now satisfied by every one of the workstations. The other client interfaces
comes bundled with Dashboard that can be introduced on the essential customer stations to be
inspected in the above sub-segment (Elmer and Leigland, 2014).
7

It begins with assignment investigation which comprehends the client's essential
undertakings and issue area. It ought to be outlined as far as User's wording and start of client's
activity instead of programmers (Kon and Kermarrec, 2011).
Appropriate or great UI configuration works from the client's capacities and impediments
not the machines. While outlining the UI, information of the idea of the client's work and
condition is likewise basic.
3.6 About the usage of Network components and bandwidth
For the given case, large quantities of information are separated and to be changed
between the segments of incorporated BI usage. As information sources and data warehouse are
in same area. It is used to give adaptability in capacity of picking transmission, and LAN arrange
provides arrangement in the given case. The bandwidth provide by LAN is 10.100/1000 Mbps
between each in arrange segment. What's more, it is used to enhance the capacity of transmission
in WLAN as revealing administrations on thin customers uses high assets popular. We have
chosen to utilize Cisco SG500 switch in a private system of the association which is
unequivocally secured and effectively reasonable and very dependable.
3.7 Required Functionalities of DBMS
 In MySQL server database, daily backup is available and it is fully automated
function
 We require MySQL 5,6 Monitoring tool as well as Pentaho monitoring services
3.8 Development tools
 MySQL WorkBench
 Eclipse IDE
 Talend open studio
 MySql Connector (JAR file)
 BI Dashboard tool
3.9 Access and analysis tools
In this project, Pentaho is used which is an open source OLAP analysis tool. Pentaho is a
business open source Business Intelligence device, BI Suite of Pentaho incorporates everything
what's expected to fulfil exceptionally modern and different business needs, including capable
8

and extensive revealing, quick OLAP investigation, numerous dashboards, and complex
information coordination (Wood, 2010).
3.10 Meta-data repository
The Metadata Repository gives an area to put stuff. Its miles usually thoughts boggling
and calls for careful enterprise and affiliation. The Metadata Repository offers an efficient
information—however an awful lot of the time genuine—document for get-together, joining,
securing, sharing, and imagining metadata and its officeholder limits and structures. The
chronicle inside which metadata lives offers key limits:
 Recognize and include motives for business information and metadata
 Hold the metadata in a shape that may be tested, managed, and progressed
 Warranty traceability and circle of relatives line of business definitions and judgments
from their initiation to the point of usage or previous pleasant
 Manipulate and direct the Metadata Repository tool(s) as an regular shape across finished
materials and territories, making sure statistics trustworthiness and consistency
 Painting and execute standard running methodology and statutes, such as the ones for
records Governance
 Offer unrestricted availability and easy get entry to for commercial enterprise clients
 Acquire checking, correspondence, and accumulating of Metadata and the Metadata
Repository to assist make use of
 Installation Process
As the growth of development of the Metadata Repository engages an expansion of vital
agencies. Most importantly, the assistant and association parts of the Metadata Repository allow
depiction of Metadata in meta-models that propel diverse commercial enterprise-important
companies:
 Make, stack, trade, supervise, and investigate Metadata models
 Add as much as and connect Metadata models from diverse sources
 Run request and reports on save content
 Change Metadata fashions into general meta-fashions
 Toll Metadata fashions into one-of-a-kind institutions
 Joint exertion help
 Partitioning Metadata models
9

 Metadata suggest framing and dating
 Access manipulate for security and component recognition straightforwardness
 Web access utility for comprehensive get entry to access the data source.
Figure 4 Meta data Repository
Figure 5 Customer payment data
10

Figure 6 Actor Name Table
A metadata archive is a database of 'information about information' i.e store of meta-data.
This store bolsters on meta-information data from isolated sources. Meta information may
incorporate data about how to get to particular information or more insights about it. For our
situation our meta-information vault nourishes on DV database and Sakila database and extra
source if required. This storehouse enables clients to see all substances inside the association.
This metadata is dynamic and continues refreshing on runtime.
11

4. MySQL Execution
MySQL Database
12

ER Diagram
MySQL code is attached here.
5. Conclusion
The infrastructure evaluation is assessed in two sections that they are assessment report
on Non-technical infrastructure and Assessment report has investigation about technical
infrastructure. In first section, the standards, process involved in the merging project, data
integration and measuring the quality of data. In second section, the server and client
workstations, OS to be used, Middleware, interfaces, applied network components,
functionalities of DBMS, tools required for project development, data analytics tools and Meta
data repository functionalities are investigated.
13

References
Ballard, C. (2012). InfoSphereDataStage for Enterprise XML data integration. Poughkeepsie,
N.Y.: IBM Corp., International Technical Support Organization.
Blake, D. (2013). Middleware. [Brisbane, Australia]: Emereo.
Bringer, J. and Rodgers, S. (2011). Online media attribution of pipeline infrastructure failure,
sourcing and the public health model. Columbia, Mo.: University of Missouri--Columbia.
Dimitroff, T. (2011). Risk and energy infrastructure. London: Globe Law and Business.
Elmer, V. and Leigland, A. (2014). Infrastructure planning and finance. New York: Routledge.
Kon, F. and Kermarrec, A. (2011). Middleware 2011. Berlin: Springer.
NOERGAARD, T. (2017). DEMYSTIFYING EMBEDDED SYSTEMS MIDDLEWARE. [S.l.]:
NEWNES.
Reynolds, A. and Wright, M. (2010). Oracle SOA suite 11g R1 developer's guide. Birmingham:
Packt Pub.
Roldán, M. (2010). Pentaho 3.2 data integration. Birmingham, U.K.: Packt Pub.
Wood, D. (2010). Linking enterprise data. New York: Springer.
14