dataStore和数据库之间有什么区别?

时间:2022-10-13 15:51:00

I’m in the process of setting up a CKAN instance. I have to setup a postgres database for CKAN to be operated. Additionally I have to set up a dataStore too.

我正在设置CKAN实例。我必须为CKAN设置一个postgres数据库才能运行。另外,我还要设置一个dataStore。

I found this question on * but didn’t answer my question.

我在*上发现了这个问题,但没有回答我的问题。

How to think in data stores instead of databases?

如何在数据存储而不是数据库中思考?

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

一般来说,dataStore和数据库之间有什么区别?

3 个解决方案

#1


4  

CKAN uses two PostgreSQL databases:

CKAN使用两个PostgreSQL数据库:

  1. CKAN's catalogue database, this is the first database that you're asked to configure when installing CKAN. This stores all the data for CKAN's data catalogue, e.g. the metadata associated with datasets and resources (titles, tags, etc.), the user accounts, the groups and organizations, etc. etc.

    CKAN的目录数据库,这是您在安装CKAN时要求配置的第一个数据库。这存储了CKAN数据目录的所有数据,例如与数据集和资源(标题,标签等),用户帐户,组和组织等相关联的元数据等。

  2. CKAN's DataStore is an optional feature that enables a Data API and data previews for files uploaded to or linked to from CKAN. This is a second PostgresSQL database, data*store* is just the name the CKAN uses for this feature. (The DataStore in CKAN has nothing to do with the Google App Engine concept of data store that you linked to.)

    CKAN的DataStore是一项可选功能,可为从CKAN上传或链接的文件启用数据API和数据预览。这是第二个PostgresSQL数据库,data * store *只是CKAN用于此功能的名称。 (CKAN中的DataStore与您链接到的数据存储的Google App Engine概念无关。)

CKAN also has a FileStore which, if enabled, is used to store files uploaded to CKAN. The FileStore isn't really a database, it's just a directory on disk that stores uploaded files.

CKAN还有一个FileStore,如果启用,它用于存储上传到CKAN的文件。 FileStore实际上不是一个数据库,它只是磁盘上存储上传文件的目录。

#2


2  

To me it's two words for the same thing.

对我来说,这是同一件事的两个字。

Though, admittedly, I mostly hear or read the term coming out of nosql users. If we accept nosql store as the definition, it's a column-oriented store -- as opposed to a row-oriented one.

虽然,不可否认,我大多听到或读到了来自nosql用户的术语。如果我们接受nosql store作为定义,它就是一个面向列的存储 - 而不是面向行的存储。

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

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

#3


1  

Arriving a little bit late...

到达有点晚了...

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

我将数据库视为一种特殊类型的数据存储区。顾名思义,数据存储区是存储数据的地方。

You can store data in a hard disk using a file storage system (e.g., ext4 in Linux) or in a database (e.g., PostgreSQL), in which the data are stored in files, but those files are managed by the database management system (access permissions, uniqueness of keys and etc.).

您可以使用文件存储系统(例如,Linux中的ext4)或数据库(例如PostgreSQL)将数据存储在硬盘中,其中数据存储在文件中,但这些文件由数据库管理系统管理(访问权限,密钥的唯一性等)。

NoSQL databases usually don't have a builtin manager, so the management is done in the application level. You may see them as just a storage system.

NoSQL数据库通常没有内置管理器,因此管理是在应用程序级别完成的。您可能会将它们视为存储系统。

#1


4  

CKAN uses two PostgreSQL databases:

CKAN使用两个PostgreSQL数据库:

  1. CKAN's catalogue database, this is the first database that you're asked to configure when installing CKAN. This stores all the data for CKAN's data catalogue, e.g. the metadata associated with datasets and resources (titles, tags, etc.), the user accounts, the groups and organizations, etc. etc.

    CKAN的目录数据库,这是您在安装CKAN时要求配置的第一个数据库。这存储了CKAN数据目录的所有数据,例如与数据集和资源(标题,标签等),用户帐户,组和组织等相关联的元数据等。

  2. CKAN's DataStore is an optional feature that enables a Data API and data previews for files uploaded to or linked to from CKAN. This is a second PostgresSQL database, data*store* is just the name the CKAN uses for this feature. (The DataStore in CKAN has nothing to do with the Google App Engine concept of data store that you linked to.)

    CKAN的DataStore是一项可选功能,可为从CKAN上传或链接的文件启用数据API和数据预览。这是第二个PostgresSQL数据库,data * store *只是CKAN用于此功能的名称。 (CKAN中的DataStore与您链接到的数据存储的Google App Engine概念无关。)

CKAN also has a FileStore which, if enabled, is used to store files uploaded to CKAN. The FileStore isn't really a database, it's just a directory on disk that stores uploaded files.

CKAN还有一个FileStore,如果启用,它用于存储上传到CKAN的文件。 FileStore实际上不是一个数据库,它只是磁盘上存储上传文件的目录。

#2


2  

To me it's two words for the same thing.

对我来说,这是同一件事的两个字。

Though, admittedly, I mostly hear or read the term coming out of nosql users. If we accept nosql store as the definition, it's a column-oriented store -- as opposed to a row-oriented one.

虽然,不可否认,我大多听到或读到了来自nosql用户的术语。如果我们接受nosql store作为定义,它就是一个面向列的存储 - 而不是面向行的存储。

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

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

#3


1  

Arriving a little bit late...

到达有点晚了...

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

我将数据库视为一种特殊类型的数据存储区。顾名思义,数据存储区是存储数据的地方。

You can store data in a hard disk using a file storage system (e.g., ext4 in Linux) or in a database (e.g., PostgreSQL), in which the data are stored in files, but those files are managed by the database management system (access permissions, uniqueness of keys and etc.).

您可以使用文件存储系统(例如,Linux中的ext4)或数据库(例如PostgreSQL)将数据存储在硬盘中,其中数据存储在文件中,但这些文件由数据库管理系统管理(访问权限,密钥的唯一性等)。

NoSQL databases usually don't have a builtin manager, so the management is done in the application level. You may see them as just a storage system.

NoSQL数据库通常没有内置管理器,因此管理是在应用程序级别完成的。您可能会将它们视为存储系统。