...
GET /binary/full/!800,600/default.jpg
SELECT * FROM scaled_800x600 WHERE original_id = '' ......Handled by IIIF Image ServerSELECT mime FROM originals WHERE original_id = '' Brauchen wir nicht, da hier immer ein image/jpeg zurückkommt.
...
Originals (originals)
| Code Block |
|---|
use binaries; CREATE TABLE IF NOT EXISTS binaries.originals (original_id text, last_modified PRIMARY KEY,checksum text,created timestamp,e_tag text,height mime text, created int,last_checked timestamp, last_checkedmodified timestamptext, checksummime text, size bigint, status text, PRIMARY KEY(original_id))width int); |
| Column / Label | original_id | last_modified | e_tag | mime | created | last_checked | checksum | size | status | width | height |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Attribute | PRIMARY KEY, Partition Key | ||||||||||
| Data Type | text | text | text | text | timestamp | timestamp | text | bigint | text | int | int |
| Description | Last Modified Datum aus dem Response Header des Servers | E-Tag aus dem Response Header des Servers | Mime-Type des Binaries | Zeitstempel der den Zeitpunkt des Speicherns der Daten angibt. | Zeitstempel der angibt wann überprüft wurde ob die Daten auf dem Server sich geändert haben | Aus den Daten errechnete Prüfsumme | Größe des Binaries | Status des Download-Prozesses ( PROCESSING | OK | ERROR | RETRY ) | with of image | height of image |
URLs (urls)
| Code Block |
|---|
use binaries; CREATE TABLE IF NOT EXISTS urls (url text, original_id text, PRIMARY KEY(url)); CREATE MATERIALIZED VIEW urls_original AS SELECT original_id FROM urls WHERE url IS NOT NULL AND original_id IS NOT NULL PRIMARY KEY(original_id, url); |
...
| Column / Label | original_id | part | data |
|---|---|---|---|
| Attribute | PRIMARY KEY, Partition Key | PRIMARY KEY, Partition Key | |
| Data Type | text | int | blob |
| Description | Verweis auf die Id in der Originals-Tabelle | Chunk des Binaries | Content des Binary-Chunks |
Scaled images 800 (scaled_800x600) (obsolete)
| Code Block |
|---|
use binaries; CREATE TABLE IF NOT EXISTS scaled_800x600 (original_id text, data blob, PRIMARY KEY(original_id)); |
...
| Column / Label | original_id | data |
|---|---|---|
| Attribute | PRIMARY KEY, Partition Key | |
| Data Type | text | blob |
| Description | Verweis auf die Id in der Originals-Tabelle | das skalierte Bild |
Scaled images 140 (scaled_140x105) (obsolete)
| Code Block |
|---|
use binaries; CREATE TABLE IF NOT EXISTS scaled_140x105 (original_id text, data blob, PRIMARY KEY(original_id)); |
...
| Column / Label | original_id | data |
|---|---|---|
| Attribute | PRIMARY KEY, Partition Key | |
| Data Type | text | blob |
| Description | Verweis auf die Id in der Originals-Tabelle | das skalierte Bild |
Scaled images 116 (scaled_116x87) (obsolete)
| Code Block |
|---|
use binaries; CREATE TABLE IF NOT EXISTS scaled_116x87 (original_id text, data blob, PRIMARY KEY(original_id)); |
...
| Column / Label | original_id | data |
|---|---|---|
| Attribute | PRIMARY KEY, Partition Key | |
| Data Type | text | blob |
| Description | Verweis auf die Id in der Originals-Tabelle | das skalierte Bild |
Scaled images 440 (scaled_440x330) (obsolete)
| Code Block |
|---|
use binaries; CREATE TABLE IF NOT EXISTS scaled_440x330 (original_id text, data blob, PRIMARY KEY(original_id)); |
...