Authors
MARYAM JAN CHAUDHARY ANTREASCHRISTODOULOU
HOUSAIN ALIPANTELITSA THEODOROUJIE MA CLAIRE JONES
HOUSAIN ALIPANTELITSA THEODOROUJIE MA CLAIRE JONES
SALFORD COUNCIL TAX
Abstract
This report is a part of live project that undertaken during my second year in Salford University.The aim of the project is to deliver a
system that will hold all the information relating to the councils telephone
and broadband services. This part outline the research that undertaken in Microsoft SQL Server 2005. Moreover there is further descussion about the benefits of the software, disadvantages of the software and compare it with other softwares.
Microsoft SQL Server 2005
Content:
- Introduction
- Microsoft SQL server 2005.
- Benefits of the software
- Disadvantages of the software
- Compare with other software
- Conclusion
- References
1. Introduction
Server Databases is a database server is the back-end system of a database application using client/server model. As defined by the client/server model the server is the computer program that provides database services to other computer programs or computers. Database Server may also refers to just a computer running the program. DBMSs frequently provide database server functionality, and some of them (e.g., MySQL) rely exclusively on the client-server model for database access. It is essential to say what a database is and what it can offer us. A database is a system intended to organize, store, and retrieve large amounts of data easily. It consists of an organized collection of data for one or more uses, typically in digital form. Digital databases are managed using database management systems, which store database contents, allowing data creation and maintenance, and search and other access. However they are many sources which can get and use a database, in our situation we suggest the Microsoft SQL server to the client.
2. Microsoft SQL Server.
Microsoft SQL Server 2005 is comprehensive, integrated data management and analysis software that enables organizations to reliably manage mission-critical information and confidently run today’s increasingly complex business applications. SQL Server 2005 allows companies to gain greater insight from their business information and achieve faster results for a competitive advantage.
2. Benefits of software.
The Microsoft SQL Server as we said before, is a database application that hosts company information for customers, orders, financial records and other important data. SQL Server 2005 followed the SQL Server 2000 edition, and it brought several advantages over the older database software. SQL Server 2005 supports small to large businesses, and it has advantages over other database solutions. It is essential to list some of its advantages below:
· Microsoft is positioned in Leaders Quadrant for Magic Quadrant for Business Intelligence Platforms, 2008.
· Microsoft is positioned in Leaders Quadrant for Magic Quadrant for Data Warehouse Database Management Systems, 2007
· SQL Server is the fastest growing Database and Business Intelligence vendor
· SQL Server ships more units than Oracle and IBM combined.
· SQL Server is the #1 OLAP Server on the market.
· SQL Server is more secure than Oracle. Since July 2003 more than 100 critical Oracle database security vulnerabilities have been identified, compared to ZERO for SQL Server for that period.
· SQL Server is best in price/performance for TPC-H 1TB & 3TB (non-clustered).
· Microsoft SQL Server and Unisys are the first to publish TPC-E benchmark results.
· Gartner 2006 worldwide RDBMS market share reports highest growth rate in market share for Microsoft SQL Server. With 28% growth in market share, growth is almost twice the nearest competitor at 14.8% growth.
· Scalability. SQL Server 2005 is able to scale with a business's computer hardware needs. Scalability means the database is able to support business growth, including expanding hardware design on the network.
· Backups, save the tables, stored procedures and security information in case of an emergency.
· Mirroring backups provides administrators with the tools needed to backup information across several media devices.
4. Disadvantages of the software.
However although Microsoft sql server 2005 doesn’t have as many disadvantages as there is advantages there is however some disadvantages that may be worth knowing:
· Cost: Enterprise Edition: $24,999 per processor or $13,969 per server
· Complexity: all the new improvements on its 2000 model made the system harder to use and more complex which took away the only advantage Microsoft sql had on its oracle competition
· It is easy to view table relationships, constraints, indexes, stored procedure in database but triggers are difficult to view.
· Triggers execute invisible to client-application application. They are not visible or can be traced in debugging code.
· It is hard to follow their logic as it they can be fired before or after the database insert/update happens.
· It is easy to forget about triggers and if there is no documentation it will be difficult to figure out for new developers for their existence.
· Triggers run every time when the database fields are updated and it is overhead on system. It makes system run slower.
5. Compare with other software.
MySQL Community Server (Current Generally Available Release: 5.1.52)
MySQL Community Server (Current Generally Available Release: 5.1.52)
MySQL Community server is an open source relational database system that runs a server providing multi-user access to a number of databases. A user can manage his online storage and create his own database on the server. It is freely downloadable and is supported by an active community of open source developers. SQL stands for Structured Query Language. MySQL is available under the terms of the General Public License (GNU) and is owned by Oracle Corporation.
Benefits
· The world’s most popular open-source database.
· Supported by an active worldwide community.
· Fully integrated.
· Transaction-safe.
· Easy to use.
· Flexible.
· Recovery of data when crash.
Microsoft SQL Server 2008 R2 Express.
Microsoft SQL Server 2008 R2 Express is a new management database system which enables us to create as many databases as we want and with unlimited number of users. It has four editions which are all free. The design of databases is easily made as the version provides as with a graphical management tool, reporting capabilities and full-text search and support. It is ideal for building websites and apps and small scale Line-of-business solutions for example accounting. More importantly it provides users with 1 GB memory and 10 GB storage and has the same advanced database engine as other versions of SQL Server. If the business needs grow Express edition is compatible with all editions of SQL Server so can easily be upgraded into another (which will cost) and is designed to work with Visual Studio and ASP.NET. This is a low budget solution and the RAM memory is a bit low. If a big number of users try to access the database in the same time the server may crush. The Salford City Council currently has 1200 telephone lines and 300 IP/stream lines. The storage may not be enough for all the users to access the database at the same but can limit the number of users that will be allowed access at the same time in order to avoid a possible crush. However in order to have a high quality server that can give access to a lot of people and avoid disappointment there aren’t many free software options.
Microsoft SQL Server 2008 R2 Express is a new management database system which enables us to create as many databases as we want and with unlimited number of users. It has four editions which are all free. The design of databases is easily made as the version provides as with a graphical management tool, reporting capabilities and full-text search and support. It is ideal for building websites and apps and small scale Line-of-business solutions for example accounting. More importantly it provides users with 1 GB memory and 10 GB storage and has the same advanced database engine as other versions of SQL Server. If the business needs grow Express edition is compatible with all editions of SQL Server so can easily be upgraded into another (which will cost) and is designed to work with Visual Studio and ASP.NET. This is a low budget solution and the RAM memory is a bit low. If a big number of users try to access the database in the same time the server may crush. The Salford City Council currently has 1200 telephone lines and 300 IP/stream lines. The storage may not be enough for all the users to access the database at the same but can limit the number of users that will be allowed access at the same time in order to avoid a possible crush. However in order to have a high quality server that can give access to a lot of people and avoid disappointment there aren’t many free software options.
We need a server with over of 1 GB RAM in order to avoid possible crushes. The client has already got a website which runs on a server and we could just add 1GB ram by using an extra memory. If they don’t they can buy a server which will cost thousands of pounds for just the server and additional costs for broadband, computer and electricity.
Another option is to rent a server by paying monthly. 1&1 Web Hosting is an English-based company and can be found at www.1and1.co.uk. It provides Microsoft Hosting with four editions. 1&1 Business is the edition which gives as 40GB web space, unlimited monthly traffic, includes domain, with 3000 IMAP/POP3 E-mail Accounts which have 2 GB mailbox capacity and with MS SQL 2008 already installed on the server. It provides you with Google sitemaps for advertising, a 1&1 control panel for easy developing of a database, simple submission and managing of web files through your internet explorer. Easy, flexible and can add optional tools. It is available from £2.49 per month for three months and then from £9.99 per month. A relatively low budget solution with good features.
Desktop Databases
Desktop Databases, like Microsoft Access, are oriented towards single-user application and can be found on personal computers. Desktop databases offer an inexpensive solution to less complex data storage and less manipulation requirements. You can buy Microsoft Access 2010 around 120 pounds compared to thousands of pounds for server-based databases.
A broad knowledge and understanding of SQL syntax is not required when using desktop databases, although many do support SQL, because desktop DBMSs usually offer an easy-to-navigate graphical user interface. With Microsoft Access 2010 we are able to build databases faster by using built-in customizable templates and different easy-to-use tools like adding automation and complex expressions without writing a line of code.
6. Conclusion
To sum up, Microsoft SQL server become very famous and popular in nowadays. The operational tasks related to the data center span the full life-cycle of the data services it helps to provide, from planning, through building and deployment, to operation.
Managed data stores use database mirroring and therefore when performance becomes an issue, the IT operations team can add new higher specification servers. Role of the database administrator is changing, thoughts on the relevance of 64-bit and Itanium with respect to Business Intelligence (BI), and the very on-topic advances in High Availability, such as Database Mirroring and Log Shipping technology in SQL Server 2005 and its implications for disaster recovery. Database Mirroring can be set to fail-over and recover automatically. Indeed, db mirroring offers a substantial increase in availability over standard log shipping, by maintaining a hot-standby server where changes are reflected real-time, and applications can recover quickly with minimal, if any, intervention.The performance of database mirroring is very closely associated with the type of application, transaction safety level, and network performance. The network plays a very important role in a database mirroring environment. When used with a high-bandwidth and low-latency network, database mirroring can provide a reliable high-availability solution against planned and unplanned downtime. Across geographically distant data centers, database mirroring can provide the foundation for a disaster-recovery solution. Additionally do not forget to test and plan for any sort of new introduction to your High Availability ranch, even changes in Database Mirroring mode.
Reference:
1. Project details report.
5. http://www.google.co.uk/search?sourceid=chrome&ie=UTF-8&q=conclusion+for+database+server+2005 (Effective Usage of SQL Server 2005 Database Mirroring).
6. http://www.microsoft.com/sqlserver/2005/en/us/product-information.aspx
7. http://www.infoworld.com/d/data-management/sql-server-2005-piles-it-021
8. http://ezinearticles.com/?Advantages-and-Disadvantages-to-Using-MySQL-Vs-MS-SQL&id=1559158
No comments:
Post a Comment