Database: review db.system list

[lmolkova]

Area(s)

area:db

Some random observations on databases in db.system:

• coldfusion is not a database, but "a commercial rapid web-application development computing platform".
• cache is too broad and should not be used as a product name
• FileMaker is an app-development platform
• firstsql seems to be dead - https://dbdb.io/db/firstsqlj
• cloudscape is an old name of Apache Derby - https://en.wikipedia.org/wiki/Apache_Derby

most of the constants came from https://github.com/open-telemetry/opentelemetry-specification/pull/928 and it's not clear what criteria was used to add them

Describe the solution you'd like

Let's remove obsolete, not-quite-a-database constants and clean up some obvious naming issues like cache.

[lmolkova]

Related: https://github.com/open-telemetry/semantic-conventions/issues/608 Specifically:

• mssqlcompact - https://github.com/open-telemetry/semantic-conventions/issues/608#issuecomment-1936166073