Click to learn more about author Stuart Tarmy. Globally, some 1.7 billion people are unbanked, with the World Bank estimating the largest number — about 225 million — are in China, followed by India with about 190 million. Other countries with a greater percentage of unbanked citizens include Indonesia, Pakistan, Nigeria, Mexico, and Bangladesh. Even in the U.S., […]
What’s Going on with Data Platforms in Brokerages During the Times of Covid
Click to learn more about author Stuart Tarmy. The volatility of the stock market caused by the pandemic’s economic fallout has led to an incredible surge of trading by both experienced and new investors looking for financial opportunities. This year, these investors drove a second-quarter retail equity trading volume to skyrocket more than 50 percent from the first […]
Generally Accepted Data Modeling Principles
What can data modelers learn from accountants? Accounting is a solidly established practice that the world cannot live without. One of the established guidelines for accountants is called GAAP (Generally Accepted Accounting Principles in the US), and there are similar international setups. You might guess these standards are about rules, but actually, accounting is much […]
The False Technology Choice Dichotomy
Click to learn more about author David Segleau. I recently spent more than a few hours trying to build and configure a DIY solution in the cloud for ad-hoc analytical queries. The exact pieces of software are not that important because all of the build-it-yourself-better-and-cheaper solutions start to look the same after a while. After […]
Top Five Issues When Migrating Database Workloads to the Cloud
Click to learn more about author Ron Bennatan. If you are responsible for your company’s database security and compliance program, chances are you started this project when most database workloads were on-premises, and your databases lived inside your own data centers. Most likely, you are also embarking on or already in the middle of a […]
What Is an ETL Developer?
Click to learn more about author Edwin Lisowski. What is ETL? To begin with, ETL stands for extract, transform, and load. ETL allows businesses to collect data from various sources into one database. The process consists of three stages: 1. Reading data from a database2. Converting the extracted data into a form that can be […]
Working with Complex Data Models
Complex data models have now become the norm. A single stream of the data can travel through many hubs, and many different technologies. It may travel through the front end, the APIs, the Kafka pub/sub systems, Lambda functions, ETLs, data lakes, data warehouses, and more. Riding within this stream of data is the schema, and […]
Graph Databases vs. Key-Value Databases
Graph databases and key-value databases have very different features and are used for accomplishing different tasks. Key-value databases are streamlined and fast, but are limited and not as flexible. Graph databases, on the other hand, are very flexible and great for research, but not terribly fast. Both typically use a non-relational foundation. The two key […]
Hybrid Database Architectures Lead the Way
Hybrid databases have evolved in the last decade, with a focus on cloud environments. In 2013, Gartner created the term “Hybrid Transaction/Analytical Processing” (or HTAP), which is defined by Gartner as: “An emerging application architecture that ‘breaks the wall’ between transaction processing and analytics. It enables more informed and ‘in business real time’ decision making.” […]
Data Lake or Data Warehouse?
Click here to learn more about Joe deBuzna. Abandoning a data warehouse for a data lake may not be the answer. Over the last few decades, we’ve seen an explosion in the use of data warehousing within the IT industry. It was all the rage for doing analytics and reporting. Data warehouses are popular because […]