This is the 19th day of my participation in the More text Challenge. For details, see more text Challenge

The first three chapters have covered cracking mysql and Oracle databases. So the amount of time we spent configuring the data source, we had to put it to good use. Today we’ll look at how we can view databases using PowerDesign. How can You use PowerDesign to help you sort out your database structure

Configuring the database

  • Where the data source in the configuration comes from is described in Chapters 2 and 3. Once the configuration is complete, we can connect. Now that the database is connected, we can update the data from the database

  • The default is the data source we connect to

  • The default is all tables under all users. If it’s mysql then we have to select our database table. One of the two marks on the right of the picture below is selected all and the other is not selected all

So we’re not going to select All users. Then go to our user table and select all the tables in the corresponding database.

View the generated tables

Reverse generation into the database

  • In the previous step we have generated tables from the database into our PDM, this step we start with the reverse generation of PDM data into the database as we design

Originally created in PDM, the goal is to be able to understand the database structure in real time, so reverse generation is used

  • After connecting us in PowerDesignCtrl+G, or click below to start generating data to the database

  • However, there was a version error when I generated it to the mysql database, which has not been solved for now. Ps: Readers have solved can contact me!

  • But the reverse generation to the Oracle database is ok. The mysql server is not installed properly. Specific readers have solved can contact me

conclusion

  • At this point we’ve basically completed the preparation for PowerDesign. This chapter is the use of PowerDesign, based on PowerDesign we can update the database design after the vivid understanding of the relationship between the tables in the system. The other thing is that we can update the view as the data changes
  • As mentioned in the previous article about powerDesign generating data, it’s ok to try Oracle here. But the attempt in mysql failed. There’s no time for that. To be discussed!!
  • When we have a lot of tables in our system, powerDesign generates a lot of views, which doesn’t seem very convenient. At build time we can choose which table views we want to generate. Need to pay attention!