Web Database Technologies Available Microsoft Access, MySQL, Microsoft SQL, Oracle 9i

Web Database Technologies Available
Microsoft Access, MySQL, Microsoft SQL, Oracle 9i

A multithreaded database solution like MySQL would be able to treat multiple visitors at the same time without slowing down the web site.

MySQL is a relational database management system (RDBMS) that: provides users with a powerful multi-user, multi-threaded SQL (Structured Query Language) database solution. Microsoft Access is a single-threaded system. This means it deals with requests one at a time

MySQL is significantly faster and more robust than Microsoft Access.

MS Access cannot cope effectively with more than 5 concurrent users. My SQL by default can cope with 100 concurrent users without any loss of performance.

Table 1 Solution analysis

	Low End Solution	Mid Way Solution	High Mid Way	High End Solution
	MS Access	MySQL	MS SQL	Oracle 9i
Cost of Developing	Within Budget	Reasonable	Expensive	Very Expensive
Advantages	Ideal for testing a prototype system Skills, wide spread. Little or no Maintenance Costs as the functional specification includes web site administration.	MySQL is one of the most used open source databases in the world. Its free and available over the world wide web Ability to handle an unlimited number of simultaneous users. Capacity to handle 50,000,000+ records. Very fast command execution, perhaps the fastest to be found on the market. Easy and efficient user privilege system.	Supports MS SQL Server specific features Simplifies data updating Speeds up fetch of records from database Provides automatic refresh for records Advanced design time editors	Suitable for very large corporate e-commerce solutions Improved throughput Scalability over single instance systems Improved response time High availability Transparency
Disadvantages	Mainly Suitable for SME’s.		Skills and support scarce and can be expensive Maintenance costs high	Skills and support very scarce and expensive Maintenance costs expensive

Post a new comment