It appears that there are now temporal databases and a query language similar to SQL used to model historical data. However we don't use those DB packages.
Johnherman,
It would seem that probabillity of default would be the obvious fact. Thing I should mention is that this is a OLTP not an MIS system used for reporting so I don't want to use this design to run reporting type queries. It is just so that I can get a snapshot of what the data...
I considered using data warehousing modelling but this presumes that the facts are changing daily. The changes I have are probably going to be once a month so to hold the snapshot each day would be overkill I think. Here is the data model I am playing with. Tried my best to model!
Grades...
I have an application which has a series of semi static tables that contain reference type data. I need to be able to able to create an historic picture of the tables and relations at any given point in time. One way of doing this is to use effective_from and effective_to columns in each of...
Has anyone successfully used the Object Oriented features in Ora 8i? In what situations would you use these features above the traditional techniques? Are there any performance problems with using the OO features?
Thanks
Ketan
Thank you Nigel for your tips, I tried to find the document you suggested on Metalink but could not find it there in fact there has been a thread raised on metalink for just the same problem. Do you by any chance have the documnet yourself. If so would be kind enough to email to me...
Does anybody know of any reasonably priced DBA monitoring tools that offer you general DB performance monitoring views of a DB i.e. Cahch hits/misses, I/O, CPU etc. Plus tablespace de-fragmentation, tablespace sizing tools to. I know there is enterprise manager and SQL/Navigator products I was...
Although in principle the idea of materialise views is great, I found that in practice there are certain restrictions that can prove annoying. The main problem I faced was using the fast refresh mechanism to refresh the mat view when the detail tables had been changed. If you performed the...
I think I remember reading that in 8.1.6 there is a package that allows you to send emails directly from PL/SQL. This is going on memory so please excuse if I'm mistaken. Maybe something called DBMS_SMTP. I don't have the doc at hand to check. If this is the case you could create the trigger...
Although in principle the idea of materialise views is great, I found that in practice there are certain restrictions that can prove annoying. The main problem I faced was using the fast refresh mechanism to refresh the mat view when the detail tables had been changed. If you performed the...
Hi All,<br><br>I have an row level after insert trigger on table DEPT which calls a stored procedure to dynamically create a trigger on a different table based on the values inserted into table DEPT. I get the following error :<br><br>ORA-04092: cannot COMMIT in a trigger<br>ORA-06512: at...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.