Research title: Optimization of human name processing time and storage in database applications

Mostly, the Personnel Information Applications required the human name as a full term in all human resources submissions. The full name attribute consists of five parts: First name, Second name, Third name, Fourth name, and Family name. Most queries require to display the name of any person in a variety form to reply the requested demand of this type of information, this type of requests involves amount of storage in both memory and a secondary storage, in addition to significant CPU processing time [1]. In this paper an attempt to optimize the storage requirements and processing time requested to deal with person full name efficiently. Due to the processing name as, composite attributes need some attention during all stages that concerns this type of data such as: insertion, update, arrange, delete, truncate…etc. In most human resources applications, name of an individual starting of his/her birth date need to be recorded correctly in many applications: Either social and business, and must be kept in save and secure places, even after the person death. Normally person name in most computer system is a variable size field and usually it requires range of characters between 20 – 40 characters: each character require one byte. The experiment of the suggested method shows significant reduction in both storage and processing time, where for a dataset of 6904 persons full name requires 2000 Parts Names in the index Names, while if the number of records in the application reach several millions records the size of index will remain approximately constant. The optimization factor in storage very high and it might be exceed 98%, and it is proportional to the numbers records volume of the information in a database files, and the limit of integer type of two Bytes (uint ) which can accommodate number of part names code equal to (216 – 1), for value range between 0-65535. Also, the optimization will directly affect the processing time in both off line and on-line applications systems, especially nowadays the computer technology have been offered a power of parallel processing in both Hardware and Software.