Using BlobCity with diverse data models

The BlobCity database is a multi-model system. By this we mean the database natively stores and processes multiple data formats. Most databases are able to store and process data in a single format, they may take multiple formats of imports and are able to support multiple formats of export, but the data processing / querying is possible only in a single data format.

The BlobCity database is known for its speciality of being able to store and process multiple data types. This means once can store XML and JSON in a single datastore and fire a single SQL query that scans through XML and JSON records as if they were a homogeneous dataset.

Data TypeDescription
JSONJSON is an open standard format that uses human-readable text to transmit data
objects consistent of attribute-value pairs.

http://www.json.org
XMLExtensible Markup Language (XML) is a markup language that defines a set of
rules for encoding documents in a format that is both humanly readable and
machine readable.


http://www.w3.org/XML/
CSVcomma-separated values (CSV) file stores tabular data (numbers and text) in plain
text. Each line of the file is a data record. Each record consists of one or more fields, separated by commas. The use of the comma as a field separator is the source of the name for this file format.

https://en.wikipedia.org/wiki/Comma-separated_values
SQLStructured Query Language (SQL) is a special purpose programming language
designed for managing data held in a relational database management system
(RDBMS), or for stream processing in a relational data stream management system
(RDSMS).


https://en.wikipedia.org/wiki/SQL
Plain TextPlain text is the data (e.g. file contents) that represent only characters of readable
material but not its graphical representation nor other objects (images, etc.). It may
also include a limited number of characters that control simple arrangement of
text, such as line breaks or tabulation characters. Plain text is different from
formatted text, where style information is included, and from "binary files" in which
some portions must be interpreted as binary objects (encoded integers, real
numbers, images, etc.)

https://en.wikipedia.org/wiki/Plain_text
PDFThe Portable Document Format (PDF) is a file format developed by Adobe in the 1990s to present documents, including text formatting and images, in a manner independent of application software, hardware, and operating systems.

https://en.wikipedia.org/wiki/PDF
ExcelMicrosoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.

https://en.wikipedia.org/wiki/Microsoft_Excel
WordMicrosoft Word (or simply Word) is a word processor developed by Microsoft. It was first released on October 25, 1983[5] under the name Multi-Tool Word for Xenix systems.

https://en.wikipedia.org/wiki/Microsoft_Word
RTFThe Rich Text Format (often abbreviated RTF) is a proprietary[6][7][8] document file format with published specification developed by Microsoft Corporation from 1987 until 2008 for cross-platform document interchange with Microsoft products. Prior to 2008, Microsoft published updated specifications for RTF with major revisions of Microsoft Word and Office versions.

https://en.wikipedia.org/wiki/Rich_Text_Format
ZIPZIP is an archive file format that supports lossless data compression. A ZIP file may contain one or more files or directories that may have been compressed.

https://en.wikipedia.org/wiki/Zip_(file_format)
LOGIn computing, a log file is a file that records either events that occur in an operating system or other software runs, or messages between different users of a communication software.

https://en.wikipedia.org/wiki/Log_file
PowerpointMicrosoft PowerPoint (or simply PowerPoint) is a presentation program,[5] created by Robert Gaskins and Dennis Austin[5] at a software company named Forethought, Inc.

https://en.wikipedia.org/wiki/Microsoft_PowerPoint
syslogIn computing, syslog is a standard for message logging. It allows separation of the software that generates messages, the system that stores them, and the software that reports and analyzes them. Each message is labeled with a facility code, indicating the software type generating the message, and assigned a severity level.

https://en.wikipedia.org/wiki/Syslog
Audio FilesAn audio file format is a file format for storing digital audio data on a computer system. BlobCity DB currently supports MP3 files.

https://en.wikipedia.org/wiki/Audio_file_format
Video FilesA video file format is a type of file format for storing digital video data on a computer system. BlobCity DB currently supports M4V and AVI.

https://en.wikipedia.org/wiki/Video_file_format
Image FilesImage file formats are standardized means of organizing and storing digital images. BlobCity DB currently supports PNG & JPEG file formats.

https://en.wikipedia.org/wiki/Image_file_formats
GISA GIS file format is a standard of encoding geographical information into a computer file. They are created mainly by government mapping agencies (such as the USGS or National Geospatial-Intelligence Agency) or by GIS software developers.

https://en.wikipedia.org/wiki/GIS_file_formats