StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...

Database Management. MSSQL Server Database - Essay Example

Cite this document
Summary
Navathe (2003) defines database as a collection of programs that enables users to create and maintain a database. It can also be defined as general purpose software for defining, creating, fetching and sharing databases among various users…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER94.5% of users find it useful
Database Management. MSSQL Server Database
Read Text Preview

Extract of sample "Database Management. MSSQL Server Database"

Download file to see previous pages

In this case the university requirements deal with a variety of services which requires their data to be stored in a database so that it can be successfully fetched and modified for performing a variety of functions. The database technology that can be offered for an online educational institution would be a server based database system for payment of student fees and other details, student registration, facilitating admission procedure, producing reports and others (About.com, 2008). The MSSQL server database would most suitable for mapping the various requirements of the university.

It is recognized to map the organizational requirements and used widely. It is able to take care of scalability of the university operations and service, meaning that it takes care of the various additions of new courses, new students and various other programs, modifications relating to the various rules and obligations. Improves visibility of operations for student registration and admission facilities. Stores appropriate records for further fetching of reports of student activity and staff activity.

Quite easy to extend the schema for enlarging the database. This database variant serves a set of standards that is required to launch ecommerce database requirements. The features of the database are as follows: Efficient buffer management to cache pages in memory so that more amounts the pages are cached the better the system operates. The transaction management is quite efficient in the manner that if a transaction is not able to complete it is roll backed so that changes can be reversed. In that manner data integrity is maintained.

The concurrency control is quite effective and it ensures data integrity. It facilitates replication which ensures that proper synchronization is done for the information in the databases. It also facilities merge and snapshot replication. The OLAP provides analysis services for the data objects. The reporting services and notification services serve as a great function to the database functionality.It offers a great GUI for dragging and dropping the elements in the database arena which had made it quite high in usability for greater acceptance and usage.

It also offers greater facility for supporting various front end platforms for wide usage and business applicability. ConclusionTaking into account the above factors, MSSQL server stands out in the crowd for all the features which makes it quite flexible, scalable and cross-functional. The above features make sure that all the university would be able to accommodate all features required to make it a virtual campus and provide effective and efficient

...Download file to see next pages Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Database Management. MSSQL Server Database Essay”, n.d.)
Retrieved de https://studentshare.org/miscellaneous/1533251-which-of-the-database-products-described-in-the-article-would-be-most-effective-in-meeting-the-needs-of-an-online-educational-institution-such-as-tui
(Database Management. MSSQL Server Database Essay)
https://studentshare.org/miscellaneous/1533251-which-of-the-database-products-described-in-the-article-would-be-most-effective-in-meeting-the-needs-of-an-online-educational-institution-such-as-tui.
“Database Management. MSSQL Server Database Essay”, n.d. https://studentshare.org/miscellaneous/1533251-which-of-the-database-products-described-in-the-article-would-be-most-effective-in-meeting-the-needs-of-an-online-educational-institution-such-as-tui.
  • Cited: 0 times

CHECK THESE SAMPLES OF Database Management. MSSQL Server Database

Project 3: Databases

A given database management system provides more than five models.... hellip; MSQL is a relational database management system developed by Microsoft.... Databases Name Institution Databases Commonly used database include; oracle, SQL and MYSQL.... database primary function is to retrieve and store data as requested by other software applications (Roza, 2011).... database security is the only way of securing the platform and the applications....
3 Pages (750 words) Essay

Database or Spreadsheet: Which Is More Practical

Microsoft Excel and other spreadsheet software programs are not database management systems.... From a technical perspective, the database can be defined as a set of related files that are created and managed by a database management system (DBMS).... Now these days, a database management system can manage any form of data.... In this paper, the main focus will be on the two software database or spreadsheet as MS Access and MS Excel....
8 Pages (2000 words) Research Paper

Management and Graphical Front Ends

ree-software projects that require a full-featured database management system often use MySQL.... In the paper “Management and Graphical Front End” the author analyzes MySQL, which is a popular choice of database for use in web applications, and is a central component of the widely used LAMP web application software stack — the LAMP is an acronym for "Linux, Apache, MySQL, PHP".... In addition, an ODBC interface called MyODBC allows additional programming languages that support the ODBC interface to communicate with a MySQL database, such as ASP or ColdFusion....
10 Pages (2500 words) Assignment

The Importance of MySQL Program

It is the subsequent most extensively applied open source RDBMS (relational database management system) (DuBois, 2013).... To discuss the paper strategic role of the system to a company, business needs driving the need of the system and the information used in the system are analyzed. A database system is a… kind of computer application that is devised to deal with several data, but to keep those data in such a manner that retrieving any snippet of information is proficient than if one just discarded them anyhow all over the location....
2 Pages (500 words) Essay

Implementing and Managing Large Databases

Databases are managed through database management systems (DBMS).... Companies ought to examine and evaluate their database design, to identify the inherent inhibitors to a seamless database management system.... The software used explains the database management system employed, as well as its implementation.... Scaling-up is not a preferable option in the modern day of database management systems.... The paper "Implementing and Managing Large Databases" establishes that size of a company's database influences its selection of a DBMS and the database design....
7 Pages (1750 words) Essay

Web-Based Systems - NoSQL and MongoDB

Examples of relational database systems include MySQL, MS SQL Server, and PostgreSQL(Ticknor and Corcoran, 2011).... Also, they help the user to compare data quickly due to the arrangement of information in columns, which helps the relational database to build new tables from the information available on the existing tables.... non-relational database refers to a database that does not integrate the table/key model, which is promoted by the relational databases....
7 Pages (1750 words) Case Study

An Analysis of the NoSQL Database Management System

With social graphs, personal user data, machine logging and… For such services to be availed properly, huge amounts of data are processed - a service that traditional database management system could not handle (Pludge & Membrey, 2010).... also used the term while referring to databases which are distributed and non-relational, and which did not conform to the ACID properties of the traditional relational database management systems.... Manipulation of these databases does not rely on SQL as is the case of the conventional relational database management systems....
6 Pages (1500 words) Essay

Database Buyer's Guide Conclusion from Database Journal

The term database systems often describe the constructs of database management systems, a data model, as well as a database.... On the other hand, a database management system refers to the computer software used to provide interfacing to users when they access databases and database systems on computers.... A database management system is the shell that surrounds databases and allows for interactions to the databases.... Retrieved March 4, 2012, from Database Journal This article is a form of guide to be used by customers looking to find the best database to use or to implement a system on; it highlights the pros as well as the cons of the different types of relational database management systems....
3 Pages (750 words) Research Paper
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us