CASE STUDY 1
MASSIVE DATABASES AT MASTERCARD INTERNATIONAL
“Big data” is associated with many storage
challenges and opportunities that address the working capability for many
organizations. Experts in industrial estimated that, for every 18 months of
time the volume of data is getting doubled and new data is produced in the
field of the business. There are many issues that belongs to the massive
database for an MasterCard International (www.mastercard.com). More than 1.8
petabytes of growth are formed because of the experts of the company insiders and
size is of more than 100-terabytes of data is amassed by MasterCard data ware
house. Around 25,000 institutions by financial has been provided many credit
card like 140 million credit cards per hour by using the client/server network
for MasterCard’s data warehouse. By the end of the 2007 there was $2.3 trillion
transactions means around 18.7 billion transaction networks for the
MasterCard’s has a high speed of accessing and
response time of around 140 milliseconds per each transaction or less than 140
milliseconds.so, that the clients can expects the computers to be fast. The settles,
authentication and clears of each credit card is done by the computers of the Master
Card with in a millisecond when the card is swiped in real world entity. Mastercard’s
computer facility authorizes,
clears, and settles each credit card transaction in real time as a cardholder’s
credit card is swiped. Security is most considered issue for clients while
performing the transaction and storing data in the database. Master card
company had promise to provide Network availability of around 99.99% during the
failure system crash and the redundancy of the data in the systems. To make
master card more expandable and profitable, company must impress the clients
with may services and by launching new products every year. The most important
thing to get issued is by increasing the number of clients and the volumes of
the credit cards. The services must be increased by extending customer care
services and to reduce the issues during the transactions, especially during
the payment and purchases on online sites. The customer satisfaction is more
important to increase the volume of the credit card. To be more competitive
with the similar services provided by the other credit cards like Visa,
American Express, Discover and many more Master Card needs to be update system
software and make more responsive employers. And to attract the customers
Master Cards must increase the services like office, branches etc. It must be
best way for providing a good service for the business partner for the clients.
Other services are also important like
offering prepaid cards, debit cards, contactless cards and embedded chips with
the smart cards along with the credit cards of the master card because the
usage along with these will be increased the number of the customers that
provides clients many services within one place along with the security.
Business card will make use for both the small sector and large commercial
organizations. To attract the customers more the Master Card company, need to
provide the reward and program of loyalty. The services that are benefits to its
customer need to be identify by the company and try to make their customers
Worldwide programs need to b processes
globally to make extend their customers. Most of the successful area for being
loyalty of master card is by the airlines and hotel systems.
MasterCard’s Data Warehouse Strategy
competitive strategy is considered as the most
important role for emerging in the MasterCard data warehouse. Business
Intelligence(BI) is one of a factor that makes data repository more global for business
decisions more effective that helps the credit card giant. warehouse planning
for the data is started in the 1990’s. Mastercard had formed a team to make the
data warehouse to be more efficient with the help of IT division game charger. To
have MasterCard a competitive one data warehouse has proposed a strategic move
by providing a business case having recommendations with the IT investment.
Market share is to be increased by the MasterCard by every year. Only 25% of
charges is accounted worldwide for goods and services with the data ware house,
but at that time Visa is accounted by 25%, where Visa is doubled in the number
then the data ware house. After a recreation Master Card is increased to 31%.
But, still Visa is considered as leader in the industry, MasterCard is to
strengthen by enhancing its processing with the necessary services.
Most of banks rely on the history of the
credit card a customer is associated with, means the information and the
payment with the card can provide more information about a customer. These
helps the company for marketing the product and can plan according to the usage
with the card. The best example is When
a customer book a flight ticket using this credit card that makes a large
amount of payment.so that case bank can notice the information where customer
is associated with airline and can use the information whenever the bank offers
a special deal and helps the cardholders. In the same way, it is also used with
the hotels when hotels offered a opportunities for the customer (like stay 3
days and get 1 day extra) for using MasterCard.
MasterCard’s BI and Reporting Tools
MasterCard runs a combination
of homegrown and off-the-shelf analytic tools to identify the progression,
credit card deception, and other useful information. The company can correlate
and examine the regular transactions to identify the interest of the costumer towards the company and also it
detects the anomalies of the stolen card. MasterCard provide their clients the
permission to access these tools as well as the reports of the customer.
MasterCard Marketing Center is one the most popular
tool, where customers get help for use of their cards by understanding, tracking
and developing For Example, a card guarantor in Los Angeles may utilize the
information to perceive what number of cardholders burned through $25 or more
in January and February on donning merchandise at Wal-Mart stores. At that
point it may propose to Wal-Mart a mail advertising effort before the opening
of baseball season, attached to squanderers with a fondness to the Dodgers or
Angels. A card guarantor in New York City could utilize MasterCard’s BI and
announcing instruments to recognize designs in eatery charges for its most rich
cardholders. This data could be utilized to build up an “insider’s
guide” to NYC “shrouded diamonds for nourishment and wine” to
impart to choose gatherings of other MasterCard holders.
To access the data warehouse by the customers of the Mastercard’s for
populating reports or to perform the quires of Business Intelligence, should
follow following cases:
Master Card also provide the facility, credit card can be accessed
by using the Internet. By using Internet, we can use by either by mobile phones
and computers.so that all the transactions can be performed very easily. By
using the private network area such as HTTP, TCP/IP protocols. These networks
has a high area of security and usage of the firewall will make all the
unnecessary traffic blocked.
To use all the facilities and
the services of the MasterCard a customer must be an authenticated (user must
be genuine), to know whether user is authenticated the company need to assign a
group of servers for making all incoming transactions has the enough
permissions and enough restrictions etc.
Every customer is produced with a product license that needs to be
verified by the MasterCard for doing this a business need a software tool has
to be handled by the bank.
Once a request is raised by the user then it is forwarded to the
software application that is handled by the bank, then the software will invoke
all the transactions according the request. Once the application is done it
translates to the respective database and perform necessary operations.
The request from the user forward to the data warehouse and perform
all the transactions and then process the response to the user.
MasterCard keeps on extending the extent of the data
store and the tool set. The objective is to incorporate each exchange taken
care of by individuals over a three-year time period, catching the dollar sum,
the card number, the area, and the merchant in each occurrence. In any case, it
is the group of applications gave to individuals that is significant in
attaining competitive edge. MasterCard plans to pick up support with portfolio
directors and member banks, who choose whether to push Visa or MasterCard.
Master Card will be benefited if the online tools help the managers in
analyzing the profit of the cards in their portfolio and gain more customers.
MasterCard ahead of Visa, MasterCard IT shop more full-time developers that
come with new tools and technologies to submit to the banks and other
respective clients. The full-time developers work on the reports frequently to
focus on a transaction, authorizing a card and eliminate the fraud or illegal
MasterCard is accessed by 1.7 billion people worlds
widely and is used for purchases in 33 million locations.
MasterCard is helping in the checking out process by
avoiding time through electronic payment.
MasterCard increases the sales as the customers are
not worried on spending through card. The efficiency of currency conversion is
improved, thereby reducing the volumes of cash.
The probability of theft and snatching is minimized.