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

Database Management System - Case Study Example

Cite this document
Summary
This review 'Database Management System' are exceptionally composed software applications that connect with the user, different applications, and the database itself to catch and dissect data. A universally useful DBMS is a software system intended to permit the definition, creation, updating and organization of databases…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER96.6% of users find it useful
Database Management System
Read Text Preview

Extract of sample "Database Management System"

Database Database Management System (DBMS) Definition: Database administration systems (DBMS) are exceptionally composed software applications that connect with the user, different applications, and the database itself to catch and dissect data. A universally useful DBMS is a software system intended to permit the definition, creation, updating, querying and organization of databases. Few example of well known database are MySQL, SQLite, Orcale, IBM DB2, Microsoft SQL Server, dBASE, File Maker Pro, LibreOffice Base, and Microsoft Access. A few functions of a DBMS perform to guarantee data trustworthiness and consistency of data in the database. Such as, data word reference management, data stockpiling management, data change and presentation, security management, multiuser access control, reinforcement and recuperation management, data trustworthiness management, database access dialects and application programming interfaces, database correspondence interfaces, and transaction management. History of DBMS: 1960s, navigational DBMS: The first introduction of the term database harmonized with the accessibility of direct access storage from the mid-1960s beyond. The term used to a stand out from the tape-based systems of the past, permitting imparted intelligent utilize instead of every day cluster transforming. The Oxford English dictionary refers to a 1962 report by the System Development Corporation of California as the first to utilize the expression "data-base" in a particular specialized sense. In 1971 the Database Task Group conveyed their standard, which by and large got to be known as the "CODASYL approach", and soon various business items focused around this methodology entered the business. IBM likewise had their own particular DBMS in 1968, known as Information Management System (IMS). IMS was an advancement of software composed for the Apollo program on the System/360. 1970s, relational DBMS: Starting in 1973, INGRES conveyed its first test items which were for the most part prepared for far reaching use in 1979. INGRES was like System R in various ways, including the utilization of a "dialect" for data access, known as QUEL. About whether, INGRES moved to the rising SQL standard. In 1970, the University of Michigan started advancement of the MICRO Information Management System focused around D.L. Micro was utilized to oversee extensive data sets by the US Department of Labor, the U.S. Natural Protection Agency, and specialists from the University of Alberta, the University of Michigan, and Wayne State University. It ran on IBM centralized server machines utilizing the Michigan Terminal System. The system stayed in generation until 1998. Integrated approach: In the 1970s and 1980s endeavors were made to assemble database systems with incorporated fittings and software. The underlying reasoning was that such joining would give higher execution at lower cost. Late 1970s, SQL DBMS: IBM began chipping away at a model system approximately focused around Codds ideas as System R in the early 1970s. The primary rendition was prepared in 1974/5, and work then began on multi-table systems in which the data could be part so that the majority of the data for a record did not need to be put away in a solitary substantial "lump". Ensuing multi-user adaptations were tried by clients in 1978 and 1979, by which time an institutionalized question dialect – SQL had been include 1980s, on the desktop: The 1980s introduced the time of desktop registering. The new machines enabled their users with spreadsheets like Lotus 1-2-3 and database software like dBASE. The dbase item was lightweight and simple for any machine user to understand. dBASE was one of the top offering software titles in the 1980s and early 1990s. 1980s, object-oriented: The 1980s, alongside an ascent in object oriented programming; saw a development in how data in different databases were taken care of. Software engineers and creators started to treat the data in their databases as objects. 2000s, NoSQL and NewSQL: The up and coming era of post-social databases in the 2000s got to be known as NoSQL databases, including quick key-quality saves and record arranged databases. NoSQL databases are frequently quick, dont oblige settled table outlines, evade join operations by putting away de-normalized data, and are intended to scale on a level plane. NewSQL is a class of current social databases that plans to give the same versatile execution of NoSQL systems for online transaction transforming workloads while as of now utilizing SQL and keeping up the ACID insurances of a conventional database system. Database Model: A database model is a kind of data model that decides the consistent structure of a database and in a broad sense decides in which way data might be put away, composed, and controlled. The most prominent case of a database model is the social model, which utilizes a table-based arrangement. Hierarchical database model: Hierarchical database model is a data model in which the data is composed into a tree-like structure. The data is put away as records which are joined with each other through connections. A record is an accumulation of fields, with each one field containing stand out value. The entity sort of a record characterizes which fields the record contains. An example of a hierarchical model: a record in the various leveled database model compares to a row in the relational database model and an entity sort relates to a table. Network model: Network model is a database model imagined as an adaptable method for speaking to protests and their relationships. Its recognizing feature is that the outline (schema), saw as a graph or diagram in which objects sorts are nodes and relationship sorts are arch or circular segments, is not limited to being a pecking order or cross section. Relational model: Relational model for database management is a database model focused around first-request predicate rationale, initially planned and proposed in 1969 by Edgar F. Codd. In the relational model of a database, all data is spoken to regarding tuples, assembled into relations. A database sorted out regarding the relational model is a relational database. Entity-relationship model: Entity–relationship model is a data model for portraying the data or data parts of a business area or its process necessities, in an unique way that fits eventually being executed in a database, for example, a relational database. The fundamental segments of ER models are elements and the relationships that can exist among them, and database. Object model: Gathering of classes or objects via which program can inspect and control. This type of interface is known as object model, for example Document Object Model. Entity-attribute-value model: Entity–attribute–value model is a data model to depict entities where the quantity of attribute that might be utilized to portray them is conceivably inconceivable, however the number that will really apply to a given entity is generally modest. Star schema: Star Schema is also known as star-join schema, which is the least complex style of data store outline. Star schema comprises of one or more certainty tables referencing any number of measurement tables. Languages: Data definition language: It defines data types and their relationship among them. For example (in SQL): CREATE TABLE office ( id INTEGER PRIMARY KEY, name VARCHAR(20) NOT NULL, department VARCHAR(20) NOT NULL, date_of_joining DATE NULL ); Data manipulation language: It performs a few tasks for example inserting, deleting, updating and many more. For example (deleting in SQL: delete row from table office where the column id equals 001) DELETE FROM office WHERE id=001; Query language: It permits seeking for information and aids to computing derived information. For example (select in SQL) SELECT * FROM office WHERE id=002; Data Migration: A database fabricated with one DBMS is not portable to an alternate DBMS. Be that as it may, in a few circumstances it is attractive to move, migrate a database starting with one DBMS then onto the next. The reasons are essentially prudent, functional, and operational. The migration includes the databases change starting with one DBMS sort then onto the next. The change ought to keep up the database related application in place. Consequently, the databases reasonable and outer compositional levels ought to be kept up in the change. It might be sought that additionally a few parts of the building design inner level are kept up. An unpredictable or substantial database migration may be a confounded and excessive extend without anyone elses input, which ought to be figured into the choice to migrate. This despite the way that apparatuses may exist to help migration between particular DBMSs. Regularly a DBMS merchant gives devices to help importing databases from other famous DBMSs. Bibliography Dhawan, R. (2010). Database management system (1st ed.). New Delhi: A P H Pub. Corp. Pathak, N. (2008). Database management system (1st ed.). Mumbai [India]: Himalaya Pub. House. Singh, Y. (2006). Database management system (1st ed.). New Delhi: Shree Publishers & Distributors. Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(Database Management System Case Study Example | Topics and Well Written Essays - 1250 words, n.d.)
Database Management System Case Study Example | Topics and Well Written Essays - 1250 words. https://studentshare.org/information-technology/1838062-database
(Database Management System Case Study Example | Topics and Well Written Essays - 1250 Words)
Database Management System Case Study Example | Topics and Well Written Essays - 1250 Words. https://studentshare.org/information-technology/1838062-database.
“Database Management System Case Study Example | Topics and Well Written Essays - 1250 Words”. https://studentshare.org/information-technology/1838062-database.
  • Cited: 0 times

