Re: Confused by "Database" concept in Informix

"David E. Grove" <david_grove@correct.state.ak.us> wrote in message news:<1034pfta6o4r1be@corp.supernews.com>... > > Of course, to me, the Informix model seems more, well... elegant. It just > seems "more right" that the term "database" should not include the notion of > processes or threads. Etc., etc. > > But, then again, I'm sure if I had originally worked in Oracle, I would > likely perceive Informix's "one set of processes for multiple databases" as, > well... "messy". As I've tried to learn Informix, I keep thinking that Oracle is more "natural" for the very reason that all the data and processes are encapsualated together; while Informix everything seems all thrown together... yeah sort of messy. I suspect it's just what you were first trained on - "Mother Tongue" as it were - and it's difficult to change the terms of reference. > Bottom line: I gotta do what I gotta do (what the boss wants). So, I also > gotta learn Oracle/Informix "translation". > > DG Yep me too. We also have a couple of Sybase and SQL Server DB's around the place - I probably won't be able to avoid those forever. As I've been writing this it occurs to me that a really useful site would be one where common DBA tasks were listed (create DB, add space, move files, etc.) and solutions were provided for each of the RDBM systems. That would be a useful matrix methinks. I'd do it if I had another 24 hours every day.

"Chris Bullivant" <cbullivant@orange.net.au> wrote in message news:21e62a09.0402171649.1c9dc7d9@posting.google.com... > "David E. Grove" <david_grove@correct.state.ak.us> wrote in message news:<1034pfta6o4r1be@corp.supernews.com>... > > > > Of course, to me, the Informix model seems more, well... elegant. It just > > seems "more right" that the term "database" should not include the notion of > > processes or threads. Etc., etc. > > > > But, then again, I'm sure if I had originally worked in Oracle, I would > > likely perceive Informix's "one set of processes for multiple databases" as, > > well... "messy". > > As I've tried to learn Informix, I keep thinking that Oracle is more > "natural" for the very reason that all the data and processes are > encapsualated together; while Informix everything seems all thrown > together... yeah sort of messy. > I suspect it's just what you were first trained on - "Mother Tongue" > as it were - and it's difficult to change the terms of reference. > I was trained as a musician. When I was in school, I used to hear the statement - "Well, I don't know much about music, but I know what I like". Must have heard this thousands of times. I always felt like correcting them by replying .... "No - you don't know much about music, but you like what you know." ;-)