Hello Sheethal,
as Catalin already posted - there are at least 2 very different databases for a CA Spectrum install.
Both are important - most important is the SpectroSERVER database covering the device(modeling) (socalled SSdb) - followed by the ArchiveManager database covering the event-information (socalled DDmdb).
It is recommended to do a "read" for these databases only - as the database access is vital for CA Spectrum runtime. Therefore I would suggest NOT to do any native database access - but to use the "restful" API which allows to retrieve most of all data via one common API.
The SSdb is a Berkely-DB, the DDmdb is a mysql-DB. Both databases - when accessed and "updated" could cause a full failure for the Spectrum application. Using the "restful"-API ensures the access is gracefully and most likely validated before reading/writing the data.
May you can provide more info what your target is - that would help a lot.
hth - cheers, Joerg