WWW.WIPRO.COM
Sankar Natarajan Practice Lead (Netezza & Vertica Data Warehouse Appliance) at Wipro Technologies
High Performance Analytics through Data Appliances
Table of contents
01
01
02
03
02
03
Does your data need more attention?
Limitations of traditional database systems
Data Appliances to the rescue
Manage the future with Data Appliances
About the Author
01
Today, businesses are expecting answers to questions
that were previously considered as impossible to
answer. Credit card companies want to offer
customers best rates based on their existing
banking patterns and their long-standing relationships.
Insurance companies want to identify fraudulent
claims before they surface. How can a retail white
goods store automatically identify a customer’s
need for a loan in order to complete a purchase?
Can marketing campaign tactics be adjusted dynamically
based on current performance and end goals? How
can an airline identify customers who are about to
move to a competitor? How can a stock broker move
closer to predicting the movement of certain scrips?
Can hospitals predict readmissions and prevent
them? All this is being made possible by in-database
analytics – a powerful new method of examining
data using an emerging generation of sophisticated
data appliances. The data appliances or purpose build
devices are pre-loaded with Hardware (processor,
memory and storage) and software (server and
database) designed to address specific workload.
In-database analytics, as the name suggests, has the logic to shift through the data and extract intelligence from the data storage location itself. This eliminates the traditional issues associated with extracting, preparing and shipping large data sets to analytical engines.
Does your data need more
attention?
Limitations of traditional
database systems
Extracting intelligence from traditional databases is a time-intensive process. The problem is that organizations today want answers to their business problems at Google speed, customers want lightning-fast personalized attention and enterprise users want zero-latency in their applications. No one has the time to wait. Taking a hit are traditional databases. They are unable to keep pace with the demand from data-hungry analytics engines that make the magic happen in the background. The fall out is that the capability of the traditional enterprise data warehouse (EDW) is being questioned. While being reliable, the inherent nature of traditional databases is not suitable for current business demands. Preparing the data for model development often involves a slow and laborious process of integrating data assets from a variety of sources. Value is seeping out because of: • Poor speed and agility of traditional systems
• Unnecessary data movement, costing time and making the data vulnerable to security threats
• Data duplication due to data being available in EDW as well as analytic server, resulting in high costs and management implications • Data samples, instead of complete data sets, used to speed up the
process, with less than optimal output
• Inordinate amount of human effort involved in data
management – whereas the same effort could have been made more productive when directed to analytics
The solution lies in a new breed of appliances designed for high data volumes. These data appliances are loaded with OS, database management systems (DBMS), memory, storage, fail-over systems and critically, the analytical models themselves.
The data in these appliances is available in close proximity to the analytical engine, eliminating the need to move data. The most immediate impact of this is on the access to parallel processing power and increasing data security. But equally important the shared-nothing architecture reduces the cost of managing the system and radically reduces the analytical cycle time. Processes that earlier took days to complete can now be done in minutes. Database appliances can initially be more expensive than traditional relational database management systems (RDBMS). But over a period of time the ROI justifies the investment. We need look no further than one simple fact to realize why ROI is guaranteed: In the past, every industry used data sampling to draw intelligence, make predictions and develop strategies. Today, high performance database appliances are making it possible to use every data point to train their analytical models. The accuracy and reliability delivered by such systems is unparalleled.
Data Appliances to the rescue
Manage the future with Data
Appliances
The advantage of using database appliances is that they eliminate the errors induced by antiquated methodologies. They also free up people resources to focus more on analytics activities rather than data extraction and preparation. The benefits of in database analytics are wide ranging:
• Gain insights into risk and thereby decrease regulatory penalties, cost of legal action, reputational loss, impact on profitability
• Understand customer needs and behavior to customize offers and improve sales outcomes
About The Author
Sankar Natarajan
Sankar is Practice Lead (Netezza & Vertica Data Warehouse Appliance) at Wipro Technologies.
Sankar has more than 14 experienced in DW & BI Professional with incredible Technical experience acquired over the years in diverse areas such as Practice Lead, Pre-sales, Architecting, Designing, Development, Implementation of large Data Warehouse involving Data Migration of large Data centric projects for Insurance & Securities and Capital Markets.
Sankar Natarajan holds a Master of Computer Application from Madurai Kamaraj University.
About Wipro Ltd.
Wipro Ltd. (NYSE:WIT) is a leading Information Technology, Consulting and Business Process Management company that delivers solutions to enable its clients do business better. Wipro delivers winning business outcomes through its deep industry experience and a 360 degree view of "Business through Technology" - helping clients create successful and adaptive businesses. A company recognized globally for its comprehensive portfolio of services, a practitioner's approach to delivering innovation, and an organization wide commitment to sustainability, Wipro has a workforce of over 150,000 serving clients in 175+ cities across 6 continents.
For more information, please visit www.wipro.comor write to us at [email protected]
