Actian Case Studies NK Transforms Big Data into Actionable Insights that Drive Business Success

Edit This Case Study Record

	NK Transforms Big Data into Actionable Insights that Drive Business Success Actian

NK Transforms Big Data into Actionable Insights that Drive Business Success

Actian

Technology Category	Analytics & Modeling - Big Data Analytics Platform as a Service (PaaS) - Data Management Platforms
Applicable Industries	Telecommunications
Applicable Functions	Business Operation Sales & Marketing
Use Cases	Predictive Quality Analytics Real-Time Location System (RTLS)
Services	Data Science Services
Challenge	NK.pl, a popular social networking service in Poland, was facing a challenge in keeping pace with the changing preferences and behaviors of its 13 million users. The traditional transaction database used by NK.pl was not powerful enough to process the 250 terabytes of data generated by its users in a timely manner. When product managers attempted to run queries against the data, which was spread across 1,500 servers, they faced query response times of three to four weeks. Such slow response times were unacceptable to NK.pl because the data was outdated and meaningless by the time it was received. To optimize product features, marketing efforts, and the experience of its social network members, NK.pl needed a system that could perform both simple and rich queries quickly for intra-day analysis and response in an extremely cost-effective manner. Read More
About Customer	NK (NK.pl) is a Polish social networking service that brings students and alumni together online. Created in 2006 by 24-year-old Maciej Popowicz, a computing student in Poland’s high-tech hub of Wroclaw, NK is an abbreviation of “Nasza Klasa” which literally means “our class”. The site has been compared to Britain’s Friends Reunited, France’s Copains d’avant, and the US’s Classmates, and Facebook. Yet NK.pl is more popular than Facebook in Poland, boasting more than 13 million active users compared to Facebook’s 6.5 million (in Poland). According to Google’s annual Zeitgeist list of commonly used Web search terms, NK was the seventh-fastest rising term in the world in 2008. The success of NK.pl has been attributed to its high-quality social networking features, online gaming offerings, and targeted advertising capabilities. Read More
Solution	In an effort to speed query response times, NK.pl built a data warehouse that would open new windows into data stored in the transaction database. Split into two main parts, the main “fast” analytics portion now sits on a single server and is powered by the VectorWise analytic database. The other main part contains large data storage and analytics powered by Hadoop solutions. Hadoop technology stores click-stream data, such as POST and GET requests as well as AdServer logs. Before integrating Vectorwise into the data analysis infrastructure, the data warehouse could not deliver the query response times that the organization required. Now, employees use Vectorwise to achieve fast, actionable insights to make more fully informed strategic business decisions. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Big Data Analytics

Platform as a Service (PaaS) - Data Management Platforms

Applicable Industries

Telecommunications

Applicable Functions

Business Operation

Sales & Marketing

Use Cases

Predictive Quality Analytics

Real-Time Location System (RTLS)

Services

Data Science Services

Challenge

NK.pl, a popular social networking service in Poland, was facing a challenge in keeping pace with the changing preferences and behaviors of its 13 million users. The traditional transaction database used by NK.pl was not powerful enough to process the 250 terabytes of data generated by its users in a timely manner. When product managers attempted to run queries against the data, which was spread across 1,500 servers, they faced query response times of three to four weeks. Such slow response times were unacceptable to NK.pl because the data was outdated and meaningless by the time it was received. To optimize product features, marketing efforts, and the experience of its social network members, NK.pl needed a system that could perform both simple and rich queries quickly for intra-day analysis and response in an extremely cost-effective manner.

About Customer

NK (NK.pl) is a Polish social networking service that brings students and alumni together online. Created in 2006 by 24-year-old Maciej Popowicz, a computing student in Poland’s high-tech hub of Wroclaw, NK is an abbreviation of “Nasza Klasa” which literally means “our class”. The site has been compared to Britain’s Friends Reunited, France’s Copains d’avant, and the US’s Classmates, and Facebook. Yet NK.pl is more popular than Facebook in Poland, boasting more than 13 million active users compared to Facebook’s 6.5 million (in Poland). According to Google’s annual Zeitgeist list of commonly used Web search terms, NK was the seventh-fastest rising term in the world in 2008. The success of NK.pl has been attributed to its high-quality social networking features, online gaming offerings, and targeted advertising capabilities.

Solution

In an effort to speed query response times, NK.pl built a data warehouse that would open new windows into data stored in the transaction database. Split into two main parts, the main “fast” analytics portion now sits on a single server and is powered by the VectorWise analytic database. The other main part contains large data storage and analytics powered by Hadoop solutions. Hadoop technology stores click-stream data, such as POST and GET requests as well as AdServer logs. Before integrating Vectorwise into the data analysis infrastructure, the data warehouse could not deliver the query response times that the organization required. Now, employees use Vectorwise to achieve fast, actionable insights to make more fully informed strategic business decisions.

Impact #1	NK collects an additional one terabyte of information per day from its servers, including user attributes, messages, comments, and photos.
Impact #2	With Vectorwise, product managers now run 50-90 huge queries daily and receive sub-second response times.
Impact #3	This helps them gain fast, actionable insights to make more fully informed strategic business decisions.

Impact #1

NK collects an additional one terabyte of information per day from its servers, including user attributes, messages, comments, and photos.

Impact #2

With Vectorwise, product managers now run 50-90 huge queries daily and receive sub-second response times.

Impact #3

This helps them gain fast, actionable insights to make more fully informed strategic business decisions.

Benefit #1	50-90 huge queries daily
Benefit #2	Sub-second query response time

Benefit #1

50-90 huge queries daily

Benefit #2

Sub-second query response time

Download PDF Version

Overview

NK Transforms Big Data into Actionable Insights that Drive Business Success

Operational Impact

Quantitative Benefit