1. there are about 70 businesses. 2. there are eight public fields in these services. 3. in addition to public fields, each service has 5-20 fields different from other services. 4. for example, business 1 has the following public fields (channels, sizes ..) self-owned field: name, ID card, gender .. business 2 has the following public fields (channels, sizes ..) free field: color, length, width... 5. currently, the solution is to place a business in one table, which only counts five businesses and uses five tables. However, as the business volume increases, the number of tables will also increase to 70. can I use a nosql database like mongodb... nosqlmongodbhadoop database mysql
- There are about 70 businesses.
- There are eight common fields in these services.
- In addition to public fields, each service has 5-20 fields different from other services.
- For example, business 1 has the following public fields (channels, sizes ..) self-owned field: name, ID card, gender .. business 2 has the following public fields (channels, sizes ..) free field: color, length, width...
- Currently, the solution is to place a business in one table, which only counts five businesses and uses five tables. However, as the business volume increases, the number of tables will also increase to 70.
- Can I use a nosql database like mongodb? The predecessors said that Nosql is only suitable for data with simple data models.
- Or hadoop ..? PS. The total data volume of various businesses is about 50 thousand per day.