Database reverse engineering: From requirements to CARE tools

This paper analyzes the requirements that CASE tools should meet for effective database reverse engineering (DBRE), and proposes a general architecture for data-centered applications reverse engineering CASE environments. First, the paper describes a generic DBMS-independent DBRE methodology, then it analyzes the main characteristics of DBRE activities in order to collect a set of desirable requirements. Finally, it describes DB-MAIN, an operational CASE tool developed according to these requirements. The main features of this tool that are described in this paper are its unique generic specification model, its repository, its transformation toolkit, its user interface, the text processors, the assistants, the methodological control and its functional extensibility. Finally, the paper describes five real-world projects in which the methodology and the CASE tool were applied. This is a heavily revised and extended version of “Requirements for Information System Reverse Engineering Support” by J.-L. Hainaut, V. Englebert, J. Henrard, J.-M. Hick, D. Roland, which first appeared in the Proceedings of the Second Working Conference on Reverse Engineering, IEEE Computer Society Press, pp. 136–145, July 1995. This paper presents some results of the DB-MAIN project. This project is partially supported by the Région Wallonne, the European Union, and by a consortium comprising ACEC-OSI (Be), ARIANE-II (Be), Banque UCL (Lux), BBL (Be), Centre de recherche public H. Tudor (Lux), CGER (Be), Cockerill-Sambre (Be), CONCIS (Fr), D'Ieteren (Be), DIGITAL, EDF (Fr), EPFL (CH), Groupe S (Be), IBM, OBLOG Software (Port), ORIGIN (Be), Ville de Namur (Be), Winterthur (Be), 3 Suisses (Be). The DB-Process subproject is supported by the Communauté Fran?aise de Belgique.     

The impact of LIMS design and functionality on laboratory quality achievements

 A laboratory information management system (LIMS) can make a major contribution to the quality and therefore to the efficiency and competitiveness of a laboratory. Since it can impact all aspects of a laboratory's organization it must be the key if not the principal player of the laboratory's quality system. It should support the laboratory in establishing, maintaining and applying quality procedures thereby enabling the laboratory to achieve its quality goals. As a tool, LIMS permits the laboratory to input and use its own know-how and experience to optimize the total organization (internal and external) and workflow of generated information. However, perceived "quality" in the context of an LIMS, can be viewed as being made up of different facets such as the security, reliability and accessibility of information as well as its turn around time and production cost. This paper reviews the role of a LIMS in the laboratory and the contribution that both system design and functionality can have on "building quality ". Received: 5 October 1998 · Accepted: 20 October 1998     

CrN镀层的微粒磨损性能及其切削行为研究

在Teer UDP 550型闭合场非平衡磁控溅射离子镀设备上制备CrN镀层,以球-盘方法测定的比磨损率和微粒磨损法测定的微粒磨损率评价CrN镀层的耐磨性能,采用高速钢镀层钻头的钻孔数评价镀层的切削性能.结果表明,CrN镀层的微粒磨损率对氮流量(用光谱发射因子OEM值控制)的变化很敏感,而比磨损率却不能反映这种由于氮流量变化带来的镀层结构和性能的变化.在不同偏压条件下所制备的镀层微粒磨损率变化不明显.当微粒磨损率低于某一值时,CrN镀层的钻孔寿命明显提高,而比磨损率则无此规律.     

Open-Source Browser-Based Tools for Structure-Based Computer-Aided Drug Discovery

We here outline the importance of open-source, accessible tools for computer-aided drug discovery (CADD). We begin with a discussion of drug discovery in general to provide context for a subsequent discussion of structure-based CADD applied to small-molecule ligand discovery. Next, we identify usability challenges common to many open-source CADD tools. To address these challenges, we propose a browser-based approach to CADD tool deployment in which CADD calculations run in modern web browsers on users’ local computers. The browser app approach eliminates the need for user-initiated download and installation, ensures broad operating system compatibility, enables easy updates, and provides a user-friendly graphical user interface. Unlike server apps—which run calculations “in the cloud” rather than on users’ local computers—browser apps do not require users to upload proprietary information to a third-party (remote) server. They also eliminate the need for the difficult-to-maintain computer infrastructure required to run user-initiated calculations remotely. We conclude by describing some CADD browser apps developed in our lab, which illustrate the utility of this approach. Aside from introducing readers to these specific tools, we are hopeful that this review highlights the need for additional browser-compatible, user-friendly CADD software.     

用脉冲紫外激光预处理提高刀具的金刚石涂层的附着强度

