Used to be called internet file system. You can write code to it (java), or you can mount it as NFS, NetBeui, access thru FTP, etc. The framework looks interesting, you can define extended atributes, perform searches, has a pretty complete ACL system, etc. Obviously, runs on Oracle databases only:). Might need work to integrate with front end apps.
Did you notice that both Tanenbaun and Linus comments are still "under construction"? They have been that way for ages. They sure had time to post a reply. I wonder why they didn't do the same they did with the press...just link them. Well, really, I don't wonder that much:)
errr, no. You musn't run setup as root (otherwise, most likely it wont work). Neither in the DB nor the App server setup. You must install it with the user that will run the services later. All you run as root is a.sh close to the end of the instalation, that basically sets up some permissions on the files and such (you can read it, its not big deal). And yes, the installer can get a bit heavy sometimes, but in anything decent (read: minimum specs required) it usually works ok. If you are installing, read the release notes, the pre-install and try not to skip anything. It usually works ok, and in the latest versions the notes cover up everything needed.
I'm not a DBA, and I've installed both the DB and the app server (which is a real pain in the ass to install) many times, and I've found that USUALLY if you follow the pre-instalation (on the same CD) it tends to work 9.5 out of 10 times. Well, 7 out of 10 for the App server, but those docs are getting better lately too:) Btw, I digged some notes for those bored that wants to install on nonsupported platforms:
1.Compiler (GCC Version) 2.Libraries (Lib gcc mainly) 3.Installed Packets (available packets) for some misc OS utilities.
Usually, 95% of the work of making Oracle work in some other enviroment (not certified) is figuring out the right convination from those 3. You can imagine the beast does some low lvl stuff that gets broken easily.
Err, sorry, but most tools have been Java for a while. End user tools are a different thing tho, and even then most of them are going Java now. What's left on Windows only for the moment is SCM/Designer, Discoverer, Warehouse Builder and some other stuff. Discoverer got a web version for 1/2 the functionality tho. DB Admin tools are either web based or Java.
Arcane knowledge? If you install it on the supported linux versions, the process is pretty well documented. Going for a non-supported config will be a bit of pain, but there's information around the net with help on how to do it. Considering the level of complexity of the software, I woudn't expect otherwise. BTW, its supported under RH ES, Suse SLES and United Linux. I've seen it installed under RH9 and some other platforms with some tweaking. Obviously, who would run a production database on unsupported OS escapes to me.
It sucks. Its pretty innocent, besides some soft-penises and some kissing, not much more. AND, the game is boring too. Its really a sims ripoff (I dont understand how they managed to publish that piece of crap without being sued).
And, what pisses me off, the only gay man alternative you get is ugly and a sissy. I was even considering hacking the sprites/models just to spice the game a little bit more:).
In fact, IBM is saying that as SCO hasn't already presented evidence, even after being ordered twice by the judge, they shouldn't be alowed to present any now... like, you had time to put up, now just shut up. Its even worst after the executives kept talking trash (read: we have all the evidence, millions of lines of code, rockets scientist checking the code, and a long etcetera).
Dig up a bit in the forums. I'm using a Athlon XP optimized build (with all that black magic voodoo compiler switches). If you have the hardware to support it, you can REALLY feel the difference.
The default value thing I was mentioning had to do with altering a table that has data already in it.
Again, in Oracle:
alter table foo (add column bar varchar2(50) default 10)
The rule is, the columns you add must be either nullable or have a default. Check the manual, you might be amused on the things you can do.
I *do* perform the primary key checks before I ever issue an insert. Why? I don't like to parse db error message strings, so I perform N+2 select queries beforehand to ensure that if the insert *would* fail, [...]
You are kidding me, Right? so instead of doing a single insert, with a single table lookup, you turn it into N table lookups for each partial key? That's a really bad practice performance-wise.It multiplies the transaction load (hardware resources) needed. This includes memory, cpu, disk, etc. Parsing the message is much cheaper, especially parsing it on the frontend.
And, you are most certainly correct! I do charge by the hour, because only God Himself knows how long anything is going to take
That must give you a lot of time to read slashdot. You are lucky, as you seem to can get the users to pay for something for which they dont know how long it will take to code...and lucky because your user didn't find out someone with some more proper DB design techniques which might get the job done at a fraction of the price with a more solid data model.
I mean, this stuff you are writing about can work for a small table model, with very little data, but as soon as you starting to scale the model it gets really ugly really soon.
I work for an Oracle partner company, and we tend to use the Oracle stack. I've found Oracle Designer to be quite adecuate for the task. We use it both for logical and physical data model, and for the script generation. In fact, we also use the tool for frontend generation in some cases. It also has some pretty good code repository tools, with versioning, multibranches, dependency and impact analysis and so forth. A bit quirky, not to cheap (its part of a bundle of dev tools) but quite a nice thing for Oracle DBs.
One key point here is that most dbs that I've dealt with (Informix, MySQL, SQL Server & Oracle) do not let you specify the default value for a new column automatically. That means you're gonna have to script the modifications to insert/compute the new column anyway.
Dont really know about the rest, but in Oracle you just do a
Not quite sure, but this sounds like ANSI92 to me.
Of course, maintaint anything else than a 5 tables model by hand is a big PITA.
And also, as a mini-rant, I have to say that the use of foreign keys has *never* been necessary in any db I've designed (and I have created very complex db apps with 30-70 well-connected tables).
Well, that's just plain wrong. Declarative referential integrity saves a LOAD of work, makes your data model self-documenting, easier to maintain, and believe me, most modern databases know have query optimizers that work wonders on them.
Of course, unless you charge by the hour, want to have to code on each of your 50 tables for such a basic thing as referential integrity, and want to make your database a pain to work with. If that's your objetive, you can also code primary key logic too:D
My point here is that your accessor logic (so-called middleware) is what manifests the "foreign" relationship and if that's screwed then your app just doesn't work. Slowing the db down to do all that referential integrity is a waste of time. You've either got the middleware right or not.
It really doesn't slow things much, as long as you have the proper indexes, which you should have in any case, as usually foreign keys in a data model represent relationships you are going to use to join different tables... This is, unless you are working with a very toy-like data model with 100 records on each table.
Better yet, they can do the same SCO did in the IBM case... first print it out, and then when requested a computer readable version, scan the printouts and send them PDFs:)
Slashdot Mirror
Blade server
And its a deadly weapon!
Used to be called internet file system. You can write code to it (java), or you can mount it as NFS, NetBeui, access thru FTP, etc. The framework looks interesting, you can define extended atributes, perform searches, has a pretty complete ACL system, etc. :). Might need work to integrate with front end apps.
Obviously, runs on Oracle databases only
Did you notice that both Tanenbaun and Linus comments are still "under construction"? They have been that way for ages. They sure had time to post a reply. :)
I wonder why they didn't do the same they did with the press...just link them. Well, really, I don't wonder that much
errr, no. You musn't run setup as root (otherwise, most likely it wont work). Neither in the DB nor the App server setup. You must install it with the user that will run the services later. All you run as root is a .sh close to the end of the instalation, that basically sets up some permissions on the files and such (you can read it, its not big deal).
And yes, the installer can get a bit heavy sometimes, but in anything decent (read: minimum specs required) it usually works ok.
If you are installing, read the release notes, the pre-install and try not to skip anything. It usually works ok, and in the latest versions the notes cover up everything needed.
Actually, Oracle is OS agnostic. They run everywhere (bah, mostly. Win, Linux, Hp Ux, Solaris, and a big etcetera).
They do pitch linux a lot lately.
I'm not a DBA, and I've installed both the DB and the app server (which is a real pain in the ass to install) many times, and I've found that USUALLY if you follow the pre-instalation (on the same CD) it tends to work 9.5 out of 10 times. :)
Well, 7 out of 10 for the App server, but those docs are getting better lately too
Btw, I digged some notes for those bored that wants to install on nonsupported platforms:
Installing Oracle 9i on RedHat Linux 7.1, 7.2, 7.3, 8.0, 9, Red Hat Advanced Server 2.1, and on Red Hat Enterprise Linux Advanced Server 3 (RHEL AS 3). Fedora core is around there too.
For what I've seen so far, what changes is:
1.Compiler (GCC Version)
2.Libraries (Lib gcc mainly)
3.Installed Packets (available packets) for some misc OS utilities.
Usually, 95% of the work of making Oracle work in some other enviroment (not certified) is figuring out the right convination from those 3. You can imagine the beast does some low lvl stuff that gets broken easily.
Err, sorry, but most tools have been Java for a while.
End user tools are a different thing tho, and even then most of them are going Java now. What's left on Windows only for the moment is SCM/Designer, Discoverer, Warehouse Builder and some other stuff. Discoverer got a web version for 1/2 the functionality tho.
DB Admin tools are either web based or Java.
Arcane knowledge?
If you install it on the supported linux versions, the process is pretty well documented.
Going for a non-supported config will be a bit of pain, but there's information around the net with help on how to do it. Considering the level of complexity of the software, I woudn't expect otherwise.
BTW, its supported under RH ES, Suse SLES and United Linux. I've seen it installed under RH9 and some other platforms with some tweaking. Obviously, who would run a production database on unsupported OS escapes to me.
humm...how? :)
Leisure Suit Larry in the Land of Lounge Lizards?
I'll save you some time:
:).
It sucks.
Its pretty innocent, besides some soft-penises and some kissing, not much more.
AND, the game is boring too. Its really a sims ripoff (I dont understand how they managed to publish that piece of crap without being sued).
And, what pisses me off, the only gay man alternative you get is ugly and a sissy. I was even considering hacking the sprites/models just to spice the game a little bit more
It sounds more like he would rather forbid them of publishing that kind of game at all. I mean, not on stores, not online, what's left?
In fact, IBM is saying that as SCO hasn't already presented evidence, even after being ordered twice by the judge, they shouldn't be alowed to present any now ... like, you had time to put up, now just shut up. Its even worst after the executives kept talking trash (read: we have all the evidence, millions of lines of code, rockets scientist checking the code, and a long etcetera).
"Vapor-whore?"
Meanwhile the modern Windows user is used to looking at stuff like this
Does anyone actually look at the control panel like that instead of changing it to classic view?
I'm using the Firefox now, but u should be able to find custom builds for the big zilla in the this forum
Dig up a bit in the forums. I'm using a Athlon XP optimized build (with all that black magic voodoo compiler switches). If you have the hardware to support it, you can REALLY feel the difference.
The default value thing I was mentioning had to do with altering a table that has data already in it.
Again, in Oracle:
alter table foo (add column bar varchar2(50) default 10)
The rule is, the columns you add must be either nullable or have a default. Check the manual, you might be amused on the things you can do.
I *do* perform the primary key checks before I ever issue an insert. Why?
I don't like to parse db error message strings, so I perform N+2 select queries beforehand to ensure that if the insert *would* fail, [...]
You are kidding me, Right? so instead of doing a single insert, with a single table lookup, you turn it into N table lookups for each partial key? That's a really bad practice performance-wise.It multiplies the transaction load (hardware resources) needed. This includes memory, cpu, disk, etc. Parsing the message is much cheaper, especially parsing it on the frontend.
And, you are most certainly correct! I do charge by the hour, because only God Himself knows how long anything is going to take
That must give you a lot of time to read slashdot. You are lucky, as you seem to can get the users to pay for something for which they dont know how long it will take to code...and lucky because your user didn't find out someone with some more proper DB design techniques which might get the job done at a fraction of the price with a more solid data model.
I mean, this stuff you are writing about can work for a small table model, with very little data, but as soon as you starting to scale the model it gets really ugly really soon.
For instance, on a string field, why not just use ""?
In fact, in Oracle last time I checked "" IS null
Odd, eh?
I work for an Oracle partner company, and we tend to use the Oracle stack. I've found Oracle Designer to be quite adecuate for the task. We use it both for logical and physical data model, and for the script generation. In fact, we also use the tool for frontend generation in some cases. It also has some pretty good code repository tools, with versioning, multibranches, dependency and impact analysis and so forth.
A bit quirky, not to cheap (its part of a bundle of dev tools) but quite a nice thing for Oracle DBs.
One key point here is that most dbs that I've dealt with (Informix, MySQL, SQL Server & Oracle) do not let you specify the default value for a new column automatically. That means you're gonna have to script the modifications to insert/compute the new column anyway.
:D
Dont really know about the rest, but in Oracle you just do a
create table foo (bar varchar2(10) default 'whatever')
Not quite sure, but this sounds like ANSI92 to me.
Of course, maintaint anything else than a 5 tables model by hand is a big PITA.
And also, as a mini-rant, I have to say that the use of foreign keys has *never* been necessary in any db I've designed (and I have created very complex db apps with 30-70 well-connected tables).
Well, that's just plain wrong. Declarative referential integrity saves a LOAD of work, makes your data model self-documenting, easier to maintain, and believe me, most modern databases know have query optimizers that work wonders on them.
Of course, unless you charge by the hour, want to have to code on each of your 50 tables for such a basic thing as referential integrity, and want to make your database a pain to work with. If that's your objetive, you can also code primary key logic too
My point here is that your accessor logic (so-called middleware) is what manifests the "foreign" relationship and if that's screwed then your app just doesn't work. Slowing the db down to do all that referential integrity is a waste of time. You've either got the middleware right or not.
It really doesn't slow things much, as long as you have the proper indexes, which you should have in any case, as usually foreign keys in a data model represent relationships you are going to use to join different tables...
This is, unless you are working with a very toy-like data model with 100 records on each table.
Better yet, they can do the same SCO did in the IBM case... first print it out, and then when requested a computer readable version, scan the printouts and send them PDFs :)
Bzzzzzzzt, wrong. In Johnny Mnemonic it was dataglobes and VR googles, not floating-in-the-air data input.
1. Ball grandma
2. ??????
3. Profit!