INF30010 / 80037 Database Administration 代写

  • 100%原创包过,高质量代写&免费提供Turnitin报告--24小时客服QQ&微信:273427
  • INF30010 / 80037 Database Administration 代写

    INF30010 / 80037
    Database Administration
    Assignment 1
    Contemporary Issues in DBA
    August 2017
    INF30010 Assignment 1
    1. Introduction
    Database Administration is fundamental to modern day business: without good database
    administration, database designs can become outdated, performance may become suboptimal,
    user needs are less likely to be met over time, data loses integrity, and the whole system may
    completely fail.
    All mainstream DBMS require ongoing maintenance. It is the role of the Database Administrator to
    keep database systems online, up-to-date, and functioning efficiently, and delivering on user
    demands. They can play a role in evaluating new systems or updates, designing the database,
    establishing use and access policies, tuning the database, ensuring backup and recovery, and
    planning for future developments. Database Administrators and tools for administering databases
    have been around as long as databases: new tools emerge over time, as do specialist roles – these
    developments depend on both the technological opportunities and business needs of the day.
    In this assignment, working in teams, we challenge you to explore some of the contemporary
    challenges and opportunities facing organizations and database administrators. To this end, each
    group will focus on a specific DBA issue, independently and critically analyse relevant literature and
    tools, and communicate findings via a group report and presentation. The aim is for students to
    better understand database administration in the context of modern organizations, in terms of
    performance requirements, monitoring approaches, available tools, and improvement strategies,
    INF30010 Assignment 1
    2. Activities and Requirements
    To successfully complete this task, you and your group will need to complete the following tasks and
    requirements. If you’re unsure about any of the steps please consult your lab instructor or the
    course convenor.
    i.  In Week 3 of the unit, your lab instructor will help organize you into groups of 4 students
    ii.  Each group will either select or be allocated a topic (see below). Each topics consists of brief
    background and set of questions that needs to be understood and researched.
    iii.  In addition to the above, each group should ensure they’ve answered the following general
    questions, relevant to all topics: 1) Critically examine the societal and/or organizational
    trends driving the uptake of the DBA-related technology; 2) Explore and explain the technical
    nature of the DBA-related technology (i.e. hardware, software, networks, models,
    standards/protocols) and how these complement or compete with conventional DBA tools;
    3) Explain the approaches and potential challenges for implementing the DBA technology
    within organizations; 4) Identify and articulate any changes to the role of DBA – or new roles
    a DBA might be required to undertake; 5) Hypothesize what the impact of your topic area
    will be on DBAs (individuals and the industry), organizations, and society more broadly – in
    the next 5 to 10 years (you might develop multiple scenarios); 6) If possible, identify a real
    case study organization or individual and use it help further demonstrate and justify your
    answers to the first five questions (note: you can use DBA industry contacts here, or make
    use of grey literature, or even academic literature from the library)
    iv.  Before commencing the research, the team must decide and record how it plans to work
    together. The following should be completed: a) decision on whether to appoint a team
    leader; b) outline of when, where, and how often the team plans to meet; c) a code of set of
    rules to which all team members must adhere to, including incentives or penalties in cases
    where team members fail to adhere to the code; d) articulation of the tasks than need to be
    completed by the team; e) clear allocation of which team members will complete what tasks;
    f) justification that the allocation of tasks is equitable; g) a timeline or Gantt chart identifying
    when each task is to be completed. This team plan should be recorded by the group and
    submitted as an appendix to the final report. Minutes of each meeting should also be kept
    and submitted in the appendix.
    v.  Using iii as your guide, investigate and research your allocated topic area. You can make
    use of academic literature, grey literature, web resources, and case studies. You can also
    speak with industry experts and/or leaders within the field. If you do this, be sure to seek
    their permission to be recorded (verbally or written) and make clear that the information
    they provide you will only be used within your group report. Your topic might also require
    you to analyse, test, and apply different database administration tools – either online or
    available from within Swinburne’s ICT suite of hardware and software. When undertaking
    these investigations remember you’ll need an approach for assessing the tools and record
    your findings.
    vi.  Synthesize your research findings into a structured report. The report should be no longer
    than 3000 words. It should be written in English and make use of correct spelling and
    INF30010 Assignment 1
    grammar. Include a title page, executive summary and contents page. You may structure the
    sections however your group prefers, but, it should be logical and well organized. If
    necessary, you may include SQL statements and/or scripts as needed. These should be
    added as an appendix. The report should, where necessary, cite the relevant literature used
    to make arguments and arrive at conclusions. A reference section (or bibliography) should
    be provided at the back of the report: be sure to use a standard and consistent approach to
    referencing. Likewise, if you used interviews with industry contacts, you should disclose and
    provide citations in the appropriate places within the report. The backend of the report
    should include sections covering discussion, recommendations (if any), and conclusions.
    Each group member should make a contribution to the report. The report should be
    submitted in hardcopy at the end of Week 8. The group report is marked out of 20 (or 20%
    of the final unit grade).
    vii.  Your group should also convert the report into presentation format. Your group will
    present your topic during Week 7 or 8 of the course. Your group can choose the format of
    the presentation, however, it should run for 20 minutes and allow for 10 minutes of
    questions. You can make use of MS Powerpoint or other presentation software and tools.
    Ambitious groups might like to include (and even create) videos, animations and other form
    of multimedia. Each group member should be available to answers questions during
    question time, although, not all group members necessarily need to present during the
    presentation. The group presentation is marked out of 10 (or 10% of the final unit grade).
    Combined the presentation and report are marked out of 30 (or 30% of the final unit grade).
    INF30010 Assignment 1
    3. Topics
    Below is the list of topics. You and your group will be assigned one of these topics. For each of the
    topics, your report and presentation should cover the general questions (see Section 2, part iii) and
    any specific questions raised in the topic descriptions below.
    a) DBAs in the Cloud
    Over the last 5-10years, cloud service offerings have grown exponentially in uptake. Organizations
    have been quick (and sometimes slow) to incorporate cloud services to store data and manage data.
    What is driving this uptake? Can you provide examples and/or compare common cloud data storage
    and management service providers? What technologies do they make use of? How should DBAs
    evaluate cloud services? What challenges does storing data off premises in the cloud create for
    DBAs? Does the DBA remain ultimately responsible when data and database services are put into
    the cloud? What advice can we give to DBAs when managing data in the cloud?
    b) Big Data, NoSQL – the end of DBA?
    Big data is a hype. Big data is a reality. Whilst structured data dominated the world of databases for
    decades, since the 2000s, solutions for creating and storing unstructured data (think NoSQL) have
    gained in prominence. What is big data? What is driving big data? How is big data different to
    conventional data? What has driven the rise of unstructured data management solutions? What are
    some of the key contemporary tools available for managing unstructured data? Compare different
    offerings. What is driving the trend to integrate SQL and NoSQL solutions? Can you provide
    examples? How do they work? What is the role of databases and database administrators in the age
    of big data? Does NoSQL mean no DBA? Is there any difference for a DBA working in a NoSQL
    environment?
    c) Open Source DBMS vs. Commercial DBMS
    Open Source DBMS have rapidly gained in popularity over the last decade. What is the difference
    between an Open Source and Commercial DBMS? What are some of the most popular Open Source
    DBMS? Are they technically different to some of the more common Commercial DBMS? If yes, in
    what ways (perhaps provide some comparisons)? Is database administration any different with an
    Open Source Solution? If yes, explain. Why have Open Source gained in popularity? Provide some
    examples of organizations that have commenced using Open Source DBMS (perhaps alongside a
    Commercial DBMS). What does the rise of Open Source mean for DBAs?
    d) Database Diversity 4 DBAs
    DBAs are increasingly being asked to be responsible for multiple databases running on multiple
    platforms. In modern contexts, a DBA might be responsible for administering dozens of databases
    at any one time. What is driving this proliferation in diversity? Is this trend likely to continue? Is there
    a limit? What are some of the most common vendor technologies that a DBA needs to be across?
    What are the key differences between them – and what challenges does that create for the DBA?
    What are some of the good practices DBAs can put in place to help manage this increasingly
    complex and demanding environment.
    e) Database Performance, DBAs, and the Age of the App
    We’re living in the age of the app. Databases lie at the heart of most apps. The challenge for DBAs is
    that database performance is now, more than ever, more closely linked to application performance
    – and vice versa. What has driven business to focus more applications? Is this trend likely to
    INF30010 Assignment 1
    continue into the future? In these contexts, what should database performance be measured on?
    What can DBAs do at the organizational level to respond to the focus on applications (hint: think
    about DevOps)? What are some of the technical tools and options available to DBAs to improve
    performance - of both app and database?
    f) Automation of DBAs
    Automation of administrative and maintenance tasks is a hot topic across many industry sectors –
    database administration included. Is automation impacting on database administration? What might
    be driving the trend? What are some of the example technologies and tools that can be used to
    automate DBA tasks? How do they work? What do they enable? Does automation eliminate the need
    for DBAs? How might automation change the roles and tasks of DBAs? What tasks can be
    automated? Which tasks cannot? How is automation going to impact on the field of DBA in the next
    5 to 10 years.
    g) DBA Offshoring
    In developed economies, IT offshoring has been an increasing trend over the last decade –
    particularly in highly repetitive tasks, perhaps including DBA? What is offshoring? What do you think,
    are the tasks associated with DBAs the kind that can be offshored? Which tasks can? Which cannot?
    What might be some example technical set ups in terms of backup and recovery, when it comes to
    offshoring DBA activities? What are some of the benefits of DBA offshoring? What are some of the
    risks and problems? Can you identify success stories or case examples? What about failures? What
    can a DBA expert do to respond to offshoring?
    h) DBAs 4 Data Warehousing and BI
    As early as the 1970s, Data Warehouses emerged in response to the opportunity to leverage of
    transactional data held in operations databases. What is a data warehouse? What are some of the
    common performance issues that Data Warehouse DBAs must deal with? What technical tools and
    approaches are available to DBA Data Warehouse specialists? How do they work? What future
    trends are evident in the domain of Data Warehousing? How will this impact on the DBA? Does the
    DBA need to upskill? Will the Data Warehousing DBAs role change or further specialize within an
    organization?
    i)  Database Security and DBAs
    Security has always been a key focus of the DBA toolkit, but, its importance has been emphasized in
    recent times. What is driving the increased focus on database security? What are some of the most
    common attacks? Can you identify case examples and identify at what level a security breach
    occurred – did it relate to weaknesses in the database administration? What is the role of the DBA
    when it comes to data security? What tools does a DBA have to help maintain data and database
    security? Are there newly emerging data security tools? How do these differ from conventional
    tools? How can a DBA contribute to IT security more generally across an organization? How should
    DBAs work with IT security teams?
    INF30010 Assignment 1
    4. Submission and Marking Rubric
    The group report is submitted in Week 8 (Friday 29 th September @ 17:00 AEST), once all
    presentations have been completed. The report should be submitted online, by one group member,
    using the submission instructions provided on Blackboard. The report will be assessed for
    plagiarism.
    The group presentation is completed at an allocated slot during the lecture sessions in Week 7 or
    Week 8. The lecturer will allocate your group a time prior to those weeks. The presentation slides (or
    files) should be submitted online on Blackboard, following the instructions provided, by one group
    member, by Friday 29 th September @ 17:00 AEST.
    A single mark out of 30 (30% of total unit grade) is provided for the whole assignment, however, it is
    made up of two main components: the presentation and the report. The marking rubric for these
    components is provided below. All criteria carry equal weighting for both the report and
    presentation components.
    INF30010 Assignment 1
    Criteria  Fail  Pass  Credit  Distinction  High Distinction
    Report
    Context: Appreciation of
    organizational or societal
    contexts within which
    DBAs operate
    None provided  Superficial or little
    shown or articulated
    Several issues
    identified and
    impact on DBAs
    explained
    Clear articulation of
    key issues -
    explained and
    justified
    Excellent
    organization,
    articulation and
    explanation
    Technical: Identification
    and explanation of
    technical aspects in DBA
    development
    No technical DBA
    aspects covered
    Limited to no
    covered of DBA
    technical aspects
    Key technologies
    and tools
    explained
    Good breadth of
    relevant technical
    aspects
    Excellent breadth
    of relevant
    technical aspects
    Analysis:
    Evidence of critical
    examination and fusion of
    contextual and technical
    DBA issues
    No analysis or fusion
    evident
    Analysis is
    superficial, siloed,
    and/or includes
    minimal synthesis
    Good effort to
    synthesize
    technical and
    contextual aspects
    Excellent coverage
    and fusion of
    technical and
    contextual aspects
    Evidence of
    contribution to
    knowledge in the
    specific topic area
    Communication:
    Approach to conveying
    written message to target
    audience
    Report is incomplete
    or several elements
    are unsatisfactory
    All required
    elements of the
    report are provided.
    Some structure.
    Good structure. All
    required elements.
    Easy to read.
    Professionally
    presented and
    structured. Well
    written. Good use of
    aids.

    INF30010 / 80037 Database Administration 代写
    Industry standard
    report – all
    elements excellent
    Teamwork:
    Level of organization,
    comradery, and shared
    vision across group
    No evidence  Evidence provided.
    Some coherence in
    report
    Evidence provided.
    Report is coherent.
    Detailed evidence
    provided – backed by
    professional report
    Industry level
    evidence of
    teamwork +
    reporting
    20 marks
    INF30010 Assignment 1
    Presentation
    Context Appreciation of
    organizational or societal
    contexts within which
    DBAs operate
    None provided  Superficial or little
    shown or articulated
    Several issues
    identified and
    impact on DBAs
    explained
    Clear articulation of
    key issues -
    explained and
    justified
    Excellent
    organization,
    articulation and
    explanation
    Technical Identification
    and explanation of
    technical aspects in DBA
    development
    No technical DBA
    aspects covered
    Limited to no
    covered of DBA
    technical aspects
    Key technologies
    and tools
    explained
    Good breadth of
    relevant technical
    aspects
    Excellent breadth
    of relevant
    technical aspects
    Analysis
    Evidence of critical
    examination and fusion of
    contextual and technical
    DBA issues
    No analysis or fusion
    evident
    Analysis is
    superficial, siloed,
    and/or includes
    minimal synthesis
    Good effort to
    synthesize
    technical and
    contextual aspects
    Excellent coverage
    and fusion of
    technical and
    contextual aspects
    Evidence of
    contribution to
    knowledge in the
    specific topic area
    Communication
    Approach to conveying
    written message to target
    audience
    Presentation is
    incomplete or
    several elements are
    unsatisfactory
    All required
    elements of the
    presentation are
    provided. Some
    structure.
    Good structure. All
    required elements.
    Easy to follow.
    Professionally
    presented and
    structured. Good use
    of aids.
    Industry standard
    presentation – all
    elements excellent
    Teamwork
    Level of organization,
    comradery, and shared
    vision across group
    No evidence  Evidence of
    coherence and
    comradery in
    presentation
    Presentation is
    highly cohesive
    and consistent
    Professional
    transitions and
    interactions amongst
    group
    Industry level
    teamwork
    10 marks
    Total  30 marks
    INF30010 / 80037 Database Administration 代写