UWE logoUniversity of the West of England Home Page - Peter Hale Home Page - SEEDS Site Map - SEEDS Page - Text Only Site Map

Software Engineering Research Group - Centre for Complex Cooperative Systems logoCentre for Complex Cooperative Systems


RDF

XML

Service Oriented Architecture - Information and Links.

Software Engineering and Model Driven Programming - http://www.cems.uwe.ac.uk/amrc/seeds/softwareengineering.htm.

Software Engineering Research Group SERG - http://www.cems.uwe.ac.uk/cccs/researchgroup.php?menu=off&group=serg - SERG's mission is to bridge the gap between software engineering research and its application to different disciplines.

UML (Unified Modeling Language) - http://www.cems.uwe.ac.uk/amrc/seeds/Modelling.htm#UML.


Usability Survey

I'm developing a survey on usability, I don't think it's quite right yet, but I would still welcome anyone using it to leave feedback on my research topic (or about the survey) - Click Here to take part in a usability survey, and support my PhD research, for anyone who does not want to remain anonymous, I would be pleased to take an interest in their research.

The survey compares these interfaces -

Taxonomy - http://www.cems.uwe.ac.uk/~phale/ELearning/ELearningDemonstration1.htm.

Diagrammatic - http://www.cems.uwe.ac.uk/~phale/ELearning/ELearningDemonstration2.htm.

And asks for further advice on end-user programming.

I'm interested in feedback from anyone, whatever their level of IT skills.

Survey - Seeking feedback on software usability.


Create polls and vote for free. dPolls.com

Database Research

This research brings together approaches of object orientation, the Semantic Web, relational databases, and model driven and event driven programming, Frankel et al (2004) explain the opportunities for and importance of this kind of research. The system provides automated translation from a model provided by the user, or by other systems into the software, ontology, and database representation. The diagram below shows the overall system designed. The Protégé ontology is saved as a relational database.

Figure 2 Translation Process - Shows ontology made up of taxonomies, taxonomies are shown with their individual names this translated into modelling tools, modelling tool doing calculations and further translations to the Web.

Translation Process Implementation

Results visualizer - inputs visualizer - calculation engine - ontology visualizer - ontology engine - database

Spreadsheets are often used for modelling of information. However, spreadsheets do not provide the centralised and structured data-store required for a distributed collaborative system. Such systems can be made much more powerful if the information is codified into a relational database structure. Wang et al (2005) outlines an approach for integrating distributed relational database systems. Then On-Line Analytical Processing (OLAP) data mining can be used for more sophisticated data collection and analysis. OLAP is explained by Shim et al (2002). Lau et al (2001) explain how OLAP displays a multi-dimensional view of aggregated data, and presents a Rule-Based Analytical Processing (RBOLAP) model which can be used for decision support. The use of RBOLAP techniques is demonstrated using a case study on a mould and die information network.

The objective is to build a catalogue and make use of it for decision support and costing systems, while demonstrating that the same approach could be used for other types of system(s). It is essential that this catalogue can query information from organisations' existing database systems. Most large organisations have key operational knowledge and information dispersed across different types of information systems, often in Relational Databases. This has the advantage of allowing the use of the standardised language Structured Query Language (SQL) to access this information.

The intention has been to provide a centralised spreadsheet type modelling system that makes use of a structured database to store the information, which it relies upon. A further advantage of this is that the database can be accessed by other applications. The figure is an example page from the implementation of a decision support tool for manufacture of tooling for wing spar manufacture. This was created using ExcelWriter, software (Softartisans, 2007) for creating or converting existing spreadsheets, to be used in a distributed web environment.

Distributed Spreadsheet Spar Definition

Distributed Spreadsheet Spar Definition

This distributed spreadsheet communicates with a centralised relational database. This allows the re-use of the manufacturing data source for other manufacturing problems, and allows it to contribute to a manufacturing taxonomy.