CHECK THESE SAMPLES OF Database Management System

Information Systems Development

adoption of the Database Management System.... So before moving to… he future the efficient management of the data is very important for business oriented, strategic, social, educational, medical, and defense organizations and even no one can deny the importance of data at individual level.... As different organizations are still using spreadsheets for the management of their data facts and its due to the lack of domain knowledge regarding databases....
4 Pages (1000 words) Essay

Service Request SR-ta-001

Taylor Ambulance needs a relational Database Management System.... The most notable feature about a relational Database Management System is that it enables the user to spread a single database across multiple tables.... The database system is linked to a customer relationship management system that has various modules.... Fundamentals of Relational database management Systems.... Considering the growth of Taylor Ambulance, there is a need for a computerized system that will integrate all the scheduled services offered by the company and store all the information in a centralized database....
2 Pages (500 words) Essay

UR UMUC Healthy Fitness Center

Hardware: The essential hardware aspects associated with e-commerce are server, input as well as output tools and Database Management System.... The most essential software for e-commerce is the Database Management System, which can store vital information in the form of text and images.... The center ought to establish a secure and free WI-FI system in the premises as well as improvise a membership database, which is digital.... This server will contain critical information and will act as a backup for information preservation system....
3 Pages (750 words) Case Study

Module review questions

For example, a Database Management System for employees in an organization… On the other hand, the file processing approach leads to creation of different files for each employee (Panneerselvam, 2003). -The database management approach is also advantageous in that Module review questions Discuss the advantages of a database management approach to the file processing approach?... For example, a Database Management System for employees in an organization provides room for all employee data to be stored in a single well-designed database system....
2 Pages (500 words) Coursework

Components of a Database Application, Database Management System

The paper "Components of a Database Application, Database Management System" states that Samantha could easily implement MySQL.... Since most database functions performed by Samantha would be simple, a single user personal Database Management System (DBMS) would be a good choice.... hellip; Information regarding the customer and the job would have to be entered and monitored in a database by a single individual managing the company, which is Samantha....
1 Pages (250 words) Assignment

Build and Sustain an Innovative Work Environment

The innovation goals toward coming up with the Database Management System came due to the how the work was tiresome in getting the details for the workers or staffs therefore resulted to the system designer and analyst contribute their creativity in coming up with the system that will manage staffs database efficiently and that will save time when accessing their data.... Therefore, according to the accounting department in the microfinance business, there has been need for ensuring database for the staffs is stored electronically rather than manually, this organizations goal motivated them to become creative in coming up with the need to develop a Database Management System (Wang & Global, 2012)....
4 Pages (1000 words) Assignment

Database Management System Project

In regard to that, there is need to integrate the company with a Database Management System (Gupta & Mittal, 2009).... They will be introduced and Database Management System proposal memo Insert Insert Introduction Offsite has been experiencing an increasing growth in the kind of data it handles.... In regard to that, there is need to integrate the company with a Database Management System (Gupta & Mittal, 2009).... Introduction to Database Management System....
2 Pages (500 words) Essay
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