Free trial

Blog

This blog is intended for software system engineers, architects and managers or people generally interested in development, testing and integration of software systems. It is part of profiq’s community effort that has the objective of sharing knowledge and ideas about software system integration, testing and development. In addition to this technical content, we share updates about life at profiq.

Tags

Presto – part 2: Data Analysis and Machine Learning in SQL

In an earlier article, we introduced you to Presto, an open-source, distributed SQL query engine. It lets you use SQL to query data from many types of storage solutions. This includes data sources that don’t support SQL natively; for example, a JSON file stored on AWS S3. What’s even more interesting, is that Presto lets you perform joins across multiple databases based on different technologies. In our view, Presto is a great tool for organizations that store their data in multiple data sources, and want to analyze this data without…

database sql

Presto: Running SQL queries on anything

It is not uncommon for companies to use multiple data stores based on different technologies. We can easily imagine an organization using relational databases for transactional data, a NoSQL database such as MongoDB for semi-structured data, and an S3 bucket for large datasets. When performing analytical tasks, we often need to combine data from all of these sources. Traditionally, this meant gathering everything in one place: a data warehouse or a data lake. This brings a lot of issues; movement of data takes time, and we also need to perform…

database sql

Kinetica: The Next Generation of GPU Databases

“Data will be the raw material of the 21st century.”       Angela Merkel - World Economic Forum 2018 In IT, innovation and rapid change are constant. New technologies and frameworks are created daily. Rapid evolution of JavaScript and the world of web is a good example. The database world, on the other hand, has been relatively stable and changing slowly for decades. This does not imply that innovation is not happening. Databases are stable, time-tested, well-optimized, and improved yearly. The pace of innovation moves at a different rate…

cuda database gpu kinetica