Blog

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…

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…

“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…