article thumbnail

Speed up queries with the cost-based optimizer in Amazon Athena

AWS Big Data

Starting today, the Athena SQL engine uses a cost-based optimizer (CBO), a new feature that uses table and column statistics stored in the AWS Glue Data Catalog as part of the table’s metadata. Let’s discuss some of the cost-based optimization techniques that contributed to improved query performance.

article thumbnail

Microsoft to optimize process automation stack with Minit acquisition

CIO Business Intelligence

Microsoft has bought Minit, a developer of process mining software, to help its customers optimize business processes across the enterprise, on and off Microsoft Power Platform. Minit began life in Slovakia in 2015, and now has around 50 employees.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

Take Your SQL Skills To The Next Level With These Popular SQL Books

datapine

Amongst the various topics that it covers, ”SQL Performance Explained” offers knowledge into: Correctly applying SQL functions Using indexes correctly How to use LIKE queries efficiently How to optimize join operations Data clustering Database scalability. 17) “SQL Database Programming” (2015 Edition) By Chris Fehily.

article thumbnail

AI is key player in Texas Rangers’ winning formula

CIO Business Intelligence

In 2015, Major League Baseball revolutionized a sport already known for its sophisticated use of data with MLB Statcast, a tracking technology that collects enormous amounts of game data. Booth and his team built models to predict not only the optimal times to deploy the shift, but spots for players to position themselves on the field.

article thumbnail

How HPE Aruba Supply Chain optimized cost and performance by migrating to an AWS modern data architecture

AWS Big Data

Hewlett-Packard acquired Aruba Networks in 2015, making it a wireless networking subsidiary with a wide range of next-generation network access solutions. The new solution has helped Aruba integrate data from multiple sources, along with optimizing their cost, performance, and scalability.

article thumbnail

12 most popular AI use cases in the enterprise today

CIO Business Intelligence

Organizations all around the globe are implementing AI in a variety of ways to streamline processes, optimize costs, prevent human error, assist customers, manage IT systems, and alleviate repetitive tasks, among other uses. And with the rise of generative AI, artificial intelligence use cases in the enterprise will only expand.

article thumbnail

How Edge as a Service is shaping the future of fan engagement

CIO Business Intelligence

have expanded the reach of the race to a new generation of fans and ensured they’re able to continually optimize race operations. “We We started working on Tour de France in 2015 and, when we began, the digital capability of the event was very limited,” says Peter Gray, Senior Vice President, Advanced Technology Group (Sport) at NTT.

IoT 98