RE: dbms mini project
DBSMSs.doc (Size: 2.05 MB / Downloads: 216)
DB SERVER MANAGEMENT SYSTEM
In the Current Scenario SQL Server 2005 can be administered with the help of SQL Server Management Studio Installed on the Server. Microsoft® SQL Server™ 2005 administration provides different applications, services to assist the system administrator with all administrative tasks related to maintaining and monitoring server performance and activities. But, all this is possible provided the administrator uses SQL Server Management Studio. Consider a case wherein administrator is not in a position to get to the server and an immediate task has to be carried out. Is there a way where in the administrator can take over the control of the system from a remote location and do not feel any different than using a same SQL Server Management Studio.
To fulfill any such need of an administrator wherein he can administer the SQL Server from a remote location NSQL Server Management Studio is designed. The Interface is so designed that an administrator can feel as if he is working on the server and using an SQL Server Management Studio. All this is possible if the administrator provides a proper authentication.
This volume presents the manner in which the software was developed and how the various problems are tackled at the different levels for the convince of user.
We hope that this package would prove to be an excellent tool for exporting and importing of Data within a local network.
Introduction to .nsql Server Management Studio
Each new version of Microsoft® SQL Server seeks to automate or eliminate some of the repetitive work performed by database administrators. Because database administrators are typically among the people most highly trained in database issues at a site, these improvements allow a valuable resource to spend more time working on database design and application data access issues. The Scope of administration of such complex task is still limited to the desktop over a LAN network where the Server is installed on a Single system, which acts as server, and the other systems in the client work under the client environment to interact with the SQL Server. The Project DB Server Management System aims to increase the scope of administration by building the remote administration tool to interact with SQL server located over the web.
PURPOSE OF THE PROJECT:
• Need of an application to administer the SQL Server from a remote location.
• Increase the scope of the administrator where in the administrator need not be stay at serve all the time to carry out simpler tasks
• An interface not different from the SQL Server Management Studio with even simpler methods of performing administration tasks.
• Maintain Security for SQL Server similar to SQL Server Management Studio.
CMC Limited is India’s Information Technology company, offers both users in India and abroad a range services and solutions in areas like systems design and development , system engineering, multivendor networking, consultancy, installation, training, maintenance and total facilities management.
CMC has extensive and continually updated expertise in real time, on line systems, process control, image processing, data communications, networking, parallel architectures, etc. Integrated with horizontal expertise in information technology, is CMC’s vertical expertise in a whole range of industries both in infrastructural industries like power, coal, oil, and transportation, as well as service industries such as banking, law and order and education.
It is this totality of expertise that has enabled CMC to develop a variety of superior IT products and to execute a number of complex and challenging projects, not only in India, but also in Europe, America, Africa, the middle-east and South-East Asia.
CMC limited commenced operation as “Computer Maintenance Corporation” in October 1976. The first challenge came just one year later in November 1977. IBM announced that it would cease its maintenance and support operations in India from June, 1978. The entire Indian Computer community, the majority of whom had IBM equipment, was thrown into confusion. It was at this juncture that CMC took a bold decision: It offered to provide maintenance services to all users to all users of IBM equipment in India, Regardless of the type, age, size or the location of their machines. The task was a truly a staggering one but CMC faced it with confidence. Exactly six months later, CMC stepped into IBM shoes and took over the maintenance of over the maintenance of over 800 IBM installations with any dislocation.
Even as maintenance operations for IBM equipment were established, the Corporation began looking further Afield. While maintenance activities progressed apace, CMC turned its attention to other areas of computer support. Computer centers were set up in different cities and a whole range of consultancy services were offered. Computer education and training programmers were started. The R&D Centre at Hyderabad undertook pioneering projects in areas of contemporary technology. Software development in data communications and database management became one of the corporation’s fastest growing activities. And INDONET, India’s first national computer network began taking shape.
It soon became evident that calling Maintenance Corporation did not reflect the wide scope of its activities and services. It was in recognition of this fact that in August, 1984, ‘Computer Maintenance Corporation’ became ‘CMC Limited’.
While hardware maintenance continues to play a major role, CMC’s activities have advanced in many new directions CMC is one of the leading systems Integrators in the country with multi-faceted expertise in Information Technology. As a part of the globalization activity, CMC has acquired a subsidiary Company in the USA, thereby expanding its international activities. In the light of the growth of the communication sector and its importance to be liberalized economy, CMC revamped its communications network – INDONET, in terms of new protocols, communication equipment as well as host systems. The need for highly specialized software engineering skills in the coming years has triggered increased Education & Training activities.
In order to give focus to the above mentioned business areas, five Strategic Business Units (SBU’s) have been formed, namely, customer services, Systems Integration, International Operations, INDONET and Education & Training. Each of the vertical units in the CMC’s line of business will operate as a profit centre with increased overall productivity and accountability. This will also help to gauge the performance of various business activities in terms of contribution and other measure of excellence to achieve industry standards and ultimately result in greater customer satisfaction.
With 18 offices in INDIA, a subsidiary company in USA, 760 Software engineers, 800 hardware engineers, CMC caters to IT requirements of the customers from varied fields, spread over a vast global area.
Study of the system
Microsoft® SQL Server™ management comprises a wide variety of administration tasks, including:
• Registering servers and assigning passwords.
• Reconfiguring network connectivity.
• Configuring standby servers.
• Setting server configuration options.
• Managing SQL Server messages. Etc
In most cases, you do not need to reconfigure the server. The default settings for the server components, configured during SQL Server Setup, allow you to run SQL Server immediately after it is installed. However, server management is necessary in those situations where you want to add new servers, set up special server configurations, change the network connections, or set server configuration options to improve SQL Server performance.
Creating a Database:
To create a database determines the name of the database, its owner (the user who creates the database), its size, and the files and file groups used to store it.
Before creating a database, consider that:
• Permission to create a database defaults to members of the sysadmin and dbcreator fixed server roles, although permissions can be granted to other users.
• The user who creates the database becomes the owner of the database.
• A maximum of 32,767 databases can be created on a server.
• The name of the database must follow the rules for identifiers.
Three types of files are used to store a database:
• Primary files:
These files contain the startup information for the database. The primary files are also used to store data. Every database has one primary file.
• Secondary files:
These files hold all the data that does not fit in the primary data file. Databases do not need secondary data files if the primary file is large enough to hold all the data in the database. Some databases may be large enough to need multiple secondary data files, or they may use secondary files on separate disk drives to spread the data across multiple disks.
• Transaction log :
These files hold the log information used to recover the database. There must be at least one transaction log file for each database, although there may be more than one. The minimum size for a log file is 512 kilobytes (KB).
When a database is created, all the files that comprise the database are filled with zeros to overwrite any existing data left on the disk by previously deleted files. Although this means that the files take longer to create, this action prevents the operating system from having to fill the files with zeros when data is written to the files for the first time during usual database operations. This improves the performance of day-to-day operations.
Create a database using the Create Database Wizard (SQL Server Management Studio):
To create a database using the Create Database Wizard
1. Expand a server group, and then expand the server in which to create a database.
2. On the Tools menu, click Wizards.
3. Expand Database.
4. Double-click Create Database Wizard.
5. Complete the steps in the wizard.
Creating and Modifying a Table:
After you have designed the database, the tables that will store the data in the database can be created. The data is usually stored in permanent tables. Tables are stored in the database files until they are deleted and are available to any user who has the appropriate permissions.
You can also create temporary tables. Temporary tables are similar to permanent tables, except temporary tables are stored in tempdb and are deleted automatically when no longer in use.
The two types of temporary tables, local and global, differ from each other in their names, their visibility, and their availability. Local temporary tables have a single number sign (#) as the first character of their names; they are visible only to the current connection for the user; and they are deleted when the user disconnects from instances of Microsoft® SQL Server™ 2000. Global temporary tables have two number signs (##) as the first characters of their names; they are visible to any user after they are created; and they are deleted when all users referencing the table disconnect from SQL Server.