#RelationalDatabases

CoListycolisty
2025-01-16

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

colisty.netlify.app/courses/ex

Annika Rockenberger (she/they)arockenberger@fedihum.org
2024-12-18

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!
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

Vis Lab @ Khoury, NortheasternKhouryVis@vis.social
2024-05-17

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:

vis.khoury.northeastern.edu/pu

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

Diagram of a SQL queryDiagram of a SQL query
2024-04-07

Trying to come up with the fundamental principles of the #RelationalDatabases and #SQL way of thinking:

- Common Language
SQL as the "lingua franca" of data. This was revolutionary 50 years ago when data had a "tower of babel" situation.

- Single source of truth
To avoid ambiguities and to conserve (expensive lol) storage space.

- Garbage in = Garbage out
Use strong typing at input-time to ensure data quality at output-time.

What else might also be such a high-level guiding principle?

2024-03-11

Managed #RelationalDatabases offer convenience, but are you aware of the hidden costs?

Gain valuable insights into monitoring service expenses, revising default settings, and understanding operational constraints.

#InfoQ article by Vignesh Ravichandran: bit.ly/3VewIBa

#CloudComputing

2023-11-13

#MySQL 8.2 is now generally available, including support for Read/Write Splitting support!

This long-awaited feature has been introduced in the latest innovation release and helps optimize database performance & scalability.

Details on #InfoQ: bit.ly/3svcMOo

#Oracle #SQL #Database #RelationalDatabases

2023-10-30

Still time to register for this two-part workshop (beginner and advanced) on Nodegoat to be hosted at UGent on 16/11 (with support from CLARIAH-VL)! 👇 👇

#dhinbelgium #digitalhumanities #relationaldatabases glammr.us/@socket0/11112622772

2023-05-23

#CaseStudy - Meta is rolling out #MySQL Raft in its data centers to replace its current MySQL semisynchronous databases. The new consensus engine helps operation and allows MySQL servers to take responsibility for promotions and membership.

More on #InfoQ: bit.ly/437uO6w

#AI #ML #SQL #RelationalDatabases

LinkML (OLD ACCOUNT)linkml@qoto.org
2022-11-09

Hello all!

This account is for the LinkML project. LinkML is an open #DataModeling framework that allows you to easily add #semantics to your data. It can be used to build #DataStandards and #DataDistionaries that are linked to #Ontologies.

The LinkML framework also comes with a number of tools for a range of activities, from generating code (primarily #python), and interchanging between #JSON/#YAML, #RDF, and #RelationalDatabases.

You can find a guide to LinkML here linkml.io/linkml, and our main #GitHub repo is here: github.com/linkml/linkml

We are a friendly and welcoming community, join us!

Client Info

Server: https://mastodon.social
Version: 2025.04
Repository: https://github.com/cyevgeniy/lmst