2
good afternoon!
I’m developing a system for product registration. However, I am thinking of creating an XML file to store the general characteristics of the products (the other information will be in the database), because each product has its specific attributes. The structure would be +/- like this:
<produto id="1">
<atributo>Editora</atributo>
<decricao>Globo</descricao>
</produto>
<produto id="2">
<atributo>Altura</atributo>
<decricao>1,65m</descricao>
<atributo>Largura</atributo>
<decricao>5,00m</descricao>
<atributo>Material</atributo>
<decricao>Sucupira</descricao>
</produto>
The problem is that the amount of registered products will be huge (I believe thousands)! So this xml file will get very large.
I would like to know from you if it is feasible to use an XML file for this purpose. And if it is also possible to use it together with a DBMS to facilitate the search inside that file.
Thank you, André
Dude, from what you described the ideal would be to do everything using a DBMS, the ideal is to work with files only if you want to exchange data with some other system.
– Júlio Neto