SynDB

From XionKB
Revision as of 05:55, 29 January 2024 by Alexander (talk | contribs) (Created page with "'''SynDB''' is a database schematic for light data rich hypermedia syndication. ==Schemas== ===Canonical schemas=== These schemas contain raw media data in a singular canonical format. These formats serve as master copies from which processed "composite" media formats can be created for various purposes and the constraints thereof. {| class="wikitable" |+ Raster images |- ! Field ! Type ! Description |- | style="background-color:rgba(192,248,192,0.5)" | <tt>id</tt>...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

SynDB is a database schematic for light data rich hypermedia syndication.

Schemas

Canonical schemas

These schemas contain raw media data in a singular canonical format. These formats serve as master copies from which processed "composite" media formats can be created for various purposes and the constraints thereof.

Raster images
Field Type Description
id u64 ID of the raster image.
w u64 Width of image minus one, in pels.[1]
h u64 Height of image minus one, in pels.[1]
colspace enum : u4 Colour space in use.[2]
data blob Data payload, using the given colour space as its ABI.
Vector images
Field Type Description
id u64 ID of the vector image.
w u64 Nominal width of image minus one, in pels.[1]
h u64 Nominal height of image minus one, in pels.[1]
data blob Data payload, using the PackVector format as its ABI.
Motion pictures
Field Type Description
id u64 ID of the motion picture.
w u32 Width of motion picture minus one, in pels.[3]
h u32 Height of motion picture minus one, in pels.[3]
data blob Motion picture payload, stored as HEVC Main 10 Profile lossless in AVCC container format (MPEG-4 Part 15).
Waveform audio
Field Type Description
id u64 ID of the waveform.
rate u32 Sample rate of the waveform, in hertz.
depth enum : u2 Bit depth of an audio sample.[4]
chcount u3 Channel count minus one, thereby allowing anywhere from 1 to 8 channels.
ttl u64 Total sample count.[5]
data blob Raw PCM waveform payload.
Text
Field Type Description
id u64 ID of the text.
encoding enum : u2 Content encoding of the text.[6]
data blob Data payload of the text, without any BOM.

Composite schemas

These schemas contain information particular to composite media formulations sourced from canonical "master copies" in tables following the schemas above. They are tailored to specific uses very close to the product level.

Animated images
Field Type Description
id u64 ID of the animated image.
loop bool Whether the animation loops infinitely or not at all.
count u32 Total number of frames in the animated image.
frames u64[] Ordered list of IDs to canonical raster images, constituting the animation frame list.
Web videos
Field Type Description
id u64 ID of the video.
video u64 ID of the canonical motion picture data source.
audio u64 ID of the canonical waveform data source.
subs u64 | nil ID of the canonical text data, interpreted as SRT format subtitles. Optional.

References

  1. 1.0 1.1 1.2 1.3 Allows for a range of 1 to 18,446,744,073,709,551,616 pels.
  2. Can be one of GRAY1=0, GRAY2=1, GRAY4=2, GRAY8=3, GRAY16=4, GRAY32=5, RGB332=6, RGBA4444=7, RGB565=8, RGBA5551=9, RGBA8888=10, RGBX1010102=11, RGBA16161616=12, YUV420=13, YUV422=14, or YUV444=15.
  3. 3.0 3.1 Allows for a range of 1 to 4,294,967,296 pels.
  4. Can be one of U8=0, U16LE=1, U24LE=2 or U32LE=3.
  5. This counts inter-channel samples, ergo 1 second of 44.1kHz audio is 44,100 samples regardless of the channel count.
  6. Can be one of ASCII=0, UTF8=1, UTF16LE=2, or UTF32LE=3.