LEADER 04112cam 2200505Ii 4500001 on1113942233 003 OCoLC 005 20200203095925.0 006 m o d 007 cr unu|||||||| 008 190827s2019 ncua obm 000 0 eng d 035 (Sirsi) o1113942233 035 (OCoLC)1113942233 040 ERE |beng |erda |cERE |dOCLCO |dERE |dUtOrBLW 049 EREE 090 QA76.9.D3 100 1 Khanal, Rabindra, |eauthor. |=^A1395492 245 10 PostgreSQL as a multi-model database / |cby Rabindra Khanal. 264 1 [Greenville, N.C.] : |b[East Carolina University], |c2019. 300 74 pages : |bcolor illustrations 336 text |btxt |2rdacontent 337 computer |bc |2rdamedia 338 online resource |bcr |2rdacarrier 347 text file |bPDF |c331.2 KB |2rda 538 System requirements: Adobe Reader. 538 Mode of access: World Wide Web. 502 |bM.S. |cEast Carolina University |d2019. 500 Presented to the faculty of the Department of Computer Science 500 Advisor: Venkat N. Gudivada 500 Title from PDF t.p. (viewed January 24, 2020). 520 3 Data is being generated at unprecedented volume and speed, which is popularly known as Big Data. Most of this data is unstructured and requires natural language processing and information retrieval techniques to extract actionable information. Furthermore, storing and retrieving such data requires extensible data models, flexible query mechanisms, and tunable consistency models for transaction support. The traditional Relational Database Management Systems (RDBMS) are not clearly suitable for meeting these needs. A plethora of data management systems have been introduced during the last ten years under the umbrella term NoSQL to meet this need. There are several classes of NoSQL data management systems including key-value, document-oriented, column-oriented, column-family, native XML, and graph-model based. Each class is geared towards meeting the needs of a class of applications. This necessitates an organization to install and operate multiple NoSQL systems, which is not cost-effective. In this thesis, we investigate performance of PostgreSQL database management system as a multi-model NoSQL system. More specifically, we evaluate PostgreSQL as a multi-model database with support for the following data models: row-oriented, column-oriented, key-value, and document-oriented. We describe cluster setup, datasets, data loading procedures, and query performance evaluation. During our investigation of features of PostgreSQL as a multi-model NoSQL system, we were able to achieve the scalability and high availability feature of PostgreSQL by using it as a row-oriented database. Our results showed that PostgreSQL for row-oriented is better for Online Transaction Processing (OLTP) when the records are frequently accessed whereas PostgreSQL as a column-oriented database is more suitable for the Online Analytical Processing (OLAP) of queries. The feature of PostgreSQL as a document-oriented database was exhibited as PostgreSQL supports Json/Jsonb (JavaScript Object Notation) data-types it is efficient to store the unstructured data efficiently. We were able to demonstrate the features of PostgreSQL as a key-value database from our implementation using the h-store extension. 504 Includes bibliographical references. 650 0 Database management. |=^A349280 650 0 Big data. |=^A1157100 653 PostgreSQL 653 multi-model database 700 1 Gudivada, Venkat N. |edegree supervisor. |=^A1308613 710 2 East Carolina University. |bDepartment of Computer Science. |?UNAUTHORIZED 856 40 |zAccess via ScholarShip |uhttp://hdl.handle.net/10342/7491 949 |owjh 994 C0 |bERE 596 1 4 998 5168901