English 中文(简体)
Is Oracle Workspace Manager production ready?
原标题:

I m exploring options for implementing a large-scale temporal database. There will likely be billions of records managed with minimal temporal churn, and I d like a vendor implemented solution to avoid placing too much responsibility in the application(s) that will populate, update, and query the warehouse.

Oracle Workspace Manager is one potential solution I m looking at, but I ve gotten the impression from online research that OWM isn t practical for a production system. Does anyone have any experience with using OWM for a temporal database, in particular using the TSQL2 constructs?

Many thanks.

问题回答

I have heard that PostgreSQL has a decent support for bi-temporal databases so you may try to do something with it.

I m currently also trying to find the best way to implement a large-scale database, and am making you question my favorite.





相关问题
Table design for spatio-temporal data

I am interested in best practices for designing relational DB tables for holding spatio-temporal data. Specifically data that will be kept in such tables are custom geometries that have certain ...

Storing object graph as of date in a database

I m going to try to keep this question database agnostic, but I have an interesting problem that I need to tackle and I thought I d open up the floor for suggestions and feedback. I need to be able ...

比较时间序列

我试图总结一下我的任务,并想知道,是否有标准的方式来做这项工作,还是一些有用的图书馆。

Is there an SQL database that can rollback in time?

I am looking for an SQL database of some type that is entirely based around the concept of time, just like those that are geo-centric, relationship-centric, etc. My main wish is that I can make ...

Temporary group membership tally - Any clever way to do it?

I m building a website. It has groups that users can join. The difference between this and "normal" groups is that membership is temporary - when a user joins a group, he decides the length of ...

Is Oracle Workspace Manager production ready?

I m exploring options for implementing a large-scale temporal database. There will likely be billions of records managed with minimal temporal churn, and I d like a vendor implemented solution to ...

热门标签