A practical, how-to book on Excel programming, suitable for readers already proficient with the Excel user interface (UI). If you are looking to automate Excel routine tasks, this book will ...progressively introduce you to programming concepts via numerous illustrated hands-on exercises. --
The conceptual design is the early stage of aircraft design process where results are needed fast, both analytically and visually so that the design can be analyzed and eventually improved in the ...initial phases. Although there is no necessity for a CAD model from the very beginning of the design process, it can be an added advantage to have the model to get the impression and appearance. Furthermore, this means that a seamless transition into preliminary design is achieved since the CAD model can guardedly be made more detailed. For this purpose, knowledge-based aircraft conceptual design applications Tango (Matlab) and RAPID (CATIA) are being developed at Linköping University. Based on a parametric data definition in XML, this approach allows for a full 3D CAD integration. The one-database approach, also explored by many research organizations, enables the flexible and efficient integration of the different multidisciplinary processes during the whole conceptual design phase. This paper describes the knowledge-based design automated methodology of RAPID, data processing between RAPID and Tango and its application in the courses “Aircraft conceptual design” and “Aircraft project course” at Linköping University. A multifaceted user interface is developed to assist the whole design process.
Traditional databases mainly focus on the processing of deterministic data. However, information is often uncertain in practical applications. This paper aims to provide a basic framework for ...managing possibilistic XML (Extensible Markup Language) data queries in a dynamic environment. Existing efforts are mainly made on querying XML data towards the representation of crisp concepts based on the static labeling schemes. Once an updating operation is involved, these static labeling scheme approaches often need to search the whole original XML document again to relabel all the labels of the nodes. This re-labeling obviously sacrifices the processing performance. Different from the prior work, we adopt a novel dynamic encoding scheme which is tailored for both static and dynamic possibilistic XML documents to effectively avoid re-labeling after updates. On this basis, we propose an efficient algorithm to handle the problem of dynamic twig queries in possibilistic XML documents. Finally, we report our experimental results to show that our algorithm is superior to previous approaches.
XML has become a common language for data exchange on the Web, so it needs to be managed effectively. There are four central problems in XML data management: capture, storage, retrieval, and ...exchange. Even though numerous database systems are available, the relational database (RDB) is often used to store and query the content of XML documents. Therefore the processes of mapping from XML to RDB and vice versa occur frequently. Numerous researchers have proposed approaches to map hierarchically structured XML documents into the tabular format of a RDB. However, the previously developed approaches have faced problems in terms of storage and query response time. If the design of a RDB is inefficient, the number of join operations between tables increases when a query is executed, which affects the query response time. To overcome this limitation, this paper proposes a new mapping approach, known as XAncestor, which consists of two algorithms: an XML mapping algorithm (XtoDB) and a query mapping algorithm (XtoSQL). XtoDB maps XML documents to a fixed RDB with less storage space. XtoSQL translates XPath queries into corresponding SQL queries based on the constructed RDB in order to reduce the query response time i.e., the time taken to execute the translated SQL query. XAncestor is then developed as a prototype in order to test its effectiveness. The results of XAncestor are compared with those produced by five similar approaches. The comparison proves that XAncestor performs better than the previously developed approaches in terms of effectiveness and scalability. The correctness of XAncestor is also verified. The paper concludes with some recommendations for further work.
Data classification for distributed and heterogeneous XML data sources is always an open challenge. A considerable number of algorithms for classification of XML documents have been proposed in the ...literature. Yet, the existing approaches fall short in ability to classify the fuzzy XML documents. In this paper, we provide a KPCA-KELM classification framework for the fuzzy XML documents based on Kernel Extreme Learning Machine (KELM). Firstly, we propose a novel fuzzy XML document tree model to represent fuzzy XML documents. Secondly, we employ an effective vector space model to represent the semantic structure of fuzzy XML documents based on the proposed fuzzy XML document tree model. Thirdly, we classify the fuzzy XML document using KELM after feature extraction using Kernel Principal Component Analysis (KPCA). The corresponding experimental results demonstrate that our proposed KPCA-KELM approach shortens the training time while maintaining the same level of accuracy as the state-of-the-art baseline models.