Skip to main content
Database Administrators

Return to Question

Post Closed as "Not suitable for this site" by Evan Carroll, Joe Obbish, Marcello Miorelli, kevinskio, mustaccio
Improve formatting
Source Link
edit approved Jul 16, 2019 at 7:50
Laurenz Albe
edit approved Jul 16, 2019 at 7:50
Laurenz Albe
  • 56.5k
  • 4
  • 50
  • 82

My company has a huge (hundreds of millions of records) Oracle database of GIS/temporal information. We are trying to switch to an open source alternative.
 

If it helps, we imagined the following requirements:
 

  1. horizontal scaling (like elastic search, for example)

    horizontal scaling (like elastic search, for example)

  2. fully SQL compliant. We don't think we can use NoSQL, etc, because we would have to rewrite all our queries.

    fully SQL compliant. We don't think we can use NoSQL, etc, because we would have to rewrite all our queries.

  3. No license fee

    No license fee

My company has a huge (hundreds of millions of records) Oracle database of GIS/temporal information. We are trying to switch to an open source alternative.
 

If it helps, we imagined the following requirements:
 

  1. horizontal scaling (like elastic search, for example)
  2. fully SQL compliant. We don't think we can use NoSQL, etc, because we would have to rewrite all our queries.
  3. No license fee

My company has a huge (hundreds of millions of records) Oracle database of GIS/temporal information. We are trying to switch to an open source alternative.

If it helps, we imagined the following requirements:

  1. horizontal scaling (like elastic search, for example)

  2. fully SQL compliant. We don't think we can use NoSQL, etc, because we would have to rewrite all our queries.

  3. No license fee

edited tags
Link
Evan Carroll
Evan Carroll
  • 64.7k
  • 49
  • 251
  • 496
Source Link
Craeft
Craeft
  • 101
  • 2

Oracle GIS database replacement

My company has a huge (hundreds of millions of records) Oracle database of GIS/temporal information. We are trying to switch to an open source alternative.

If it helps, we imagined the following requirements:

  1. horizontal scaling (like elastic search, for example)
  2. fully SQL compliant. We don't think we can use NoSQL, etc, because we would have to rewrite all our queries.
  3. No license fee