Structured query language (SQL) is now 50 years old. The original paper for SQL (then called SEQUEL) was published in May 1974 by Raymond Boyce and Donald Chamberlin, and provided a guide for data manipulation based on a set of simple commands. Today, we take SQL for granted around data – it is still the third most […]
Why Total Cost of Ownership Is a Critical Metric in High-Availability Databases
In the world of data management, the focus often zeroes in on the performance, scalability, and reliability of database systems. Total cost of ownership (TCO) is a crucial aspect that should hold equal – if not more – importance. TCO isn’t just a financial metric; it’s a comprehensive assessment that can significantly impact a business’s […]
Knowledge Graphs 101: The Story (and Benefits) Behind the Hype
Knowledge graphs, while not as well-known as other data management offerings, are a proven dynamic and scalable solution for addressing enterprise data management requirements across several verticals. As a hub for data, metadata, and content, they provide a unified, consistent, and unambiguous view of data scattered across different systems. Using global knowledge as context for […]
How In-Database Machine Learning Transforms Decision-Making
In the contemporary landscape of data-driven decision-making, enterprises are increasingly turning to predictive analytics to gain valuable insights into future trends and behaviors. Predictive analytics involves extracting patterns from historical data to forecast future outcomes, enabling organizations to make proactive decisions and optimize their operations. Traditionally, predictive analytics has been performed using standalone machine learning […]
DevOps and Data: Lessons Teams Can Learn About Managing Databases
According to the Bureau of Labor Statistics, the outlook for jobs around managing data architecture and databases looks pretty good: The number of professionals with roles around managing data is due to grow by eight percent from 2022 to 2032. However, while the number of roles that work around data is going up, the position of database […]
Integrating AWS Data Lake and RDS MS SQL: A Guide to Writing and Retrieving Data Securely
Writing data to an AWS data lake and retrieving it to populate an AWS RDS MS SQL database involves several AWS services and a sequence of steps for data transfer and transformation. This process leverages AWS S3 for the data lake storage, AWS Glue for ETL operations, and AWS Lambda for orchestration. Here’s a detailed […]
Four New Apache Cassandra 5.0 Features to Be Excited About
With the recent beta release of Apache Cassandra 5.0, now is a great time for teams to give it a spin and discover 5.0’s most interesting and anticipated new capabilities. As I’ve poked around with the new beta, here are four features introduced with open-source Cassandra 5.0 that developer teams should be excited about: 1. Vector […]
Mastering Microsoft SQL Server: Analyzing and Optimizing Complex Queries
In the realm of database management, particularly with Microsoft SQL Server, understanding and optimizing complex queries is crucial for maintaining system performance and efficiency. As databases grow and complexity, the queries used to retrieve, update, or manipulate data can become increasingly intricate, potentially leading to slower response times and decreased application performance. This blog post […]
How AI Graph Databases Are Empowering the Business with Better Insights (Part Two)
In the dynamic landscape of data-driven decision-making, businesses are turning to the transformative power of AI graph databases to unlock unparalleled insights. This cutting-edge technology is reshaping the way organizations harness and analyze interconnected data, paving the way for more informed, strategic, and agile business strategies.
In the first part of this blog series, we discussed…
Handling Data Concerns in 2024 and Onwards
Looking back, then forward, is a traditional exercise by year-end. Which data concerns are important enough to worry about in 2024? Which of those do we stand a chance of doing something good for in 2024? Needless to say, money (budget and costs) is an issue. But even more needless to say, solving real business […]