Compare and contrast multi-paradigm solutions to domain specific database constructs.
computer science
Description
Advanced Databases and Big Data
Learning Outcomes Assessed
LO2: Compare and contrast multi-paradigm solutions to domain specific database constructs.
LO4: Evaluate appropriate technologies to develop database solutions.
Scenario:
Fast Forwarding Ltd. is a global freight forwarding company based in the UK for over 50 years. The company offers worldwide freight service including land, sea and air from the offices in Asia, Europe and North America. The company has over 100 logistic partners through its own offices and agencies. They ship thousands of containers per annum throughout the globe.
The company goal is to full-fill any size of the consignment to any country. Currently, Fast Forwarding is using an in-house management system to support customer 24/7 throughout the globe. The company also use multiple software components such as databases, track and trace and payment systems, from third parties. As the business growing every year, the company produces a high volume of data, which needs to be managed efficient manner. The management has decided to improve the existing management system and build a modern information management system to meet the future goal of the company. The proposed system requires the following functionalities.
• To be adaptable to the growth of the company
• To have appropriate database system to meet the expansion plan of the company
• To have modern database systems that are scalable and capable of storing various types of data
• To visualise the system performance
• To have the solution to handle various types of databases systems
• Customer must be able to track and trace their consignments
Part 1: Multi-paradigm database solutions (LO2)
The company is using basic RDBMS system to store data, which does not allow any data warehousing facilities. The current does not allow integration of data from multiple heterogeneous sources that could support analytic, reporting, data cleansing, or integration. The management wants you to design a data warehouse architecture that will persuade how multiple data sources can help to produce queries, reports, mining and analytics. Discuss your data warehouse architecture in detail and justify why this solution would be better for the company’s future warehousing.
The whitepaper should have a word count of 2500 words and at least 6 references of which 3 should be relevant peer-reviewed journal/ conference papers.
Part 2: Database solutions (LO4)
Evaluate appropriate Big Data technologies for Fast Forwarding’s to develop a database solution. Since the company wants to analyse both structured and unstructured data in real time to check the performance of freight shipment, they need a system that can deploy effective data analytics. Analyse big data analysis and visualisation techniques that influence the organisation’s decision-making in cost-effective database solution.
Write a report of 2500 words to inform the company management about the technologies available and how they will fit for the company’s new database solutions. The report should identify and compare various Big Data visual tools and techniques suggest three suitable visual tools and/ or techniques to meet the company’s future need. The report should have at least 6 references of which 3 should be relevant peer-reviewed journal/ conference papers.
