Fast index creation system for cloud big data database

A fast index creation system for a cloud big data database, electrically and communicatively coupled to a cloud non-relational database and a user service system, for inquiring and creating an index, comprising:

• one or more hardware processors;
• an application exchange module executed by the one or more hardware processors, electrically and communicatively coupled to the user service system, for receiving a query string inputted from the user service system;
• a data exchange module executed by the one or more hardware processors, electrically and communicatively coupled to the cloud non-relational database, and having at least one temporary index table with field data related to record data of the cloud non-relational database;
• a first processing module executed by the one or more hardware processors, electrically and communicatively coupled to the data exchange module and the application exchange module, for receiving and computing the query string to generate a query instruction, and the query instruction including at least one key field and at least one sorting condition;
• the first processing module computing the at least one temporary index table according to the query instruction and comparing the at least one temporary index table to the at least one key filed of the query to check whether or not the at least one temporary index table has any data that is same as the at least one key field and then generating a cache index table, a create instruction, or both;
• wherein, if the at least one temporary index table has data that is same as the at least one key field, then the first processing module will compute the at least one temporary index table according to the query instruction to generate the cache index table;
• and if the at least one temporary index table does not have data that is same as the at least one key field, then the first processing module will generate the create instruction;
• a second processing module executed by the one or more hardware processors, electrically and communicatively coupled to the data exchange module, the first processing module and the cloud non-relational database, for receiving the create instruction and the query instruction and computing the cloud non-relational database according to the query instruction to generate an index table;
• and
• an integrated processing module executed by the one or more hardware processors, electrically and communicatively coupled to the first processing module, the second processing module, the data exchange module and the application exchange module, for receiving and computing the cache index table, the index table or both according to the query instruction to generate a result index table, and the result index table has field data related to record data of the cloud non-relational database and returned to the application exchange module for prompting the result index table to the user service system to let the user service system know that the result index table has been generated.