On Software Application Database Constraint-driven Design and Development

This paper presents a methodology driven by database constraints for designing and developing(database)software applications.Much needed and with excellent results,this paradigm guarantees the highest possible quality of the managed data.The proposed methodology is illustrated with an easy to understand,yet complex medium-sized genealogy software application driven by more than 200 database constraints,which fully meets such expectations.

Automatic relational database compression scheme design based on swarm evolution

Compression is an intuitive way to boost the performance of a database system. However, compared with other physical database design techniques, compression consumes large amount of CPU power. There is a trade-off between the re- duction of disk access and the overhead of CPU processing. Automatic design and adaptive administration of database systems are widely demanded, and the automatic selection of compression schema to compromise the trade-off is very important. In this paper, we present a model with novel techniques to integrate a rapidly convergent agent-based evolution framework, i.e. the SWAF (SWarm Algorithm Framework), into adaptive attribute compression for relational database. The model evolutionally consults statistics of CPU load and IO bandwidth to select compression schemas considering both aspects of the trade-off. We have im- plemented a prototype model on Oscar RDBMS with experiments highlighting the correctness and efficiency of our techniques.

A model-driven approach to semi-structured database design

Recently XML has become a standard for data representation and the preferred method of encoding struc- tured data for exchange over the Internet. Moreover it is fre- quently used as a logical format to store structured and semi- structured data in databases. We propose a model-driven and configurable approach for modeling hierarchical XML data using object role modeling （ORM） as a flat conceptual model. First a non-hierarchical conceptual schema of the problem domain is built using ORM and then different hierarchical views of the conceptual schema or parts of it are specified by the designer using transformation rules. A hierarchical mod- eling notation called H-ORM is proposed to show these hier- archical views and model more complex semi-structured data constructs and constraints. We also propose an algorithm to map hierarchical H-ORM views to XML schema language.

Design and Development of Garment Fabric Database Management System

The main performance characteristics of garment fabric are analyzed and extracted,which include physical characteristics,appearance characteristics and subjective evaluation characteristics.A calculating model of fabric’s subjective evaluation is provided,which can be adjusted as the data increasing.The database system of garment fabric is analyzed,and then function design,concept design and logic design are carried out.The user interface(UI)design of garment fabric database system is described.The system can not only serve the fabric management and customization of garment enterprises,but also serve the teaching work of colleges and universities,because it is rich in information and convenient.It is of great significance to digital construction in the clothing field.

An Intelligent Tool to Support Requirements Analysis and Conceptual Design of Database Design

As an application of artificial intelligence and expert system technology to database design,this paper presents an intelligent design tool NITDT,which comprises a requirements specification lan- guage NITSL,a knowledge representation language NITKL,and an inference engine with uncertainty reasoning capability.NITDT now covers the requirements analysis and conceptual design of database design.However,it is possible to be integrated with another database design tool, NITDBA,developed also at NIT to become an integrated design tool supporting the whole process of database design.

MULTI-WORLD MECHANISM FOR MODELING EVOLUTIONARY DESIGN PROCESS FROM CONCEPTUAL DESIGN TO DETAILED DESIGN

A multi-world mechanism is developed for modeling evolutionary design process from conceptual design to detailed design. In this mechanism, the evolutionary design database is represented by a sequence of worlds corresponding to the design descriptions at different design stages. In each world, only the differences with its ancestor world are recorded. When the design descriptions in one world are changed, these changes are then propagated to its descendant worlds automatically. Case study is conducted to show the effectiveness of this evolutionary design database model.

The text design for continuous speech database of standard Chinese

Well developed continuous speech recognition and synthesis systems demand a high quality continuous speech database which is compact and valid, and whose scientific design would benefit from incorporating linguistic and phonetic knowledge. It is argued that at the present stage the database should be limited to read speech. To describe those very complex variabilities in continuous speech, the following speech units are proposed: (1) 401syllables without tone; (2) 415 inter-syllabic diphones, (3) 3035 inter-syllabic triphones, (4) 781 inter-syllabic final-initial structures. The 17 basic sefltence patterns in standard Chinese are summarized to cover the most important prosodic phenomena. By using the automatic method,2393 sentences and 388 phrases are selected by above phonetic rules from a large corpus, which includes People's Daily in recent years, TV play scripts and dictionary entries, as the reading text of continuous speech recognition database in standard Chinese. This set of sentences and pbrases covers 99.8% syllables without counting tones, 100% inter-syllable diphones, 99.6% inter-syllable triphones and 100% sentence patterns.

Construction and application of time-effect assessment database for experiments on war-traumatized animals

Background:High-quality real war trauma data are important,but they are still lacking.Using the database to realize the networked,systematic,standardized,and dynamic management of war injury animal experimental data can provide a real and reliable supplement for the research of war injury treatment.Methods:Through demand analysis,module design,architecture design,compilation and debugging,and other processes,JAVA language development tools were used to develop a time-effect assessment database for experiments on war-traumatized animals,where the browser/server architecture(B/S architecture)is used as the technical architecture and SQL Server as the database management system.Results:A time-effect assessment database for experiments on war-traumatized animals that features reasonable structural design,rich data resources,and convenient use has been established,in which case efficient collection,storage,display,retrieval,and management of animal experimental data have been achieved.At present,the database is running well and has good data quality.