SQLite has been widely applied in embedded system because of its open source and less resource consumption. A novel optimization method with Red-black tree replacing B tree in indexing mechanism in order to solve the low efficiency and large energy consumption problem when inserting and deleting data in SQLite database was proposed in the paper. The contrast test of efficiency of between red-black tree and B tree while inserting and deleting data shows that this method can effectively improve the SQLite insertion and deletion operation efficiency and reduce the energy consumption.

On the basis of the traditional assemble method of components modular fixture, the establishment of a component-based modular fixture design method was proposed in the paper. First of all, the concept of modular fixture components was put forward, and then the components according to different functions were classified, and the relationship table between the components and elements were established. At last of this paper, the application of this method was introduced through an instance. While designing fixture for part family, this method can utmost save design time and minimize the quantity of disassembling of combined fixture element, reduce the wear and tear of components, and shortening the time of manufacturing.

Retrieval, recall rate and precision are not acceptable according to the general search engine in searching networked manufacturing resource. Manufacturing Resource Domain Ontology was derived and established based on the concept of the ontology in this paper. Model description was completed with protégé.