The application relates to the technical field of
big data, in particular to a
data dimension table generation method and device, a
server and a storage medium, the method comprises the following steps: creating an automatic configuration project, and introducing
remote procedure call dependencies, geographic indexes and group transaction monitor dependencies; providing a location-based service (LBS) service interface, receiving a calling request by using the LBS service interface, obtaining consumption data of a distributed publish / subscribe message
system Kafka according to the calling request, and
parsing the consumption data to obtain positioning data and a
unique identifier of a vehicle; querying a topological tree by using the positioning data to obtain location coding data of the vehicle, querying a
database by using the
unique identifier to obtain vehicle information of the vehicle, generating a
data dimension table according to the coding data and the vehicle information, and
synchronizing the
data dimension table to the
database. Therefore, the problems that in the related art, the external access pressure is too large during the data
dimension table generation process, the
data delay is relatively long, and the
scalability is poor are solved.