BILLERICA, Massachusetts and WOODCLIFF LAKE, New Jersey -
- Operator of Leading OTC Securities Marketplace Sees Major Savings with World Record Solution
Pink OTC Markets Inc., the company that operates the OTCQX and Pink Sheets over-the-counter equity marketplace, has slashed the time it takes to generate market reports from hours to seconds while also saving big on reduced hardware and programming costs, thanks to a business intelligence (BI) data warehouse solution built with the Vertica Analytic Database and Syncsort’s DMExpress(TM) data integration software.
As the third largest U.S. equity trading marketplace, Pink OTC needed to improve its reporting capability to stay ahead of the millions of records its trading system amasses daily. The company connects OTC marketplace participants, providing a quotation and trading platform for FINRA member broker-dealers, market data for OTC participants, and disclosure services for issuers with securities traded on the OTC market. An important element in keeping this diverse set of clients happy is Pink OTC’s ability to quickly generate reports for up-to-the-minute market analysis.
“Better reporting results in increased customer satisfaction,” explained Rahul Bose, director of application development at Pink OTC. “By filtering, analyzing and aggregating historical and streaming financial data into easily accessible reports, we provide our customers with actionable intelligence they can turn into opportunity.”
With the relentless growth in messaging rates characteristic of modern electronic trading systems, Pink OTC management faced a challenge of rapid delivery of new services to its customers that would provide real-time insight into the market trends hidden within the growing volumes of trade, quote and company financial data.
The company evaluated a solution pairing Vertica and Syncsort alongside the Informix and InfoBright databases. With a data store of over a billion records and expanding rapidly at several million records a day, Pink OTC faced a huge investment in data warehouse and storage area network (SAN) hardware, software, and integration effort going the traditional route. Pink OTC decided on a Vertica-Syncsort solution for three key reasons:
- it’s ability to execute complex queries and generate reports up to 100X faster than some other offerings, - the large savings the company gained in reduced hardware and programming costs, and - superior customer service.
The Vertica Analytic Database relies on a unique columnar, MPP architecture and pioneering data compression to reduce storage requirements for the Pink OTC data warehouse by as much as 90 percent, eliminating the need for a large SAN that would need to be upgraded every 12-18 months. The Vertica Analytic Database can operate directly on that compressed data, delivering query results exponentially faster than other systems evaluated.
Syncsort’s DMExpress dramatically reduces the time for processing Pink OTC’s high daily data volumes with high-performance extraction, transformation and load (ETL). Together, these technologies power an easy-to-use data warehouse that enables Pink OTC’s analysts and developers to load, transform and generate complex reports on large volumes of data with minimal effort. In 2008 Syncsort’s DMExpress set a new ETL world record and broke the 1 GB per second barrier, to extract, transform, and load 5.4 TB of raw TPC-H data into a Vertica Analytic Database at an unprecedented rate of 1.6 GB per second — all while deployed on highly cost-efficient HP c7000 Blade servers.
Custom reports for market aggregates, securities, trades and other market intelligence that used to take a team of Java programmers days to code can now be done in minutes by any analyst who knows a little about SQL queries.
“Pink OTC Markets leverages best-of-breed technologies to drive a highly efficient OTC market at lower cost than traditional securities exchanges,” said Bose. “We’re all about connecting traders, improving price discovery and providing better intelligence to our customers. The Vertica-Syncsort solution solved a big data analytics challenge at a fraction of cost and with much better performance than traditional database systems.”
About Syncsort Incorporated
Syncsort is a global software company that speeds data processing, data integration, and data protection & recovery. Supported by a professional services team built on 40 years of expertise, Syncsort helps customers drive ROI with software solutions that combine high performance, optimal hardware utilization, and ease of use. With over 12,000 deployments worldwide, Syncsort customers include 96 of the Fortune 100 companies. Syncsort is headquartered in Woodcliff Lake, NJ, and has international subsidiaries in the United Kingdom, France, and Germany, with support centers in the United States and Netherlands. An international network of partners, resellers and distributors positions Syncsort products as an integral component of IT solutions. For more information call +1-201-930-8200 (1-877-FAST-951 in the US and Canada) or visit: www.syncsort.com.
About Vertica
Vertica Systems is the market innovator for high-performance analytic database management systems that run on industry-standard hardware. Co-founded by database pioneer Dr. Michael Stonebraker, Vertica has developed column-oriented analytic database technology with an MPP architecture that lets companies of any size store and query very large databases orders of magnitude faster and more affordably than other solutions. The Vertica Analytic Database is available as software only, as a hardware based appliance, as a virtual appliance on VMware or online as a cloud computing solution. The technology’s unmatched speed, scalability, flexibility and ease of use helps customers like JP Morgan Chase, Verizon, Mozilla, Comcast, Level(3) Communications and Vonage capitalize on business opportunities in real time. Vertica is headquartered in Billerica, Mass. For more information, visit the company’s Web site at www.vertica.com.
Source: Vertica
Ed Marshall of Beaupre & Co. Public Relations for Vertica, +1-603-559-5816, emarshall at beaupre.com
Related Press Releases
Vertica: World's Fastest Growing Data Warehouse Vendor Lands Its 100th Customer in Record TimeSeptember 29th, 2009 BILLERICA, Massachusetts -
Vertica continues to share tangible proof points of its rising leadership in the data warehouse market by announcing today the signing of its 100th customer. This achievement firmly establishes Vertica as the fastest growing company in the data warehouse market.
Contemporary Apparel Manufacturer Selects Vertica Analytic DatabaseAugust 26th, 2009 BILLERICA, Massachusetts -
- Market-leading columnar, MPP analytic DBMS chosen to reduce cost of data warehousing terabytes of retail data in North America and Europe
Contemporary apparel and consumer products manufacturer Guess?, Inc. has selected the Vertica Analytic Database to help the rapidly growing company analyze dozens of terabytes of point-of-sale (POS), manufacturing, inventory, customer and store performance data in several global data centers.
Vertica Analytic Database 3.5 Broadens Reach with Added FlexStore Architecture, Incorporates MapReduce IntegrationAugust 3rd, 2009 SAN DIEGO -
A new version of the Vertica Analytic Database features a next-generation database architecture that promises huge performance gains for a broader range of analytic applications that can now take full advantage of the columnar MPP database's blazingly fast speeds. Vertica 3.5, which is being announced today at the TDWI World Conference, pioneers an innovative enhancement in storing and processing columnar data called FlexStore(TM).
Syncsort Welcomes New CEOJuly 27th, 2009 WOODCLIFF LAKE, New Jersey -
- Executive Brings Deep Expertise and New Vision to Performance-Driven Data Management and Data Protection Software Company
Syncsort, a global leader in high-performance data processing, data integration and data protection and recovery software, today announced that Flavio Santoni has joined as Chief Executive Officer. With more than 25 years of experience in the IT market, Santoni will lead the strategic direction and operations of Syncsort worldwide.
Nevis Selects Vertica to Make Business Intelligence Fast, Easy and Affordable for European Retailers and ManufacturersJuly 7th, 2009 BILLERICA, Massachusetts -
Italian software developer, Nevis, has developed a new kind of data analytics tool, called NFactum that combines Vertica's high-performance analytic database with its own parametric modeling software to analyze terabytes of multidimensional data in seconds. The software allows executives to gain better, more immediate insight into profitability and other key performance through NFactum's easy-to-use dashboard.
Vertica and Sigma Systems Webinar Showcases IPDR Mediation and Data Warehousing Solution for Telecom Service ProvidersJune 10th, 2009 BILLERICA, Massachusetts - WHO:
Vertica Systems, maker of high-performance analytic database management software, and Sigma Systems, a leading supplier of OSS solutions for the design, delivery, management, and mediation of advanced communications and entertainment services. WHAT:
The two companies are hosting a webinar about a new internet protocol detail record (IPDR) mediation and data warehousing solution for cable and telecom service providers.
Integra Taps Vertica to Deliver World's Fastest Log Data WarehouseMay 25th, 2009 BILLERICA, Massachusetts - Businesses are drowning in a sea of audit log data from their IT systems, which must be tracked to mitigate the risks of security threats, legal exposure and regulatory compliance. Vertica is working with Italian IT security specialist, Integra, to offer these businesses the world's fastest log warehouse for managing never-ending volumes of audit data.
Syncsort Invited To Join Transaction Processing Performance CouncilMay 11th, 2009 AUSTIN, Texas and WOODCLIFF LAKE, New Jersey - Joins Microsoft and IBM as only ETL Experts to Sit on Benchmarking Subcommittee
Syncsort, a global provider of high-performance data integration software, is pleased to announce its invitation to join the Transaction Processing Performance Council (TPC), a non-profit corporation founded to define transaction processing and database benchmarks. Syncsort will participate in the TPC's ETL Benchmark subcommittee, where it will lend expertise in performance and low total cost of ownership to drive industry thinking and direction.
Syncsort Joins the VMware Technology Alliance Partner ProgramApril 20th, 2009 WOODCLIFF LAKE, New Jersey - Joint Solution for Data Protection in Consolidated Virtual Environment Accelerates Time-to-Value for Customers
Syncsort, a global leader in data protection software, today announced it has joined the VMware Technology Alliance Partner (TAP) program. The VMware TAP program helps technology vendors integrate their products with VMware virtualization software and deliver timely, joint solutions to mutual customers.
Vertica and VMware Discuss How Virtualization Can Transform the Economics of Data Warehousing and Business IntelligenceMarch 15th, 2009 BILLERICA, Massachusetts - Webinar attendees will learn how virtualizing analytic data marts will
bring in a new era of economics and agility for data warehousing and business
intelligence; MarketBridge customer case study featured
WHO:
- Gaetan Castelein, Product Marketing Director, VMware
- Charlie Wardell, CTO, MarketBridge
- David Menninger, VP Marketing & Product Management, Vertica
WHAT:
Vertica and VMware have partnered to combine two of the top trends in IT
-- virtualization and data warehousing -- and enable a new era of
economics and agility. Instead of grossly over-provisioning dedicated
servers, IT can now deploy new, pre-configured virtualized Vertica
analytic data marts on any available data center hardware in a matter of
minutes, and eliminate the weeks of lead time required to procure
dedicated hardware and manually configure the solution.
Related News
Electronic hardware aboard 2012 test satellite would be able to 'transform'July 23rd, 2009 LONDON - Reports indicate that the flight computer of a test satellite planned for 2012 will contain electronic hardware that can be completely reconfigured in space, allowing it to switch form. According to a report in New Scientist, dubbed the "flying laptop", the spacecraft is the brainchild of Toshinori Kuwahara of the Institute of Space Systems at the University of Stuttgart, Germany.
NBC Universal drama programming executive Nora O'Brien dies at 44May 1st, 2009 NBC Universal programming exec Nora O'Brien diesNEW YORK — NBC Universal says Nora O'Brien, its executive in charge of drama programming, has died. Spokesman Curt King says O'Brien died Wednesday after collapsing in Sausalito, Calif., on the set of a TV series in development for NBC.
Sonus Networks to cut more jobs as restructuring activities wind downAugust 13th, 2009 Sonus Networks to lay off 10 percent of workforceWESTFORD, Mass. — Sonus Networks Inc.
Pink reconsidering relationship with former hubbyApril 9th, 2009 LONDON - Pop star Pink seems to be reconsidering her relationship with former husband Carey Hart, with reports suggesting that the two of them have been spotted dating. Pink, who released the no 1 hit 'So What About the Split' after her divorce from Hart, has remained pals with him.
Pop Singer Pink back with ex-husband Carey HartApril 9th, 2009 LONDON - Pop singer Pink is back with her ex-husband Carey Hart. Hart, 33, confirmed that the two are back saying, 'We're working s*** out, I admit it.
Pink Floyd's co-founder says in West Bank he will give concert if Israel wall comes downJune 2nd, 2009 Ex-Pink Floyd rocker wants Israeli wall downAIDA REFUGEE CAMP, West Bank — The legendary rocker and co-founder of Pink Floyd says he would give a concert in a flash if Israel's West Bank wall is torn down. Roger Waters made the promise Tuesday during a visit to a Palestinian refugee camp that is hemmed in by the separation barrier's tall slabs of cement.
Julia Roberts streaks hair pink for daughterMarch 19th, 2009 LONDON - Actress Julia Roberts streaked her hair pink after her four-year-old daughter Hazel begged her to dye it. Roberts, a mother of three, showed off her new look on the US talk show 'Late Show with David Letterman', reports contactmusic.com.
Pink, Stella McCartney, Ricky Gervais support PETA's anti-fur campaignMarch 12th, 2009 LONDON - Pink, Stella McCartney and Ricky Gervais have lent their support to People for the Ethical Treatment of Animals' latest anti-fur commercial. The computer-generated video would see singer Pink and actor-comic Ricky Gervais loaning their voices for an alligator and a rabbit, respectively, demanding the return of their fur while being skinned.
Allen wears favourite pink dressFebruary 17th, 2009 LONDON - British pop singer Lily Allen chose the same kind of pink dress to perform on a US TV show as she had for the GQ magazine 20th anniversary three months before. Dailymail.co.uk reports that Allen wore the sugar pink fringed dress for the performance on the 'Tonight Show with Jay Leno'.
NY's Schumer filing legislation making it mandatory for airports to report bird strikesMay 6th, 2009 Schumer: Mandate bird strike reportingWASHINGTON — New York Sen. Chuck Schumer said Wednesday that each time a bird hits an airplane, it should be reported to the Federal Aviation Administration.
