BITP 2323 Data is used by different people in different...

This preview shows page 1 - 13 out of 48 pages.

BITP 2323
Image of page 1

Subscribe to view the full document.

Data is used by different people, in different departments, for different reasons Interpretation and presentation of data in useful formats Information Distribution of data and information To the right people At the right time Wherever needed Data Preservation Control over Data Duplication and Use
Image of page 2
Primary Role: To Support Managerial Decision Making at All Levels of the Organization Top Level Strategic Decisions Middle Management Tactical Decisions Operational Management Daily, Operational Decisions DBMS must provide each level a separate view of the data and support their specialized decision making roles Provide a seamless flow of information throughout the organization
Image of page 3

Subscribe to view the full document.

This is being driven by rapid changes in Technology Platforms (e.g. Micro vs. Mainframe vs. Server) Organizational Structure We will focus on the core functions and tasks of these roles (traditional or current)
Image of page 4
Data Processing Department Information Systems Department Service functions to provide end users active data management support Production functions to provide solutions to information needs (application development) DBA Database Administrator Number of DBAs and roles vary from company to company DBA’s function is very dynamic Distributed databases Internet databases Object Oriented databases Sophistication and Power of the DBMS packages
Image of page 5

Subscribe to view the full document.

Data Administrator (DA) Responsible for the overall management of data resources within an organization Database Administrator (DBA) Responsible for physical database design and technical issues in managing databases These roles are often combined or overlapped in some organizations
Image of page 6
DA Data administrator - person responsible for the Data Administration function in an organization Sometimes may be the CIO (Chief Information Officer) DBA Database administrator - person responsible for the Database Administration Function
Image of page 7

Subscribe to view the full document.

Database Planning Standards, procedures, enforcement Requirements Gathering and Conceptual Design Logical Design Physical Design and Implementation Testing and Debugging Operations and Maintenance Training and Support (Follows the requirements of the DBLC phases)
Image of page 8
Operation & Maintenance Database Implementation Database Design Growth & Change Database Analysis Database Planning
Image of page 9

Subscribe to view the full document.

Development of a strategic plan for database development that supports the overall organization’s business plan DA supports top management in development of this plan The result of this stage is an enterprise data model
Image of page 10
Develop corporate database strategy (DA) Develop enterprise model (DA) Develop cost/benefit models (DA) Design database environment (DA) Develop data administration plan (DA)
Image of page 11

Subscribe to view the full document.

This is the process of identifying data entities currently used by the organization, precisely defining those entities and their relationships,
Image of page 12
Image of page 13
  • Fall '17
  • DR RAJA RINA
  • Database management system

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern