#MySQL 9.7.0 is now generally available!

This version consolidates recent work across the 9.x cycle, including improvements in replication observability, telemetry & query optimization.

Several capabilities previously available only in the Enterprise Edition are now available in the Community Edition.

Learn more: https://bit.ly/49JJbD4

#InfoQ #Oracle #opensource #RelationalDatabases

Lakehouse architectures allow multiple engines to run on shared data through open table formats like #ApacheIceberg.

But #SQL identifier resolution and catalog naming rules differ across engines - creating hidden interoperability failures.

In this #InfoQ article, Maninder Parmar explains why enforcing consistent naming conventions and cross-engine validation is critical.

📰 Read now: https://bit.ly/4902zeH

#RelationalDatabases #DataLake

Software developer and book author Alexey Makhotkin reviews fifth normal form (5NF) and offers valuable links to (some free) further information on relational database design and normalization.

"5NF and Database Design"

https://kb.databasedesignbook.com/posts/5nf/

#programming #databases #relationaldatabases #sql #databasenormalization #normalforms

#Uber redesigned its #MySQL fleet using a consensus-driven architecture based on MySQL Group Replication:
✅ Cluster failover dropped from minutes → seconds
✅ Leader election & failure detection now inside the database layer
✅ Improved availability, simpler orchestration, stronger consistency across thousands of production clusters

Learn more: https://bit.ly/4b8RWYL

#SoftwareArchitecture #DistributedSystems #Clusters #FaultTolerance #RelationalDatabases

Starting with #MySQL 9.6, foreign key validation & cascade actions will be managed by the SQL layer instead of the InnoDB storage engine.

Why this matters ❓
✅ Better change tracking
✅ More accurate replication
✅ Stronger data consistency

This shift makes MySQL more reliable for CDC pipelines, mixed-database environments, and analytics workloads.

Learn more: https://bit.ly/4rRJqDq

#InfoQ #opensource #RelationalDatabases

Using the expand and contract pattern for schema changes

https://www.prisma.io/dataguide/types/relational/expand-and-contract-pattern

#HackerNews #expandAndContract #schemaChanges #dataPatterns #databaseManagement #relationalDatabases #prisma

Designing the Database to Support SAS® Marketing Automation | CoListy
Learn database design for SAS Marketing Automation to boost performance and configure environments seamlessly. Free Online Learning! | CoListy
#optimaldatabasedesign #sasmarketingautomation #sascustomerintelligencetools #sasmanagementconsole #dataconfiguration #relationaldatabases #freeonlinelearning #colisty

https://colisty.netlify.app/courses/explore-and-visualize_-getting-started/

Better late than never, pt. 2: We have published the (very long) blog post summarising our research seminar in Oslo last April.
👉 Read it on our blog!
https://dsenetwork.hypotheses.org/146

A group of textual scholars & software engineers discussed challenges of #DigitalScholarlyEditions regarding #Sustainability, mainly from a Norwegian perspective.

Headlined by @helling_patrick, we looked at #Coptic #Manuscripts, #Runes in #RelationalDatabases & #XML, #Mycenean #Inscriptions & #Norwegian #ArchivalEditions

Congrats to @codydunne & Wolfgang Gatterbauer for their #SIGMOD 2024 best paper honorable mention (one of 3 for the conference)!

Check out "On the reasonable effectiveness of Relational Diagrams: explaining relational query patterns and the pattern expressiveness of relational languages" here:

https://vis.khoury.northeastern.edu/pubs/Gatterbauer2024ReasonableEffectiveness/

#SQL #RDBMS #RelationalDatabases #RelationalAlgebra #RelationalCalculus #Logic #Visualization #HCI