Tag: Database
-
Delta Lake and MinIO for multi-cloud data lakes
Posted on August 31, 2022, Level beginner Resource Length medium
Delta Lake is an open-source storage framework that is used to build data lakes on top of object storage in a Lakehouse architecture. Delta Lake supports ACID transactions, scalable metadata handling and unified streaming and batch data processing. By Matt Sarrel.
Tags cio big-data cloud database data-science
-
Seven ways to reduce MySQL costs in the cloud
Posted on August 30, 2022, Level beginner Resource Length medium
With the economy slowing down and inflation raging in many parts of the world, your organization will love you if you find ways to reduce the costs of running their MySQL databases. This is especially true if you run MySQL in the cloud, as it often allows you to see the immediate effect of those savings, which is what this article will focus on. By Peter Zaitsev.
Tags mysql cio devops cloud database
-
Data Manipulation with functional programming and queries in Ballerina
Posted on August 18, 2022, Level intermediate Resource Length medium
As an adept at Functional Programming (FP), I feel at ease with expressing my data manipulation logic by chaining high order functions like map, filter, and sort operating on arrays and maps. Ballerina, being designed as a Data-Oriented programming language, supports this FP style of coding. By Yehonathan Sharvit.
Tags app-development programming database functional-programming mysql
-
Introduction to Apache Spark and its Datasets
Posted on August 15, 2022, Level intermediate Resource Length medium
In this article, we will introduce you to the big data ecosystem and the role of Apache Spark in Big data. We will also cover the Distributed database system, the backbone of big data. In today's world, data is the fuel. Almost every electronic device collects data that is used for business purposes. By Abhishek Jaiswal.
Tags big-data data-science database miscellaneous
-
Expanding the CAP tradeoff frontier at scale
Posted on August 14, 2022, Level advanced Resource Length medium
Distributed systems must balance their needs for high availability and low latency with consistency guarantees; providing a mostly hit happy path for requests enables these systems to push the boundaries of this tradeoff. By Audrey Cheng.
Tags database big-data data-science performance devops
-
Hidden gems of Google BigQuery
Posted on August 9, 2022, Level intermediate Resource Length medium
BigQuery is amazing. It is one of my favorite tools within Google Cloud. Luckily, it looks like Google feels the same and, to the joy of BigQuery fans, keeps adding new features there. By Artem Nikulchenko.
Tags golang app-development database miscellaneous gcp
-
Scaling up and load balancing your PostgreSQL Cluster using Pgpool-II
Posted on July 12, 2022, Level intermediate Resource Length medium
PostgreSQL's speed, robustness and security makes it suitable for 99% of the new-age applications. Today, let's deep dive into how you can enable scalability and load balancing of your PostgreSQL cluster using Pgpool-II. By Azman Agung Nugraha.
Tags database performance software-architecture mysql
-
Working with a JSONB array of objects in PostgreSQL
Posted on July 7, 2022, Level intermediate Resource Length medium
Get, add and remove JSON objects from an array. By Rob Tomlin.
Tags json database mysql app-development
-
What MongoDB teaches us about database trends
Posted on June 7, 2022, Level beginner Resource Length medium
Back in June 2014, the top five most popular databases were exactly the same as June 2022: Oracle, MySQL, Microsoft SQL Server, PostgreSQL and MongoDB. The difference is their relative popularity: PostgreSQL and MongoDB have been gaining in popularity relative to the relational incumbents. By Matt Asay.
Tags cloud nosql microservices database
-
AIOps with Azure Metrics Advisor
Posted on June 4, 2022, Level intermediate Resource Length long
AIOps is a term introduced by Gartner in 2016, referring to AI for IT Operations. It combines big data and machine learning to automate IT operations processes, including event correlation, anomaly detection, and causality determination. By ODSC Community.
Tags cloud devops azure database big-data
-
Migrating to utf8mb4: MySQL things to consider
Posted on May 1, 2022, Level intermediate Resource Length medium
The utf8mb4 character set is the new default as of MySQL 8.0, and this change neither affects existing data nor forces any upgrades. By Sveta Smirnova.
Tags mysql web-development app-development database
-
MySQL 8: Password verification policy
Posted on April 28, 2022, Level intermediate Resource Length medium
The artcicle discusses the password verification-required policy introduced in MySQL 8.0.13. With this feature, it is possible to require that attempts to change an account password be verified by specifying the existing current password to be replaced. By Brian Sumpter.
Tags mysql database cio infosec devops