group projects in mode ANSI
Posted in 1992
I would like comments on the "right" way to deal with the following: We are using informix to manage a medium sized time-series database (right now it is 800 points hourly ). The best model we have found for this is one table per point (timestamp,value). We have analysis, QA, and reporting routines that munge these reports together. We chose to use mode ANSI for implicit transactions and better default access security. Now, the "ownername". restrictions of mode ANSI are biting us. To keep the programming bearable, we have chosen a uniform "owner" for the tables that the routines will touch. The problem is that sometimes these routines need to create a table (If a QA routine finds some bad data it needs to pump it out to a bad_table for that channel - if the table doesnt exist it will create it.) Creating that table with the mother approved "ownername" is turning out to be painful. This strikes me as a common scenario - what is the usual way of working with it? RjS rjsparks@loanstar.tamu.edu