Linux Help
guides forums blogs
Home Desktops Distributions ISO Images Logos Newbies Reviews Software Support & Resources Linuxhelp Wiki

Welcome Guest ( Log In | Register )



Advanced DNS Management
New ZoneEdit. New Managment.

FREE DNS Is Back

Sign Up Now
 
Reply to this topicStart new topic
> Oracle
Robert83
post Apr 5 2004, 03:15 AM
Post #1


Its GNU/Linuxhelp.net
*******

Group: Support Specialist
Posts: 1,439
Joined: 3-January 04
From: Germany
Member No.: 2,069



Hi,

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

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

Sincerely
Robert B


--------------------
Robert Becskei
robert83@linuxhelp.net
--------------------
May the source be with us!
--------------------
AMD X2-3800 @ 2400Mhz
2048MB DDR 400Mhz
DFI Lanparty UT4 NF4 ULTRA-D
GeForce 7800GT
250GB+250GB
Pioneer DVD-RW
17inch Samsung Syncmaster 757NF
WinXP Pro (SP2)/ CentOS 4.3
--------------------
Go to the top of the page
 
+Quote Post
hughesjr
post Apr 5 2004, 05:55 AM
Post #2


Its GNU/Linuxhelp.net
*******

Group: Admin
Posts: 3,433
Joined: 25-July 03
From: Corpus Chrsiti, TX, USA
Member No.: 1,151



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.


--------------------
Johnny Hughes
hughesjr@linuxhelp.net
Enterprise Alternatives: CentOS, WhiteBoxEL
Favorite Workstation Distros (in order): CentOS, Gentoo, Debian Sarge, Ubuntu, Mandrake, FedoraCore, Slackware, SUSE
Favorite Server Distros (in order): CentOS, WhiteBoxEL, Debian Sarge, Slackware, Mandrake, FedoraCore, Gentoo, SUSE
Go to the top of the page
 
+Quote Post
hughesjr
post Apr 5 2004, 05:57 AM
Post #3


Its GNU/Linuxhelp.net
*******

Group: Admin
Posts: 3,433
Joined: 25-July 03
From: Corpus Chrsiti, TX, USA
Member No.: 1,151



Microsoft SQL server is another example of an RDBMS system.


--------------------
Johnny Hughes
hughesjr@linuxhelp.net
Enterprise Alternatives: CentOS, WhiteBoxEL
Favorite Workstation Distros (in order): CentOS, Gentoo, Debian Sarge, Ubuntu, Mandrake, FedoraCore, Slackware, SUSE
Favorite Server Distros (in order): CentOS, WhiteBoxEL, Debian Sarge, Slackware, Mandrake, FedoraCore, Gentoo, SUSE
Go to the top of the page
 
+Quote Post
Hemant
post Apr 5 2004, 03:09 PM
Post #4


RMS is my Hero
******

Group: Support Specialist
Posts: 782
Joined: 6-October 02
From: Trichy,INDIA
Member No.: 29



MySQL is another example....of Database Package....And they say...
PHP-Mysql-Apache-Linux
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???


--------------------
Hemant Kumar
user posted image
hemant@linuxhelp.net
Go to the top of the page
 
+Quote Post
hughesjr
post Apr 5 2004, 07:05 PM
Post #5


Its GNU/Linuxhelp.net
*******

Group: Admin
Posts: 3,433
Joined: 25-July 03
From: Corpus Chrsiti, TX, USA
Member No.: 1,151



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 8.1.7.4. 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 )


--------------------
Johnny Hughes
hughesjr@linuxhelp.net
Enterprise Alternatives: CentOS, WhiteBoxEL
Favorite Workstation Distros (in order): CentOS, Gentoo, Debian Sarge, Ubuntu, Mandrake, FedoraCore, Slackware, SUSE
Favorite Server Distros (in order): CentOS, WhiteBoxEL, Debian Sarge, Slackware, Mandrake, FedoraCore, Gentoo, SUSE
Go to the top of the page
 
+Quote Post
Hemant
post Apr 6 2004, 03:18 AM
Post #6


RMS is my Hero
******

Group: Support Specialist
Posts: 782
Joined: 6-October 02
From: Trichy,INDIA
Member No.: 29



I have been using mysql...since a long time...i know that postgresql is a bit more powerful..than mysql..but still..it's(postgresql) integration with PHP and Apache...is 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....


--------------------
Hemant Kumar
user posted image
hemant@linuxhelp.net
Go to the top of the page
 
+Quote Post
hughesjr
post Apr 6 2004, 06:10 AM
Post #7


Its GNU/Linuxhelp.net
*******

Group: Admin
Posts: 3,433
Joined: 25-July 03
From: Corpus Chrsiti, TX, USA
Member No.: 1,151



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).


--------------------
Johnny Hughes
hughesjr@linuxhelp.net
Enterprise Alternatives: CentOS, WhiteBoxEL
Favorite Workstation Distros (in order): CentOS, Gentoo, Debian Sarge, Ubuntu, Mandrake, FedoraCore, Slackware, SUSE
Favorite Server Distros (in order): CentOS, WhiteBoxEL, Debian Sarge, Slackware, Mandrake, FedoraCore, Gentoo, SUSE
Go to the top of the page
 
+Quote Post
Hemant
post Apr 6 2004, 10:21 PM
Post #8


RMS is my Hero
******

Group: Support Specialist
Posts: 782
Joined: 6-October 02
From: Trichy,INDIA
Member No.: 29



Our use mysql..is pretty simple..Actaully i am a member of my college Web-Team..Checkout my college site..here

So basically we provide all the students and staff with an nterface..so that they can enter information about themselves..
And database doesn't changes much..excpet..at 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 implement..it on my college server..

Thanks..for valuable suggestions...


--------------------
Hemant Kumar
user posted image
hemant@linuxhelp.net
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 13th December 2017 - 02:30 AM