AWS Launches Amazon Redshift Spectrum
New capability allows Amazon Redshift customers to run analytic queries quickly and inexpensively against exabytes of data in Amazon S3
SEATTLE--(BUSINESS WIRE)--Apr. 19, 2017-- Today, Amazon Web Services, Inc. (AWS), an Amazon.com company (NASDAQ: AMZN), announced Amazon Redshift Spectrum, a new feature that allows Amazon Redshift customers to run SQL queries against exabytes of their data in Amazon Simple Storage Service (Amazon S3). With Redshift Spectrum, customers can extend the analytic power of Amazon Redshift beyond data stored on local disks in their data warehouse to query vast amounts of unstructured data in their Amazon S3 data lake - without having to load or transform any data. Redshift Spectrum applies sophisticated query optimization, scaling processing across thousands of nodes so results are fast - even with large data sets and complex queries. To get started with Redshift Spectrum, visit https://aws.amazon.com/redshift/spectrum.
Amazon Redshift is one of AWS's fastest-growing services because it allows customers to perform complex queries on petabytes of structured data stored on high-performance local disks and get superfast performance - all for a tenth of the cost of traditional data warehouses. However, as the cost of data storage has continued to drop, customers are increasingly storing vast amounts of data in Amazon S3 data lakes, including unstructured data that may never make it into a data warehouse. Now, with Redshift Spectrum, analyzing all of this data is as easy as running a standard Amazon Redshift SQL query. Redshift Spectrum directly queries data in Amazon S3, with no loading or transformation required, using the open data formats customers already use, including CSV, TSV, Parquet, Sequence, and RCFile. Since Redshift Spectrum supports the same SQL syntax of Amazon Redshift, customers can run sophisticated queries using the same Business Intelligence (BI) tools they do today. They can also run queries that span both the frequently accessed data stored locally in Amazon Redshift and their full data sets stored cost-effectively in Amazon S3. Redshift Spectrum automatically scales query compute capacity based on the data being retrieved, so queries against Amazon S3 data run fast, whether processing just a few terabytes, petabytes, or even exabytes.
Customers such as Amgen, Boingo Wireless, Electronic Arts, Hearst, Lyft, Nasdaq, Scholastic, TripAdvisor, and Yahoo! are migrating to Amazon Redshift in droves because it leverages the scale of AWS to analyze petabytes of data with ten times the performance at one-tenth the cost of old guard data warehouses. Many of these customers have asked us to extend the speed and flexibility of Amazon Redshift beyond the data warehouse to analyze all of the data they have in Amazon S3, said Raju Gulabani, Vice President, Databases, Analytics, and AI, AWS. Redshift Spectrum does just this, offering the best of both worlds by making it incredibly easy to query exabytes of data in Amazon S3 directly from Amazon Redshift. We're excited to now make exabyte-scale analytics fast, simple and accessible to companies of all sizes.
Tokyo-based NTT DOCOMO is the largest mobile service provider in Japan, serving more than 68 million customers. Our data analysis platform collects tens of terabytes of log data each day from a variety of internal and external sources to help us improve our logistics and marketing operations. Migrating to Amazon Redshift two years ago allowed us to scale to over ten petabytes of uncompressed data with a ten times performance improvement over our prior on-premises system, said Mick Etoh, Senior Vice President and General Manager of Innovation Management Department, NTT DOCOMO. Redshift Spectrum will let us expand the universe of the data we analyze to 100s of petabytes over time. This is truly a game changer, and we can think of no other system in the world that can get us there.
Time Inc. is a leading content company that engages over 150 million consumers every month through its portfolio of premium brands across platforms. As a media company, we receive a large quantity of data from a number of ad serving providers. This data comes in a variety of formats and needs to be integrated with our own internal systems in order for our teams to be able to analyze it, said Vladimir Barkov, Director of Data Architecture and Engineering at Time Inc. Redshift Spectrum enables us to directly operate on our data in its native format in Amazon S3 with no preprocessing or transformation. Our data pipeline is much simpler now, and our execution time has been lowered significantly.
Edmunds offers detailed, constantly updated information about vehicles to 20 million monthly visitors. Amazon Redshift's scalability allows us to support our ever-growing data volumes, unlike our previous, on-premises data warehouse solution, said Ajit Zadgaonkar, Edmunds's Executive Director of Operations and Infrastructure. With Redshift Spectrum, we no longer need to think about what data to retain for analysis and what to throw away. We can now run real SQL queries directly on many years of data stored cost-effectively in Amazon S3. Redshift Spectrum's fast performance across massive data sets is unprecedented.
Redfin is the next-generation real estate brokerage, combining its own full-service agents with modern technology to redefine real estate in the consumer's favor across more than 80 metros in the US. With millions of users and hundreds of millions of property listings, our website and internal systems generate a vast amount of data. Our data analytics platform has been built from the ground up on AWS, using Amazon S3 for storage, Amazon Kinesis for streaming, Amazon EMR for data processing and real-time applications, and Amazon Redshift
Most recent headlines
04/08/2024
Dalet, a leading technology and service provider for media-rich organizations, is excited to announce Santiago Solanas as its new Chief Executive Officer (CEO)....
03/06/2024
Dalet, a leading technology and service provider for media-rich organizations, a...
07/05/2024
PORTSMOUTH, N.H. New findings from Hub Entertainment Research provides extensive data showing that the majority of consumers will opt for lower cost ad-supporte...
07/05/2024
NEW YORK The Library of American Broadcasting Foundation (LABF) has announced th...
07/05/2024
CBS News has named Lindsey Reiser an anchor and correspondent for CBS News 24/7, the network's live, streaming news service. Reiser, who was most recently a...
07/05/2024
NEEDHAM, Mass. After more than two years of decline, worldwide tablet shipments posted modest year-over-year growth of 0.5% in the first quarter of 2024 (1Q24),...
07/05/2024
ESPN is reporting that April was a record-setting month as the network delivered its best April prime time audience on record, dating back more than 30 years....
07/05/2024
WASHINGTON, D.C. The National Association of Broadcasters (NAB) has announced that Kirsten Donaldson has joined NAB as vice president of public policy. Donaldso...
07/05/2024
The Bulls are back home again this week from May 7-12! Don't miss out on any...
06/05/2024
By Ilyse McKimmie
Now, more than ever
That's a phrase so often used in the last few years that I've come to dread seeing it in notes like this one. A...
06/05/2024
alt= class=wp-image-12099 data-lazy-src=/wp-content/uploads/2024/05/Blog-Exabyte-Storage-Demand-960x540-1.jpg/> Demand for storage solutions has reached unprece...
06/05/2024
Around the world, Asian and Pacific Islander (API) artists continue to impact mu...
06/05/2024
Spotify is making it easier for booklovers to count down the days, hours, minutes, and seconds until a new audiobook releases. With Countdown Pages for audioboo...
06/05/2024
Get Ready to join Dan Hong as he hits the streets in his ultimate culinary journ...
06/05/2024
In this video, cinematographer Simon Rowling welcomes viewers behind the scenes as he lights a daytime-interior scene inside a coffee shop. Shooting on Panavisi...
06/05/2024
L3Harris is well positioned to support the complex and multifaceted nature of special operations forces in all domains through our agile and responsive technolo...
06/05/2024
OAKVILLE, Ontario As part of Emergency Preparedness Week, Alert Ready, Canadas national public alerting system, will be distributing a test alert to Canadians i...
06/05/2024
NEW ROCHELLE, N.Y. Horowitz Research has released a new study on the viewing and media habits of U.S. Hispanic/Latine audiences that shows a dramatic decline in...
06/05/2024
RE:Vision Effects Autograph 2024.4 released! 50% Off Through May 9th
Brie Clayton May 6, 2024
0 Comments
New game-changing motion graphics & VFX featu...
06/05/2024
NBC has renewed Night Court for a third season. The courtroom comedy was on the network from 1984 to 1992, and NBC rebooted it in early 2023....
06/05/2024
ABC has revealed its summer schedule. The Bachelorette gets going Monday, July 8, with Jenn Tran the star in season 21. Celebrity Family Feud starts up Tuesday,...
06/05/2024
It's almost go-time for the Holly Springs Salamanders! The season opener is ...
06/05/2024
Tonight on Skeem Saam: Kobus busts Pretty in a compromising positionDon't miss Monday, 6 May's riveting episode of South African soapie Skeem Saam on SA...
06/05/2024
Tonight on House of Zwide: Bra Zakes and Sphamandla agree to leave Tembisa and n...
06/05/2024
RT has announced details of its coverage across digital, TV and Radio in the ru...
06/05/2024
For years, radio stations have used on-premises servers to broadcast content and manage automation, traffic, and billing systems. As technology continues to adv...
06/05/2024
06 May 2024
AI and Big Data Take the Centre Stage in Central Asia at Beetech 20...
06/05/2024
FIRST LOOK AT JIM PARSONS & MAYIM BIALIK REPRISING THEIR ROLES FROM THE BIG BAN...
06/05/2024
NBC Sports and Churchill Downs Extend Historic Partnership, Kentucky Derby to Be...
06/05/2024
Beverly Hills Aerials, LIV Golf Make Australian-Broadcast History by Flying Live...
06/05/2024
Back to All News
Watch the Trailer for A Part of You - Felicia Maxime, Edvin Ry...
06/05/2024
Leadership in 12G-SDI for low impact migration to 4k production...
06/05/2024
Press release - 6 May 2024 07:31
STATEMENT CONCERNING EUTELSAT GROUP'S GROUND NETWORK Facebook
LinkedIn
Twitter
Download as PDF
Paris, 06 May 2024 ...
06/05/2024
Tyngsboro, Mass. - May 6, 2024 - Join us at InfoComm 2024 to experience the latest advancements in live production technology. From June 12-14, 2024, at the Las...
06/05/2024
To champion global movements to protect and advance equality for LGBTQ+ communities, Apple is introducing a new Apple Watch Pride Edition Braided Solo Loop, ava...
06/05/2024
Actress Matseliso Mohale has joined Muvhango'Talented actress Matseliso Mohale has joined SABC2's soapie Muvhango' as Vhangani's lover and a c...
06/05/2024
Tonight on Smoke and Mirrors: Leroy refuses to give up fighting to bury MthethoDon't miss Monday, 6 May's riveting episode of South African soapie Smoke...
06/05/2024
Intrinsic, a software and AI robotics company at Alphabet, has integrated NVIDIA AI and Isaac platform technologies to advance the complex field of autonomous r...
06/05/2024
Cybersecurity experts at the RSA Conference this week will be on the hunt for ways to secure their operations in the era of generative AI.
They'll find man...
06/05/2024
1) What is the rationale of the transaction? What is the benefit for SES shareholders?
This combination creates a stronger and more competitive multi-orbit ope...
05/05/2024
A special evening performance by multiplatinum singer Becky G will provide a memorable conclusion to TeievisaUnivision's Casa Cultura upfront event on May 1...
05/05/2024
Giant media buyer Publicis is telling network sales executives that it does not think Nielsen's new panel-plus-big-data currency is ready for this upfront....
05/05/2024
WASHINGTON Glenn Kirschner, legal analyst at NBC News, blasted the media for referring to the New York trial of former President Donald Trump as a hush-money ...
05/05/2024
Catchy Comedy's weekend marathon sees The Beverly Hillbillies on the weekend of May 4-5. The event kicks off Saturday, May 4 at 11 a.m. ET, and runs through...
05/05/2024
NBC Sports has the 150th Kentucky Derby Saturday, May 4. The coverage begins at 2:30 p.m. ET on NBC and Peacock and the feature race at Churchill Downs in Louis...
05/05/2024
Back to All News
Netflix Announces New Comedy Series Roosters, Starring Jeroen ...
05/05/2024
Back to All News
Showdown Alert: Baki Hanma VS Kengan Ashura' Drops Electr...
04/05/2024
NEW YORK As the Asian Pacific American Heritage Month kicks off in May, Nielsen has released an extensive new report diving into their media habits with data sh...
04/05/2024
PHILADELPHIA As National Military Appreciation Month gets underway, Comcast has announced several new initiatives to help veterans, service members, and their f...
AWS Launches Amazon Redshift Spectrum 