The UML tool Rational Rose was used in order to illustrate the concept of creating an object oriented hierarchy and using this as an editor for a Web based ontology. This approach worked, but my later research has used the same approach using ontology editor tools linked to a relational database to create a wing cost modeller. Nilsson et al (2002) also used UML as a meta-model for Semantic Web research.

Protégé allows storage of information in the semantic languages Resource Description Framework (RDF), Web Ontology Language (OWL), and the relational database Access. The ability of Jena and Protégé to save in relational database format also makes it possible to use SQL (Structured Query Language). Using these standards it is possible to represent information in Jena, Protégé, or other ontology systems. The ontology created is saved in a database and then read by a Decision Support tool Vanguard Studio. This was used on an example of a wing spar. The Protégé information from this example is read into Vanguard Studio decision support software. The automated production of software containing recursive Structured Query Language (SQL) queries enables this. The taxonomy was stored in a relational database using a system of key values that define all relationships and data types. This achieves the desired result of representing a hierarchical structure in a relational database. Generic code written using the Vanguard Studio editor reads from this database and recreates the tree.

In this research the focus is on combining the development of dynamic software created in response to user actions, with object oriented, rule based and Semantic Web techniques. This helps solve problems of mismatch of data between object oriented and relational database systems identified by Ambler (2003). The information is highly structured. Visualization of this structure in order to represent the relationship between things clarifies the semantics.

All information other than that dependant on user interaction, including the names of each node and its relationships to other nodes, needs to be held in a standardised data structure, e.g. a database or structured text file(s). A visual interface to this ontology is required so that model builders can maintain and extend it.

References

Ambler S., The Object-Relational Impedance Mismatch - Object-oriented technology supports the building of applications out of objects that have both data and behavior. Relational technologies support the storage of data in tables and manipulation of that data via data manipulation language (DML) internally within the database via stored procedures and externally via SQL calls.

Frankel, D., Hayes, P., Kendall, E., McGuinness, D., 2004. The Model Driven Semantic Web - 1st International Workshop on the Model-Driven Semantic Web (MDSW2004) Enabling Knowledge Representation and MDA® Technologies to Work Together (2004).

Jena - http://jena.sourceforge.net/.

Lau, H. C. W., Bing, J., Lee, W. B., Kau, K. H., 2001. Development of an intelligent data-mining system for a dispersed manufacturing network. Expert Systems Vol 18(4).

Nilsson, M., Palmér, M., Naeve, A., 2002. - Semantic Web Metadata for e-Learning - Some Architectural Guidelines - WWW2002 Hawaii USA.

J.P. Shim, Merrill Warkentin, James F. Courtney, Daniel J. Power. 2002. - Past, present, and future of decision support technology - Decision Support Systems - Volume 33, Issue 2 , June 2002, Pages 111-126.

Softartisans - http://www.softartisans.com/.

Vanguard Home Page - http://www.vanguardsw.com/

Wang, C.-B., Chen, T.-Y., Chen, Y.-M., Chu, H.-C., 2005. Design of a Meta Model for integrating enterprise systems. Computers in Industry, 56, pp 205-322.

Links

Internal

Interoperability - http://www.cems.uwe.ac.uk/amrc/seeds/softwareengineering.htm#Interoperability.

Ontologies

RDF

Semantic Web

Semantic Web Modelling

XQuery

XML

Service Oriented Architecture - Information and Links.

Software Engineering and Model Driven Programming - http://www.cems.uwe.ac.uk/amrc/seeds/softwareengineering.htm.

Software Engineering Research Group SERG - http://www.cems.uwe.ac.uk/cccs/researchgroup.php?menu=off&group=serg - SERG's mission is to bridge the gap between software engineering research and its application to different disciplines.

UML Research

External

BBC Radio 4 - http://news.bbc.co.uk/1/hi/programmes/file_on_4/6922882.stm - ID cards will give 'false' data - The government's ID card system will give thousands of "false matches" when more than six million people are registered on its database, an academic has claimed. - By Sarah Spiller - BBC File On 4.

Exist - http://exist.sourceforge.net/ - Open Source Native XML Database.

