Data Modeling is a process that involves the structuring of the data in the database by creating tables(objects), and columns(fields). So, to learn Data Modeling in Salesforce, the first thing one should learn is Database.
About Database
It is simply a base of data, and can also be defined as an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system (DBMS).
Databases are widely divided into two major types or categories namely, Relational or Sequence Databases and Non-relational or Non-sequence databases or No SQL databases. An organization may use them individually or combined, depending on the nature of the data and its required functionality.
Databases often store information about people, such as customers or users. For example, social media platforms use databases to store user information, such as names, email addresses, and user behavior. Such data can be used to recommend content to users and improve the user experience.
Table: Student |
||||
Id |
First Name |
Last Name |
|
Year of Birth |
1 |
Peter |
Lee |
plee@university.edu |
1992 |
2 |
Jonathan |
Edwards |
jedward@university.edu |
1993 |
3 |
Marilyn |
Kim |
mkim@university.edu |
1995 |
4 |
Joe |
Martinez |
jmartinez@university.edu |
1994 |
6 |
Haley |
Mfume |
hmfume@university.edu |
1992 |
12 |
John |
Letty |
jletty@university.edu |
1995 |
In A Relational Database
- Data related to each object/entity is stored in a separate table.
- Each table comprises a number of columns of a particular data type such as Text, Number, or Date.
- Information is stored in the rows of tables.
- Tables can be related to other tables using the concept of Primary Key and Foreign Key.
Whereas In Salesforce
- Databases use objects to store data.
- Each object comprises several fields that correspond to columns in a database.
- Data is stored in records of objects which correspond to the rows in a database.
- Objects can be related to other objects using relationship fields.
What Are Objects In Salesforce?
Objects in the Salesforce platform are represented in the form of a table which is used to categorize the data and is similar to an entity in a database.
Types Of Objects In Salesforce
There are 2 different types of objects in Salesforce:
1. Salesforce Standard Objects
Standard Objects are the objects which are already present in Salesforce by default. Common business objects like Account, Contact, Lead, and Opportunity are all standard objects. Although we can customize these standard objects but we cannot delete them.
2. Salesforce Custom Objects
Custom Objects are new objects created to store information unique to an organization. Custom objects extend the functionality that standard objects provide. We can both customize and delete custom objects.
Note:
Each object in the Salesforce platform has several built-in features like user interface, security, sharing model, and much more.