Preview

Enterprise Database Management System Paper

Good Essays
Open Document
Open Document
766 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Enterprise Database Management System Paper
Enterprise Database Management System Paper
Tania Hillard
Database Management / DBM 502
Pamela Hurd
June 25, 2006 Introduction This paper will discuss the implementation, use of an enterprise DBMS, the advantages and disadvantages of an enterprise DBMS. A database management system , or DBMS, gives the user access to their data and helps them transform the raw data into information. The DBMS is just a collection of programs that manages the database structure and controls access to the data stored in the database. These systems allow users to create, update, and extract information from their databases. When the mainframes dominated enterprise computing, the DBMS architecture was simpler concern. Mostly everything ran on the mainframe and that was that. Even for a mainframe DBMS implementation, the overall architecture will likely consist of multiple platforms and interpreting pieces of system software. Information technology experts should include database resource management representatives including data administrators, database administrators, and system administrators.
However, you always want to be sure that the DBMS you select is appropriate for the nature of business and type of processing you plan to implement. There are four level of DBMS architecture that you can chose or selected from: enterprise, departmental, personal, and mobile.

Levels of DBMS Architecture

Enterprise DBMS An enterprise DBMS is designed for salability and high performance. It must be capable of supporting very large databases, a large number of concurrent users, and multiple types of applications. The enterprise DBMS will run on a large-scale machine, typically a mainframe or a high-end UNIX, Linux, or Windows NT machine. Furthermore, an enterprise DBMS offers all of the "bells and whistles" available from the DBMS vendor. Mulit-processor support, support for parallel queries, clustering, and other advanced DBMS features will be core components of an



