We are mixing it up on you again, no Outlaw this week, but we can offer you some talk of exotic databases. Also, Joe pronounces everything correctly and Allen leaves you with a riddle.
The full show notes are available on the website at https://www.codingblocks.net/episode229
News
- Thanks for the reviews!
- ivan.kuchin (has taken the lead!), Yoondoggy, cykoduck, nehoraigold
- Want to help us out? Leave a review! (reviews)
Multivalue DBMS
- Popular: 86. Adabas, 87. UniData/UniVerse, 147. JBase
- Similar to RDBMS - store data in tables
- Store multiple values to a particular record's attribute
- Some RDBMS's can do this as well, BUT it's typically an exception to the rule when you'd store an array on an attribute
- In a MultiValue DBMS - that's how you SHOULD do it
- Part of the reason it's done this way is these database systems are not optimized for JOINS
- Looked at the Adabas and UniData sites - the primary selling points seem to be rapid application development / ease of learning and getting up to speed as well as data modeling that closely mirrors your application data structures
- Store multiple values to a particular record's attribute
- I BELIEVE it's a schema on write (docs.rocketsoftware.com)
- Supposed to be very performant as you access the data the way your application expects it
- Per the docs, it's easy to maintain (Wikipedia)
Spatial DBMS
- Popular: 29. PostGIS, 59. Aerospike, 136. SpatiaLite
- Provides the ability to efficiently store, modify, and query spatial data - data that appears in a geometrical space (maps, polygons, etc)
- Generally have custom data types for storing the spatial data
- Indices that allow for quick retrieval of spatial data about other spatial data
- Also allow for performing spatial-specific operations on data, such as computing distances, merging or intersecting objects or even calculating areas
- Geospatial data is a subset of spatial data - they represent places / spatial data on the Earth's surface
- Spatio-temporal data is another variation - spatial data combined with timestamps
- PostGIS - basically a plugin for PostgreSQL that allows for storing of spatial data
- Additionally supports raster data - data for things like weather and elevation
- If you want to learn how to use it and understand the data and what's stored (postgis.net)
- Spatial data types are: point, line, polygon, and more…basically shapes
- Rather than using b-tree indexes for sorting data for fast retrieval, spatial indexes that are bounding boxes - rectangles that identify what is contained within them
- Typically accomplished with R-Tree and Quadtree implementations
- RedFin - a real estate competitor to realtor.com
Popular Podcasts
Las Culturistas with Matt Rogers and Bowen Yang
Ding dong! Join your culture consultants, Matt Rogers and Bowen Yang, on an unforgettable journey into the beating heart of CULTURE. Alongside sizzling special guests, they GET INTO the hottest pop-culture moments of the day and the formative cultural experiences that turned them into Culturistas. Produced by the Big Money Players Network and iHeartRadio.
Dateline NBC
Current and classic episodes, featuring compelling true-crime mysteries, powerful documentaries and in-depth investigations. Follow now to get the latest episodes of Dateline NBC completely free, or subscribe to Dateline Premium for ad-free listening and exclusive bonus content: DatelinePremium.com
This is Gavin Newsom
I’m Gavin Newsom. And, it’s time to have a conversation. It’s time to have honest discussions with people that agree AND disagree with us. It's time to answer the hard questions and be open to criticism, and debate without demeaning or dehumanizing one other. I will be doing just that on my new podcast – inviting people on who I deeply disagree with to talk about the most pressing issues of the day and inviting listeners from around the country to join the conversation. THIS is Gavin Newsom.