PERFORMANCE IMPROVEMENT THROUGH TABLE PARTITIONING (Comparison of table partitioning in SQL Server 2008)

Increasing the size of the databases might face database administrators withperformance issues.Most of the software vendors for DBMS products have included tools andtechniques that help the database administrator to improve the performance of thedatabase. In this article we will test one of the techniques used to enhance thedatabase performance, named "table partitioning". The test will be done on SQLServer, which is one of the most used database management systems. The articlewill show the steps to implement the table partitioning in SQL Server 2008 R2. Apartitioned table with two partitions will be created to test the performance ofqueries on each partition. A data population process will be applied to the table inorder to fill the partitions with differentiated amount of data. The largest partition will be called "archive" and the smaller one "current".A comparison table storing the amount of time required to execute each of the queries will be created. Six tests for each query will be executed in order to provide accurate results.The comparison table will guide the interpretation process and will facilitate the conclusions

The Role of AIA for Inducing Regeneration Embryogenesis that Palm

In a period of 3 years in the AUT, it is experimenting embryogenesis process of three palms: Washingonia Filifera, Phoenix Humilis and Chamareops Daxtylifera through the treatment with the solution of 50 ppm concentrations AIA, 200 ppm, 500 ppm sol hydroalcoholic and Control (water only). The seeds were immersed in the solutions for 24 hours and then are stored at the substrate of sand and peat (1: 1). During embryogenesis, temperature regimes: 18-200 C, and optimal humidity of the substrate. After germination, the main examinations were (i) the awakening and opening of the embryo, and the number of embryos / no (ii) the number and length of the radicle. Data are analyzed in JMP software for variance (alpha = 0:05). Genotypes Ch. Humilis, Ph. Daxtylifera and W Filifera treated with AIA 200 ppm have germination 94%, 93% and 97% while control; 46%, 44%, and 51%. Influence of AIA was simultaneous germination ability and radicle number compared with control. A number of radicles for three genotypes of palm was, respectively: Ch Humilis (9.6-1.9), Ph Daxtylifera (4.4-4.1) and W Filifera (2.5-1.6). The impact of AIA It has been indirect on the length of radicle and plant performance. In this case, embryogenesis expressed a cell potential found only in the zygote and instigated by the hormone. Dimensions of radicle were not interdependent of their number. As a conclusion embryogenesis induced by Auxin in any of its concentration it has given a good effect in awakening and regeneration of embryos.Keywords: Germination, AIA, Washingonia filifera, Chamareops humilis and Phoenix daxtylifera