INTEROP Portal - http://www.interop-noe.org/ - Interoperability Research for Networked Enterprises Applications and Software.

Interop Events - http://interop-vlab.eu/Events - Presentation of events around Enterprise Interoperability.

INTEROP - Interoperability Research for Networked Enterprises Applications and Software - INTEROP is a Network of Excellence supported by the European Commission for a three-year-period - INTEROP aims to create the conditions of an innovative and competitive research in the domain of Interoperability for Enterprise Applications and Software.

INTEROP Portal - http://www.interop-noe.org/ - Interoperability Research for Networked Enterprises Applications and Software.

MOdel driven MOdernisation of Complex Systems - http://www.viewzone.org/momocs/index.php?option=com_content&task=blogcategory&id=20&Itemid=17 -MOMOCS aims at studying a methodology and related tools for fast reengineering complex systems. The project is studying how to solve the dilemma between rigorous methodologies and agile and unstructured one, allowing the modernisation engineer to concentrate on what to do and not how to do it.

O'Reilly XML.com - http://www.xml.com/pub/a/2007/07/12/xquery-and-data-abstraction.html - XQuery and Data Abstraction - by Kurt Cagle - July 12, 2007.

O'Reilly XML.com - http://www.xml.com/pub/a/2007/06/01/xquery-the-server-language.html - XQuery, the Server Language - Kurt Cagle - June 06, 2007.

TANET - Technology Application Network - TECHNOLOGY COLLABORATION SPANNING the whole of the UNITED KINGDOM AND BEYOND! - TANet is a unique network of over 20 co-operating Universities, Technology Centres and Key Business Partners providing the most comprehensive support for the SME Manufacturing sector for the whole of the UK.

The End of an Architectural Era (It's Time for a Complete Rewrite) - http://web.mit.edu/dna/www/vldb07hstore.pdf - In previous papers [SC05, SBC+07], some of us predicted the end of "one size fits all" as a commercial relational DBMS paradigm. These papers presented reasons and experimental evidence that showed that the major RDBMS vendors can be outperformed by 1-2 orders of magnitude by specialized engines in the data warehouse, stream processing, text, and scientific database markets. - MIT - Massachusetts Institute of Technology.

The Object-Relational Impedance Mismatch - Object-oriented technology supports the building of applications out of objects that have both data and behavior. Relational technologies support the storage of data in tables and manipulation of that data via data manipulation language (DML) internally within the database via stored procedures and externally via SQL calls - Scott W. Ambler.

Conferences - Computing and Aerospace

15 April 2008

New College, Swindon

British Computer Sociey (BCS) - Swindon Branch

Relational Database Management Systems and SQL - a load of Codds or just past its sell-by Date

18:30 - 20.00

Relational technology has been with us for over 30 years! Its use in the transactional world has been relentless since that time. It is now ubiquitous in most information management environments. And yet - well publicised failures of large scale, complex, information integration projects in the Government space seem destined to be blamed on anyone and anything rather than the underlying information management logic. In his presentation, George will look closely at the fundamental challenges of normalisation, data silos and information complexity that has conspired to make it time to look for new answers to joined up information challenges in the Defence, Intelligence and other Government spaces.

Further Information - http://www.bcs.org/server.php?show=conEvent.1691.


http://www.cems.uwe.ac.uk/~phale/Events.htm.

Systems Engineering, Estimation, Decision Support - http://www.cems.uwe.ac.uk/amrc/seeds/#Conferencesrecentandfuture.


Home Pages

SEEDS Page - SEEDS Home Page

Software Engineering Research Group - http://www.cems.uwe.ac.uk/cccs/researchgroup.php?menu=off&group=serg - SERG's mission is to bridge the gap between software engineering research and its application to different disciplines.

Peter Home Page - Peter Hale Home Page


Developed by Peter Hale, 2007. The University of the West of England, Bristol, UK.


Made with Notepad Valid XHTML Valid CSS

Terms and conditions
   Privacy policy    Accessibility

© 2007 University of the West of England, Bristol (except acknowledged extracts from newspapers, journals, etc)