database systems

  1. Research the Internet for database vendors that provide cloud computing services and complete the following:
    1. Estimate  the types of costs involved or the pricing structure required when  implementing a cloud-hosted solution for a database.
    2. Analyze security considerations and pricing of the different cloud implementation types.
    3. Rank  the cloud services options of Software as a Service, Platform as a  Service and Infrastructure as a Service in terms of functionality,  mobility, and ability to provide distributed transaction concurrency.  Compare how these cloud-based services fit within an environment where  users are mobile. Determine the technical provisions that would be  required to ensure data integrity.
  2. Evaluate  whether the use of a distributed DBMS structure is appropriate and  identify the optimization techniques that should be factored in to  enhance the operations of the database in your design.
  3. Provide  at least two (2) examples of how lost updates and uncommitted data may  occur, keeping in mind that five (5) stores will be generating  transactions.
  4. Determine  the concurrency control factors that can be used to ensure valid  execution of transactions within the current multiuser environment.
  5. Research  the Internet for backup and restoration recovery solutions and database  security threats that could be applicable to the department store. Upon  your research, complete the following:
    1. Suggest  at least two (2) options that could be made available to provide  disaster management functions for the database system within the retail  environment.
    2. Assess  the types of security threats that may exist when managing the  department store database and suggest measure(s) that can be performed  to minimize these threats that are particular to retail.
  6. Use at least six (6) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

Your assignment must follow these formatting requirements:

  • Be  typed, double spaced, using Times New Roman font (size 12), with  one-inch margins on all sides; citations and references must follow APA  or school-specific format. Check with your professor for any additional  instructions.
  • Include  a cover page containing the title of the assignment, the student’s  name, the professor’s name, the course title, and the date. The cover  page and the reference page are not included in the required assignment  page length.
  • Include  charts or diagrams created in any chart or drawing tool with which you  are familiar. The completed diagrams / charts must be imported into the  Word document before the paper is submitted.