atleast 10 difference between sql and oracle.greenspun.com : LUSENET : OpenKnowledge : One Thread
Qestion1. WHATS THE DIFFERENCE BETWEEN ORACLE AND SQL GIVE ME AS MUCH AS POSSIBLE. QUESTIONS2. WHAT IS DEPENDENT OBJECT IN VB. QUESTIONS3.WHAT DO YOOU MEAN BY DYNAMIC WEB PAGE. QUESTION4.HOW CAN YOU DISTRIBUTE YOUR ASP PAGES.
-- prem kumar (firstname.lastname@example.org), May 07, 2002
WHATS THE DIFFERENCE BETWEEN ORACLE AND SQL and what is the advantage and disadvantage of each one
-- Basma Tobia (email@example.com), October 16, 2002.
1) sql basically using multithreading concept where oracle using multiprocessor 2) workable with preemptive operating system which provide multi threading. 3) Oracle using special hardware configuration where in sql you don`t need any special hardware 4) oracle using for high database handling like banking etc... 5) in Sql there is limitation for number of user that connected with sql server at a time.
-- amit malhotra (firstname.lastname@example.org), April 12, 2003.
Oracle is more concerned with Security of the Database.
-- Ananthakrishnan (email@example.com), June 30, 2003.
what is the dependent object in vb
-- aruna (firstname.lastname@example.org), November 11, 2003.
1) How To access the component from Java? 2) How to access the component from one sytem to another system? 3) In VB.NET .dll file is not a component. but C#.Net it is a component. y?
-- Surya (email@example.com), January 07, 2004.
1. Oracle runs on many platforms, SQL on Windows only 2. Oracle includes IFS (Internet File System), Java integration, SQL is more of a pure database 3. Oracle requires client install and setup (Not difficult, but very UNIX-like for Windows users) 4. SQL is #1 in Cost/Performance and overall Performance, although Oracle will refute that 5. Replication is much easier in SQL (I have been at clients where even the Oracle consultant couldn't get it working w/oracle) 6. Failover support in SQL is much, much easier 7. JDBC support is much better in Oracle, although Microsoft is working on it 8. ODBC support in both 9. SQL is ANSI-SQL '92 compliant, making it easier to convert to another ANSI compliant database, theoretically anyway (truth is every database has proprietary extensions). Oracle is generally more proprietary and their main goal is to keep their customers locked-in. 10. SQL natively supports ODBC, OLEDB, XML, XML Query, XML updates. Oracle natively supports proprietary connections, JDBC. Not sure about XML support though. 11. SQL Server is much easier to administrate, with GUI and command- line tools. Most of Oracle is command-line (Back in SQL 6.5 days I had a customer who was so proud that after a day's worth of work he had managed to script his database. I showed him how it was a 3 click operation in SQL ;-) 12. Oracle requires add-ons for transaction monitors, failover, etc. SQL has COM+, uses NT clustering and generally has everything built-in 13. SQL Analysis Services is included (A very powerful OLAP server). For Oracle it is a separate purchase.
-- Priya Ranjan Palai (firstname.lastname@example.org), March 18, 2004.