Indexes in PostgreSQL

Sultana, Seema; Dixit, Sunanda

doi:10.1109/icimia.2017.7975511

Cited by 2 publications

(2 citation statements)

References 4 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…However, a proper index removes duplicates that affects system resources (Kamatkar et al 2018). It is also recommended that indexing should be created on the accurate columns of the database tables (Sultana et al 2017), like the primary key of the table.…”

Section: Database Indexingmentioning

confidence: 99%

See 1 more Smart Citation

Secured and Modular Data Portal: Database System to Manage Broadly Classified and Large-Scale Data

Lencha,

Mitiku,

Woldemichael

2024

Data Science Journal

View full text Add to dashboard Cite

Using various types of broadly classified and large-scale data, the Ethiopian Construction Design and Supervision Works Corporation (ECDSWC) provides professional services such as engineering studies and design. Storing, managing, and sharing datasets within workgroups and research teams was not an easy task before the corporation implemented the data portal. To resolve the issues related to data management, this study provides a secured and modular data portal by implementing REST API principles. The data portal is used to manage a wide variety of datasets, such as spatial data and their attributes, along with metadata and other serialized documents that support the business operation of the corporation. On the top of data management strategies, the Security in Depth (SiD) mechanism is developed by implementing the Unified Identity Authentication Service, which provides a multilayered security scheme. The applicability of the data portal is demonstrated using datasets obtained from ECDSWC. Further, the accuracy, integrity and privacy of the data are evaluated, and system performance is weighed through a prepared test case.

show abstract

Section: Database Indexingmentioning

confidence: 99%

“…PostgreSQL provides several indexing techniques, such as Balanced tree (B-tree), Hash, Generalized Index Search Tree (GiST), Specially Partitioned-GiST (SP-GiST), Generalized Inverted Index (GIN) and Block Range Index (BRIN) (Sultana et al 2017). B-tree and hash are the two most used methods (Qu et al 2019).…”

Section: Database Indexingmentioning

confidence: 99%