Keywords : Oracle


Representation of a Distributed Database System for the Medical Purposes Using Oracle

Basam A. Mustafa; Ahmed A. Al-Saman

AL-Rafidain Journal of Computer Sciences and Mathematics, 2013, Volume 10, Issue 2, Pages 173-187
DOI: 10.33899/csmj.2013.163493

This research concerned with the designing and implementation of a distributed database system for the medical purposes. The system has been applied on dental clinic unit and statistics department at Al-Khansaa Educational Hospital at Mosul, and dental clinic unit at Woman Health Care Center at Mosul as a case study.
Client/server model has been used to implement the proposed system's architecture. The computers have been connected together through a local area network (LAN). Horizontal fragmentation technique has been used to distribute the database which achieved a good level of local autonomy. Oracle software were used and utilized to implement the system. It played a dramatic role in protecting data using combination of passwords and user roles hierarchies in addition to achieving transparency and data integrity concepts in the system. The proposed system simplified saving and retrieving data of dental clinics. It also provides dental clinics units  and statistics department with necessary reports and statistics. The proposed system has the ability to automatically perform daily backup for the database in addition to the manual options for database backup and recovery.
 

An Application of Integration (GBOM & GPS) for Quick Response Manufacturing

Akela M. Al-Atroshi; Sama T. Al-Aubaidy; Salar J. Abdul hameed

AL-Rafidain Journal of Computer Sciences and Mathematics, 2010, Volume 7, Issue 1, Pages 117-133
DOI: 10.33899/csmj.2010.163851

The current paper aims at treating a fundamental problem which is the large volume of operating data associated with increasing the variety, high competition and production according to (Quick Response Manufacturing ) system .Thus, the current study focuses on link the Generic Bill of Material file (GBOM) and Generic Product Structure file (GPS) to creating ( BOMO) Approach as the main requirement for applying (QRM) system, because this approach contributes, to a high extent, in reducing deadlines of production by achieving the simultaneous timing in performing processes .
In order to fulfill the aims of the current study, a database is designed by using (Oracle ), then applied practically to a real product(a three–drawer desk). The results are exhibited within the framework of (BOMO) through the integration between (BOMO) and the (Routing) of the product .
 

Measuring of Oracle Optimizer Performance for Object-Relational Database Entities

Esam Mahmoud Mohammed; Alaa F.S. AL_Mukhtar

AL-Rafidain Journal of Computer Sciences and Mathematics, 2008, Volume 5, Issue 2, Pages 125-140
DOI: 10.33899/csmj.2008.163977

SQL Optimization is the process of choosing the most efficient way to execute SQL such  as Data manipulation language  (Select, Insert, Update, Delete). Relational model represents the object through the use of relations; on the other hand the main aim of ORDBMS model is to represent the special characteristics of OOP. The first model deals with the Relation & Correlated sub queries, while the second one uses collection types (Object type, Varrays, Nested table). Explain plane is used to examine exactly how oracle execute SQL statements “ oracle SQL analyze” provides a facility for easily generate any  explain plan . DML language (SQL) as tools for any comparison can be achieved by the statistical performance parameter (Elapsed time, CPU time, Logical block read, Physical block read …). Statistical analysis using ANOVA TABLE is used to judge between comparisons. We found that nested table was the most effective type of data, the object type was the least effective (consume lowest time of execution). We also found that increasing data size will increase any of performance data parameter until we reach size of 40% the time begins to decrease. It is found that SELECT, UPDATE and DELETE have the most influence on the performance parameter, respectively.
 

Priority Dispatching Rules for Virtual Manufacturing Using Genetic Algorithm

Akela M. Al-Atroshi; Abdulsatar M. Khudur; Sama Talee Azez Al-Aubaidy

AL-Rafidain Journal of Computer Sciences and Mathematics, 2008, Volume 5, Issue 1, Pages 139-164
DOI: 10.33899/csmj.2008.163956

The current research concentrates on designing and applying an intelligent information system by the use of (Oracle) language based Multi- Agents manufacturing process to produce a new product. Every agent (user) has its own roles and privileges. The research focuses on determining the delivery date through using genetic algorithms to simulate Shop floor and specify priorities for dispatching orders according to specific rules  which determine the lead time of the product. The importance of the research stems from designing software in c++  to simulate manufacturing processes in the genetic algorithm to realize the following :

Attain the best sequences in implementing jobs according to the required rules.
Decreasing the queuing time for products and their components in the production processes.
Perfect utilization of the available resources.

The results of the designed system application have revealed that the operations planning by the use of the GA philosophy will perform a great role in calculating the product's lead time at the manufacturing operations' stages. This role supports the VM philosophy in calculating the industrial part of the products lead time quickly. Also the application results have confirmed that the designed GA software efficiency depends upon the number of jobs available at the time of execution; whenever the number of jobs is bigger, the software execution efficiency is better.