{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,10]],"date-time":"2026-03-10T14:48:15Z","timestamp":1773154095213,"version":"3.50.1"},"reference-count":36,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2022,8]]},"abstract":"<jats:p>Recently, the trend of developing digital twins for smart cities has driven a need for managing large-scale multidimensional, dynamic, and scene-oriented spatial data. Due to larger data scale and more complex data structure, queries over such data are more complicated and expensive than those on traditional spatial data, which poses challenges to the system efficiency and deployment costs. The existing spatial databases have limited support in both data types and operations. Therefore, a new-generation spatial database with excellent performance and effective deployment costs is needed.<\/jats:p>\n          <jats:p>This paper presents Ganos, a cloud-native spatial database engine of PolarDB for PostgreSQL that is developed by Alibaba Cloud, to efficiently manage multidimensional, dynamic, and scene-oriented spatial data. Ganos models 3D space and spatio-temporal dynamics as first-class citizens. Also, it natively supports spatial\/spatio-temporal data types such as 3DMesh, Trajectory, Raster, PointCloud, etc. Besides, it implements a novel extended-storage mechanism that utilizes cloud-native object storage to reduce storage costs and enable uniform operations on the data in different storages. To facilitate processing \"big\" queries, Ganos extends PolarDB and provides spatial-oriented multi-level parallelism under the architecture of decoupling compute from storage in cloud-native databases, which achieves elasticity and excellent query performance. We demonstrate Ganos in real-life case studies. The performance of Ganos is evaluated using real datasets, and promising results are obtained. Finally, based on the extensive deployment and application of Ganos, the lessons learned from our customers and the expectations of modern cloud applications for new spatial database features are discussed.<\/jats:p>","DOI":"10.14778\/3554821.3554838","type":"journal-article","created":{"date-parts":[[2022,9,29]],"date-time":"2022-09-29T22:28:39Z","timestamp":1664490519000},"page":"3483-3495","source":"Crossref","is-referenced-by-count":9,"title":["Ganos"],"prefix":"10.14778","volume":"15","author":[{"given":"Jiong","family":"Xie","sequence":"first","affiliation":[{"name":"Alibaba Group"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Zhen","family":"Chen","sequence":"additional","affiliation":[{"name":"Alibaba Group"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jianwei","family":"Liu","sequence":"additional","affiliation":[{"name":"Alibaba Group"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Fang","family":"Wang","sequence":"additional","affiliation":[{"name":"Alibaba Group"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Feifei","family":"Li","sequence":"additional","affiliation":[{"name":"Alibaba Group"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Zhida","family":"Chen","sequence":"additional","affiliation":[{"name":"Alibaba Group"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Yinpei","family":"Liu","sequence":"additional","affiliation":[{"name":"Alibaba Group"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Songlu","family":"Cai","sequence":"additional","affiliation":[{"name":"Alibaba Group"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Zhenhua","family":"Fan","sequence":"additional","affiliation":[{"name":"Alibaba Group"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Fei","family":"Xiao","sequence":"additional","affiliation":[{"name":"Alibaba Group"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Yue","family":"Chen","sequence":"additional","affiliation":[{"name":"Alibaba Group"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2022,9,29]]},"reference":[{"key":"e_1_2_1_1_1","volume-title":"KiCad Services Corp. Retrieved","author":"KiCad Services Corp. [n.d.]. FreeCAD","year":"2022","unstructured":"KiCad Services Corp. [n.d.]. FreeCAD : Your own 3D parametric modeler . KiCad Services Corp. Retrieved January 25, 2022 from https:\/\/www.freecadweb.org\/ KiCad Services Corp. [n.d.]. FreeCAD: Your own 3D parametric modeler. KiCad Services Corp. Retrieved January 25, 2022 from https:\/\/www.freecadweb.org\/"},{"key":"e_1_2_1_2_1","unstructured":"Oracle [n.d.]. MySQL Documentation. Oracle. Retrieved January 25 2022 from https:\/\/dev.mysql.com\/doc\/  Oracle [n.d.]. MySQL Documentation. Oracle. Retrieved January 25 2022 from https:\/\/dev.mysql.com\/doc\/"},{"key":"e_1_2_1_3_1","volume-title":"Oracle's Spatial Database. Oracle. Retrieved","author":"Oracle","year":"2022","unstructured":"Oracle [n.d.]. Oracle's Spatial Database. Oracle. Retrieved January 25, 2022 from https:\/\/www.oracle.com\/database\/spatial\/ Oracle [n.d.]. Oracle's Spatial Database. Oracle. Retrieved January 25, 2022 from https:\/\/www.oracle.com\/database\/spatial\/"},{"key":"e_1_2_1_4_1","volume-title":"PostgreSQL: The World's Most Advanced Open Source Relational Database","author":"The PostgreSQL Global Development Group [n.d.].","year":"2022","unstructured":"The PostgreSQL Global Development Group [n.d.]. PostgreSQL: The World's Most Advanced Open Source Relational Database . The PostgreSQL Global Development Group . Retrieved January 25, 2022 from https:\/\/www.postgresql.org\/ The PostgreSQL Global Development Group [n.d.]. PostgreSQL: The World's Most Advanced Open Source Relational Database. The PostgreSQL Global Development Group. Retrieved January 25, 2022 from https:\/\/www.postgresql.org\/"},{"key":"e_1_2_1_5_1","volume-title":"Simple Feature Access, Part 1: Common Architecture","author":"Open Geospatial Consortium [n.d.].","year":"2022","unstructured":"Open Geospatial Consortium [n.d.]. Simple Feature Access, Part 1: Common Architecture . Open Geospatial Consortium . Retrieved January 25, 2022 from http:\/\/www.opengeospatial.org\/standards\/sfa\/ Open Geospatial Consortium [n.d.]. Simple Feature Access, Part 1: Common Architecture. Open Geospatial Consortium. Retrieved January 25, 2022 from http:\/\/www.opengeospatial.org\/standards\/sfa\/"},{"key":"e_1_2_1_6_1","volume-title":"Retrieved","author":"PostGIS Project Steering Committee (PSC) [n.d.].","year":"2022","unstructured":"PostGIS Project Steering Committee (PSC) [n.d.]. Spatial and Geographic objects for PostgreSQL. PostGIS Project Steering Committee (PSC) . Retrieved January 25, 2022 from https:\/\/postgis.net\/ PostGIS Project Steering Committee (PSC) [n.d.]. Spatial and Geographic objects for PostgreSQL. PostGIS Project Steering Committee (PSC). Retrieved January 25, 2022 from https:\/\/postgis.net\/"},{"key":"e_1_2_1_7_1","volume-title":"Spatial Developer's Guide. Oracle. Retrieved","author":"Oracle","year":"2022","unstructured":"Oracle [n.d.]. Spatial Developer's Guide. Oracle. Retrieved February 23, 2022 from https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/21\/spatl\/ Oracle [n.d.]. Spatial Developer's Guide. Oracle. Retrieved February 23, 2022 from https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/21\/spatl\/"},{"key":"e_1_2_1_8_1","unstructured":"SQLite Consortium [n.d.]. SQLite. SQLite Consortium. Retrieved February 7 2022 from https:\/\/www.sqlite.org\/index.html  SQLite Consortium [n.d.]. SQLite. SQLite Consortium. Retrieved February 7 2022 from https:\/\/www.sqlite.org\/index.html"},{"key":"e_1_2_1_9_1","volume-title":"Amazon. Retrieved","author":"Amazon","year":"2022","unstructured":"Amazon [n.d.]. Working with Amazon Aurora PostgreSQL . Amazon. Retrieved January 25, 2022 from https:\/\/docs.aws.amazon.com\/AmazonRDS\/latest\/AuroraUserGuide\/Aurora.AuroraPostgreSQL.html Amazon [n.d.]. Working with Amazon Aurora PostgreSQL. Amazon. Retrieved January 25, 2022 from https:\/\/docs.aws.amazon.com\/AmazonRDS\/latest\/AuroraUserGuide\/Aurora.AuroraPostgreSQL.html"},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.5555\/645927.758383"},{"key":"e_1_2_1_11_1","volume-title":"Spatial Data (SQL Server). Microsoft. Retrieved","author":"Andzic Mladen","year":"2022","unstructured":"Mladen Andzic , Van To , Mike Ray , Craig Guyer , Saisang Cai , and Douglas Laudenschlager . [n.d.]. Spatial Data (SQL Server). Microsoft. Retrieved January 25, 2022 from https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/spatial\/spatial-data-sql-server?view=sql-server-ver15 Mladen Andzic, Van To, Mike Ray, Craig Guyer, Saisang Cai, and Douglas Laudenschlager. [n.d.]. Spatial Data (SQL Server). Microsoft. Retrieved January 25, 2022 from https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/spatial\/spatial-data-sql-server?view=sql-server-ver15"},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1145\/3299869.3314047"},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1145\/3356999.3365467"},{"key":"e_1_2_1_14_1","volume-title":"Software Pioneers: Contributions to Software Engineering","author":"Bayer Rudolf","unstructured":"Rudolf Bayer and Edward McCreight . 2002. Organization and maintenance of large ordered indexes . In Software Pioneers: Contributions to Software Engineering . Springer , 245--262. Rudolf Bayer and Edward McCreight. 2002. Organization and maintenance of large ordered indexes. In Software Pioneers: Contributions to Software Engineering. Springer, 245--262."},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.3390\/ijgi9020095"},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.14778\/3229863.3229872"},{"key":"e_1_2_1_17_1","volume-title":"Proceedings of 2nd International Advanced Database Conference (IADC '06)","author":"Carvalho Alexandre","year":"2006","unstructured":"Alexandre Carvalho , Cristina Ribeiro , and Ant\u00f3nio Augusto Sousa . 2006 . Spatial timedb-valid time support in spatial dbms . In Proceedings of 2nd International Advanced Database Conference (IADC '06) . Alexandre Carvalho, Cristina Ribeiro, and Ant\u00f3nio Augusto Sousa. 2006. Spatial timedb-valid time support in spatial dbms. In Proceedings of 2nd International Advanced Database Conference (IADC '06)."},{"key":"e_1_2_1_18_1","volume-title":"Research and Practical Issues of Enterprise Information Systems","author":"Carvalho Alexandre","unstructured":"Alexandre Carvalho , Cristina Ribeiro , and A. Augusto Sousa . 2006. A spatio-temporal database system based on timedb and oracle spatial . In Research and Practical Issues of Enterprise Information Systems . Springer , 11--20. Alexandre Carvalho, Cristina Ribeiro, and A. Augusto Sousa. 2006. A spatio-temporal database system based on timedb and oracle spatial. In Research and Practical Issues of Enterprise Information Systems. Springer, 11--20."},{"key":"e_1_2_1_19_1","volume-title":"IBM's DB2 spatial extender: Managing geo-spatial information within the DBMS. IBM corporation (May","author":"Davis Judith R.","year":"1998","unstructured":"Judith R. Davis . 1998. IBM's DB2 spatial extender: Managing geo-spatial information within the DBMS. IBM corporation (May 1998 ). Judith R. Davis. 1998. IBM's DB2 spatial extender: Managing geo-spatial information within the DBMS. IBM corporation (May 1998)."},{"key":"e_1_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.1007\/s43762-021-00005-y"},{"key":"e_1_2_1_21_1","unstructured":"Alessandro Furieri. [n.d.]. SpatiaLite. Retrieved February 7 2022 from https:\/\/www.gaia-gis.it\/fossil\/libspatialite\/index  Alessandro Furieri. [n.d.]. SpatiaLite. Retrieved February 7 2022 from https:\/\/www.gaia-gis.it\/fossil\/libspatialite\/index"},{"key":"e_1_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.1145\/602259.602266"},{"key":"e_1_2_1_23_1","unstructured":"Joseph M. Hellerstein Jeffrey F. Naughton and Avi Pfeffer. 1995. Generalized search trees for database systems.  Joseph M. Hellerstein Jeffrey F. Naughton and Avi Pfeffer. 1995. Generalized search trees for database systems."},{"key":"e_1_2_1_24_1","unstructured":"ISO\/IEC. 2016. Information Technology---Database Languages---SQL Multimedia and Application Packages---Part3: Spatial.  ISO\/IEC. 2016. Information Technology---Database Languages---SQL Multimedia and Application Packages---Part3: Spatial."},{"key":"e_1_2_1_25_1","volume-title":"Berkay Aydin, Michael A Schuh, and Rafal A Angryk.","author":"Kucuk Ahmet","year":"2016","unstructured":"Ahmet Kucuk , Shah Muhammad Hamdi , Berkay Aydin, Michael A Schuh, and Rafal A Angryk. 2016 . Pg-trajectory : A postgresql\/postgis based data model for spatiotemporal trajectories. In IEEE International Conferences on Big Data and Cloud Computing (BDCloud), Social Computing and Networking (SocialCom), Sustainable Computing and Communications (SustainCom) (BDCloud-SocialCom-SustainCom '16). IEEE , 81--88. Ahmet Kucuk, Shah Muhammad Hamdi, Berkay Aydin, Michael A Schuh, and Rafal A Angryk. 2016. Pg-trajectory: A postgresql\/postgis based data model for spatiotemporal trajectories. In IEEE International Conferences on Big Data and Cloud Computing (BDCloud), Social Computing and Networking (SocialCom), Sustainable Computing and Communications (SustainCom) (BDCloud-SocialCom-SustainCom '16). IEEE, 81--88."},{"key":"e_1_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.14778\/3352063.3352141"},{"key":"e_1_2_1_27_1","volume-title":"Proceedings of the 25th ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems (SIGSPATIAL '17)","author":"Oliveira Lizardo Lu\u00eds Eduardo","year":"2017","unstructured":"Lu\u00eds Eduardo Oliveira Lizardo and Clodoveu Augusto Davis Jr . 2017 . A PostGIS extension to support advanced spatial data types and integrity constraints . In Proceedings of the 25th ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems (SIGSPATIAL '17) . 1--10. Lu\u00eds Eduardo Oliveira Lizardo and Clodoveu Augusto Davis Jr. 2017. A PostGIS extension to support advanced spatial data types and integrity constraints. In Proceedings of the 25th ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems (SIGSPATIAL '17). 1--10."},{"key":"e_1_2_1_28_1","doi-asserted-by":"crossref","unstructured":"S. Logothetis E. Valari E. Karachaliou and E. Stylianidis. 2017. Spatial DMBS architecture for a free and open source BIM. International Archives of the Photogrammetry Remote Sensing & Spatial Information Sciences 42 (2017).  S. Logothetis E. Valari E. Karachaliou and E. Stylianidis. 2017. Spatial DMBS architecture for a free and open source BIM. International Archives of the Photogrammetry Remote Sensing & Spatial Information Sciences 42 (2017).","DOI":"10.5194\/isprs-archives-XLII-2-W5-467-2017"},{"key":"e_1_2_1_29_1","first-page":"133","article-title":"Towards an intelligent platform for big 3d geospatial data management. ISPRS Annals of Photogrammetry","volume":"4","author":"Semnani N Mazroob","year":"2018","unstructured":"N Mazroob Semnani , PV Kuper , M Breunig , and M Al-Doori . 2018 . Towards an intelligent platform for big 3d geospatial data management. ISPRS Annals of Photogrammetry , Remote Sensing and Spatial Information Sciences 4 (2018), 133 -- 140 . N Mazroob Semnani, PV Kuper, M Breunig, and M Al-Doori. 2018. Towards an intelligent platform for big 3d geospatial data management. ISPRS Annals of Photogrammetry, Remote Sensing and Spatial Information Sciences 4 (2018), 133--140.","journal-title":"Remote Sensing and Spatial Information Sciences"},{"key":"e_1_2_1_30_1","doi-asserted-by":"publisher","DOI":"10.1109\/ACCESS.2021.3120843"},{"key":"e_1_2_1_31_1","doi-asserted-by":"publisher","DOI":"10.3390\/su13063386"},{"key":"e_1_2_1_32_1","doi-asserted-by":"publisher","DOI":"10.3390\/ijgi9040240"},{"key":"e_1_2_1_33_1","doi-asserted-by":"publisher","DOI":"10.1145\/3035918.3056101"},{"key":"e_1_2_1_34_1","doi-asserted-by":"publisher","DOI":"10.1186\/s40965-018-0046-7"},{"key":"e_1_2_1_35_1","doi-asserted-by":"publisher","DOI":"10.1145\/1653771.1653815"},{"key":"e_1_2_1_36_1","doi-asserted-by":"publisher","DOI":"10.1145\/3406534"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3554821.3554838","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T11:27:05Z","timestamp":1672226825000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3554821.3554838"}},"subtitle":["a multidimensional, dynamic, and scene-oriented cloud-native spatial database engine"],"short-title":[],"issued":{"date-parts":[[2022,8]]},"references-count":36,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2022,8]]}},"alternative-id":["10.14778\/3554821.3554838"],"URL":"https:\/\/doi.org\/10.14778\/3554821.3554838","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2022,8]]}}}