News Feed Item

MemSQL Eliminates ETL and Delivers Real-Time Advantage to Ad Tech Leader CPXi

New Tiered Storage Architecture Leverages 250 Billion Rows of Data for Real-Time Bidding and Offers Hundreds of Thousands of Dollars in Annual Savings

SAN FRANCISCO, CA -- (Marketwired) -- 03/20/14 -- MemSQL, the leader in distributed in-memory database technology, today announced that global digital-media holding company CPXi recently deployed MemSQL v3.0 in order to utilize all of the company's data -- 250 billion rows of real-time and historical data -- for its real-time bidding operations. CPXi provides multi-screen messaging that leverages display, social, mobile and video advertising at scale and serves billions of managed impressions daily. Extract, transform and load (ETL) is expensive and required CPXi to have extra machines and storage to run this time-intensive process. By switching from Hadoop to MemSQL, CPXi eliminated ETL processes and also cut 50 percent of its Amazon Elastic Compute Cloud (EC2) instances and 50TB of storage, which led to hundreds of thousands of dollars in annual savings.

"As we tested multiple vendors, we came to see that we don't just have Big Data, we have Huge Data, which brings new problems and complications," said Mike Zacharski, chief operating officer at CPXi. "With its real-time queries, cost-effective data accessibility and reliability, MemSQL provided the right solution to meet our unique business requirements -- including our large data sets -- so that we can operate more effectively and efficiently and push innovation forward within the highly competitive ad tech space."

Digital media clients are increasingly demanding real-time bidding (also known as programmatic ad buying), a dynamic auction process that ingests and analyzes billions of data points in real time to produce fast and accurate bids and more targeted ads. But many media companies are struggling to implement real-time bidding because of the sheer volume of data and velocity of processing that it requires.

Before MemSQL, CPXi was one of those companies: loading data from its tiered architecture into its analysis tools was an expensive, cumbersome process that could take 12 to 24 hours, which meant that data aged and became less relevant before it could be analyzed. MemSQL eliminated that problem: CPXi now does a front-line ingest into row store and then a real-time transfer of the data to the column store for analysis. This new consolidated, tiered storage architecture with a unified SQL interface eliminates CPXi's ETL process and simplifies the complexity of its database infrastructure. The architecture also helps CPXi to scale up staffing by exposing a familiar ANSI SQL interface so that new employees can come up to speed swiftly.

"Performance and reliability are crucial in the ad tech space, and CPXi needed the ability to scale out and analyze data quickly in order to provide the most accurate results for their customers," said Eric Frenkiel, co-founder and CEO of MemSQL. "We find our customers have Big Data challenges that require solutions that provide immediate business value. CPXi is a testament to the power of our database, and we're proud to be its valued partner in helping it to better serve customers."

About MemSQL
MemSQL is the database for fast data processing. With a single platform, companies can converge live data with their data warehouse to accelerate applications and power real-time operational analytics. MemSQL's Big Data platform brings speed, scale, and simplicity to enterprise customers worldwide. Based in San Francisco, MemSQL is a Y Combinator company funded by prominent venture capitalists and angel investors, including Accel Partners, Khosla Ventures, Data Collective, First Round Capital and IA Ventures. For more information, please visit www.memsql.com.

Add to Digg Bookmark with del.icio.us Add to Newsvine

More Stories By Marketwired .

Copyright © 2009 Marketwired. All rights reserved. All the news releases provided by Marketwired are copyrighted. Any forms of copying other than an individual user's personal reference without express written permission is prohibited. Further distribution of these materials is strictly forbidden, including but not limited to, posting, emailing, faxing, archiving in a public database, redistributing via a computer network or in a printed form.

