search

TileDB-Inc / TileDB-MariaDB

MyTile is a MariaDB storage engine for accessing TileDB arrays
MIT License
29 stars 6 forks source link

Is it possible to use the MD saved in TDB as a row in a large MD table? #197

Open JosephBizu opened 2 years ago

JosephBizu commented 2 years ago

HI, I have read the documentation of the library, and as far as I understand, you can easily query the MD in each TDB created and treat the MD as a MySQL DB (MariaDB). However, I couldn't quite figure out whether I can treat all the TDB items as a whole table. Meaning, each TDB MD is a row that belongs to one large table that I am able to query over ( meaning the table is a MariaDB). For example, each TDB holds a geospatial location polygon, and I can query TDB objects over geospatial polygon like I would do with PostgreSQL for instance.

Hope my question is clear enough.

Shelnutt2 commented 2 years ago

Hello @JosephBizu! If I understand your question correctly, you are currently creating separate TileDB arrays for each of your polygon. You are then wanting to query all the separate TileDB arrays as one single MariaDB Table?

If I understood that correctly, then the most common way users handle this is to actually have one TileDB array with all the polygons. There is usually a dimensions with an identified. This lets you efficiently have all the data in the single array and allows you to query it as you are looking to in MariaDB.

If you are able to share your current array schema and more details about the Polygons and your use case or queries you are looking to perform we'd be happy to provide some suggestions to adjusting the schema. If you do not want to share those details here please feel free to also send me an email, seth@tiledb.com and we can discuss over email.