Help - Search - Members - Calendar
Full Version: Oracle
Linuxhelp > Support > Technical Support

I've got a few questions about Oracle...

1.what is oracle? it something similiar to samba, I mean ,...can a windows computer see it, and run programs from it?

Robert B
Oracle is a company that produces a Relational Database Management System (RDBMS) (at least older versions were). Now Oracle produces applications for Customer Relationship Management(CRM) and Enterprise Resource Planning(ERP) that run in their database...or you can get other HR, ERP, CRM applications an run them in an Oracle database system.

Here is a link for Oracle on Linux. They also make products for UNIX (Solaris, HP-UX, AIX, UnixWare, etc.) and Windows.

The Oracle database is basically a more mature version of PostGreSQL or Firebird. (these are free RDBMS systems for Linux). Most large RDBMS systems are Oracle or IBM DB2 databases.

MySQL is developing towards a full RDBMS system and the new MySQL MaxDB (formerly maintained by SAP) is a RDBMS system with stored procedures, triggers, etc. As they move all the MAX features into their other product, it to will be a fully functional RDBMS.
Microsoft SQL server is another example of an RDBMS system.
MySQL is another example....of Database Package....And they say...
is a deadly combination...A revolution that is sweeping entire Net World..
I don't know the reality...Here in our college we use this combination..
And i feel it is really great..But Mysql doesn't support OOP(object oriented programming) features of SQL.ANd there are few other limitation.

But it seems that Oracle is lately pusing Linux on thier Datbase Servers...They prefer Linux.
What say you hughesjr???
It is really hard to find the UNIX oracle stuff on their site right now. Oracle is indeed pushing Oracle on Linux (although it's on Enterprise Linux).

MySQL is just starting to do some of the Programming aspects of an RDBMS ... they are adding stored procedures, etc. The MySQL MaxDB is pretty good, and they are rolling alot of this functionallity into the standard MySQL product. After they do, it will be much better.

Of all the opensource databases, I like FireBird the most. PostGreSQL is also good. Both are more full featured than MySQL ... but MySQL is great for a LAMP (Linux-Apache-MySQL-PHP) server, and there are many products for it.

I also use MySQL on my MythTV PVR.

MySQL is OK (FireBird and PostGreSQL are better databases, but have less things pre written for them) ... but Oracle and DB2 are both much better than all the open source alternatives right now (in my opinion).

And as far as stability is concerned, I don't think anything can rival UNIX. I have an HP-UX sever that is 8 years old. It has been on all the time during that 8 year period (I mean, I reboot after major software upgrades .. but it has never been down). I did have a RAID drive fail, but it was just a switch the drive while powered up event.

I have upgraded the OS from HP-UX 10.20 to 11.0 and 11i upgraded the database from Oracle 7.3 to 8.05 to The hardware has moved from (2) 32-bit RISC to (4) 32-bit RISC to (6) 64-bit RISC processors and the memory has moved from 1GB to 2GB to 8GB.

This system is absolutely ROCK solid ... I have never seen anything like it! (Of course, now it is going to crash wink.gif )
I have been using mysql...since a long time...i know that postgresql is a bit more powerful..than mysql..but's(postgresql) integration with PHP and limited...

But i have never heard of Firebird RDBMS...i knew that only as a browser...How...this thing Firebird integrates...with Apache and PHP....
FireBird is an opensource project based on the Borland Interbase 6 (which was relased as open source in August 2000).
Neither PostGreSQL or FireBird (or Oracle for that matter) have as many things prebuilt to interface with apache.

MySQL is very good at that.

But, you can use PHP (after it is compiled with the proper support) and apache to send SQL statements to all the RDBMS database types.

The programming for each is very similar, after PHP is properly setup.

However, there are many more examples (and programs) already published that use MySQL than use any of the others.
So specifically for apache / PHP integration, MySQL is probably the best product currently. If you are going to develope reports, do lots of data analysis, or want to use triggers and stored procedures, then I would recommend one of he other databases.

Personally, I can't live without stored procedues and triggers. In my database setup, records are added to my tables from another site's application. After an insert of a record by them into our interface table, I need to kick off a process to add that record (and do things to several tables) to our applications. An after insert trigger on the interface table kicks off a stored procedure to make all the required changes.

Without the ability to do either stored procedures or triggers, MySQL is worthless in a large RDBMS environment (in my opinion)...except for single transactions driven by website.

MySQL 5 has stored procedures and MySQL 5.1 is supposed to have triggers (see this, but since those technologies are so new in MySQL, I would wait several upgrades before I used them in Mission Critical deployments).
Firebird and PostGreSQL both do triggers and stored procedures (as does Oracle and IBM DB2).
Our use pretty simple..Actaully i am a member of my college Web-Team..Checkout my college

So basically we provide all the students and staff with an that they can enter information about themselves..
And database doesn't changes the end of academic session...when final year students leave and new students come in.
So for them proper data entry must be done..

Apart from that we use database for college notice board,placement papers...and stuff like..that..

But certaily..i will first try Firbird on my computer..and depending on how things goes..we may on my college server..

Thanks..for valuable suggestions...
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2018 Invision Power Services, Inc.