You are the senior data administrator at a small to mid-size organization. The IT department director wants you determine the best data configuration which will maximize operational efficiency and effectiveness for the organization based on the following organizational information:
Sales and marketing
Customer relations management system (data & database not connected to any other system)
Data resides in a cloud-based solution Human resources Payroll and benefits system (data & database not connected to any other system)
Data resides in on-premise servers Building and grounds
Work order system and inventory system (data & database not connected to any other system) Data resides in an on-premise Network Attached Storage (NAS)
Finance and accounting Budgeting and capital expenditure system (data & database not connected to any other system) Data resides in an on-premise server
Information technology (data & database not connected to any other system)
Help desk and work order system (data & database not connected to any other system) Data resides in an on-premise Storage Area Network (SAN)
Administration Separate report interfaces to each system
Your report (paper) must:
Define each data storage term: database, data warehouse, data pool, data lake, and data mart. Explain the function(s) of a database, a data warehouse, a data pool, a data lake, and a data mart.
Explain the relationship between databases, data warehouses, data pools, data lakes, and data marts.
Identify the most efficient and effective data and database configuration for the organization and explain why your selection is the most efficient and effective.
Identify potential data recovery risks with your solution.
Required Section Headings:
Introduction – 1 paragraph
An introduction should (a) provide the context needed to understand your topic; (b) identify the topics covered in the paper; and (c) provide a clear sense of the paper’s direction
Definition of Terms
Functions and Use
Relationships
Configuration Solution
Risks
Summary/Conclusion
Remember to support your statements with factual information (i.e., attribution/citations) from subject matter experts and/or scholarly sources and use a formal writing style. In addition, material from the course textbook or the textbook’s author(s) cannot comprise more than 25% of the sourced and/or quoted material.
The paper must follow the formatting guidelines in the most current version of The Publication Manual of the American Psychological Association and contain a title page, five scholarly references, three pages of content, and a reference page. In addition, the paper will be submitted through the Turnitin originality-checking tool.
APA formatting assistance can be found at the Purdue University Online Writing Lab. In addition, the WilmU Student Success Center’s website contains more resources related to APA Formatting, Grammar, and Research Writing.
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|