• Home Page
  • Advantages And Disadvantages Of The Database Management System

Advantages And Disadvantages Of The Database Management System

Superior Essays
Show More
According to (Connolly, 2003) the database is “A shared collection of logically related data, and a description of this data, designed to meet the information needs of an organization”. The Database Management System (DBMS) is software that enables users to define, create, maintain and control access to the database. The database has identified three levels of abstraction. All these three levels will have different aspects and they are as follows:

• Physical or external level- The database system can show for the users the part of the database what they need to use.
• Conceptual or Logical level- According to Connolly (2003) this level is “The community view of the database. This level describes what data is stored in the database and the relationships among the data.” This …show more content…
Disadvantages: Hard to find expert user, poor monitoring tools
Microsoft SQL server-
According to the http://www.computerweekly.com/ it is the third biggest selling database eg TFL. According to the www.techwalla.com these are the advantages and disadvantages about MSQL:
• Advantages- Enterprise-grade management software, excellent data recovery support
• Disadvantages- Cost and limited compatibility
Sybase- According to www.searchenterpriselinux.techtarget.com Airtel (Spanish telecommunication operator), Telstra (Australian telecommunications provider) or Primark use Sybase. According to the http://infocenter.sybase.com website these are the disadvantages:
• It usually speeds retrieval but can slow data modification.
• It is always application-specific and must be revaluated if the application changes.
• It can increase the size of tables.
• In some instances, it simplifies coding; in others, it makes coding more complex.

I would recommend for Reading College to use Oracle because as a HE/FE college, we will need to deal with huge amount of data, the database need to be in stable and

