|
smartsoft (m)
|
hey guys, is it that people don't really use SQL SERVER that much and what is the future of SQL SEVER like  is like most people now prefer using ORACLE to SQL SERVER in your opnion do share with us please, or does it mean ORACLE has taken over SQL SEVER |
|
|
|
|
|
Fdeveloper (m)
|
I personally prefer Oracle mainly due to the fact that it supports several operating systems and not just Windows as is the case with SQL Server and this may be the reason why it appears to be more popular with organizations with very large databases as it means they can run on unix servers. Oracle however is more expensive and more complicated to install and configure. The following site is just one of many which gives a good comparison between the 2 databases: http://www.mssqlcity.com/Articles/Compare/sql_server_vs_oracle.htm |
|
|
|
|
|
Zahymaka (m)
|
PostgreSQL is the best open-source alternative to Oracle I've seen -- although MySQL is damn fast [Yahoo and several other big sites use it].
Unlike SQL Server, it runs on as many operating systems as Oracle -- probably more.
|
|
|
|
|
|
smartsoft (m)
|
i seeeeeeeee
|
|
|
|
|
|
sbucareer (f)
|
smartsoft, I don't particularly use SQL Server and wouldn't know much about its engine. I know that MS is not sleeping and must have provided some powerful features with their new SQL Server.
But oracle has done tremendous changes to their SQL Server. They have introduced new SQL language called PL/SQL that helps DBA to write efficient DML and automate processes with the Database engine.
Oracle has combined their database engine with Client/Server Application Server called Oracle 10g. Enterprise Web applications or ERP infrastructure comes in combination of:
1. Application server
2. Web Server/HTTP server
3. Database Server
Oracle is the most popular solution to this end. It is also recommended by FSA (Financial Services Authority) that controls the use and policies governing public funds and Banks in the UK.
Beside that it employs open source because it uses Java as their middleware solution and employ J2EE/JEE for their Enterprise application architecture.
SQL Server is and always a proprietary software like every other MS products. Their licence is very expensive but their benefit comes from the support MS renders its user i.e. patches and other bug/virus related issues. Bug and virus also makes MS very unpopular in commercial sector.
Remember that MS only build soft wares for Win32 API only, because of it proprietary policy. Oracle 10g has got every version of the 10g on different platform.
I am not an anti MS just that, I and millions of people out there believe that information should be available free of charge.
|
|
|
|
|
|
smartsoft (m)
|
thats quite intresting that Oracle is going places i for one like prefer oracle to SQ SERVER it only depend of what kinda application i'm really developing, basically most guys uses SQL SERVER on thier website, like MTN for instance uses that, but don't know by now if they have change to ACCESS why ppl like JAMB e.tc uses ACCESS, i just like oracle and i came accross a site which has a platform for Oracle Database, thats if you wanna use oracle on your Website they help in Setup up one for you and you can administer your stuff from their site.
|
|
|
|
|
|
Fdeveloper (m)
|
smartsoft, Just out of interest, how do you know what database MTN uses on their website? Are you an MTN employee by any chance?
Secondly, are you sure that anyone developing a medium sized commercial application would even consider using Access?
|
|
|
|
|
|
sbucareer (f)
|
In case you were wondering what is Oracle 10g. It is Oracle new software suite that encompasses database server 10.x, oracle application server/http server and web server engine that leverage time taken to setup these environments for web/enterprise application deployment.
In summary, it is only a big software that when downloaded and installed on any supported platform, you have all the necessary software and engine needed to develop and deploy web/enterprise application. The new 10.5g comes with jdeveloper, which is a powerfull integrated IDE for developing application and web application including database query or PL/SQL and UML etc
See Oracle site
|
|
|
|
|
|
smartsoft (m)
|
smartsoft, Just out of interest, how do you know what database MTN uses on their website? Are you an MTN employee by any chance?
Secondly, are you sure that anyone developing a medium sized commercial application would even consider using Access?
lol why woun't i know okay let me ask ya, what database does your Jamb site use |
|
|
|
|
|
sbucareer (f)
|
It be interesting to know where you got that knowledge from that JAMB and MTN uses Access and sequel server respectively smartsoft, but sometimes you can find out the database engine an organization use if their developers had developed a sloppy code that do not have a generic fault page.
Some sites, when their database server is down you will see an error message like could not connect to mysql server etc.
Smartsoft, when you said SQL Server do you really mean sequel server? Access by no means have the transaction capability and online capability like pooling manager and thread management. It is really for a very small application that two or three clients are going to use.
If you use Access for web app development, you will suffer these issues:
1. Deadlock
2. Synchronization problem
3. Poor Pool Management
4. Poor DML/DDL Management
5. Poor SQL
These are very serious issues with Access database, deadlock is an inter-blocking that occurs when two processes want to access a shared variables mutually locked by other processes.
Synchronization in database is the mechanism that controls how shared variables enter the critical region.
POOL Management, coordinates how the database engine manage multiple users by creating a pool of database object.
DML, Data Manipulation Language, believe Access do not have a every strong DML, i.e. triggers, besides the conceptual layer is kept secret from users due to its proprietary nature, so no one can really ascertain the nature of their Algorithm.
Like many serious database engines, they have their own SQL, like Oracle uses PL/SQL, Sequel server use Transact-SQL. However, all of these variations are based upon the industry standard ANSI SQL.
The reason MS invented sequel server was Access inability to cope with these issues above.
Finally, Access do not have rich DDL, which could be the main basis a database engine could be popular to the rest.
|
|
|
|
|
|
Fdeveloper (m)
|
@smartsoft, I have no idea what database JAMB or MTN use but sbucareer's observation is very valid and I guess that's how you know?
|
|
|
|
|
|
kitaun (m)
|
maybe that is the reason the Jamb database seems slow for the prospective candidates trying to submit their applications ?
|
|
|
|
|
|
smartsoft (m)
|
maybe that is the reason the Jamb database seems slow for the prospective candidates trying to submit their applications ?
hahahahahah true yarnings |
|
|
|
|
|
Panache (m)
|
My brother, comparing Oracle to SQL Server is like comparing a KIA with a Toyota. Both are cars, both performance separate the boys from the men. Oracle is more reliable and robust and more accepted than SQL Server. Also Oracle has invested a lot in portability and compatibility of Oracle software with many other systems and applications.
|
|
|
|
|
|
Panache (m)
|
FYI, Access is just a flat-file system. It's not advisable for any commercial use that targets a large user base.
|
|
|
|
|
|
chinedum
|
MSSQL Server is a baby when it comes to database SDKs. Yes! However, with version 2005, I'm afraid. The database master will have to go back and do something to Oracle to be able to meet up.
|
|
|
|
|
|
![Nairaland [Nigerian Forum] Home](http://www.nairaland.com/Themes/default/images/english/home.gif)
Author
