Re: informix vs oracle

Christopher wrote: > utkanbir compared IDS and that other thing: > >>3. Nologging operations: > > > IDS also allows non-logged tables, called RAW tables: > > The following is from the IDS 10 doc, because I can link directly to > the appropriate passage, but is true for IDS 7.31, 8.x, and 9.3 and > higher (not certain about 9.2): > > RAW tables are nonlogging permanent tables and are similar to > tables in a nonlogging database. RAW tables use light appends, > which add rows quickly to the end of each table fragments. > Updates, inserts, and deletes in a RAW table are supported but > not logged. RAW tables do not support indexes, referential > constraints, or rollback. You can restore a RAW table from the > last physical backup if it has not been updated since that > backup. Fast recovery rolls back incomplete transactions on > STANDARD tables but not on RAW tables. A RAW table has the > same attributes whether stored in a logging or nonlogging > database. > > RAW tables are intended for the initial loading and validation > of data. To load RAW tables, you can use any loading utility, > including dbexport or the High-Performance Loader (HPL) in > express mode. If an error or failure occurs while loading a > RAW table, the resulting data is whatever was on the disk at > the time of the failure. > > It is recommended that you do not use RAW tables within a > transaction. Once you have loaded the data, use the ALTER > TABLE statement to change the table to type STANDARD and > perform a level-0 backup before you use the table in a > transaction. > > This is from the Administrator's Guide: > http://publib.boulder.ibm.com/epubs/html/25122670/admin357.htm > > Raw tables are quite useful when loading but the lack of indexes, > referential constraints, and rollback can make other processing rather > tedious. > > Sincerely, > > Christopher Coleman > > President > Kansas City Informix Users Group > www.iiug.org/kciug > > Database Analyst > Medication Management > Mediware Information Systems, Inc. Similar functionality exists in Oracle. Perhaps I am missing something ... is there some point to this thread other than an invitation to a good old fashioned flame-war? -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond)