The Glue-Nail deductive database system: Design, implementation, and evaluation

This paper presents the design and implementation of a deductive database system. RDL1, is the production rule language for this system. This language is an extension of logic based languages towards the support of updates and complex domains. Different features of this language are described with its applications. The general architecture of the system is presented highlighting integration with a relational database system. Then, three original features of the system are discussed: extensibility through the definition of end user data types, query optimization techniques, and the extensibility of the control strategy. Future improvements and extensions conclude the paper.

We describe the design and implementation of the Glue-Nail deductive database system. Nail is a purely declarative query language; Glue is a procedural language used for non-query activities. The t...

Deductive database systems combine the inferencing capabilities of logic programming with the secondary storage capabilities of databases in a single system. BERMUDA is such a system. It interfaces C-Prolog to the Britton-Lee intelligent database machine (IDM). The author explores several architectural issues which influence the design of deductive database systems by presenting the solutions adopted in BERMUDA. He suggests that integrated hospital information systems are a natural environment in which to port BERMUDA. >

The music database system based on data mining algorithms is an intelligent system based on large scale music datasets, aiming to analyze, classify, and recommend music through data mining technology. This article proposes a methodology for designing and implementing the system. Firstly, the system uses a large scale music dataset and uses data preprocessing techniques to clean and organize the music data for subsequent mining and analysis. Then, the system introduces various data mining algorithms, such as clustering, association rule mining, classification, etc., to extract useful information and features from music data. These mining algorithms can help the system achieve functions such as music style classification, sentiment analysis, and recommendation. Secondly, the system has designed a front end interface for user interaction and query, through which users can search, browse, and manage songs in the music database. The system also provides personalized recommendation function, which recommends relevant music works based on user preferences and historical behavior.During the implementation process, we used the Python programming language and common data mining tools and algorithm libraries. The system architecture includes modules such as data preprocessing, feature extraction, model training, and user interface. Through the collaborative work of these modules, a fully functional music database system has been achieved. The experimental results show that the system can effectively process music data, extract key features and information of music, and provide personalized recommendations based on user needs and preferences. User feedback on the system also indicates that the system has a certain degree of accuracy and practicality in music classification and recommendation.

Medical database security plays an important role in the overall security of medical information systems and networks. This is both because of the nature of this technology and its widespread use today. Database security not only involves fundamental ethical principles, but also essential prerequisites for effective medical care. The development of appropriate secure medical database design and implementation methodologies is an important research problem in the area and a necessary prerequisite for the successful development of such systems. The general framework and requirements for medical database security are given and a number of parameters of the secure medical database design and implementation problem are presented and discussed in this paper. A secure medical database development methodology is also presented which could help overcome some of the problems currently encountered.

Extended set theory is an effective method for describing the complex data structures needed to support large-scale data base applications. This paper describes the incorporation of the salient concepts of extended set theory into a general tool for the design and implementation of large-scale database systems. This tool is called a set processor. This implementation is based on the representation of sets of positive integers as bit strings and the application of the Cauchy/Cantor Diagonal Method.

Extended set theory is an effective method for describing the complex data structures needed to support large-scale data base applications. This paper describes the incorporation of the salient concepts of extended set theory into a general tool for the design and implementation of large-scale database systems. This tool is called a set processor. This implementation is based on the representation of sets of positive integers as bit strings and the application of the Cauchy/Cantor Diagonal Method.

Logical design of data base systems

In this paper, we present the design and implementation of ITDB, a self-healing or intrusion-tolerant database prototype system. While traditional secure database systems rely on preventive controls and are very limited in surviving malicious attacks, ITDB can detect intrusions, isolate attacks, contain, assess, and repair the damage caused by intrusions in a timely manner such that sustained, self-stabilized levels of data integrity and availability can be provided to applications in the face of attacks. ITDB is implemented on top of a COTS DBMS. We have evaluated the cost effectiveness of ITDB using several micro-benchmarks. Preliminary testing measurements suggest that when the accuracy of intrusion detection is satisfactory, ITDB can effectively locate and repair the damage on-the fly with reasonable (database) performance penalty.

We have developed a deductive database system PACADE for analyzing 3-D and secondary structures of protein. The PACADE system consists of a relational database created from Protein Data Bank and a deductive engine DEE based on logic programming. It has the following features: (1) The system has an inference mechanism. This means by which users can easily write and check biological hypotheses using logical and declarative rules instead of procedural programs. (2) The relational database of the PACADE system stores data on both 3-D and secondary structures of protein. The integration of this two level structure makes feasible an abstract representation of the protein structure. We describe herein the design, functions, and implementation of this PACADE system.

