Geek Answers Handbook

What is the difference between dataStore and database?

Im in the process of creating a CKAN instance. I need to configure the postgres database for CKAN. In addition, I also need to set up a data warehouse.

I found this question on stackoverflow but did not answer my question.

How to think in data warehouses instead of databases?

In general, what's the difference between a dataStore and a database?

+6
source share
3 answers

CKAN uses two PostgreSQL databases:

  • The CKAN directory database is the first database that you want to configure when installing CKAN. This saves all the data for the CKAN data directory, for example. metadata associated with data sets and resources (headers, tags, etc.), user accounts, groups and organizations, etc. etc.

  • CKAN DataStore is an optional feature that allows the data API and data preview for files uploaded or associated with CKAN. This is the second PostgresSQL database, data * store * is just the name that CKAN uses for this function. (The CKAN DataStore has nothing to do with the Google App Engine data warehouse concept you linked to.)

CKAN also has a FileStore , which, if enabled, is used to store files uploaded to CKAN. FileStore is not really a database, it's just a directory on the disk where the downloaded files are stored.

+4
source

For me, these are two words for the same thing.

Although, admittedly, I mostly hear or read the term coming from nosql users. If we take the nosql store as a definition, this is column-oriented storage, as opposed to row-oriented storage.

http://en.wikipedia.org/wiki/Column-oriented_DBMS

+2
source

Arrival a bit late ...

I see the database as a special type of data warehouse. The data warehouse, as the name indicates, is the place where the data is stored.

You can store data on your hard drive using a file storage system (for example, ext4 on Linux) or in a database (for example, PostgreSQL), in which data is stored in files, but these files are managed by a control system database (access permissions, unique keys etc.).

NoSQL databases usually do not have a built-in manager, so management is done at the application level. You can consider them as a storage system.

+1
source

More articles:


All Articles