Advantages And Disadvantages Of The Database Management System

Better Essays
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

  • Decent Essays

    Operations management is the manage lifecycle and performance operations functionalities. It evaluates performance on how exactly APIs are performing within the system, develops reports for investigating APIs, allows a staging process to be set up for testing APIs ability to interact within the system, and over all help migrates versions of APIs easily into the system. Identity…

    • 1025 Words
    • 5 Pages
    Decent Essays
  • Decent Essays

    The purpose of generalized audit software programs is to perform a variety of auditing operations on the computer files used to store the information. The steps to be followed by the internal auditor to use generalized computer audit software include: • planning and designing the audit application. • ensuring that the output and final reports are generated from the files being • tested. ii. The purpose of integrated test facility (ITF) packages is to test both source data controls and processing controls.…

    • 828 Words
    • 4 Pages
    Decent Essays
  • Decent Essays

    For example, system analyst jobs is to solved problems that related with the computer technology, database administrator is responsible for the performance and security of a database and also involved in the planning and development of the database. Network administrator jobs is to maintains computing environment such as monitoring network performance, installing upgrades regarding to the network, so on and so forth. For the web developer, their job varies depending on whether they work mainly for clients or in house for an organization. But, my point is that, at Fintech Solution IT department, their job position is vital in keeping the company running productively, proficiently and…

    • 1337 Words
    • 6 Pages
    Decent Essays
  • Decent Essays

    It emphasises on the kind of data and software combined to deliver information necessary for the implementation of the business strategy. Rouse (2010) identified various data management policies like Data life cycle Management, Master Data Management policy and Big Data Management policy. The Data Life Cycle Management policy focuses on managing how information flows throughout the data’s life cycle. The policy controls data movement from the creation stage until the time the data is deemed obsolete. The other that is Master Data Management strategy enables an enterprise to link all its crucial data together through a master file.…

    • 986 Words
    • 4 Pages
    Decent Essays
  • Decent Essays

    Kelly's Salon Case Study

    • 1186 Words
    • 5 Pages

    SaaS has an automated vendor that offers testing services. Automated testing is necessary since SaaS is a web-based solution and during this procedure it uses devices to handle quality aspects in the functioning, interface and unit. Therefore, to ensure that the system operates effectively to meet Kelly’s business requirements, she will create at least two databases; Production database for the daily activities of the…

    • 1186 Words
    • 5 Pages
    Decent Essays
  • Decent Essays

    The above shows that the main issue of distributed computing is programs in execution, which are called processes. The second issue is that these processes cooperate or compete in order to provide the requested services. This means that these processes are synchronized. A natural model of distributed computing is the client-server model, which is able to deal with the problems generated by distribution, could be used to describe computation processes and their behavior when providing services to users, and allows design of system and application software for distributed computing systems. Client-server communicates at the virtual (logical) level by exchanging requests and responses.…

    • 1122 Words
    • 5 Pages
    Decent Essays
  • Decent Essays

    This container is called the web container (also known as the servlet engine). Unified Modelling Language (UML) UML is a standard language for creating blueprints that depict the structure and design of the software system. The several tool are: Rational Rose, Jude, ArgoUML, and Visio which are used to design software systems using UML. The basic building blocks of UML are: 1. Basic UML constituents: Include the static, dynamic, grouping and annotational constituents of UML.…

    • 1873 Words
    • 8 Pages
    Decent Essays
  • Decent Essays

    GUI shall be designed for the system to communicate with the users. The system depends on functioning database, operating systems, and hardware. The system depends on working LAN, WLAN, and/or TCP/IP connections. The success of the system is dependent on the users capability of operating the software. 4 Detailed Design 4.1 Screen Display Samples 4.2 Detailed Object…

    • 713 Words
    • 3 Pages
    Decent Essays
  • Decent Essays

    Relational Database Paper

    • 800 Words
    • 4 Pages

    The relational database consists of data the business needs to be operational. Relational databases split data into two-dimensional tables as entity and attributes. Every level of the…

    • 800 Words
    • 4 Pages
    Decent Essays
  • Decent Essays

    The first research question was explored through the literature review and consideration of the needs of the WCC as an example of an organization requiring an asset management information system. When attempting to update their model (Delone & McLean, 2004) there were three major dimensions of information system quality. These included service, system, and information quality. Each of these measures of quality needs to be investigated, controlled, and measured (Petter, DeLone & McLean, 2013). This is important since the majors will have an influence on user satisfaction and use.…

    • 724 Words
    • 3 Pages
    Decent Essays