Data Engineering Podcast

FEBRUARY 3, 2019

Join the community in the new Zulip chat workspace at dataengineeringpodcast.com/chat Your host is Tobias Macey and today I’m interviewing Eric Kansa about Open Context, a platform for publishing, managing, and sharing research data Interview Introduction How did you get involved in the area of data management?

Digital Media 100

Digital Media Media PostgreSQL Datasets 100

Workfall

JULY 4, 2023

With DBT, they weave powerful SQL spells to create data models that capture the essence of their organization’s information. DBT’s superpowers include seamlessly connecting with databases and data warehouses, performing amazing transformations, and effortlessly managing dependencies to ensure high-quality data.

Data Warehouse 69

Data Warehouse SQL PostgreSQL Database 69

Knowledge Hut

JUNE 16, 2023

Roles and Responsibilities of a Data Analyst Data mining: Data analysts gather information from a variety of primary or secondary sources. They then arrange the data in a suitable format that is simple to understand. Upkeep of databases: Data analysts contribute to the design and upkeep of database systems.

Programming Language 52

Programming Language Cloud Computing Data Preparation Data Science 52

Rockset

SEPTEMBER 20, 2022

Many of these services, as well as the dApps they may support, are built on transactional (OLTP) databases such as PostgreSQL, DynamoDB, MongoDB and others. These databases struggle to serve low latency results during high demand periods, when a lot of users are simultaneously querying data.

PostgreSQL 52

PostgreSQL MongoDB SQL Datasets 52

Silectis

JANUARY 3, 2021

Big Data Processing In order to extract value or insights out of big data, one must first process it using big data processing software or frameworks, such as Hadoop. Big Query Google’s cloud data warehouse. Cassandra A database built by the Apache Foundation. Database A collection of structured data.

Data Engineering 40

Data Engineering Data Engineer Engineering Hadoop 40

ProjectPro

FEBRUARY 16, 2023

If you are still wondering whether or why you need to master SQL for data engineering, read this blog to take a deep dive into the world of SQL for data engineering and how it can take your data engineering skills to the next level. Data engineers can perform any quality checks using the DDL commands in SQL.

Data Engineering 52

Data Engineering Data Engineer SQL Engineering 52

Rockset

OCTOBER 20, 2021

Until now, the majority of the world’s data transformations have been performed on top of data warehouses, query engines, and other databases which are optimized for storing lots of data and querying them for analytics occasionally. For instance, let’s say you have streaming data coming in from Kafka or Kinesis.

SQL 52

SQL PostgreSQL MongoDB NoSQL 52

Knowledge Hut

JULY 24, 2023

In this digital age, data is king, and how we manage, analyze, and harness its power is constantly evolving. Database management, once confined to IT departments, has become a strategic cornerstone for businesses across industries. In this blog, we will talk about the future of database management.

Database 52

Database NoSQL Management Relational Database 52

ProjectPro

SEPTEMBER 26, 2014

The toughest challenges in business intelligence today can be addressed by Hadoop through multi-structured data and advanced big data analytics. Big data technologies like Hadoop have become a complement to various conventional BI products and services. Big data, multi-structured data, and advanced analytics.

Business Intelligence 40

Business Intelligence Hadoop BI Relational Database 40

Rockset

SEPTEMBER 3, 2020

Offloading read operations to another database, such as PostgreSQL, is one option that accomplishes this end. After discussing what PostgreSQL is, this article will look at how to offload read operations to it. What Is PostgreSQL? This capability allows PostgreSQL to be used as a document database as well.

MongoDB 40

MongoDB PostgreSQL SQL Database 40

Knowledge Hut

MARCH 15, 2024

Making decisions in the database space requires deciding between RDBMS (Relational Database Management System) and NoSQL, each of which has unique features. RDBMS uses SQL to organize data into structured tables, whereas NoSQL is more flexible and can handle a wider range of data types because of its dynamic schemas.

NoSQL 52

NoSQL Database-centric Relational Database PostgreSQL 52

Rockset

JANUARY 5, 2022

Rockset is the real-time analytics database in the cloud for modern data teams. Get faster analytics on fresher data, at lower costs, by exploiting indexing over brute-force scanning. In many tech circles, SQL databases remain synonymous with old-school on-premises databases like Oracle or DB2.

Database 52

Database SQL NoSQL Raw Data 52

Netflix Tech

FEBRUARY 25, 2021

Many organizations are embracing GraphQL as a way to unify their enterprise-wide data model and provide a single entry point for navigating a sea of structured data with its network of related entities. Documentation can even be embedded in the database comments such that it displays in the GraphQL schema generated by Graphile.

PostgreSQL 80

PostgreSQL Database Entertainment SQL 80

AltexSoft

JUNE 26, 2023

Data collection revolves around gathering raw data from various sources, with the objective of using it for analysis and decision-making. It includes manual data entries, online surveys, extracting information from documents and databases, capturing signals from sensors, and more.

Data Collection 52

Data Collection Machine Learning Unstructured Data Non-relational Database 52

Monte Carlo

FEBRUARY 15, 2023

On the surface, the promise of scaling storage and processing is readily available for databases hosted on AWS RDS, GCP cloud SQL and Azure to handle these new workloads. Cloud data warehouses solve these problems. What is a data warehouse? What’s the difference between a transactional database and a data warehouse?

Data Warehouse 52

Data Warehouse Unstructured Data AWS Business Intelligence 52

Data Engineering Weekly

FEBRUARY 12, 2023

– Postgres Innovation: Full-Text Search Any modern databases should support storing and processing semi-structured data & free text search. Expecting a well-defined upfront schema modeling is practically impossible with the variety of data sources we deal with.

Data Engineering 52

Data Engineering Data Engineer Engineering Hadoop 52

ProjectPro

DECEMBER 10, 2021

For apps that depend exclusively on the search for both feature extraction and content navigation, Azure Cognitive Search is the ideal cloud provider for full-text search operations over content repositories and databases on Azure. It is a cloud-based NoSQL database that deals mainly with modern app development. What is Azure CosmosDB?

BI 52

BI Cloud Computing SQL Database 52

ProjectPro

APRIL 26, 2016

Pig vs Hive Criteria Pig Hive Type of Data Apache Pig is usually used for semi structured data. Used for Structured Data Schema Schema is optional. Language It is a procedural data flow language. HBase is a NoSQL database. It is suggested to use standalone real database like PostGreSQL and MySQL.

Hadoop 40

Hadoop Metadata SQL Database 40

ProjectPro

JULY 27, 2021

Differentiate between relational and non-relational database management systems. Relational Database Management Systems (RDBMS) Non-relational Database Management Systems Relational Databases primarily work with structured data using SQL (Structured Query Language).

Data Engineering 40

Data Engineering Data Engineer Engineering Hadoop 40

Knowledge Hut

JANUARY 11, 2024

Data science is the field of study that deals with a huge volume of data using modern technologically driven tools and techniques to find some sort of pattern and derive meaningful information out of it that eventually helps in business and financial decisions. This work is done by financial data scientists.

Finance 93

Finance Data Science Programming Language Machine Learning 93

ProjectPro

AUGUST 21, 2015

Hadoop vs RDBMS Criteria Hadoop RDBMS Datatypes Processes semi-structured and unstructured data. Processes structured data. Schema Schema on Read Schema on Write Best Fit for Applications Data discovery and Massive Storage/Processing of Unstructured data. are all examples of unstructured data.

Hadoop 40

Hadoop Big Data Metadata Unstructured Data 40