This paper presents the design of an adaptive intrusion tolerant database system, called AITDB. The goal of AITDB is to provide database applications with a stabilized level of data integrity and availability in the face of attacks. Using a rule-based adaptation mechanism and a set of reconfiguration operators, AITDB automatically adapts itself to the dynamic changes of environment according to a specific set of adaptation criteria, which are determined based on the current situation of the damage (i.e., data integrity level), the attacks, the workload, the availability level, the performance, and the cost.

Because flash memory now provides an economical solution for various portable devices and embedded systems, an NAND flash-based storage system has replaced the hard disk drive in many applications. Recently, the implementation of database systems using an NAND flash-based storage system has become an important research topic. In particular, the external sorting is an important operation in database systems. With the very distinctive characteristics of flash memory, the typical external sorting system that adopts a clustered sorting process can result in performance degradation and reduce the reliability of flash memory. In this article, we will propose an unclustered sorting method that considers the unique characteristics of flash memory, and we then propose a decision rule to exploit the advantages of both clustered and unclustered sorting. The decision rule can separate records according to their record length, sort them appropriately by the clustered and unclustered sorting, and merge the sorted results. The experimental results show that the proposed method can improve performance in an NAND flash-based storage system (i.e., solid-state drive).

During the implementation of database system, needs of getting fast, accurate and high-availabilitydata, has become major clauses for the implementation of “high-availability” system. Oracle 10gRAC is a clustered database solution that requires a two or more node hardware configurationcapable of working together under a clustered operating system. A clustered hardware solution ismanaged by cluster management software, usually provided by the hardware vendor. Theoperating system is also responsible for providing access to the shared disk subsystems. Parametersthat used for the performance testing and analyzing of Oracle 10g Real Application Cluster are thecpu idle, free memory, SGA, buffer cache, and shared pool. As result for the performance testingand analyzing, it can be concluded that Oracle 10g Real Application Cluster was really good for theimplementation of “high-availability system” concept. But it all depends to the analysis for itssystem.

BACKGROUND:Chemotherapy is a complex, multi-disciplinary, and error-prone process. Information technology is being increasingly used in different health care settings with complex work procedures such as cancer care to enhance the quality and safety of care. In this study, we aimed to develop a computerized physician order entry (CPOE) for chemotherapy prescribing in patients with gastric cancer and to evaluate the impact of CPOE on medication errors and order problems.MATERIALS AND METHODS:A multi-disciplinary team consisting of a chemotherapy council group and system design and implementation team was formed for chemotherapy process evaluation, requirement analysis, developing computer-based protocols, and implementation of CPOE. A before and after study was conducted to evaluate the impact of CPOE on the chemotherapy process and medication errors and problem orders. To evaluate the level of end-user satisfaction, an ISO Norm 9241/110 usability questionnaire was chosen for the evaluation.RESULTS:Before the implementation of the CPOE system, 37 medication errors (46.25%) and 53 problem orders (66.25%) were recorded for 80 paper-based chemotherapy prescriptions. After implementation of the CPOE system, 7 (8.7%) medication errors and 6 (7.5%) problem orders were recorded for 80 CPOE prescriptions. The implementation of CPOE reduced the medication error by 37.55% and the problematic order by 58.75%. The results for usability evaluation indicate that the CPOE was within the first class of the ISONORM level rating; this shows that a CPOE is with very high satisfaction and a very high functionality rate.CONCLUSION:Developing a CPOE system significantly improved safety and quality of the chemotherapy process in cancer care settings by reducing the medication error, deleting unnecessary steps, improving communication and coordination between providers, and use of updated evidence-based medicine in direct chemotherapy orders. However, the CPOE system does not prevent all medication errors and may cause new errors. These errors can be human-related factors or associated with the design and implementation of the systems.

An expert database system is an expert system which is developed on databases using DBMS technology to manage facts and rules. Frame-based expert systems are widely used as the knowledge representation for such expert systems with large knowledge bases. Many systems have the ability to connect to external databases. Facts stored in databases can be loaded into expert system's knowledge base and inference is performed by the inference engine of the expert system. In many cases, such external facts are required several times for each inference. Thus, a lot of communication traffic takes place. This research work present the design and implementation of a frame-based object-relational database system which has a tight coupling between the expert system and the external knowledge base. The external knowledge base also use frame as its knowledge representation. More over, it has its own inference engine so that inference can be perform on the knowledge base side and the results, not only simple facts, are sent back to the expert system for further inference. A medical consultation system is used as an illustrated example an Oracle lOg object relational DBMS is used as the database platform.