GFZ Data Services

Released
Software

gms-index-mediator: a R-tree-based in-memory index for fast spatio-temporal queries for the GeoMultiSens platform

Cite as:

Eggert, Daniel; Sips, Mike; Dransch, Doris (2018): gms-index-mediator: a R-tree-based in-memory index for fast spatio-temporal queries for the GeoMultiSens platform. V. 1.0.0. GFZ Data Services. http://doi.org/10.5880/GFZ.1.5.2018.004

Status

I   N       R   E   V   I   E   W : Eggert, Daniel; Sips, Mike; Dransch, Doris (2018): gms-index-mediator: a R-tree-based in-memory index for fast spatio-temporal queries for the GeoMultiSens platform. V. 1.0.0. GFZ Data Services. http://doi.org/10.5880/GFZ.1.5.2018.004

Abstract

Gms-index-mediator is a standalone index for spatio-temporal data acting as a mediator between an application and a database. Even modern databases need several minutes to execute a spatio-temporal query to huge tables containing several million entries. Our index-mediator speeds the execution of such queries up by several magnitues, resulting in response times around 100ms. This version is tailored towards the GeoMultiSens database, but can be adapted to work with custom table layouts with reasonable effort.

Dataset Contact

  • Eggert, Daniel; GFZ German Research Centre for Geosciences, Potsdam, Germany;

Keywords

science > informatics > data base > relational database

GCMD Science Keywords

