DBM502 Week 2 Individual Assignment
This paper will discuss and make comparisons on the markets top Database Management Systems (DBMS) currently available. The paper includes a table for side-by-side comparisons of feature sets and other factors required when making decisions on which DBMS to purchase and implement in a business. While this may not be a complete list of all available DBMS systems it will include important discussions on aspects required when evaluating any major application / system choice.
Currently in today's complex computer systems environment there are more choices available than ever before. While this is a huge advantage to the purchasing agent, it adds an enormous amount of work to the IT department tasked with specifying which DBMS is best for the organization. Making the wrong decision can definitely be a career-limiting move in more ways than one. The amount of resources and time invested in an endeavor such as development of a database needs to be take very seriously and fully researched prior to the first line code is written or the first data table specified. Choosing a DBMS is not as simple as looking at the specifications and finding the feature set you are interested in and then going with the lowest price option, while at first this may sound exactly like what most companies have done. There are things beyond the technical specifications that may require some in-depth thought and decision-making. While price plays a factor it is not the only factor when making a decision your company may have to live or die with. If price were the only factor, we'd all be trying to run MS Access for everything . Basing a decision solely on price could lead you down a path that turns out to be more expensive than investing in the proper DBMS initially after factoring in all the changes and work around that have to be implemented to accommodate a DBMS that does not meet the feature-set requirements of your business. Adding on extra modules or hiring consultants to design and implement special patches or options can be more expensive and time consuming that the most expensive DBMS on the market today and those costs do not include the potential lost revenue or other intangible items that can add up when your company is struggling to make do with the wrong DBMS. This paper will discuss various aspects of some of the premier DBMS systems on the market today. Those products include Microsoft Access, SQL, DB2, and Oracle. While each of these systems has specific features and advantages they also have distinct disadvantages as well. Our job is to gain an understanding of each of them to best determine which the best choice today. Technical Comparisons
While each application may be generically the same there are technical differences between them. This section will discuss some of the basic technical specifications of each of the systems. This can be a very detailed task and while a majority of these comparisons fall outside the scope of this particular paper due to the size constraints placed on this requirement. The table below points out some basic features of each DBMS system: DB NameMax SizeMax Table SizeMax Row SizeMax Columns per RowMax Char SizeMax Number Size DB2512TB512TB32677 Bytes101232KB64 bits
MS Access2GB2GB16MB25525532 bits
MySQLUnlimited2GB to 16TB64KB339864KB64 bits
OracleUnlimited4GB * block sizeUnlimited10004000 bytes126 bits Source of information for the table?
It's obvious when you look at these basic features that one option stands out as being a little less than the other, Microsoft Access. While Microsoft Access may appear to have a less robust feature sets it is one of the most prevalent DBMS on the market today. Given Microsoft's penetration into just about every aspect of computing it is no...