Related Documents

  • Improved Essays

    Nt1310 Unit 4 Test Paper
    • 419 Words
    • 2 Pages

    Nt1310 Unit 4 Test Paper

    1. Maintains an exact replica of one disk on another offering 100% fault tolerance. 2. Data redundancy - If one disk fails, data can be recovered from the other. 3.…

    • 419 Words
    • 2 Pages
    Improved Essays
    Read More
  • Improved Essays

    Nt1320 Unit 2
    • 866 Words
    • 4 Pages

    Nt1320 Unit 2

    2. D H C I J E K A B F G 4. SQL-92 was a major revision and was structured into three levels: Entry, Intermediate, and Full.…

    • 866 Words
    • 4 Pages
    Improved Essays
    Read More
  • Improved Essays

    Nt1310 Unit 3 Data Analysis
    • 841 Words
    • 4 Pages

    Nt1310 Unit 3 Data Analysis

    Part 1 Different data types and their uses - The different data types that is available for creating or developing a program on software. An example of programming software would be Microsoft Visual Studio. With this software, many data types are used which can drive an event. -…

    • 841 Words
    • 4 Pages
    Improved Essays
    Read More
  • Decent Essays

    Nt1330 Unit 1 Study Guide
    • 573 Words
    • 3 Pages

    Nt1330 Unit 1 Study Guide

    Database management system (DBMS) – is a collection of tools, features, and interfaces that enables users to add, update, manage, access, and analyze data. Offers timely, interactive, and flexible data access. 12. Scalability – which means that a system can be expanded, modified, or downsized to easily meet the rapidly changing needs of a business enterprise. 13.…

    • 573 Words
    • 3 Pages
    Decent Essays
    Read More
  • Improved Essays

    Psy 315 Week 3 Levels Of Data Analysis Paper
    • 1111 Words
    • 5 Pages

    Psy 315 Week 3 Levels Of Data Analysis Paper

    There are three levels of measurement: nominal, ordinal, and ratio. Nominal level data is the lowest level of data and is qualitative (word oriented). Ordinal data are assigned numbers reflecting on the order of the relationship between the characters studied. Interval level data is a move from the qualitative scale to the quantitative scale – numbers (Walker, 2009). It also builds on ordinal data and shows an equal value between categories.…

    • 1111 Words
    • 5 Pages
    Improved Essays
    Read More
  • Decent Essays

    Db Application Case
    • 584 Words
    • 3 Pages

    Db Application Case

    The file contains conflicting dates regarding the claimant’s date last worked at the SGA level. The conflict must be resolved to determine the correct onset date. CASE DISCUSSION & POLICY ANALYSIS (INCLUDING SPECIFIC REFERENCES) This 30-year-old claimant is filing a DIB claim alleging disability due to blindness as of 10/01/2016.…

    • 584 Words
    • 3 Pages
    Decent Essays
    Read More
  • Improved Essays

    Nt1310 Unit 3 Information Management Assignment
    • 1963 Words
    • 8 Pages

    Nt1310 Unit 3 Information Management Assignment

    Information Management Introduction Over the year, I have completed 5 DT internal assessments. These included AS 1.41, AS 1.43, AS 1.45, AS 1.46, and AS 1.50. In completing these assessments, I have became more familiar with the applications that were used to complete these internal assessments, and has given me a better understanding for file structure. Assessments Completed AS 1.43 - First assignment: Website.…

    • 1963 Words
    • 8 Pages
    Improved Essays
    Read More
  • Improved Essays

    Task 1: Project Part 1 Outline Security Policy
    • 1249 Words
    • 5 Pages

    Task 1: Project Part 1 Outline Security Policy

    The cost, risk, and complexity of managing business-critical MySQL applications are reduced. Some of the features of MySQL Enterprise Edition are: Backup; reduces the risk of data loss, and High Availability; we can make our database infrastructure highly available. Scalability, authentication, and encryption are just a few others on the list of available features in MySQL Enterprise…

    • 1249 Words
    • 5 Pages
    Improved Essays
    Read More
  • Decent Essays

    Ist 305 Assignment 6-3
    • 538 Words
    • 3 Pages

    Ist 305 Assignment 6-3

    ID: 2597622 IST 305 – Assignment 6 6-1: The Toronto Globe and Mail had an information systems issue with how their business databases and files were stored. Throughout the firm, multiple databases were isolated and duplicated among departments. This had caused issues, such as their subscribers receiving unnecessary marketing material, and not being able to keep the databases secure. In order for them to solve this issue was to implement and store all company data into a data warehouse using SAP NetWeaver, as well as educate their own employees on the new system to prevent further inconsistent databases. By implementing the data warehouse and training their employees, it produced the results that management envisioned.…

    • 538 Words
    • 3 Pages
    Decent Essays
    Read More
  • Decent Essays

    Unit 1 Explain The Importance Of Visual Alerts
    • 156 Words
    • 1 Pages

    Unit 1 Explain The Importance Of Visual Alerts

    This means when you are able to change or edit your computer software or hardware, or the peripherals. This can be things such as the ability to customize your keyboard, the ability to customise what is displayed, and the ability to enable visual alerts for those who can’t hear alerts. This is basically troubleshooting.…

    • 156 Words
    • 1 Pages
    Decent Essays
    Read More
  • Improved Essays

    Unit 7 D2
    • 693 Words
    • 3 Pages

    Unit 7 D2

    Describe the functions of database technology, the differences between centralized and Distributed database architecture, how data quality impacts performance, and the role of A master reference file in creating accurate and consistent data across the enterprise. In Chapter three, Turban discusses four types of database technologies: 1. Databases -store data gathered from business applications, transaction processing systems, and sensors.…

    • 693 Words
    • 3 Pages
    Improved Essays
    Read More
  • Great Essays

    Case Study Assignment: Mastercard International
    • 933 Words
    • 4 Pages

    Case Study Assignment: Mastercard International

    Case Study Assignment – I Campbellsville University MASSIVE DATABASE MASTERING - MASTERCARD INTERNATIONAL Various affiliations are endeavoring to address the open entryways and limit challenges related with "huge data." Industry masters gage that the total volume of data is increasing at general interims and most by a wide margin of new data being delivered is prepared to go spaces. MasterCard Universal (www.mastercard.com) is not any more impossible to miss to think about the issues identified with monstrous databases. MasterCard has amassed a data circulation focus that is more than 100-terabytes in size. Insiders expect that it will create to more than 1.8 petabytes.…

    • 933 Words
    • 4 Pages
    Great Essays
    Read More
  • Improved Essays

    Advantages And Disadvantages Of Dbt
    • 1118 Words
    • 4 Pages

    Advantages And Disadvantages Of Dbt

    Dialectical Behavior Therapy: Original Design Dialectical Behavior Therapy (DBT) was first developed by Marsha Linehan for the treatment of individuals suffering from Borderline Personality Disorder (BPD) and suicidal or self-injurious behavior (Swales, 2009). In her work with these individuals, Marsha noticed that many of them were not engaged in or collaborating with a therapeutic process based on change. She hypothesized that many of these individuals did not believe they had the ability to change, so a therapeutic method based on change was not going to work.…

    • 1118 Words
    • 4 Pages
    Improved Essays
    Read More
  • Superior Essays

    Compare And Contrast Piaget's Stages Of Cognitive Development
    • 797 Words
    • 4 Pages

    Compare And Contrast Piaget's Stages Of Cognitive Development

    1. In your own words, describe Piaget’s stages of cognitive development, describing the major characteristics of each stage. According to Jean Piaget, a child psychologist, children progress through a series of four main stages of cognitive development. Each stage is marked by changes in how the children perceive the world in terms of their thoughts, knowledge and judgment.…

    • 797 Words
    • 4 Pages
    Superior Essays
    Read More
  • Improved Essays

    Advantages And Disadvantages Of Management Control System
    • 1406 Words
    • 6 Pages

    Advantages And Disadvantages Of Management Control System

    More and more organizations utilize a management control system (MCS). A MCS can assist an organization with evaluating the organization, as well as implementing corporate strategies that will enable the organization to roll out corporate-wide systems. Typically a MCS covers the administrative and financial areas of an organization.…

    • 1406 Words
    • 6 Pages
    Improved Essays
    Read More

Related Topics

Ready To Get Started?
Discover
Company
Follow
©2024 Cram.com
Privacy Policy |  About Ads |  Site Map |  Advertise  | 
  • Cookie Settings