Hacker NewsUsing 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
CoListyDesigning 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/
Annika Rockenberger (she/they)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
Khoury Vis Lab @ NortheasternCongrats 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
On the reasonable effectiveness of Relational Diagrams: explaining relational query patterns and the pattern expressiveness of relational languages - Khoury Vis Lab, Northeastern University
On the reasonable effectiveness of Relational Diagrams: explaining relational query patterns and the pattern expressiveness of relational languages - Khoury Vis Lab, Northeastern University
urigTrying 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?
InfoQManaged #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: https://bit.ly/3VewIBa
#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: https://bit.ly/3svcMOo
MySQL 8.2 Introduces Transparent Read/Write Splitting
Oracle has recently announced the general availability of MySQL 8.2, which includes support for Read/Write Splitting. This long-awaited feature has been introduced in the latest innovation release and helps optimize database performance and scalability.
Leah BudkeStill 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 https://glammr.us/@socket0/111126227726679138
๐ ๐ ๐ ฃ๐ ๐ ๐ ก๐ ๐ ๐ ฃ๐ (@socket0@glammr.us)
Coming up: #GhentCDH will be hosting a 2 part #goatnode workshop on 16/11 at #UGent, supporting researchers in using the relational web-based data management system & network & geospatial visualizations. Workshops will be given by @LAB1100 with the support of CLARIAH-VL. https://www.ghentcdh.ugent.be/nodegoat-2-part-workshop-beginners-and-advanced
#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: https://bit.ly/437uO6w
Meta Switches to MySQL Raft to Improve Reliability and Operational Simplicity
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.
Rajiv PantThe Neural Network Revolution: Why AI Will Make Traditional Databases Obsolete
https://rajiv.com/blog/2023/05/12/the-neural-network-revolution-why-ai-will-make-traditional-databases-obsolete/
#NeuralNetworks #DatabaseEvolution #InformationStorage #AI #DataManagement #NoSQL #RelationalDatabases #MindMapping #ProgrammingHistory #LargeLanguageModels #LLM