References: Mullins, Craig. Database Trends: "DBMS Architecture".(June 2002) Retrieved June 25, 2006 from http://www.craigsmullins.com/dbta_010.htm (n.d.) What is DBMS? Retrieved June 25, 2006 from http://www.units.muohio.edu/mcs/other/aisparchive/Oracle/4_what_is_dbms.htm (n.d.) Linux Means Business: Databases. Retrieved June 25, 2006 from http://www.linuxlinks.com/local/business/databases.shtml

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Enterprise systems are large scale, integrated application software that allow for collaboration and communication across an organization. They use the computational, data storage, and data transmission of information technology. Enterprise systems are used through the collection of data that can be accessed and used by multiple departments within an organization. Enterprise systems increase operational efficiency by providing the necessary information that allows managers to make better decisions. They help organizations respond quickly to customer requests for information or products. These systems integrate order, manufacturing, and delivery data. The central database…

    • 645 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    Dbm 380 Week 1

    • 1191 Words
    • 5 Pages

    Database environments are very important in today’s industries. In selecting an organization that will need a database, I choose Smith Consulting. Smith Consulting will need a database to track their consulting staff, each staff member’s skill sets, and what projects they will be working on. This document will provide information on the following area’s listed below:…

    • 1191 Words
    • 5 Pages
    Powerful Essays
  • Powerful Essays

    Pt2520 Unit 6

    • 1447 Words
    • 6 Pages

    What is the role of a DBMS, and what are its advantages? What are its disadvantages?…

    • 1447 Words
    • 6 Pages
    Powerful Essays
  • Satisfactory Essays

    • Define relational database architecture. Consider Microsoft® Access*', Microsoft SQL Server®', Oracle®, IBM DB2®, and so on.…

    • 352 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Acme Global Consulting

    • 678 Words
    • 3 Pages

    Hello sirs, my name is , I am forwarding this correspondence to give you options pertaining to your database management system or DBMS. One of these options is to install an Entity Relationship Model or E-R model DBMS, the reason I am suggesting an E-R model is there are a number of advantages to installing and managing this type of DBMS in your company. I will provide you with information on the advantages of them in this proposal.…

    • 678 Words
    • 3 Pages
    Good Essays
  • Best Essays

    Rob, P., & Coronel, C. (2002). Database systems: design, implementation, and management (5th ed.). Boston, MA: Course Technology.…

    • 1383 Words
    • 5 Pages
    Best Essays
  • Satisfactory Essays

    Week2 Discussion2 DBMS

    • 480 Words
    • 3 Pages

    References: 1) Database system Design implementation and management 9th edition Coronel, C., Morris, S.,& Rob, P(2011).…

    • 480 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    The purpose of this project is to conduct an analysis research into the implementation and management of this business enterprise system. This project deals with developing and upgrading the computer system to handle to daily work load of our business while being able to conduct communication between sites and data back-up. Furthermore, we will analyze other various architectures features such as: system requirements, architecture selection, resources and timeline, security and the final analysis and recommendations…

    • 5638 Words
    • 19 Pages
    Powerful Essays
  • Good Essays

    Dbm 381 Week 1paper

    • 885 Words
    • 4 Pages

    A database is a structure that can store information about multiple types of entities, the attributes of those entities, and the relationships between the entities (Pratt & Adamski, 2012, Chapter 1). How data is received, stored, processed, and made available to others has an effect on the success or failure of an organization. The use of different architecture is a most to fit the needs of the organization, however the value of the data still remains in been able to access and extract information from the database system, and the only way this can be reached is by organizing, storing, and analyzing it effectively. For many organizations these systems have become an essential part of their structural and operational success.…

    • 885 Words
    • 4 Pages
    Good Essays
  • Good Essays

    References: Coronel, C., Morris, S., & Rob, P. (2013). Database systems: Design, implementation, and management (10th ed.). Independence, KY: Cengage.…

    • 906 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    References: Coronel, C., Morris, S., & Rob, P. (2011). Database systems: Design, implementation and management (9th ed.). Mason, OH: Cengage Learning.…

    • 1451 Words
    • 4 Pages
    Powerful Essays
  • Powerful Essays

    CS-669 Assignment 1

    • 985 Words
    • 4 Pages

    The purpose of the DBMS is to service between users’ applications and database. This way of accessing to data through the DBMS brings several advantages. First of all, it supports multiple user access at the same time, which helps to update data just in time.…

    • 985 Words
    • 4 Pages
    Powerful Essays
  • Better Essays

    In this paper I am going to discuss about the database and software used in my construction company. Oracle database is a multi platform database, meaning it can run efficiently on any operating system and this makes Oracle flexible and more secure when compared to its competitors. Our Oracle database is running on a Sun server, using the Sun Solaris enterprise operating system. Oracle databases are an enterprise database system, only medium and large companies would need an enterprise database. Oracle Corporation uses RDBMS rational database management systems to maintain all data within the organization. Various data items can be organized according to their relationships with each other, such as the relationship of Employee name and Employee ID, rational databases give Oracle a great deal of flexibility when describing the relationship between data elements. Oracle follows Dr.Cobbs 12 rules on how a true RDBMS should be evaluated. The following are Cobb's 12 rules.…

    • 807 Words
    • 4 Pages
    Better Essays
  • Good Essays

    One of the most important elements of a computer based information system is the database. A database is a collection of records or information that is stored in a computer in a structured manner so that information can be stored, managed, and retrieved. Databases are very useful for manipulating large amounts of data and producing reports and documents. This paper takes a look at the Oracle database system and its usage within my organization.…

    • 592 Words
    • 3 Pages
    Good Essays
  • Best Essays

    Data Warehousing and Olap

    • 2507 Words
    • 11 Pages

    In the 1990s, as businesses grew more complex, corporation spread globally, and competition became fiercer, business executives became desperate for information to stay competitive and improve the bottom line. Data warehousing technologies have been successfully deployed in many industries: manufacturing (for order shipment and customer support), retail (for user profiling and inventory management), financial services (for claims analysis, risk analysis, credit card analysis, and fraud detection), transportation (for fleet management), telecommunications (for call analysis and fraud detection), utilities (for power usage analysis), and healthcare (for outcomes analysis). This paper presents a roadmap of data warehousing technologies, focusing on the special requirements that data warehouses place on database management systems (DBMSs).…

    • 2507 Words
    • 11 Pages
    Best Essays