{"id":33,"date":"2017-07-02T22:39:37","date_gmt":"2017-07-02T20:39:37","guid":{"rendered":"podlove-2017-05-27t21:40:24+00:00-3ffd1c7aac8ebdd"},"modified":"2021-04-24T01:26:36","modified_gmt":"2021-04-23T23:26:36","slug":"datenbankstrukturen","status":"publish","type":"podcast","link":"https:\/\/andreas-hubel.de\/en\/datenbankstrukturen\/","title":{"rendered":"Datenbankstrukturen"},"content":{"rendered":"\n    \n            <div class=\"podlove-web-player intrinsic-ignore podlove-web-player-loading\" id=\"player-6ab09c62bc115\"><root data-test=\"player--xl\" style=\"max-width:950px;min-width:260px;\">\n  <div class=\"tablet:px-6 tablet:pt-6 mobile:px-4 mobile:pt-4 flex flex-col\">\n    <div class=\"flex-col items-center mobile:flex tablet:hidden\">\n      <show-title class=\"text-sm\"><\/show-title>\n      <episode-title class=\"text-base mb-2\"><\/episode-title>\n      <subscribe-button class=\"mb-4 mobile:flex tablet:hidden\"><\/subscribe-button>\n      <!-- poster class=\"rounded-sm w-48 shadow overflow-hidden\"><\/poster -->\n      <divider class=\"w-full my-6\"><\/divider>\n    <\/div>\n\n    <div class=\"tablet:flex flex-grow\">\n      <!-- div class=\"w-64 mobile:hidden tablet:block tablet:mr-6\">\n        <poster class=\"rounded-sm shadow overflow-hidden\"><\/poster>\n      <\/div -->\n      <div class=\"w-full\">\n        <div class=\"hidden tablet:block\">\n          <show-title class=\"text-base\"><\/show-title>\n          <episode-title class=\"text-xl desktop:text-2xl\"><\/episode-title>\n          <divider class=\"w-full my-4\"><\/divider>\n        <\/div>\n        <div class=\"flex items-center justify-between\">\n          <div class=\"block\">\n            <play-state on=\"active\">\n              <speed-control class=\"flex items-center\"><\/speed-control>\n            <\/play-state>\n          <\/div>\n\n          <div class=\"flex\">\n            <play-state on=\"active\">\n              <chapter-previous class=\"mx-2 block\"><\/chapter-previous>\n            <\/play-state>\n            <play-state on=\"active\">\n              <step-backward class=\"mx-2 block\"><\/step-backward>\n            <\/play-state>\n\n            <play-button class=\"mx-2 block\" :label=\"$t('PLAYER.PLAY_EPISODE')\"><\/play-button>\n\n            <play-state on=\"active\">\n              <step-forward class=\"mx-2 block\"><\/step-forward>\n            <\/play-state>\n            <play-state on=\"active\">\n              <chapter-next class=\"mx-2 block\"><\/chapter-next>\n            <\/play-state>\n          <\/div>\n\n          <div class=\"block\">\n            <play-state on=\"active\">\n              <volume-control class=\"flex items-center\"><\/volume-control>\n            <\/play-state>\n          <\/div>\n        <\/div>\n        <div class=\"flex w-full\">\n          <progress-bar><\/progress-bar>\n        <\/div>\n        <div class=\"flex w-full -mt-2\">\n          <div class=\"w-3\/12 text-left\">\n            <timer-current class=\"text-sm\"><\/timer-current>\n          <\/div>\n          <div class=\"w-6\/12 text-center truncate\">\n            <play-state on=\"active\">\n              <current-chapter class=\"text-sm\"><\/current-chapter>\n            <\/play-state>\n          <\/div>\n          <div class=\"w-3\/12 text-right\">\n            <timer-duration class=\"text-sm\"><\/timer-duration>\n          <\/div>\n        <\/div>\n      <\/div>\n    <\/div>\n    <divider class=\"w-full mt-6 mb-3\"><\/divider>\n    <div class=\"flex justify-between\">\n      <div class=\"flex mobile:w-full tablet:w-3\/12 desktop:w-3\/12 justify-between\">\n        <tab-trigger tab=\"chapters\">\n          <icon type=\"chapter\"><\/icon>\n        <\/tab-trigger>\n        <tab-trigger tab=\"transcripts\">\n          <icon type=\"transcripts\"><\/icon>\n        <\/tab-trigger>\n        <tab-trigger tab=\"files\">\n          <icon type=\"download\"><\/icon>\n        <\/tab-trigger>\n        <tab-trigger tab=\"playlist\">\n          <icon type=\"playlist\"><\/icon>\n        <\/tab-trigger>\n        <tab-trigger tab=\"share\">\n          <icon type=\"share\"><\/icon>\n        <\/tab-trigger>\n      <\/div>\n      <subscribe-button class=\"mt-1 mobile:hidden tablet:flex\"><\/subscribe-button>\n    <\/div>\n  <\/div>\n  <div class=\"w-full relative overflow-hidden\">\n    <tab name=\"chapters\">\n      <tab-chapters><\/tab-chapters>\n    <\/tab>\n    <tab name=\"transcripts\">\n      <tab-transcripts><\/tab-transcripts>\n    <\/tab>\n    <tab name=\"files\">\n      <tab-files><\/tab-files>\n    <\/tab>\n    <tab name=\"playlist\">\n      <tab-playlist><\/tab-playlist>\n    <\/tab>\n    <tab name=\"share\">\n      <tab-share><\/tab-share>\n    <\/tab>\n    <tab-overflow><\/tab-overflow>\n  <\/div>\n  <error><\/error>\n<\/root>\n<\/div>\n            <script>\n              document.addEventListener(\"DOMContentLoaded\", function() {\n                var player = document.getElementById(\"player-6ab09c62bc115\");\n                podlovePlayerCache.add([{\"url\":\"https:\\\/\\\/andreas-hubel.de\\\/en\\\/wp-json\\\/podlove-web-player\\\/shortcode\\\/publisher\\\/33\",\"data\":{\"version\":5,\"show\":{\"title\":\"andreas-hubel.de\",\"subtitle\":\"(Podcast ohne Namen)\",\"summary\":\"Verschiedene Experimente, die anderswo keinen Platz haben.\",\"poster\":\"https:\\\/\\\/andreas-hubel.de\\\/wp-content\\\/cache\\\/podlove\\\/41\\\/95394c7e71de557db4d2cf6ffdeab3\\\/andreas-hubel-de_500x.png\",\"link\":\"https:\\\/\\\/andreas-hubel.de\\\/en\"},\"title\":\"Datenbankstrukturen\",\"subtitle\":\"\",\"summary\":\"\",\"publicationDate\":\"2017-07-02T22:39:37+02:00\",\"duration\":\"00:55:50.178\",\"poster\":\"https:\\\/\\\/andreas-hubel.de\\\/wp-content\\\/cache\\\/podlove\\\/41\\\/95394c7e71de557db4d2cf6ffdeab3\\\/andreas-hubel-de_500x.png\",\"link\":\"https:\\\/\\\/andreas-hubel.de\\\/en\\\/datenbankstrukturen\\\/\",\"chapters\":[{\"start\":\"00:00:00.000\",\"title\":\"Anfang\",\"href\":\"\",\"image\":\"\"},{\"start\":\"00:02:16.305\",\"title\":\"Use Case Beschreibung\",\"href\":\"\",\"image\":\"\"},{\"start\":\"00:07:45.954\",\"title\":\"Relationale Datenbanken\\\/SQL\",\"href\":\"\",\"image\":\"\"},{\"start\":\"00:13:41.424\",\"title\":\"NoSQL Datenbanken\",\"href\":\"\",\"image\":\"\"},{\"start\":\"00:25:02.890\",\"title\":\"Mischformen: Postgres\",\"href\":\"\",\"image\":\"\"},{\"start\":\"00:27:22.319\",\"title\":\"Graphendatenbanken\",\"href\":\"\",\"image\":\"\"},{\"start\":\"00:30:57.165\",\"title\":\"RDF\",\"href\":\"\",\"image\":\"\"},{\"start\":\"00:34:03.646\",\"title\":\"Wikidata ist wie Openstreetmap: Es gibt nicht eine Datenbank auf der alles l\\u00e4uft\",\"href\":\"\",\"image\":\"\"},{\"start\":\"00:40:04.597\",\"title\":\"RDF ist aber auch wie Unicode\",\"href\":\"\",\"image\":\"\"},{\"start\":\"00:41:06.170\",\"title\":\"Zusammenfassung\",\"href\":\"\",\"image\":\"\"},{\"start\":\"00:41:25.022\",\"title\":\"SparQL Endpoints\",\"href\":\"\",\"image\":\"\"},{\"start\":\"00:44:46.328\",\"title\":\"Ontologien\",\"href\":\"\",\"image\":\"\"},{\"start\":\"00:46:39.113\",\"title\":\"Zur\\u00fcck zur Motorraddatenbank ;-)\",\"href\":\"\",\"image\":\"\"}],\"audio\":[{\"url\":\"https:\\\/\\\/andreas-hubel.de\\\/podlove\\\/file\\\/33\\\/s\\\/webplayer\\\/c\\\/website\\\/datenbankstrukturen.mp3\",\"size\":\"53603264\",\"title\":\"MP3 Audio (mp3)\",\"mimeType\":\"audio\\\/mpeg\"}],\"files\":[{\"url\":\"https:\\\/\\\/andreas-hubel.de\\\/podlove\\\/file\\\/33\\\/s\\\/webplayer\\\/datenbankstrukturen.mp3\",\"size\":\"53603264\",\"title\":\"MP3 Audio\",\"mimeType\":\"audio\\\/mpeg\"}],\"contributors\":[{\"id\":\"1\",\"name\":\"Andi\",\"avatar\":\"https:\\\/\\\/0.gravatar.com\\\/avatar\\\/401e93791a9daaa2480a96b693cfc1117cc855be520874f64cba95b8ad469c79?s=150&d=mp&r=g\",\"role\":null,\"group\":null,\"comment\":null},{\"id\":\"2\",\"name\":\"Thomas\",\"avatar\":\"https:\\\/\\\/andreas-hubel.de\\\/wp-content\\\/cache\\\/podlove\\\/60\\\/44b724c8fa6968e78cfdb72f182b6e\\\/thomas_150x150.jpg\",\"role\":null,\"group\":null,\"comment\":null}]}}, {\"url\":\"https:\\\/\\\/andreas-hubel.de\\\/en\\\/wp-json\\\/podlove-web-player\\\/shortcode\\\/config\\\/default\\\/theme\\\/default\",\"data\":{\"activeTab\":\"chapters\",\"subscribe-button\":null,\"share\":{\"channels\":[\"facebook\",\"twitter\",\"whats-app\",\"linkedin\",\"pinterest\",\"xing\",\"mail\",\"link\"],\"outlet\":\"https:\\\/\\\/andreas-hubel.de\\\/wp-content\\\/plugins\\\/podlove-web-player\\\/web-player\\\/share.html\",\"sharePlaytime\":true},\"related-episodes\":{\"source\":\"disabled\",\"value\":null},\"version\":5,\"theme\":{\"tokens\":{\"brand\":\"#E64415\",\"brandDark\":\"#235973\",\"brandDarkest\":\"#1A3A4A\",\"brandLightest\":\"#E9F1F5\",\"shadeDark\":\"#807E7C\",\"shadeBase\":\"#807E7C\",\"contrast\":\"#000\",\"alt\":\"#fff\"},\"fonts\":{\"ci\":{\"name\":\"ci\",\"family\":[\"-apple-system\",\"BlinkMacSystemFont\",\"Segoe UI\",\"Roboto\",\"Helvetica\",\"Arial\",\"sans-serif\",\"Apple Color Emoji\",\"Segoe UI Emoji\\\", \\\"Segoe UI Symbol\"],\"src\":[],\"weight\":800},\"regular\":{\"name\":\"regular\",\"family\":[\"-apple-system\",\"BlinkMacSystemFont\",\"Segoe UI\",\"Roboto\",\"Helvetica\",\"Arial\",\"sans-serif\",\"Apple Color Emoji\",\"Segoe UI Emoji\\\", \\\"Segoe UI Symbol\"],\"src\":[],\"weight\":300},\"bold\":{\"name\":\"bold\",\"family\":[\"-apple-system\",\"BlinkMacSystemFont\",\"Segoe UI\",\"Roboto\",\"Helvetica\",\"Arial\",\"sans-serif\",\"Apple Color Emoji\",\"Segoe UI Emoji\\\", \\\"Segoe UI Symbol\"],\"src\":[],\"weight\":700}}},\"base\":\"https:\\\/\\\/andreas-hubel.de\\\/wp-content\\\/plugins\\\/podlove-web-player\\\/web-player\\\/\"}}]);\n                podlovePlayer(player, \"https:\/\/andreas-hubel.de\/en\/wp-json\/podlove-web-player\/shortcode\/publisher\/33\", \"https:\/\/andreas-hubel.de\/en\/wp-json\/podlove-web-player\/shortcode\/config\/default\/theme\/default\").then(function() {\n                  player && player.classList.remove(\"podlove-web-player-loading\");\n                });\n              });\n            <\/script>\n            <style>\n              .podlove-web-player.podlove-web-player-loading {\n                opacity: 0;\n              }\n            <\/style>\n        \n\n\n    \n\n\t<div class=\"podlove-contributors-cards\">\n\t\t\t\t\t\n\t\t\t\t<div class=\"podlove-contributors-card\">\n\t\t\t\t\t<div class=\"podlove-contributors-card-inner\">\n\t\t\t\t\t\t<div class=\"podlove-contributors-card-avatar\">\n\t\t\t\t\t\t\t\n<img loading=\"lazy\" decoding=\"async\" alt=\"avatar\" width=\"50\" height=\"50\" src=\"https:\/\/0.gravatar.com\/avatar\/401e93791a9daaa2480a96b693cfc1117cc855be520874f64cba95b8ad469c79?s=50&amp;d=mp&amp;r=g\" srcset=\"https:\/\/0.gravatar.com\/avatar\/401e93791a9daaa2480a96b693cfc1117cc855be520874f64cba95b8ad469c79?s=50&amp;d=mp&amp;r=g 1x, https:\/\/0.gravatar.com\/avatar\/401e93791a9daaa2480a96b693cfc1117cc855be520874f64cba95b8ad469c79?s=100&amp;d=mp&amp;r=g 2x, https:\/\/0.gravatar.com\/avatar\/401e93791a9daaa2480a96b693cfc1117cc855be520874f64cba95b8ad469c79?s=150&amp;d=mp&amp;r=g 3x\"\/>\n\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"podlove-contributors-card-person\">\n\t\t\t\t\t\t\t<div style=\"align-self: center\">\n\t\t\t\t\t\t\t\t<div style=\"font-weight: 400;\">Andi<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"podlove-contributors-card-services\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"podlove-contributors-card-services-service\" target=\"_blank\" title=\"Mastodon\" href=\"https:\/\/chaos.social\/@saerdnaer\">\n\t\t\t\t\t\t\t\t\t\t\n<img decoding=\"async\" alt=\"Mastodon Icon\" width=\"20\" src=\"https:\/\/andreas-hubel.de\/wp-content\/cache\/podlove\/ee\/02337cfe3979ca6b330d64b91b708f\/mastodon_20x.png\" srcset=\"https:\/\/andreas-hubel.de\/wp-content\/cache\/podlove\/ee\/02337cfe3979ca6b330d64b91b708f\/mastodon_20x.png 1x, https:\/\/andreas-hubel.de\/wp-content\/cache\/podlove\/ee\/02337cfe3979ca6b330d64b91b708f\/mastodon_40x.png 2x, https:\/\/andreas-hubel.de\/wp-content\/cache\/podlove\/ee\/02337cfe3979ca6b330d64b91b708f\/mastodon_60x.png 3x\"\/>\n\n\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"podlove-contributors-card-services-service\" target=\"_blank\" title=\"Twitter\" href=\"https:\/\/twitter.com\/saerdnaer\">\n\t\t\t\t\t\t\t\t\t\t\n<img decoding=\"async\" alt=\"Twitter Icon\" width=\"20\" src=\"https:\/\/andreas-hubel.de\/wp-content\/cache\/podlove\/54\/af4182a5d48f63531926f9266a9a29\/twitter_20x.png\" srcset=\"https:\/\/andreas-hubel.de\/wp-content\/cache\/podlove\/54\/af4182a5d48f63531926f9266a9a29\/twitter_20x.png 1x, https:\/\/andreas-hubel.de\/wp-content\/cache\/podlove\/54\/af4182a5d48f63531926f9266a9a29\/twitter_40x.png 2x, https:\/\/andreas-hubel.de\/wp-content\/cache\/podlove\/54\/af4182a5d48f63531926f9266a9a29\/twitter_60x.png 3x\"\/>\n\n\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\n\t\t\t\t<div class=\"podlove-contributors-card\">\n\t\t\t\t\t<div class=\"podlove-contributors-card-inner\">\n\t\t\t\t\t\t<div class=\"podlove-contributors-card-avatar\">\n\t\t\t\t\t\t\t\n<img loading=\"lazy\" decoding=\"async\" alt=\"avatar\" width=\"50\" height=\"50\" src=\"https:\/\/andreas-hubel.de\/wp-content\/cache\/podlove\/60\/44b724c8fa6968e78cfdb72f182b6e\/thomas_50x50.jpg\" srcset=\"https:\/\/andreas-hubel.de\/wp-content\/cache\/podlove\/60\/44b724c8fa6968e78cfdb72f182b6e\/thomas_50x50.jpg 1x, https:\/\/andreas-hubel.de\/wp-content\/cache\/podlove\/60\/44b724c8fa6968e78cfdb72f182b6e\/thomas_100x.jpg 2x, https:\/\/andreas-hubel.de\/wp-content\/cache\/podlove\/60\/44b724c8fa6968e78cfdb72f182b6e\/thomas_150x.jpg 3x\"\/>\n\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"podlove-contributors-card-person\">\n\t\t\t\t\t\t\t<div style=\"align-self: center\">\n\t\t\t\t\t\t\t\t<div style=\"font-weight: 400;\">Thomas<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"podlove-contributors-card-services\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"podlove-contributors-card-services-service\" target=\"_blank\" title=\"Twitter\" href=\"https:\/\/twitter.com\/thomersch\">\n\t\t\t\t\t\t\t\t\t\t\n<img decoding=\"async\" alt=\"Twitter Icon\" width=\"20\" src=\"https:\/\/andreas-hubel.de\/wp-content\/cache\/podlove\/54\/af4182a5d48f63531926f9266a9a29\/twitter_20x.png\" srcset=\"https:\/\/andreas-hubel.de\/wp-content\/cache\/podlove\/54\/af4182a5d48f63531926f9266a9a29\/twitter_20x.png 1x, https:\/\/andreas-hubel.de\/wp-content\/cache\/podlove\/54\/af4182a5d48f63531926f9266a9a29\/twitter_40x.png 2x, https:\/\/andreas-hubel.de\/wp-content\/cache\/podlove\/54\/af4182a5d48f63531926f9266a9a29\/twitter_60x.png 3x\"\/>\n\n\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\n\t\t\t\t\t\t<\/div>\n\n\t<style>\n\t\t.podlove-contributors-cards {\n\t\t\tmargin-bottom: 1rem;\n\t\t\tbackground: white;\n\t\t\toverflow: hidden;\n\t\t\tborder-radius: 0.375rem;\n\t\t\tbox-shadow: 0 1px 3px 0 rgba(0, 0, 0, 0.1), 0 1px 2px 0 rgba(0, 0, 0, 0.06);\n\t\t}\n\t\t.podlove-contributors-card {\n\t\t\tdisplay: flex;\n\t\t\talign-items: center;\n\t\t\tpadding: 1rem 1.5rem\n\t\t}\n\t\t.podlove-contributors-card-inner {\n\t\t\tdisplay: flex;\n\t\t\talign-items: center;\n\t\t\tflex: 1 1 0;\n\t\t\tmin-width: 0;\n\t\t}\n\t\t.podlove-contributors-card-avatar {\n\t\t\twidth: 50px;\n\t\t\theight: 50px;\n\t\t\tborder-radius: 0.25rem;\n\t\t\toverflow: hidden;\n\t\t\tflex-shrink: 0;\n\t\t}\n\t\t.podlove-contributors-card-person {\n\t\t\tflex: 1 1 0;\n\t\t\tmin-width: 0;\n\t\t\tpadding: 0 1rem;\n\t\t\tdisplay: grid;\n\t\t\tgrid-template-columns: repeat(2, minmax(0, 1fr));\n\t\t\tgap: 1rem;\n\t\t}\n\t\t.podlove-contributors-card-person-details {\n\t\t\tcolor: #999\n\t\t}\n\t\t.podlove-contributors-card-services {\n\t\t\tflex-wrap: wrap;\n\t\t\tdisplay: flex;\n\t\t\talign-items: center;\n\t\t\talign-content: center;\n\t\t\tjustify-content: flex-end;\n\t\t}\n\t\t.podlove-contributors-card-services-service {\n\t\t\tdisplay: inline-block;\n\t\t\tflex-shrink: 0;\n\t\t\tpadding-left: 0.5rem;\n\t\t\ttext-decoration: none;\n\t\t\tbox-shadow: none;\n\t\t}\n\t<\/style>\n\n\n<p>In <a href=\"http:\/\/mikrowelle.me\/051.html#t=00:30:20\">Mikrowelle 51<\/a> wurde\u00a0f\u00e4lschlicherweise behauptet <em>&#8220;unter Wikidata liegt RDF&#8221;<\/em> \u2013 was <a href=\"https:\/\/twitter.com\/saerdnaer\/status\/762241481226739712\">folgenden Tweet<\/a> meinerseits ausl\u00f6ste:<\/p>\n<blockquote><p>@thomersch Ich glaube du hast das mit dem Semantic Web noch nicht so ganz [richtig] verstanden\u2026 Podcast-Idee: Wir unterhalten uns \u00fcber das Thema.<\/p><\/blockquote>\n<p>Auf der FOSSGIS 2017 haben wir das Thema wieder aufgegriffen: Dabei wir zum Schluss gekommen sind, dass wir eigentlich\u00a0noch ein paar Stufen vorher anfangen m\u00fcssen, bevor sich erkl\u00e4ren l\u00e4sst was an dieser Aussage genau falsch ist.<\/p>\n<p><strong>TL;DR:<\/strong> Wikidata ist eine Sammlung aus versionierten JSON-Dokumenten, aus denen dann Graphen (RDF) in verschiedenen Geschmacksrichtungen generiert werden. Die JSON Dokumente liegen in Maria DB, die Graphen liegen als RDF in\u00a0blazegraph und k\u00f6nnen dort mit der standardisierten\u00a0Abfragesprache SparQL abgerufen werden.<\/p>\n<p>Wer jetzt nur Bahnhof versteht, dem hilft unser Gespr\u00e4ch vielleicht weiter. Wir haben uns implizit daf\u00fcr entschieden das Thema wie folgt anzugehen:<\/p>\n<ul style=\"margin-left: 3em;\">\n<li>Relationale Datenbanken [00:07:45]\n<ul>\n<li>Tabellen:\u00a0SQLite, MySQL\u00a0bzw.\u00a0MariaDB, Postgres<\/li>\n<\/ul>\n<\/li>\n<li>NoSQL [<span class=\"chaptermark-start\">00:13:41]<\/span>\n<ul>\n<li>Dokumente: Mongo DB, Couch DB<\/li>\n<li>Spalten: Cassandra, DynamoDB<\/li>\n<\/ul>\n<\/li>\n<li>Mischformen bei Postgres: hstore, jsonb [<span class=\"chaptermark-start\">00:25:02]<\/span><\/li>\n<li>Graphen-Datenbanken:\u00a0Neo4J,\u00a0blazegraph [<span class=\"chaptermark-start\">00:27:22<\/span>]<\/li>\n<li>Wikidata-Datenmodell [<span class=\"chaptermark-start\">00:34:03]<\/span><\/li>\n<li>RDF, SPARQL [<span class=\"chaptermark-start\">00:40:04]<\/span><\/li>\n<\/ul>\n<p><!--more--><\/p>\n<p>Beispiele aus der Folge:<\/p>\n<p><!-- ER Diagram Motorr\u00e4der? --><\/p>\n<p>Abfragesprachen<\/p>\n<ul style=\"margin-left: 3em;\">\n<li>SQL:\u00a0<code>SELECT m.*, h.* FROM modelle m, hersteller h WHERE m.sitzhoehe &gt; 90<\/code><\/li>\n<li><code><\/code>SPARQL (bei Wikidata): <code>SELECT * WHERE { ?item wdt:P31 wd:Q146 . }<\/code><\/li>\n<\/ul>\n<p>Mit RDF\u00a0lassen sich\u00a0Graphen aus Knoten und gerichteten Kanten abbilden. Eine solche Verbindung zwischen Start-Knoten, Kante und Ziel-Knoten wird als Triple bezeichnet. Oft bezeichnet man den Start-Knoten auch\u00a0Subjekt, die Kante als Pr\u00e4dikat und den Ziel-Knoten als Objekt. RDF selbst definiert dabei noch nicht wie diese Informationen als Datei\u00a0gespeichert\u00a0werden \u2013 Das ist ein bisschen so wie das Verh\u00e4ltnis zwischen Unicode und UTF8 oder UTF16: Ersteres definiert einfach nur das Konzept und wei\u00dft jedem Zeichen eine Zahl zu, UTF8 definiert dann eine Darstellung dieser Zahl mit Standard-L\u00e4nge 8bit, UTF16\u00a0eine Darstellung mit Standard-L\u00e4nge 16bit. So gibt es bei RDF eine Darstellung\u00a0in Text, XML, JSON oder welches Format sonst grade in Mode ist.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37 size-full\" src=\"http:\/\/andreas-hubel.de\/wp-content\/uploads\/sites\/4\/2017\/05\/Wikidata_Datamodel.png\" alt=\"\" width=\"800\" height=\"575\" srcset=\"https:\/\/andreas-hubel.de\/wp-content\/uploads\/sites\/4\/2017\/05\/Wikidata_Datamodel.png 800w, https:\/\/andreas-hubel.de\/wp-content\/uploads\/sites\/4\/2017\/05\/Wikidata_Datamodel-300x216.png 300w, https:\/\/andreas-hubel.de\/wp-content\/uploads\/sites\/4\/2017\/05\/Wikidata_Datamodel-768x552.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/>https:\/\/commons.wikimedia.org\/wiki\/File:Datamodel_in_Wikidata.svg<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-41\" src=\"http:\/\/andreas-hubel.de\/wp-content\/uploads\/sites\/4\/2017\/05\/Ontschichten.gif\" alt=\"\" width=\"796\" height=\"1125\" \/>https:\/\/de.wikipedia.org\/wiki\/Datei:Ontschichten.gif<\/p>\n<p>&nbsp;<\/p>\n<h3>Links<\/h3>\n<ul style=\"margin-left: 3em;\">\n<li>Mit offenen Karten 10.09.2016 | Kartographische Revolution\n<ul>\n<li><a href=\"https:\/\/www.youtube.com\/watch?v=ApaUGlxsWvg\">https:\/\/www.youtube.com\/watch?v=ApaUGlxsWvg<\/a><\/li>\n<li><a href=\"http:\/\/ddc.arte.tv\/zur-das-thema\/kartografische-revolution\">http:\/\/ddc.arte.tv\/zur-das-thema\/kartografische-revolution<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","template":"","meta":{"activitypub_content_warning":"","activitypub_content_visibility":"","activitypub_max_image_attachments":4,"activitypub_interaction_policy_quote":"anyone","activitypub_status":"","footnotes":"","atmosphere_disabled":false,"atmosphere_custom_text":"","atmosphere_reply_restriction":[]},"categories":[],"tags":[],"class_list":["post-33","podcast","type-podcast","status-publish","hentry","post"],"_links":{"self":[{"href":"https:\/\/andreas-hubel.de\/en\/wp-json\/wp\/v2\/episodes\/33","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/andreas-hubel.de\/en\/wp-json\/wp\/v2\/episodes"}],"about":[{"href":"https:\/\/andreas-hubel.de\/en\/wp-json\/wp\/v2\/types\/podcast"}],"author":[{"embeddable":true,"href":"https:\/\/andreas-hubel.de\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/andreas-hubel.de\/en\/wp-json\/wp\/v2\/comments?post=33"}],"version-history":[{"count":16,"href":"https:\/\/andreas-hubel.de\/en\/wp-json\/wp\/v2\/episodes\/33\/revisions"}],"predecessor-version":[{"id":244,"href":"https:\/\/andreas-hubel.de\/en\/wp-json\/wp\/v2\/episodes\/33\/revisions\/244"}],"wp:attachment":[{"href":"https:\/\/andreas-hubel.de\/en\/wp-json\/wp\/v2\/media?parent=33"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/andreas-hubel.de\/en\/wp-json\/wp\/v2\/categories?post=33"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/andreas-hubel.de\/en\/wp-json\/wp\/v2\/tags?post=33"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}