采用脉冲紫外激光（XeCl,308nm）表面消融预处理方法以硬质合金为衬底制备了金刚石涂层刀具。利用压痕法对涂层结合强度进行了测试,得到了最佳预处理工艺条件。采用碳化硅增强铝合金材料对制备的金刚石涂层刀具进行了实际切削性能实验。实验结果表明：脉冲紫外激光表面消融预处理方法的采用对刀具的金刚石薄膜涂层附着强度的提高有很大的帮助。     

Diversely Functionalised Cytochalasins through Mutasynthesis and Semi-Synthesis

Mutasynthesis of pyrichalasin H from Magnaporthe grisea NI980 yielded a series of unprecedented 4′-substituted cytochalasin analogues in titres as high as the wild-type system (≈60 mg L⁻¹). Halogenated, O-alkyl, O-allyl and O-propargyl examples were formed, as well as a 4′-azido analogue. 4′-O-Propargyl and 4′-azido analogues reacted smoothly in Huisgen cycloaddition reactions, whereas p-Br and p-I compounds reacted in Pd-catalysed cross-coupling reactions. A series of examples of biotin-linked, dye-linked and dimeric cytochalasins was rapidly created. In vitro and in vivo bioassays of these compounds showed that the 4′-halogenated and azido derivatives retained their cytotoxicity and antifungal activities; but a unique 4′-amino analogue was inactive. Attachment of larger substituents attenuated the bioactivities. In vivo actin-binding studies with adherent mammalian cells showed that actin remains the likely intracellular target. Dye-linked compounds revealed visualisation of intracellular actin structures even in the absence of phalloidin, thus constituting a potential new class of actin-visualisation tools with filament-barbed end-binding specificity.     

TiB2增强Al2O3陶瓷刀具高速干切削摩擦磨损性能

采用TiB2增强Al2O3陶瓷刀具对淬硬钢进行高速干切削试验,利用切削高温作用下的摩擦化学反应,在刀具表面原位生成具有润滑作用的反应膜,从而实现Al2O3/TiB2陶瓷刀具的自润滑.结果表明:低速干切削时,Al2O3/TiB2陶瓷刀具的磨损机制主要表现为粘着磨损和磨料磨损;而在高速干切削时,刀具的磨损机制主要表现为氧化磨损,刀具表面经由氧化反应生成具有润滑作用的反应膜而起到固体润滑作用,从而使刀具的耐磨性能提高,随着TiB2含量和切削速度的增加,反应膜的减摩抗磨作用增强;而在切削区通入氮气时,由于刀具表面氧化膜形成受阻,刀具的抗磨能力有所降低.     

Comments on selected fundamental aspects of microarray analysis

Microarrays are becoming a ubiquitous tool of research in life sciences. However, the working principles of microarray-based methodologies are often misunderstood or apparently ignored by the researchers who actually perform and interpret experiments. This in turn seems to lead to a common over-expectation regarding the explanatory and/or knowledge-generating power of microarray analyses. In this note we intend to explain basic principles of five (5) major groups of analytical techniques used in studies of microarray data and their interpretation: the principal component analysis (PCA), the independent component analysis (ICA), the t-test, the analysis of variance (ANOVA), and self organizing maps (SOM). We discuss answers to selected practical questions related to the analysis of microarray data. We also take a closer look at the experimental setup and the rules, which have to be observed in order to exploit microarrays efficiently. Finally, we discuss in detail the scope and limitations of microarray-based methods. We emphasize the fact that no amount of statistical analysis can compensate for (or replace) a well thought through experimental setup. We conclude that microarrays are indeed useful tools in life sciences but by no means should they be expected to generate complete answers to complex biological questions. We argue that even well posed questions, formulated within a microarray-specific terminology, cannot be completely answered with the use of microarray analyses alone.     

Embedding optimisation algorithms with Mosel

Algebraic modelling languages allow models to be implemented in such a way that they can easily be understood and modified. They are therefore a working environment commonly used by practitioners in Operations Research. Having once developed models, they need to be integrated inside the company information system. This step often involves embedding a model into a programming language environment: many existing algebraic modelling languages make possible to run parameterised models and subsequently retrieve their results, but without any facility for interacting with the model during the model generation or solution process.In this paper we show how to use the Mosel environment to implement complex algorithms directly in the modelling language.The Office cleaning problem is solved by a branch-and-cut algorithm, implemented entirely in the modelling language (including the definition of the callback function for the solver). Secondly, a cutting stock problem is solved by column generation, also implemented in the modelling language.AMS classification: 90Cxx, 65K05, 68N15