More Metadata

  • iso19115:  /  download xml
    • MD_Metadata (xsi:schemaLocation=http://www.isotc211.org/2005/gmd http://www.isotc211.org/2005/gmd/gmd.xsd)
      • fileIdentifier
        • CharacterString: doi:10.5880/GFZ.1.5.2018.004
      • language
        • LanguageCode (codeList=http://www.loc.gov/standards/iso639-2/ codeListValue=eng): eng
      • characterSet
        • MD_CharacterSetCode (codeList=http://www.isotc211.org/2005/resources/codeList.xml#MD_CharacterSetCode codeListValue=utf8): 
      • hierarchyLevel
        • MD_ScopeCode (codeList=http://www.isotc211.org/2005/resources/Codelist/gmxCodelists.xml#MD_ScopeCode codeListValue=): 
      • hierarchyLevelName
        • CharacterString: 
      • contact
        • CI_ResponsibleParty
          • organisationName
            • CharacterString: GFZ German Research Centre for Geosciences
          • contactInfo
            • CI_Contact
              • address
                • CI_Address
                  • electronicMailAddress
                    • CharacterString: 
              • onlineResource
                • CI_OnlineResource
                  • linkage
                    • URL: http://www.gfz-potsdam.de/
                  • function
                    • CI_OnLineFunctionCode (codeList=http://www.isotc211.org/2005/resources/Codelist/gmxCodelists.xml#CI_OnLineFunctionCode codeListValue=information): information
          • role
            • CI_RoleCode (codeList=http://www.isotc211.org/2005/resources/Codelist/gmxCodelists.xml#CI_RoleCode codeListValue=pointOfContact): pointOfContact
      • dateStamp
        • Date: 2019-01-28
      • referenceSystemInfo
        • MD_ReferenceSystem
          • referenceSystemIdentifier
            • RS_Identifier
              • code
                • CharacterString: urn:ogc:def:crs:EPSG:4326
      • identificationInfo
        • MD_DataIdentification
          • citation
            • CI_Citation
              • title
                • CharacterString: gms-index-mediator: a R-tree-based in-memory index for fast spatio-temporal queries for the GeoMultiSens platform
              • date
                • CI_Date
                  • date
                    • Date: 2019-01-28
                  • dateType
                    • CI_DateTypeCode (codeList=http://www.isotc211.org/2005/resources/Codelist/gmxCodelists.xml#CI_DateTypeCode codeListValue=revision): revision
              • identifier
                • MD_Identifier
                  • code
                    • CharacterString: doi:10.5880/GFZ.1.5.2018.004
              • citedResponsibleParty (xlink:href=http://orcid.org/https://orcid.org/0000-0003-0251-4390)
                • CI_ResponsibleParty
                  • individualName
                    • CharacterString: Eggert, Daniel
                  • organisationName
                    • CharacterString: GFZ German Research Centre for Geosciences, Potsdam, Germany
                  • role
                    • CI_RoleCode (codeList=http://www.isotc211.org/2005/resources/Codelist/gmxCodelists.xml#CI_RoleCode codeListValue=http://www.isotc211.org/2005/resources/Codelist/gmxCodelists.xml#CI_RoleCode_author): author
              • citedResponsibleParty
                • CI_ResponsibleParty
                  • individualName
                    • CharacterString: Sips, Mike
                  • organisationName
                    • CharacterString: GFZ German Research Centre for Geosciences, Potsdam, Germany
                  • role
                    • CI_RoleCode (codeList=http://www.isotc211.org/2005/resources/Codelist/gmxCodelists.xml#CI_RoleCode codeListValue=http://www.isotc211.org/2005/resources/Codelist/gmxCodelists.xml#CI_RoleCode_author): author
              • citedResponsibleParty
                • CI_ResponsibleParty
                  • individualName
                    • CharacterString: Dransch, Doris
                  • organisationName
                    • CharacterString: GFZ German Research Centre for Geosciences, Potsdam, Germany
                  • role
                    • CI_RoleCode (codeList=http://www.isotc211.org/2005/resources/Codelist/gmxCodelists.xml#CI_RoleCode codeListValue=http://www.isotc211.org/2005/resources/Codelist/gmxCodelists.xml#CI_RoleCode_author): author
          • abstract
            • CharacterString: Gms-index-mediator is a standalone index for spatio-temporal data acting as a mediator between an application and a database. Even modern databases need several minutes to execute a spatio-temporal query to huge tables containing several million entries. Our index-mediator speeds the execution of such queries up by several magnitues, resulting in response times around 100ms. This version is tailored towards the GeoMultiSens database, but can be adapted to work with custom table layouts with reasonable effort.
          • status
            • MD_ProgressCode (codeList=http://www.isotc211.org/2005/resources/Codelist/gmxCodelists.xml#MD_ProgressCode codeListValue=Complete): Complete
          • pointOfContact
            • CI_ResponsibleParty
              • individualName
                • CharacterString: Eggert, Daniel
              • organisationName
                • CharacterString: GFZ German Research Centre for Geosciences, Potsdam, Germany
              • contactInfo
                • CI_Contact
                  • address
                    • CI_Address
                      • electronicMailAddress
                        • CharacterString: daniel.eggert(_at_)gfz-potsdam.de
              • role
                • CI_RoleCode (codeList=http://www.isotc211.org/2005/resources/Codelist/gmxCodelists.xml#CI_RoleCode codeListValue=http://www.isotc211.org/2005/resources/Codelist/gmxCodelists.xml#CI_RoleCode_pointOfContact): pointOfContact
          • descriptiveKeywords
            • MD_Keywords
              • keyword
                • CharacterString: science > informatics > data base > relational database
              • thesaurusName
                • CI_Citation
                  • title
                    • CharacterString: GEMET - INSPIRE themes, version 1.0
                  • date
                    • CI_Date
                      • date
                        • Date: 2008-06-01
                      • dateType
                        • CI_DateTypeCode (codeList=http://www.isotc211.org/2005/resources/Codelist/gmxCodelists.xml#CI_DateTypeCode codeListValue=publication): publication
          • descriptiveKeywords
            • MD_Keywords
              • keyword
                • CharacterString: EARTH SCIENCE SERVICES > METADATA HANDLING > DATA DISCOVERY
              • keyword
                • CharacterString: EARTH SCIENCE SERVICES > DATA MANAGEMENT/DATA HANDLING > DATA SEARCH AND RETRIEVAL
              • thesaurusName
                • CI_Citation
                  • title
                    • CharacterString: NASA/GCMD Earth Science Keywords
                  • date
                    • CI_Date
                      • date (gco:nilReason=missing): 
                      • dateType
                        • CI_DateTypeCode (codeList=http://www.isotc211.org/2005/resources/Codelist/gmxCodelists.xml#CI_DateTypeCode codeListValue=publication): publication
          • resourceConstraints (xlink:href=https://www.gnu.org/licenses/gpl-3.0.html)
            • MD_Constraints
              • useLimitation
                • CharacterString: GNU General Public License, Version 3, 29 June 2007, Copyright Helmholtz Centre Potsdam GFZ German Research Centre for Geosciences
          • resourceConstraints
            • MD_LegalConstraints
              • accessConstraints
                • MD_RestrictionCode (codeList=http://www.isotc211.org/2005/resources/codeList.xml#MD_RestrictionCode codeListValue=otherRestrictions): 
              • otherConstraints
                • CharacterString: GNU General Public License, Version 3, 29 June 2007, Copyright Helmholtz Centre Potsdam GFZ German Research Centre for Geosciences
          • resourceConstraints
            • MD_SecurityConstraints
              • classification
                • MD_ClassificationCode (codeList=http://www.isotc211.org/2005/resources/codeList.xml#MD_ClassificationCode codeListValue=unclassified): 
          • aggregationInfo
            • MD_AggregateInformation
              • aggregateDataSetIdentifier
                • RS_Identifier
                  • code
                    • CharacterString: 10.5880/GFZ.1.5.2018.001
                  • codeSpace
                    • CharacterString: DOI
              • associationType
                • DS_AssociationTypeCode (codeList=http://datacite.org/schema/kernel-4 codeListValue=IsSupplementTo): IsSupplementTo
          • aggregationInfo
            • MD_AggregateInformation
              • aggregateDataSetIdentifier
                • RS_Identifier
                  • code
                    • CharacterString: 10.5880/GFZ.1.5.2018.005
                  • codeSpace
                    • CharacterString: DOI
              • associationType
                • DS_AssociationTypeCode (codeList=http://datacite.org/schema/kernel-4 codeListValue=IsPartOf): IsPartOf
          • language
            • CharacterString: eng
      • distributionInfo
        • MD_Distribution
          • transferOptions
            • MD_DigitalTransferOptions
              • onLine
                • CI_OnlineResource
                  • linkage
                    • URL: http://dx.doi.org/doi:10.5880/GFZ.1.5.2018.004
                  • protocol
                    • CharacterString: WWW:LINK-1.0-http--link
                  • name
                    • CharacterString: Download
                  • description
                    • CharacterString: Download
                  • function
                    • CI_OnLineFunctionCode (codeList=http://www.isotc211.org/2005/resources/Codelist/gmxCodelists.xml#CI_OnLineFunctionCode codeListValue=http://www.isotc211.org/2005/resources/Codelist/gmxCodelists.xml#CI_OnLineFunctionCode_download): download
  • datacite:  /  download xml
    • resource (xsi:schemaLocation=http://datacite.org/schema/kernel-4 http://schema.datacite.org/meta/kernel-4/metadata.xsd)
      • identifier (identifierType=DOI): 10.5880/GFZ.1.5.2018.004
      • creators
        • creator
          • creatorName: Eggert, Daniel
          • givenName: Daniel
          • familyName: Eggert
          • nameIdentifier (nameIdentifierScheme=ORCID): https://orcid.org/0000-0003-0251-4390
          • affiliation: GFZ German Research Centre for Geosciences, Potsdam, Germany
        • creator
          • creatorName: Sips, Mike
          • givenName: Mike
          • familyName: Sips
          • affiliation: GFZ German Research Centre for Geosciences, Potsdam, Germany
        • creator
          • creatorName: Dransch, Doris
          • givenName: Doris
          • familyName: Dransch
          • affiliation: GFZ German Research Centre for Geosciences, Potsdam, Germany
      • titles
        • title (xml:lang=eng): gms-index-mediator: a R-tree-based in-memory index for fast spatio-temporal queries for the GeoMultiSens platform
      • publisher: GFZ Data Services
      • publicationYear: 2018
      • subjects
        • subject (schemeURI=http://www.eionet.europa.eu/gemet/ subjectScheme=GEMET xml:lang=en): science > informatics > data base > relational database
        • subject (schemeURI=http://gcmdservices.gsfc.nasa.gov/kms/concepts/concept_scheme/sciencekeywords subjectScheme=NASA/GCMD Earth Science Keywords xml:lang=en): EARTH SCIENCE SERVICES > METADATA HANDLING > DATA DISCOVERY
        • subject (schemeURI=http://gcmdservices.gsfc.nasa.gov/kms/concepts/concept_scheme/sciencekeywords subjectScheme=NASA/GCMD Earth Science Keywords xml:lang=en): EARTH SCIENCE SERVICES > DATA MANAGEMENT/DATA HANDLING > DATA SEARCH AND RETRIEVAL
      • language: eng
      • resourceType (resourceTypeGeneral=Software): Dataset
      • relatedIdentifiers
        • relatedIdentifier (relatedIdentifierType=DOI relationType=IsSupplementTo): 10.5880/GFZ.1.5.2018.001
        • relatedIdentifier (relatedIdentifierType=DOI relationType=IsPartOf): 10.5880/GFZ.1.5.2018.005
      • sizes
        • size: 221801 Bytes
        • size: 3 Files
      • formats
        • format: application/octet-stream
        • format: application/octet-stream
        • format: application/x-zip-compressed
      • version: 1.0.0
      • rightsList
        • rights (rightsURI=https://www.gnu.org/licenses/gpl-3.0.html): GNU General Public License, Version 3, 29 June 2007, Copyright Helmholtz Centre Potsdam GFZ German Research Centre for Geosciences
      • descriptions
        • description (descriptionType=Abstract): Gms-index-mediator is a standalone index for spatio-temporal data acting as a mediator between an application and a database. Even modern databases need several minutes to execute a spatio-temporal query to huge tables containing several million entries. Our index-mediator speeds the execution of such queries up by several magnitues, resulting in response times around 100ms. This version is tailored towards the GeoMultiSens database, but can be adapted to work with custom table layouts with reasonable effort.
  • dif:  /  download xml
    • DIF (xsi:schemaLocation=http://gcmd.gsfc.nasa.gov/Aboutus/xml/dif/ http://gcmd.nasa.gov/Aboutus/xml/dif/dif_v9.8.2.xsd)
      • Entry_ID: 10.5880/GFZ.1.5.2018.004
      • Entry_Title: gms-index-mediator: a R-tree-based in-memory index for fast spatio-temporal queries for the GeoMultiSens platform
      • Data_Set_Citation
        • Dataset_Creator: Eggert, Daniel; Sips, Mike; Dransch, Doris
        • Dataset_Title: gms-index-mediator: a R-tree-based in-memory index for fast spatio-temporal queries for the GeoMultiSens platform
        • Dataset_Release_Date: 2018
        • Dataset_Release_Place: Potsdam, Germany
        • Dataset_Publisher: GFZ Data Services
        • Online_Resource: http://dx.doi.org/10.5880/GFZ.1.5.2018.004
      • Parameters
        • Category: EARTH SCIENCE SERVICES
        • Topic: METADATA HANDLING
        • Term: DATA DISCOVERY
      • Parameters
        • Category: EARTH SCIENCE SERVICES
        • Topic: DATA MANAGEMENT/DATA HANDLING
        • Term: DATA SEARCH AND RETRIEVAL
      • ISO_Topic_Category: geoscientificInformation
      • Keyword: science > informatics > data base > relational database
      • Data_Center
        • Data_Center_Name
          • Short_Name: Deutsches GeoForschungsZentrum GFZ
          • Long_Name: GFZ
        • Personnel
          • Role: DATA CENTER CONTACT
          • Last_Name: Deutsches GeoForschungsZentrum GFZ
      • Summary
        • Abstract: Gms-index-mediator is a standalone index for spatio-temporal data acting as a mediator between an application and a database. Even modern databases need several minutes to execute a spatio-temporal query to huge tables containing several million entries. Our index-mediator speeds the execution of such queries up by several magnitues, resulting in response times around 100ms. This version is tailored towards the GeoMultiSens database, but can be adapted to work with custom table layouts with reasonable effort.
      • Metadata_Name: DIF
      • Metadata_Version: 9.8.2
  • escidoc:  /  download xml
    • resource
      • title (xml:lang=eng): gms-index-mediator: a R-tree-based in-memory index for fast spatio-temporal queries for the GeoMultiSens platform
      • creator
        • creatorName: Eggert, Daniel
        • givenName: Daniel
        • familyName: Eggert
        • nameIdentifier (nameIdentifierScheme=ORCID): https://orcid.org/0000-0003-0251-4390
        • affiliation: GFZ German Research Centre for Geosciences, Potsdam, Germany
      • creator
        • creatorName: Sips, Mike
        • givenName: Mike
        • familyName: Sips
        • affiliation: GFZ German Research Centre for Geosciences, Potsdam, Germany
      • creator
        • creatorName: Dransch, Doris
        • givenName: Doris
        • familyName: Dransch
        • affiliation: GFZ German Research Centre for Geosciences, Potsdam, Germany

Files

License: GNU General Public License, Version 3, 29 June 2007, Copyright Helmholtz Centre Potsdam GFZ German Research Centre for Geosciences

Software Description

Supplement to