An Introduction to PostGIS, H3 and its Integration with Greenplum
I am Rakesh Sharma, currently immersed in the world of technology with a focus on the R&D development of the open-source massively parallel database system, Greenplum—a cutting-edge database system. In my role, I contribute to the feature development of the Greenplum database, along with working on utilities like GPMT and extensions such as PostGIS, H3.
Before joining VMware, I served as a Technical Lead at PTC Software, where I played a key role in developing the next version of the CAD tool, Creo. Prior to that, I contributed to various projects at TATA Elxsi Ltd., gaining experience in web and embedded systems within the system and medical domains.
Passionate about technology, I'm always eager to connect with like-minded individuals. Feel free to reach out if you'd like to discuss innovation, collaboration, or anything tech-related.
I work as a Project manager in GreenPlum R&D, Vmware. I have around 18+ years of experience in the IT industry. I have worked in the Design and Development of Operating Systems and distributed database systems. Prior to joining Vmware I have worked in HPE, as HP-UX developer and in Dell EMC in a multipathing product called Powerpath. In powerpath, I have worked on all flavors of Unix and Linux.
At GreenPlum, I manage the Cluster Management utilities team which consists of a set of commands to create and maintain a GreenPlum Cluster. Most of these commands are wrappers around postgres commands and are written in python and Go.
No video of the event yet, sorry!
Greenplum Database is a massively parallel processing (MPP) database server with an architecture specially designed to manage large-scale analytic data warehouses and business intelligence workloads. MPP (a shared-nothing architecture) refers to systems with two or more processors that cooperate to carry out an operation, each with its own memory, operating system, and disks. Greenplum uses this high-performance system architecture to distribute the load of multi-terabyte data warehouses and can use all of a system’s resources in parallel to process a query. Greenplum Database is based on PostgreSQL open-source technology. It is essentially several PostgreSQL disk-oriented database instances acting together as one cohesive database management system (DBMS). It is based on PostgreSQL 12, and in most cases is very similar to PostgreSQL with regard to SQL support, features, configuration options, and end-user functionality. Database users interact with Greenplum Database as with a regular PostgreSQL DBMS.
PostGIS is an open-source spatial database extension for PostgreSQL, a powerful relational database management system. PostGIS adds support for geographic objects to the PostgreSQL database, turning it into a spatial database for geographic information systems (GIS). Whether you are new to PostGIS or looking to leverage its capabilities within the Greenplum ecosystem, this presentation aims to provide a comprehensive overview and practical insights into the seamless collaboration between PostGIS and Greenplum Database.
H3 is a geospatial indexing system developed by Uber Technologies. It provides a spatial indexing mechanism for mapping hexagons onto a sphere, making it particularly useful for applications involving geographic information, such as mapping, geospatial analytics, and location-based services. H3, a versatile hexagonal grid system, provides a unique spatial indexing mechanism that excels at handling geospatial data partitioning and aggregation.
- 2024 February 29 - 14:00
- 40 min
- Robusta + Arabica
- PGConf India, 2024
- Application Developer