por A data model is a visual representation of the elements within a database. There are different types of data to model: physical data models and logical models. In this article, we will delve into this topic.
Logical data model
The logical data model is a model independent of a database and defines the need or needs of an organization. It also collects data through key migration.
Next, we will present an example of how to define a logical data model.
What we will do is connect with a user D.B.A. of the database that we have installed, in this case it was the database Oracle 12c. This is going to be the destination of the logical design that we are going to model.
The tool we will use will be Oracle SQL Developerwhich is a graphical environment used to perform operations with a database. Inside SQL is the data modeler, which is used to develop the logical model prior to the database.
What he advises data management is to create the logical data model and, later, create the physical model and then document. He data modeler helps in the task of moving from the logical model to the physical model.
Steps to follow to create the logical data model
We create a new connection by clicking the green + symbol in the upper left:
We give a name to that connection (orcl_sys) and in yam we put syswhich was the user that we previously created in the DB, with the password that had been created and the user:
We save the password and, since we are connecting as D.B.A.we tell it that the role we are using is SYSDBA:
Other important connection string information is the hostin which the name is put (localhost), port (1521) and SID (orcl). We test the connection and click save:
With this we have all the JDBC chain parameters to connect to the DBA user of the Oracle 12c database.
Do you want to continue learning?
This is just a preamble to defining a logical data model. There is still a lot to learn! If you want to continue training about the wide world of Big data, you can’t miss our Big Data, Artificial Intelligence & Machine Learning Full Stack Bootcamp. Dare to sign up to change your life!