Software — Database — December 25th, 2024
The Future of Data Lies in Transformer Models versus Big Data Transformations
Last year witnessed the explosive rise of large models, generating global enthusiasm and making AI seem like a solution to all problems.
December 25th, 2024 — Source
Software — Database — December 13th, 2024
Which Flow Is Best for Your Data Needs: Time Series versus Streaming Databases
While both are used to handle time-related data, their underlying technologies and main purpose are built to serve different purposes.
December 13th, 2024 — Source
Software — Database — December 10th, 2024
In-Depth Analysis of MySQL 8.0 Performance Degradation
We've analyzed the causes of increased response latency in MySQL 8.0. Users can understand the performance decline from both read/write operations and the code level.
December 10th, 2024 — Source
Software — Database — November 21st, 2024
Build Autonomous SQL Databases in Microsoft Fabric
Microsoft Fabric is ushering in a new era of database management through its innovative autonomous SQL databases. These innovative databases are designed to streamline your management tasks while significantly enhancing application development capabilities. By seamlessly integrating operational and analytical data across various cloud environments, Microsoft Fabric is set to transform the way you handle and interact with data.
November 21st, 2024 — Source
Software — Database — November 18th, 2024
How Uber Sped up SQL-based Data Analytics with Presto and Express Queries
Uber uses Presto, an open-source distributed SQL query engine, to provide analytics across several data sources, including Apache Hive, Apache Pinot, MySQL, and Apache Kafka. To improve its performance, Uber engineers explored the advantages of dealing with quick queries, a.k.a. express queries, in a specific way and found they could improve both Presto utilization and response times.
November 18th, 2024 — Source
Software — Database — November 15th, 2024
GraphRAG: Improving global search via dynamic community selection
Retrieval-augmented generation (RAG) allows AI systems to provide additional information and context to a large language model (LLM) when generating a response to a user query. However, traditional RAG-based methods can struggle to retrieve information that requires high-level knowledge of the entire dataset, especially with abstract and global questions such as the keywordless query: "Catch me up on the last two weeks of updates."
November 15th, 2024 — Source
Software — Database — October 30th, 2024
Implementing LSM Trees in Golang: A Comprehensive Guide
Follow an implementation of an LSM tree in Golang, discuss features, and compare it with more traditional key-value storage systems and indexing strategies.
October 30th, 2024 — Source
Software — Database — October 22nd, 2024
Clock's ticking on PostgreSQL 12, but not everyone is ready to say goodbye
11% of databases still on aging version with a month of support left
October 23rd, 2024 — Source
Software — Database — October 18th, 2024
How to Use Self Join and WITH Clause in Oracle
The Oracle WITH clause is one of the most commonly used techniques to simplify the SQL source code and improve performance.
October 18th, 2024 — Source
Software — Database — October 16th, 2024
Event-Driven vs. Event-Sourced: A Common Misunderstanding
The terms “event-driven” and “event-sourced” are often used interchangeably, while in reality, the two are very different concepts.
October 16th, 2024 — Source
Software — Database — October 12th, 2024
How do you solve a problem like MariaDB? Cozy up to the community, says new CEO
The new CEO of MariaDB (Plc) says he wants closer-knit collaboration with the foundation behind the eponymous open source database project. He cites the corporation's newfound stability from its recent acquisition by a private equity firm as to why it should now be able to get on a firmer footing.
October 12th, 2024 — Source
Software — Database — October 7th, 2024
SAP offers different way to move SQL Server-based software to the cloud
Just don’t call it an alternative to RISE with SAP
October 7th, 2024 — Source
Software — Database — September 22nd, 2024
Transform Unstructured Data Effortlessly with LangGraph Templates
This week LangGraph has introduced templates to simplify the creation of applications for common use cases, with a particular focus on transforming unstructured research data into structured formats like CSVs or databases. These templates provide a solid foundation for users to build upon, offering extensibility and configurability without the need to start from scratch.
September 22nd, 2024 — Source
Software — Database — September 13th, 2024
MongoDB CEO says if AI hype were the dotcom boom, it is 1996
NoSQL database slinger attempts to reassure investors, kinda
September 13th, 2024 — Source
Software — Database — September 3rd, 2024
Configuring a Connection Pool
A connection pooler is a software component that manages database connections. In this post, learn what a connection pooler is and how to configure it.
September 3rd, 2024 — Source
Software — Database — August 27th, 2024
Debugging Low Cache Hit Ratio
Explore debug scenarios where we can't utilize cached data and need to read from the physical drive, why it's important, what to look for, and helpful tools.
August 27th, 2024 — Source
Software — Database — August 21st, 2024
PostgreSQL databases under attack
Poorly protected PostgreSQL databases running on Linux machines are being compromised by cryptojacking attackers.
August 21st, 2024 — Source
Software — Database — August 16th, 2024
What Is SQL Injection and How Can It Be Avoided?
Learn about SQL Injection, a security risk in which the attackers find ways to manipulate inputs that are not cleaned properly in order to gain access to data.
August 16th, 2024 — Source
Software — Database — August 6th, 2024
Develop With OCI Real-Time Speech Transcription and Oracle Database NL2SQL/Select AI To Speak With Your Data
Use a combination of real-time speech-to-text, natural language to SQL, and Gen AI, to talk with your data just as you would to a person and in real-time.
August 6th, 2024 — Source
Hyperspace is using 'domain-specific computing' to accelerate database searches
The growth in the demand for generative AI apps has led to a need for larger and larger databases to store the associated data (e.g. model training data). These databases tend to be resource-intensive from a hardware perspective and, depending on the algorithms used to orchestrate them, they can be high-latency.
August 6th, 2024 — Source
Idempotency in Data Pipelines: Overview
Idempotency is an important concept in data engineering, particularly when working with distributed systems or databases. Learn more here.
August 6th, 2024 — Source
Oracle: Migrate PDB to Another Database
Explore different approaches to move the pluggable database from source to target database such as plug/unplug, data pump, refreshable clone and DBCA relocate.
August 6th, 2024 — Source
Software — Database — July 31st, 2024
Just Use PostgreSQL, a Quick-Start Guide: Exploring Essential and Extended Capabilities of the Most Beloved Database
Tour some of PostgreSQL's most notable capabilities and use cases, including various extensions for generative AI.
July 31st, 2024 — Source
Outlier Identification in Continuous Data Streams With Z-Score and Modified Z-Score in a Moving Window
How do you spot outliers in continuous data streams? Learn to catch network performance hiccups effortlessly using z-score and modified z-score.
July 31st, 2024 — Source
Plot Your REST Endpoints Using grafana-infinity-datasource
Plotting straight from the database is convenient, but is not always the case. Sometimes you might need something more complex that your API can support.
July 31st, 2024 — Source
Software — Database — July 29th, 2024
Automating Databases for Modern DevOps Practices: A Guide to Common Patterns and Anti-Patterns for Database Automation Techniques
By embracing AI, automation, database DevOps, and other emerging trends, organizations can ensure robust, efficient, and future-proofed database management practices.
July 29th, 2024 — Source
Software — Database — July 28th, 2024
DB2 versus Oracle for IBM Maximo: A Comparative Analysis
This essay explores the differences between DB2 and Oracle in the context of their integration with IBM Maximo and specific features that benefit Maximo environments.
July 28th, 2024 — Source
Real-Time Streaming Architectures: A Technical Deep Dive Into Kafka, Flink, and Pinot
While individual components like Kafka, Flink, and Pinot are very powerful, managing them at scale across cloud and on-premises deployments can be operationally complex.
July 28th, 2024 — Source
Software — Database — July 26th, 2024
Introduction to Polymorphism With Database Engines in NoSQL Using Jakarta NoSQL
This tutorial covers setting up Helidon with Oracle NoSQL, defining polymorphic entities, and managing JSON data efficiently.
July 26th, 2024 — Source
Software — Database — July 24th, 2024
Consistency versus Availability: The Eternal Struggle in Distributed Databases
Since the CAP theorem dictates that systems can only guarantee two of the three properties, this article provides strategies to manage the trade-offs.
July 24th, 2024 — Source
Effortless API Mocking With Playwright
Automated testing of web applications often requires interaction with external APIs. However, relying on actual API responses can introduce variables beyond your control.
July 24th, 2024 — Source
Spring Microservice Tip: Abstracting the Database Hostname With Environment Variable
Secure database connection strings in Spring microservices using environment variables and placeholder expressions for the hostname using the properties file.
July 24th, 2024 — Source
Software — Database — July 18th, 2024
Boomi's API Control Plane: Simplifying API Management for Developers
Boomi's new API Control Plane simplifies API management with centralized discovery, federated control, and enhanced security, revolutionizing how developers handle APIs.
July 18th, 2024 — Source
Software — Database — June 28th, 2024
Fortra Patches Critical SQL Injection in FileCatalyst Workflow
Fortra has patched a critical-severity vulnerability in FileCatalyst Workflow leading to the creation of administrator accounts.
June 28th, 2024 — Source
Software — Database — June 21st, 2024
Embracing NoSQL: The Future of Data Storage and Retrieval
NoSQL databases handle unstructured data, provide scalability, and offer high availability, ideal for modern, big data, and real-time applications.
June 21st, 2024 — Source
Software — Database — June 16th, 2024
Custom Health Checks in Spring Boot
Spring Boot provides health indicators to monitor application health and database health with the help of Spring Boot Actuator.
June 16th, 2024 — Source
Software — Database — June 6th, 2024
Streamlining Data Integration
This article demonstrates integrating Salesforce and Oracle into Amazon Redshift using Python and stored procedures, leveraging the ELT approach.
June 6th, 2024 — Source
What are Cloud Databases and how do they work?
Cloud databases, also known as Database as a Service (DBaaS), offer a range of benefits for developers, particularly in terms of ease of use, deployment options, disaster recovery, and scalability. These databases are hosted by cloud providers with data centers distributed globally, allowing for efficient data management and accessibility. IBM outlines the core aspects and advantages of using cloud databases in the development and deployment of applications.
June 6th, 2024 — Source
Software — Database — May 21st, 2024
Running PostgreSQL in the Browser with WebAssembly
With the recently released PGlite, a Wasm build of Postgres that is packaged into a TypeScript client library, developers can run Postgres queries in the browser with no extra dependencies. PGlite is used for reactive, real-time, local-first apps.
May 21st, 2024 — Source
Software — Database — May 17th, 2024
Lords of May-hem: Seven signs it is Oracle's year end
How to handle sales pressure and licensing 'negotiations' to make sure it plays to your advantage
May 17th, 2024 — Source
UK competition cops say Microsoft's stake in Mistral is not a merger
Watchdog drops official probe but IT giant's deal with Inflection AI and Amazon's with Anthropic still in play
May 17th, 2024 — Source
Software — Database — May 1st, 2024
MongoDB aims to jumpstart AI app development with MAAP
The MongoDB AI Application Program will offer enterprises strategic advice, professional services, and an integrated end-to-end technology stack for building generative AI applications.
May 1st, 2024 — Source
Software — Database — April 28th, 2024
MongoDB CEO Dev Ittycheria talks AI hype and the database evolution as he crosses 10-year mark
A decade is a long time in tech
April 28th, 2024 — Source
Software — Database — April 24th, 2024
Graph databases speaking the same language after ISO gives GQL the nod
Standards body adoption could help ease portability between vendors
April 24th, 2024 — Source
Software — Database — April 11th, 2024
Exploring the Apache ecosystem for data analysis
How Apache Arrow, Apache Parquet, Arrow Flight, and DataFusion bring enhanced data processing capabilities to large volumes of time series and other data.
April 11th, 2024 — Source
Software — Database — March 27th, 2024
Steampipe dashboards and benchmarks for your data
Use Powerpipe to visualize and validate data in your own Postgres, SQLite, DuckDB, or MySQL database.
March 27th, 2024 — Source
Vitess Version 19 Released: Ends Support for MySQL 5.7, Improves MySQL Compatibility
Vitess v19 has been released. This latest version of the database management solution -- designed for the deployment, scaling, and administration of large clusters of open-source database instances -- provides several new features, including metrics for monitoring stream consolidations, improved query compatibility with MySQL for multi-table delete operations, support for incremental backups, and various performance enhancements.
March 27th, 2024 — Source
Software — Database — March 18th, 2024
Evaluating databases for sensor data
Sensor data and IoT applications have special requirements that might be better served by a specialized database. Here's what to consider.
March 18th, 2024 — Source
Securing AWS RDS SQL Server for Retail: Comprehensive Strategies and Implementation Guide
This article provides a detailed guide on securing AWS RDS SQL Server instances, tailored for retail stores, with practical setup examples.
March 18th, 2024 — Source
Software — Database — March 11th, 2024
How to Netflix Oracle's blockbuster audit model
Terms and conditions apply. Lawyers need not
March 11th, 2024 — Source
Software — Database — March 6th, 2024
The Hidden Cost of Using Managed Databases
In 2024, cloud computing is everywhere, often unnoticed (e.g., iCloud and Google Docs). Cloud computing has become as ubiquitous as real clouds. Many advantages of cloud computing, such as elasticity, scalability, and ease of use, are well understood at this point.
March 6th, 2024 — Source
Software — Database — March 4th, 2024
Streaming the Super Bowl: The Art of Scaling Across Multiple Cloud Regions
In this tutorial, learn to build multi-region applications that scale and tolerate all sorts of possible outages.
March 4th, 2024 — Source
Software — Database — February 28th, 2024
Simplifying SQL Server and Kubernetes Across Hybrid/Multi-Cloud
Enabling automated configuration and streamlined management and deployment across on-premise, public cloud, and hybrid infrastructure.
February 28th, 2024 — Source
Software — Database — February 23rd, 2024
Automating Efficiency: Setting Up Autoscaling in AWS RDS SQL Server Instances
This article will guide you through the process of setting up auto-calling in an AWS RDS SQL Server instance, highlighting key considerations and steps.
February 23rd, 2024 — Source
Building a Multi-Modal Image Search Application With MyScale
This article walks you through how to build a multi-modal image search application using a model from the Hugging Face library and MyScale.
February 23rd, 2024 — Source
CRUDing NoSQL Data With Quarkus, Part One: MongoDB
This article demonstrates how Quarkus, the supersonic, subatomic Java stack, greatly simplifies the NoSQL data persistence.
February 23rd, 2024 — Source
Secure Your API With These 16 Practices With Apache APISIX (Part 1)
A couple of months ago, I stumbled upon this list. In this two-post series, I'd like to describe how we can implement each point with Apache APISIX (or not).
February 23rd, 2024 — Source
Software — Database — February 21st, 2024
Can MariaDB's enterprise business be saved?
Poor financial health has taken a heavy toll on MariaDB PLC and shaken its customer base. An acquisition might not be enough to reverse the damage, experts said.
February 21st, 2024 — Source
How Slow Is Database I/O?
Perform a field test to find out the performances of retrieving data from Oracle and MySQL and compare them with the performance of retrieving data from the text file.
February 21st, 2024 — Source
Software — Database — February 19th, 2024
Building a REST Application With Oracle NoSQL Using Helidon
Dive into effortlessly creating a RESTful API with Java using Helidon and Oracle NoSQL in a straightforward manner, perfect for beginners.
February 19th, 2024 — Source
Recover Distributed Transactions in MySQL
How to identify and troubleshoot distributed (XA) transactions stuck in the prepared state in MySQL using XA recover, XA commit, and XA rollback commands.
February 19th, 2024 — Source
Rethinking Domain Driven Design: Beyond Tactical Patterns
The mainstream thought on Domain Driven Design is focused on its tactical patterns. Unfortunately, all those discussions are a disservice to the software community.
February 19th, 2024 — Source
Struggling database company MariaDB could be taken private in $37M deal
The 'non-binding' proposal comes 14 months after MariaDB went public via SPAC
February 19th, 2024 — Source
Software — Database — February 12th, 2024
Achieving Inheritance in NoSQL Databases With Java Using Eclipse JNoSQL
Explore Eclipse JNoSQL and MongoDB to streamline NoSQL database interactions in Java applications, making it easier to manage and manipulate diverse data sets.
February 12th, 2024 — Source
The Top 5 Apollo Alternatives for 2024
Explore the best database alternatives to Apollo.io for effective B2B prospecting and lead generation.
February 12th, 2024 — Source
Software — Database — February 7th, 2024
Enhancing Database Efficiency With MySQL Views: A Comprehensive Guide and Examples
This blog delves into the practical use of views in MySQL, offering insights and code examples to leverage this feature effectively.
February 7th, 2024 — Source
Software — Database — February 5th, 2024
Why developers should put the database first
Data is the heart of the user experience, so shouldn't developers start there? SQLite, NoSQL databases, and abstractions like Neurelo make that far easier to do.
February 5th, 2024 — Source
Software — Database — January 31st, 2024
Neurelo is building a simpler way for developers to connect a database to an application
Data has always been at the heart of every program, and even more so these days as data feeds machine learning and large language models, but connecting to those databases has been a constant struggle for developers.
January 31, 2024 — Source
Zilliz Cloud boosts vector database performance
The vector database cloud service may attract developers with performance and cost advantages over traditional databases for AI-related workloads, analysts say.
January 31, 2024 — Source
Software — Database — January 29th, 2024
Architecture Style: Modulith (vs. Microservices)
Use Modulith architecture to split your monolith into manageable pieces while maintaining their cohesion and unlocking your app's potential.
January 29, 2024 — Source
CockroachDB tempts legacy databases to crawl into the cloud age
Distributed system makes a grab for Oracle, Db2 features
January 29, 2024 — Source
Optimizing Data Management: Migrating From AWS RDS MySQL to Snowflake
If you're seeking a modern, innovative, and scalable approach to managing your data operations, AWS RDS just might be the solution you've been searching for.
January 29, 2024 — Source
Software — Database — January 26th, 2024
How To Back Up and Restore Azure SQL Databases
An organization needs to back up SQL Azure database records for data protection. Discover how to back up Azure SQL databases efficiently.
January 26, 2024 — Source
Software — Database — January 22nd, 2024
Instant Integrations With API and Logic Automation
Automate API creation using one command. Self-serve and ready for ad hoc integrations. Use rule-based logic for custom integrations, 40x more concise than code.
January 22, 2024 — Source
Using Approximate Nearest Neighbor (ANN) Search With SingleStoreDB
In this article, we'll evaluate ANN Index Search with the new VECTOR data type using the Fashion MNIST dataset from Zalando.
January 22, 2024 — Source
Software — Database — January 19th, 2024
Database Security: Best Practices and What You Need to Know
In this article, gain an understanding as to how implementing database security best practices is not just a technical necessity but a business imperative.
January 19, 2024 — Source
Software — Database — January 15th, 2024
SQL Data Storytelling: A Comprehensive Guide
Data storytelling involves presenting complex data concisely, visually, and analytically to communicate business insights. SQL is pivotal for data storytelling.
January 15, 2024 — Source
Software — Database — January 11th, 2024
Effortlessly Transform CSV Into a REST API Within Minutes
TiDB Serverless is a fully managed, autoscaling Database-as-a-Service (DBaaS) solution built on TiDB, an advanced open-source, distributed SQL database.
January 11, 2024 — Source
Restoring the MS SQL Server Database in Easy Steps
Explore methods to restore the Microsoft SQL Server Database in easy steps. Get the best solutions for restoring the MS SQL Server Database.
January 11, 2024 — Source
Using Schema Types To Create SQL Queries in Java
In this article, discover more about how schema types can simplify and streamline JDBC query construction in Java with examples.
January 11, 2024 — Source
Software — DataBase — Resources
A practical comparison of Map-Reduce in MongoDB and RavenDB
Over the past week I've been learning about MongoDB. in my adventures with Node.js I am now at the point where I need some kind of data store.
Provides Information — Source
Access database repair
Access database repair tool for the recovery of corrupt databases in Microsoft Access 95, 97, 2000, 2002 (XP), 2003, 2007, 2010 and 2013. It recovers all data from a corrupt mdb, mde, accdb or accde database even in the hardest cases.
Provides a Service — Source
Argentum Software
Argentum Corporation — Cataloging Software, Backup Software, Database Software.
Provides Products — Source
Convert MySQL to MSSQL
MS Access to MySQL converter tool safely converts the database tables or records with password protected records.
Provides Products — Source
Database DebunkIing
Site dedicated to dispelling fallacies and misconceptions prevailing in the database industry.
Provides Information — Source
Database Normalization and Table structures
Normalisation is the term used to describe how you break a file down into tables to create a database. There are 3 or 4 major steps involved known as 1NF (First Normal Form), 2NF (Second Normal Form), 3NF (Third Normal Form) and BCNF (Boyce-Codd Normal Form).
Provides Information — Source
Database Research at Waterloo
Research areas include traditional relational database systems, complex objects, geometric data, text, and real-time data.
Provides Information — Source
David Consulting Group
DCG services include software metrics, software process improvement and outsourcing.
Provides Information — Source
DecisionDatabases.com
DecisionDatabases.com is proficient in providing syndicated research report, customized research reports, company profiles and industry databases across multiple domains.
Provides Products — Source
Erlangen University Department of Database Systems
Research projects include data warehousing, scientific database management, workflow management, and distributed data.
Provides Products — Source
InfluxData
An open-source distributed time series database with no external dependencies.
Provides Products — Source
MySQL in Docker with Java Hibernate
Recently, I started working on a new server project at work, and wanted to be able to run a local dev environment with Docker. this has become my normal flow for a couple of server projects because of how easy Docker is to work with, and especially for the fact that I don't need to set up any of the supporting structure on my machine to run the server.
Provides Information — Source
TechnicalSharp
technical solution for you
Provides Information — Source
Temporal Database Concepts
Defines a wide range of terms and concepts specific to the temporal database research community.
Provides Information — Source