CASE STUDY 1MASTERING MASSIVE DATABASES AT MASTERCARDINTERNATIONAL”Big data” is associated with any storagechallenges and opportunities that address the working hard capability for Manyorganizations. Experts in industrial estimated that, for every 18 months of timethe volume of data is getting doubled and new data is produced in the field ofthe business. There are many issues belongs the massive database for an MasterCardInternational (www.
mastercard.com). More than 1.
8 petabytes of growth is formedbecause of the experts of the company insiders and size is of more than 100-terabytesof data is amassed by MasterCard data ware house. Around 25,000 institutions byfinancial has been provided may credit card like 140 million credit cards peran 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.7billion transaction networks for the MasterCard’s worldwide.MasterCard’s has a high speed of accessing andresponse time of around 140 milliseconds per each transaction or less than 140milliseconds.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 themaster card with in a millisecond when the card is swiped in real word entity. Master cards computer facility authorizes, clears, andsettles each credit card transaction in real time as a cardholder’s credit cardis swiped. Security is most considered issue for clients while performing the transactionand storing data in the database. Master card company had promise to provide Networkavailability of around 99.99% during the failure system crash and the redundancyof 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 newproducts every year. The most important thing to get issued is by increasingthe number of clients and the volumes of the credit cards.
The services must beincreased by extending customer care services and to reduce the issues duringthe transactions, especially during the payment and purchases on online sites.The customer satisfaction is more important to increase the volume of thecredit card. To be more competitive with the similar services provided by theother credit cards like Visa, American Express, Discover and many more Master Cardneeds to be update system software and make more responsive employers. And toattract the customers Master Cards must increase the services like office, branchesetc. It must be best way for providing a good service for the business partnerfor the clients.Other services are also important like offeringprepaid cards, debit cards, contactless cards and embedded chips with the smartcards along with the credit cards of the master card because the usage alongwith these will be increased the number of the customers that provides clients manyservices within one place along with the security.
Business card will make usefor both the small sector and large commercial organizations. To attract the customersmore 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 thecompany and try to make their customers more satisfaction.Worldwide programs need to b processesglobally to make extend their customers. Most of the successful area for being loyaltyof master card is by the airlines and hotel systems.
MasterCard’s Data Warehouse Strategycompetitive strategy is considered as the mostimportant role for emerging in the MasterCard data warehouse. Business Intelligence(BI)is one of a factor that makes data repository more global for businessdecisions more effective that helps the credit card giant. warehouse planningfor the data is started in the 1990’s. Mastercard had formed a team to make thedata warehouse to be more efficient with the help of IT division game charger. Tohave MasterCard a competitive one data warehouse has proposed a strategic moveby providing a business case having recommendations with the IT investment. Marketshare is to be increased by the MasterCard by every year. Only 25% of chargesis accounted worldwide for goods and services with the data ware house, but atthat time Visa is accounted by 25%, where Visa is doubled in the number thenthe 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 strengthenby enhancing its processing with the necessary services.Most of banks rely on the history of thecredit card a customer is associated with, means the information and thepayment with the card can provide more information about a customer. Thesehelps the company for marketing the product and can plan according to the usagewith the card. The best example is Whena customer book a flight ticket using this credit card that makes a largeamount of payment.so that case bank can notice the information where customeris associated with airline and can use the information whenever the bank offersa special deal and helps the cardholders. In the same way, it is also used withthe hotels when hotels offered a opportunities for the customer (like stay 3days and get 1 day extra) for using MasterCard.
MasterCard’s BI and Reporting ToolsMasterCard runs a combinationof homegrown and off-the-shelf analytic tools to identify the progression,credit card deception, and other useful information. The company can correlateand examine the regular transactions toidentify the interest of the costumertowards the company and also it detects the anomalies of the stolen card.MasterCard provide their clients the permission to access these tools as wellas the reports of the customer.
Among the signatureapplications provided by MasterCard is its Portfolio Analytics suite of BI andreporting tools. This suite consists a wide range of reports which helps themembers of the bank to analyze the daily, monthly and yearly transactions. Theycompare these transactions all over the world to analyze the growth. They alsocompare with the predefined groups of the similar banks.MasterCard Marketing Center is one the mostpopular tool, where customers get help for use of their cards by understanding,tracking and developing For Example, a card guarantor in Los Angeles mayutilize 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 theopening of baseball season, attached to squanderers with a fondness to theDodgers or Angels. A card guarantor in New York City could utilize MasterCard’sBI and announcing instruments to recognize designs in eatery charges for itsmost rich cardholders.
This data could be utilized to build up an”insider’s guide” to NYC “shrouded diamonds for nourishment andwine” to impart to choose gatherings of other MasterCard holders.To access the data warehouse by the customersof the Mastercard’s for populating reports or to perform the quires of BusinessIntelligence, should follow following cases:Master Card also provide the facility, creditcard can be accessed by using the Internet. By using Internet, we can use byeither by mobile phones and computers.so that all the transactions can beperformed 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 makeall the unnecessary traffic blocked. To useall 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 needto assign a group of servers for making all incoming transactions has theenough permissions and enough restrictions etc.Every customer is produced with a product licensethat needs to be verified by the MasterCard for doing this a business need asoftware tool has to be handled by the bank.Once a request is raised by the user then itis forwarded to the software application that is handled by the bank, then thesoftware will invoke all the transactions according the request. Once theapplication is done it translates to the respective database and perform necessaryoperations. The request from the user forward to the datawarehouse and perform all the transactions and then process the response to theuser.