Abstract: A fast index creation system for a cloud big data database electrically and communicatively coupled to a cloud non-relational database for inquiring and creating an index includes an application exchange module, a data exchange module, a first processing module, a second processing module and an integrated processing module. The application exchange module receives a query string inputted by a user and prompts a result index table. The data exchange module has a temporary index table. The first processing module computes the query string and generates a query instruction to compute a temporary index table for comparison and check if there is any data matched with the query instruction. If yes, then the first processing module will generate a cache index table, or else the first module will generate a create instruction provided for the second processing module to compute a non-relational database and generate a new index table.

Abstract: A fast index creation system for a cloud big data database electrically and communicatively coupled to a cloud non-relational database for inquiring and creating an index includes an application exchange module, a data exchange module, a first processing module, a second processing module and an integrated processing module. The application exchange module receives a query string inputted by a user and prompts a result index table. The data exchange module has a temporary index table. The first processing module computes the query string and generates a query instruction to compute a temporary index table for comparison and check if there is any data matched with the query instruction. If yes, then the first processing module will generate a cache index table, or else the first module will generate a create instruction provided for the second processing module to compute a non-relational database and generate a new index table.

Abstract: An automatic data index establishment method includes the steps of comparing a data index existed in at least one table when a database inquires at least one query to obtain the data index correspondingly and directly uses the data index to search related data. If the query has no corresponding data index, a Where Condition field, a Sorting field and a Group By field of the query are recorded and integrated to automatically generate the newly established data index and fill the data index into the table correspondingly. Therefore, the database has intelligent functions with automatic analysis to automatically generate, update, and delete the data index, so as to achieve the effects of enhancing the accuracy and execution efficiency of the data management and reducing the manpower of data managers effectively.

Abstract: There is disclosed an environmentally friendly method for recovering gold, silver, copper and iron from valuable metal-contained plasma-molten slag. At first, plasma is used to burn the used printed circuit boards, thus producing the slag. Then, the slag is grinded. Then, leaching, crystallization, precipitation, replacement and electric winning are conducted to recover gold, silver, copper and iron.

Abstract: Inexpensive, highly effective methods for the in-situ reduction of hexavalent chromium to the non-toxic trivalent oxidation state in soil and groundwater containing hexavalent chromium are provided, which may reduce hexavalent chromium concentration in soil to as low as 5 mg/L. The methods involve sampling soil comprising hexavalent chromium to determine a reaction amount of a reducing agent, providing a frame on a top surface of the soil, wetting the soil, spreading a reducing agent on the top surface of the soil, and flushing the soil with water to dissolve the reducing agent. The reducing agent may be a chemical agent, a biological agent, or a combination of chemical and biological agents. The biological reducing agents may include sludge from wastewater, return activated sludge, waste activated sludge, leachate from landfill or from composting operations, or compost material from municipal wastewater, industrial wastewater, or solid waste operations.

Abstract: Inexpensive, highly effective methods for the in-situ reduction of hexavalent chromium to the non-toxic trivalent oxidation state in soil and groundwater containing hexavalent chromium are provided, which may reduce hexavalent chromium concentration in soil to as low as 5 mg/L. The methods involve sampling soil comprising hexavalent chromium to determine a reaction amount of a reducing agent, providing a frame on a top surface of the soil, wetting the soil, spreading a reducing agent on the top surface of the soil, and flushing the soil with water to dissolve the reducing agent. The reducing agent may be a chemical agent, a biological agent, or a combination of chemical and biological agents. The biological reducing agents may include sludge from wastewater, return activated sludge, waste activated sludge, leachate from landfill or from composting operations, or compost material from municipal wastewater, industrial wastewater, or solid waste operations.

Abstract: Inexpensive, highly effective methods for the in-situ reduction of hexavalent chromium to the non-toxic trivalent oxidation state in soil and groundwater containing hexavalent chromium are provided, which may reduce hexavalent chromium concentration in soil to as low as 5 mg/L. The methods involve sampling soil comprising hexavalent chromium to determine a reaction amount of a reducing agent, providing a frame on a top surface of the soil, wetting the soil, spreading a reducing agent on the top surface of the soil, and flushing the soil with water to dissolve the reducing agent. The reducing agent may be a chemical agent, a biological agent, or a combination of chemical and biological agents. The biological reducing agents may include sludge from wastewater, return activated sludge, waste activated sludge, leachate from landfill or from composting operations, or compost material from municipal wastewater, industrial wastewater, or solid waste operations.

Abstract: Inexpensive, highly effective methods for the in-situ reduction of hexavalent chromium to the non-toxic trivalent oxidation state in soil and groundwater containing hexavalent chromium are provided, which may reduce hexavalent chromium concentration in soil to as low as 5 mg/L. The methods involve sampling soil comprising hexavalent chromium to determine a reaction amount of a reducing agent, providing a frame on a top surface of the soil, wetting the soil, spreading a reducing agent on the top surface of the soil, and flushing the soil with water to dissolve the reducing agent. The reducing agent may be a chemical agent, a biological agent, or a combination of chemical and biological agents. The biological reducing agents may include sludge from wastewater, return activated sludge, waste activated sludge, leachate from landfill or from composting operations, or compost material from municipal wastewater, industrial wastewater, or solid waste operations.