Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Some Possible Topics for Minor Research Advanced Databases and Applications ( CP 5520) 1. Privacy Preserving Data Mining Two parties owning confidential databases wish to run a data mining...

1 answer below »

Some Possible Topics for Minor Research
Advanced Databases and Applications ( CP 5520)

1. Privacy Preserving Data Mining
Two parties owning confidential databases wish to run a data mining algorithm on the union of their databases, without revealing any unnecessary information. This problem has many practical and important applications, such as in medical research with confidential patient records.
2. Private Information Retrieval
A private Information Retrieval (PIR) protocol enables a user to retrieve a data item from a database while hiding the identity of the item being retrieved. The main cost-measure of such protocols is the communication complexity of retrieving a single bit of data.
3. Overview of spatial databases and investigation into spatial databases used in commercial Geographic Information Systems
It is believed that as much as 90% of business commerdirk.c.aumuellercial data is geographic data. The importance of handling geographic data is ever increasing. Geographic Information Systems (GIS) are information systems that deal with geo-spatial and temporal databases to solve geo-spatial problems. It is well noted that the application of GIS is only limited by the imagination of users. In this small project, you are going to investigate special features of spatial databases and how these are structured within commercial GIS such as ArcView, ArcInfo, and Smallworld etc.
4. Investigation into Data warehouses vs. transactional databases
We witnessed the explosion of data and stored data doubles in every three years. We are drowned by data and we need intelligent ways of structuring data. Traditional databases are not good enough to analyze these dynamically growing and large-scale data to make accurate and prompt decisions. Data warehousing is one of new techniques especially designed for online analysis. Data warehousing provides infrastructure and functions for business managers to systematically analyze their customer data to make strategic decisions. It provides OLAP (On-Line Analytical Processing) tools to analyze subject-oriented, integrated, time-variant and nonvolatile data.
5. When data mining meets databases
Data mining is one of steps in knowledge discovery in databases. It attempts to discover novel, previously unknown, ultimately understandable patterns from massive databases. This task is going to investigate how data mining can be improved from database techniques or how the database community can benefit from the development of data mining. You may investigate data mining query language, data mining query optimization, data mining system architectures. etc.
1
6. Clustering in data mining
Clustering partitions a number of data items into homogeneous groups so that it minimizes within group dissimilarities and maximizes between group dissimilarities. It is the most popular data mining techniques in the data mining community. This project is going to investigate various types of clustering in data mining. Note that, clustering techniques has been widely investigated within the statistics and machine learning communities. You need to investigate what makes clustering in data mining community differ from clustering in other communities.
7. Association Rules Mining
Association rules mining is the second widely used techniques in data mining. It searches for interesting relationships among items in a given data set especially in transactional databases. This will investigate what Association rules mining is, application areas, variants, etc.
8. Temporal Databases
A wide range of database applications manage time-varying data. In contrast, existing database technology provides little support for managing such data. The research area of temporal databases aims to change this state of affairs by characterizing the semantics of temporal data and providing expressive and efficient ways to model, store, and query temporal data. It requires the study of fundamental temporal database concepts, surveys state-ofthe-art solutions to challenging aspects of temporal data management, and also offers a look into the future of temporal database research.
or, choose a (database-relevant) topic of your interest.

Answered 71 days After May 12, 2022

Solution

Priyang Shaileshbhai answered on Jul 22 2022
94 Votes
Investigation into Data warehouses vs. transactional databases
Today's society places an increasing value on data. Data is being gathered in many different businesses on a massive scale. Instead of depending on hunches or intricate models, this data may now be used to make better judgments. Today, big data analysis is used in many facets of our life, including manufacturing, retail, and mobile services.
Transactional database
Third normal form data modelling is used to create and design transactional databases (3NF). Using this method, a database may be made to be as efficient as possible for the transactional applications operating on top of it. This design method follows a database architecture consisting of a group of atomic tables that are designed for quick inserts and updates in order to eliminate data duplication and redundancy.
This design method has the drawback of requiring you to combine a lot of smaller tables in order to find the answers to the questions you're trying to answer, which leads to poor query performance when you want to start conducting analytics and business intelligence. The cost of these "joins" significantly degrades database performance, causes lengthy query times, and occasionally cause queries to time out and not complete.
The fact that your database will replace earlier values with the most recent version of a transaction is one of the other drawbacks of this design strategy. Because of this, it is challenging to monitor changes over time, which is crucial for analytics. Companies without data warehouses frequently try to run analytics and business intelligence on copies of their transactional databases, as was previously indicated.
Data Warehouses
Data Warehouses employ...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here