CASE STUDY 1
MASTERING MASSIVE DATABASES AT MASTERCARD
“Big data” is associated with any storage
challenges and opportunities that address the working hard 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 belongs the massive database for an MasterCard
International (www.mastercard.com). More than 1.8 petabytes of growth is 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 may credit card like 140 million credit cards per
an hour by using the client/server network for MasterCard’s data warehouse WALL08.
By the end of the 2007 there was $2.3 trillion transactions means around 18.7
billion transaction networks for the MasterCard’s worldwide.
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 word entity. Master cards 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 has to 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 more satisfaction.
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.
Among the signature
applications provided by MasterCard is its Portfolio Analytics suite of BI and
reporting tools. This suite consists a wide range of reports which helps the
members of the bank to analyze the daily, monthly and yearly transactions. They
compare these transactions all over the world to analyze the growth. They also
compare with the predefined groups of the similar banks.
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.
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
The request from the user forward to the data
warehouse and perform all the transactions and then process the response to the