Going through large databases, such as your personal or professional network, can be complicated. Especially when you’re working with data connected to each other. But we’re here to demystify the technology. Why? We believe that when you understand the power of what’s at your fingertips, you can use it to your own advantages as well.
First, let’s go back to the basics. What is a database? A database is a way of organizing information for you to easily access, manage, and update it. Data is typically organized in tables with columns and rows.
The relationship between data is essentially the logic of combining data from one or more tables. Usually, these fall into three categories:
- One-to-one relationship: the simplest kind of relationship that links two columns of data with unique values in every row. This is useful only when relationships match only one to one counterpart. E.g. Country – Flag, each country has one flag and one flag belongs to one country.
- One-to-many/many-to-one relationship: One table holds unique values and the other holds duplicate values for corresponding values in the first table. This allows you to store relevant information on each distinct entity. E.g. a consultant works on multiple projects, and a project can have more than one consultant working on it.
- Many-to-many relationship: Entities on either side of the relationship can have duplicate values and multiple data points. E.g. Customer–Product, one customer purchases many products, and each product can have multiple customers.
Our app, Weavit, takes all different kinds of data from your world and creates many-to-many relationships. This ranges from the friends you have to your professional connections, to the books you read, so on and so forth. Let’s look at a specific example. Say you wanted to search for the closest relationships to you in your professional network. Each person you’re connected with can also have many connections, and each of those people can have many other connections.
At Weavit, we’re identifying your professional and personal networks and the relationships between them. By the way, we do all the work so you don’t have to. Our app connects the dots across the data you’re connected to and retrieves this information with a simple search. Simplify your life, and test it today.