Click here to Skip to main content
15,064,275 members
Please Sign up or sign in to vote.
1.00/5 (3 votes)
I have to prepare an algorithm that finds, relation between data across multiple databases, degree of relationship between databases and find transformation across databases when data moves from one database to other.

It is a data lineage problem in which we can input multiple databases and we can get charts/conclusions of the above mentioned situations as an output.

What I have tried:

I'm new to this, so I don't know where to start.
Posted
Updated 19-May-21 22:21pm
Comments
CHill60 19-May-21 9:01am
   
"I'm new to this, so I don't know where to start." - Presumably your tutor has given you some course notes? Refer to those first. Please read the posting guideline - we are not here to do your research for you, but we will help with specific problems
Ayush1999 19-May-21 13:36pm
   
Understood, I just feel so helpless with my situation. I've sat for hours and I just can't figure on how to approach this.
Patrice T 19-May-21 10:01am
   
You may have to search internet on the topic.

This is a massive project so I'm not sure what you are expecting us to tell you. It sounds like you need to design this out better, create a database to store your data, and then start writing code to do what you want.
   
Quote:
Understood, I just feel so helpless with my situation. I've sat for hours and I just can't figure on how to approach this.
Let's try to get you started.

This article How to Write Code to Solve a Problem, A Beginner's Guide[^] is a good starting point. I know you are not asking to write code just yet, but the approach is sound. See how you get on.

If you really can't figure out where to start after that, then you really should talk to your tutor - it's their job after all :laugh:
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900