filmov
tv
MySQL 8x - Spatial Tables: Working with VIEWS.
Показать описание
Hello to everyone,
A few years ago, I published a video about how to create a VIEW from a spatial table, but using the version 5.3, of MySQL. Answering to some requests, I decided to update the video to the version 8.x, of MySQL.
In a few words, a VIEW it is a virtual table resulting of a query built over a table stored in the MySQL database. There are several advantages of working with a VIEW. One advantage has to do with the fact that the user can work only with a small part of the information stored in the original table. Another advantage, results of the fact that the VIEW be a virtual table, and so, does not consume hard disk space.
Now, you can ask: Can a user create VIEWS from spatial tables and see the result in a G.I.S. application? And the answer is: YES!
So, let us see, step by step, how to do it.
Software used to build this video:
Cartographic base used in this exercise:
A few years ago, I published a video about how to create a VIEW from a spatial table, but using the version 5.3, of MySQL. Answering to some requests, I decided to update the video to the version 8.x, of MySQL.
In a few words, a VIEW it is a virtual table resulting of a query built over a table stored in the MySQL database. There are several advantages of working with a VIEW. One advantage has to do with the fact that the user can work only with a small part of the information stored in the original table. Another advantage, results of the fact that the VIEW be a virtual table, and so, does not consume hard disk space.
Now, you can ask: Can a user create VIEWS from spatial tables and see the result in a G.I.S. application? And the answer is: YES!
So, let us see, step by step, how to do it.
Software used to build this video:
Cartographic base used in this exercise: