关键词: PostgreSQL数据库, hstore数据类型, MongoDB数据库, 内嵌文档

Abstract: Traditional relational databases can hardly store or handle massive unstructured data generated by Internet technology development efficiently. Varieties of NoSQL databases are capable to deal with unstructured data, but are poor in dealing with relational calculation under certain circumstances. Some new relational databases provide efficient ways to store both unstructured and structured data in multiple environments. In order to compare the data storage and processing capabilities of relational database and document-oriented NoSQL database quantitatively, this paper compares the unstructured data storage methods between hstore in PostgreSQL and embedded document in MongoDB. Performance and applicability analysis are also made by comparing performance of bulk loading, disk footprint, query on primary key and geometry coordinates.

Key words: PostgreSQL, hstore, MongoDB, embedded document