Latest Stories
DXWordEXPO New York 2018, colocated with CloudEXPO New York 2018 will be held November 11-13, 2018, in New York City and will bring together Cloud Computing, FinTech and Blockchain, Digital Transformation, Big Data, Internet of Things, DevOps, AI, Machine Learning and WebRTC to one location.
Dion Hinchcliffe is an internationally recognized digital expert, bestselling book author, frequent keynote speaker, analyst, futurist, and transformation expert based in Washington, DC. He is currently Chief Strategy Officer at the industry-leading digital strategy and online community solutions firm, 7Summits.
@DevOpsSummit New York 2018, colocated with CloudEXPO | DXWorldEXPO New York 2018 will be held November 11-13, 2018, in New York City. From showcase success stories from early adopters and web-scale businesses, DevOps is expanding to organizations of all sizes, including the world's largest enterprises - and delivering real results.
DXWorldEXPO LLC announced today that Dez Blanchfield joined the faculty of CloudEXPO's "10-Year Anniversary Event" which will take place on November 11-13, 2018 in New York City. Dez is a strategic leader in business and digital transformation with 25 years of experience in the IT and telecommunications industries developing strategies and implementing business initiatives. He has a breadth of expertise spanning technologies such as cloud computing, big data and analytics, cognitive computing, m...
Widespread fragmentation is stalling the growth of the IIoT and making it difficult for partners to work together. The number of software platforms, apps, hardware and connectivity standards is creating paralysis among businesses that are afraid of being locked into a solution. EdgeX Foundry is unifying the community around a common IoT edge framework and an ecosystem of interoperable components.
DXWorldEXPO LLC announced today that Kevin Jackson joined the faculty of CloudEXPO's "10-Year Anniversary Event" which will take place on November 11-13, 2018 in New York City. Kevin L. Jackson is a globally recognized cloud computing expert and Founder/Author of the award winning "Cloud Musings" blog. Mr. Jackson has also been recognized as a "Top 100 Cybersecurity Influencer and Brand" by Onalytica (2015), a Huffington Post "Top 100 Cloud Computing Experts on Twitter" (2013) and a "Top 50 C...
Cloud-enabled transformation has evolved from cost saving measure to business innovation strategy -- one that combines the cloud with cognitive capabilities to drive market disruption. Learn how you can achieve the insight and agility you need to gain a competitive advantage. Industry-acclaimed CTO and cloud expert, Shankar Kalyana presents. Only the most exceptional IBMers are appointed with the rare distinction of IBM Fellow, the highest technical honor in the company. Shankar has also receive...
Enterprises have taken advantage of IoT to achieve important revenue and cost advantages. What is less apparent is how incumbent enterprises operating at scale have, following success with IoT, built analytic, operations management and software development capabilities - ranging from autonomous vehicles to manageable robotics installations. They have embraced these capabilities as if they were Silicon Valley startups.
DXWorldEXPO LLC announced today that ICOHOLDER named "Media Sponsor" of Miami Blockchain Event by FinTechEXPO. ICOHOLDER give you detailed information and help the community to invest in the trusty projects. Miami Blockchain Event by FinTechEXPO has opened its Call for Papers. The two-day event will present 20 top Blockchain experts. All speaking inquiries which covers the following information can be submitted by email to [email protected] Miami Blockchain Event by FinTechEXPO also offers s...
Poor data quality and analytics drive down business value. In fact, Gartner estimated that the average financial impact of poor data quality on organizations is $9.7 million per year. But bad data is much more than a cost center. By eroding trust in information, analytics and the business decisions based on these, it is a serious impediment to digital transformation.
Daniel Jones is CTO of EngineerBetter, helping enterprises deliver value faster. Previously he was an IT consultant, indie video games developer, head of web development in the finance sector, and an award-winning martial artist. Continuous Delivery makes it possible to exploit findings of cognitive psychology and neuroscience to increase the productivity and happiness of our teams.
As DevOps methodologies expand their reach across the enterprise, organizations face the daunting challenge of adapting related cloud strategies to ensure optimal alignment, from managing complexity to ensuring proper governance. How can culture, automation, legacy apps and even budget be reexamined to enable this ongoing shift within the modern software factory? In her Day 2 Keynote at @DevOpsSummit at 21st Cloud Expo, Aruna Ravichandran, VP, DevOps Solutions Marketing, CA Technologies, was jo...
Predicting the future has never been more challenging - not because of the lack of data but because of the flood of ungoverned and risk laden information. Microsoft states that 2.5 exabytes of data are created every day. Expectations and reliance on data are being pushed to the limits, as demands around hybrid options continue to grow.
The standardization of container runtimes and images has sparked the creation of an almost overwhelming number of new open source projects that build on and otherwise work with these specifications. Of course, there's Kubernetes, which orchestrates and manages collections of containers. It was one of the first and best-known examples of projects that make containers truly useful for production use. However, more recently, the container ecosystem has truly exploded. A service mesh like Istio addr...
As IoT continues to increase momentum, so does the associated risk. Secure Device Lifecycle Management (DLM) is ranked as one of the most important technology areas of IoT. Driving this trend is the realization that secure support for IoT devices provides companies the ability to deliver high-quality, reliable, secure offerings faster, create new revenue streams, and reduce support costs, all while building a competitive advantage in their markets. In this session, we will use customer use cases...