Re: Differences between the Microsoft and the Oracle SQL server

In article <4q63gi$l2j_at_server-b.cs.interbusiness.it> aiaspistoia_at_mail.promonet.it (aias) writes:
>
>Hi, what are the difference between the Oracle SQL and
>the Microsoft SQL?

The MS product is actually an evolution of the older Sybase version 4. It is simpler for novices to set up, but does not scale as well as Oracle (scale means to grow and become a larger system with more users). Oracle has a steeper learning curve and a greater need to have well (and expensively) trained technical personell. Technically, the major drawback for MS SQL is that it doesn't have row level locking. That means that whatever your programmers do, there will be situations where data access will be prevented due to unrelated records being locked. The MS SQL will likely be much cheaper in the short run, I would recommend Oracle if you plan on expanding. You might consider one of the PC front ends available for development.

The Web product market is in extreme flux, which will continue for at least the next couple of years. I would expect both SQL's will have many options to choose from, eventually shaking out to a few. Since it is impossible to know which Web products will be the winners, and the winning products will likely be able to handle either SQL DBMS, whatever you decide for a Web server interface will have to be redone, perhaps several times. So for now, you might as well use whatever product is recommended by the vendor of the SQL you choose.

jg

>
>I am going to restructure the informatic organization of an
>association. A part of the work requires the introduction
>of a Windows NT server that should contain administration
>and medical data. I think that, at the beginning, about 4-5
>PC clients will be used, while, in the future, more clients
>will be present and other two servers could be introduced
>in branch offices. I need a SQL server to manage data.
>The candidates are the Oracle SQL server and the Microsoft
>SQL server. I would appreciate any hints on this topic.
>I would know pros and cons of the two DBMS.
>
>Further, we are going to introduce a site on Internet and
>I think that we could use a WEB server either to allow
>Internet people to access our server either for internal pourposes;
>i.e. the staff could access the data on the server by HTML
>documents. According to the selected SQL, I will use the Oracle
>WEB server or the Microsoft WEB server.
>I would knows also pros and cons about this matter.
>
>I thank in advance anybody who will help me.
>
>Franco Scarselli

-- 
Joel Garry               joelga_at_rossinc.com               Compuserve 70661,1534
These are my opinions, not necessarily those of Ross Systems, Inc.   <> <>
%DCL-W-SOFTONEDGEDONTPUSH, Software On Edge - Don't Push.            \ V /
panic: ifree: freeing free inodes...                                   O