February 11, 2006 at 1:52 am
What are the important criteria in accessing database performance? For example , if the user wants to know which database has the best/strong perforrmance, (Oracle, MS-SQl, MySQL, IBM DB2,SyBase.. etc...) what criteria should be accessed?
February 11, 2006 at 9:03 am
Anymore, performance is more a matter of application and database design rather than platform. Between DB2, Oracle, and SQL Server all of them have the ability to scale as high as you need, given the right hardware and a good design.
That's not to say that an application that works great on one can be picked up whole and dumped on another and you should expect it to work great. Each platform has a different architecture and thus, if you want to take advantage of a given platform's strengths, you'll have to design your database/application to take advantage.
The specifics of those advantages and how to leverage them is far too large a topic to tackle here.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
February 11, 2006 at 11:48 pm
Hi I'm newbie in database and if i want to use the database for my application development for example, which factors should i need to consider and how can i decide which database is suitable for my application? Is it depends on the application or depend on what?For example if want to use ASP, PhP or etc.. which DB is suitable?what are their strong performance?for Visual Basic,C++ or etc.. which is suitable.what are their strong performance?
February 11, 2006 at 11:49 pm
Hi I'm newbie in database and if i want to use the database for my application development for example, which factors should i need to consider and how can i decide which database is suitable for my application? Is it depends on the application or depend on what?For example if want to use ASP, PhP or etc.. which DB is suitable?what are their strong performance?for Visual Basic,C++ or etc.. which is suitable.what are their strong performance?
February 13, 2006 at 2:00 pm
I would humbly suggest that allowing your programming language to dictate your choice of DBMS is not the way to go. Almost any programming language, and all of those that you listed, can be used against any of the major DBMS platforms, and I am unaware of any special advantage that is imparted by a specific combination.
By far the largest determining factor of both performance and function, will be the design of the database and the application.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
February 14, 2006 at 1:45 am
There cannot be a general answer. What are you going to use it for?
If it is to be deployed as part of an embedded device than there are specialist systems designed for this.
If it is for home use or part of a shrinkwrap application for home users, you might go for Access or MySQL.
For medium to large scale commercial applications, perhaps SQL Server or Oracle.
For huge databases, Oracle MAY have the edge.
[The above are examples - not recommendations]
Is security critical, and in what respect?
BUT, it depends entirely on what you are doing and what you mean by performance. The criteria depend on the application, its intended purpose, architecture and method of deployment. Also consider maintainability and, of course, costs both capital and ongoing cost of ownership.
You need to set out all your system performance requirements (which you need anyway both for design and ultimate acceptance criteria), determine the implications of these for database selection criteria, apply weighting factors to each and then undertake an objective selection process. Alternatively, I suspect for the majority of projects, just use the one in which you have expertise or which the company already uses!
February 15, 2006 at 4:34 am
The most important duty of a DBA is to Normalize the relation as far as possible.
if your data is normalized then you can pick up the important decission in time.??
February 15, 2006 at 7:08 am
Speaking more to having worked with Oracle, DB2, Informix (I believe now owned by IBM and name changed), Sybase, MS SQL Server and a host of other types I prefer MS SQL Server. However from a perfomance standpoint I am not sure there is one clear winner as each does a great job and build on many, many years of experience. I prefer MS over th others due to the out of the box toolset, feature sets (reporting, notification, integration, analysis services) and the simplicity of install and setup. Also, the pricing has been much better under the MS umbrella so easier to suggest the cost. Look at the corporate environment for your application more than anything as someone will have to support it as well as the need to leverage existing technologies already in the company that have more capacity available. You can write to run anywhere for the most part but if you have a clear choice of whwre you are going make sure you try to utilize the full power of the features available on the platform you choose and be aware of potential need to port to other platforms or not (but even then have a plan).
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply