Research on Spatial Database Design and Tuning Based on Oracle and ARCSDE

With the development of the Database technology and Geographic Information System technology, the spatial data managing mode go through three stages, entirely File system management, File system and Relation Database System mixed management and entirely Database management. At the same time database model also develop from Relation Model, Object-Relation Model, to Object- oriented Model. At the present time there are two main spatial database management approaches using commercial database. One is using Spatial Data Engine (Such as ArcSDE) in the Relation Database Management System. The other is using Object-Relation Database. Whichever spatial database management approach is used, in practical project we need a set of technics flow about the data preparing, database design, database configuration and tuning. Especially in commercial database, the rational database design, configuration and tuning are more important. In this article the experiment construct a fundamental spatial database system for Tibet province using Geodatabase model of the ArcSDE and the Oracle database management System. Concretely, the main fields are researched as following: (1) Analyse the character of fundamental spatial data including the Digital Orthophoto Map data, the Digital Elevation Modal data, the Digital Raster Graphic data and the Digital line Graphic data. And scheme out a data processing plan for spatial database construction. (2) Rationally Design Database, this process includes the design for Geodatabase model and the design for Oracle database. (3) Configure and tune Oracle database, this process includes the configuration of the table and index of the spatial object and the configuration and tuning of the database initial parameters

The Application of Object-Oriented Views to an Engineering Environment.

With the increasing popularity of object-oriented technology, object-oriented database systems are being used in design environments as central repositories. In this thesis, we investigate the role of versioning and the characteristics of design databases in design environments. In an effort to improve the configuration management scheme in a design environment, we also investigate the use of database views as a possible configuration tool. We propose a unified version management scheme that facilitates cooperative team work and show that the use of database views provides a powerful configuration management scheme for a design environment

Tools for distributed application management

Distributed application management consists of monitoring and controlling an application as it executes in a distributed environment. It encompasses such activities as configuration, initialization, performance monitoring, resource scheduling, and failure response. The Meta system (a collection of tools for constructing distributed application management software) is described. Meta provides the mechanism, while the programmer specifies the policy for application management. The policy is manifested as a control program which is a soft real-time reactive program. The underlying application is instrumented with a variety of built-in and user-defined sensors and actuators. These define the interface between the control program and the application. The control program also has access to a database describing the structure of the application and the characteristics of its environment. Some of the more difficult problems for application management occur when preexisting, nondistributed programs are integrated into a distributed application for which they may not have been intended. Meta allows management functions to be retrofitted to such programs with a minimum of effort

Collaborative Engineering Environments. Two Examples of Process Improvement

Companies are recognising that innovative processes are determining factors in competitiveness. Two examples from projects in aircraft development describe the introduction of collaborative engineering environments as a way to improve engineering processes. A multi-disciplinary simulation environment integrates models from all disciplines involved in a common functional structure. Quick configuration for specific design problems and powerful feedback / visualisation capabilities enable engineering teams to concentrate on the integrated behaviour of the design. An engineering process management system allows engineering teams to work concurrently in tasks, following a defined flow of activities, applying tools on a shared database. Automated management of workspaces including data consistency enables engineering teams to concentrate on the design activities. The huge amount of experience in companies must be transformed for effective application in engineering processes. Compatible concepts, notations and implementation platforms make tangible knowledge like models and algorithms accessible. Computer-based design management makes knowledge on engineering processes and methods explicit

Requirement Analysis of a Signal Database for Power Plant Automation Signals

The signal lists used for the control and automation system design of Wärtsilä Power Plants are today made with a spreadsheet software-based configuration tool. The problems with this tool are difficult data maintenance, a large manual workload and traceability of the data of configured signal lists. The maintenance problems are caused by larger power plant sizes, stricter customer requirements and scattered information in different spreadsheet software-files. To solve these problems, a database solution is planned to be developed. In this thesis, the requirements of the database are analyzed, functional descriptions are made and a high-level model of the database solution is created. The main stakeholders of the database system have been identified and interviews have been held with all of them to gather requirements and get information of current problems related to the creation of the signal lists. The development work is done in close cooperation with the Wärtsilä Power Plants R&D department, project management and control system suppliers. Theory of database design and requirements management is collected from scientific literature. This theory is used to identify requirements in the early phases of the database development and in the creation of a conceptual model of the database. The goal was to collect the main requirements, create solutions for current problems and to identify possible solutions for the planned database. The results show the large amount of signal data that is today scattered in different sources. Reasons for problems in power plant project work and control system design have been identified and the main requirements for the database solution have been classified. The planned database functionalities are modelled and possible solutions to fulfill the signal list configuration work are presented. New findings of connectivity to other information systems and lifecycle management of the signal design are brought up to meet future requirements of the power plant signal configuration work.fi=Opinnäytetyö kokotekstinä PDF-muodossa.|en=Thesis fulltext in PDF format.|sv=Lärdomsprov tillgängligt som fulltext i PDF-format

Customer Feedback Information System for Quality Improvement

This research addressed the basic needs for an effective customer feedback information system and the database technology to develop the system. It discussed the system concept and configuration of a typical customer feedback information system, database management technology, programming flow charts, program functions and capabilities. A proposed customer feedback information system consists of customer data inputs, database management system and outputs to various departments in an organization. With a user-friendly interface, database management system serves as an information management tool. It can process the feedback from customers and use the information in decision making. Thus, customer feedback can be promptly and effectively used to make corrective actions by manufacturing and service departments. The idea of continuous improvement can be effectively carried out to meet and exceed customers\u27 satisfactions and expectations

Customer Feedback Information System for Quality Improvement

This research addressed the basic needs for an effective customer feedback information system and the database technology to develop the system. It discussed the system concept and configuration of a typical customer feedback information system, database management technology, programming flow charts, program functions and capabilities. A proposed customer feedback information system consists of customer data inputs, database management system and outputs to various departments in an organization. With a user-friendly interface, database management system serves as an information management tool. It can process the feedback from customers and use the information in decision making. Thus, customer feedback can be promptly and effectively used to make corrective actions by manufacturing and service departments. The idea of continuous improvement can be effectively carried out to meet and exceed customers\u27 satisfactions and expectations

Tools for distributed application management

Distributed application management consists of monitoring and controlling an application as it executes in a distributed environment. It encompasses such activities as configuration, initialization, performance monitoring, resource scheduling, and failure response. The Meta system is described: a collection of tools for constructing distributed application management software. Meta provides the mechanism, while the programmer specifies the policy for application management. The policy is manifested as a control program which is a soft real time reactive program. The underlying application is instrumented with a variety of built-in and user defined sensors and actuators. These define the interface between the control program and the application. The control program also has access to a database describing the structure of the application and the characteristics of its environment. Some of the more difficult problems for application management occur when pre-existing, nondistributed programs are integrated into a distributed application for which they may not have been intended. Meta allows management functions to be retrofitted to such programs with a minimum of effort

Tool construction for the British Airways SEE with the O<inf>2</inf> ODBMS

Software engineering environments (SEE) support the construction and maintenance of large-scale software systems. They integrate tools for the production and maintenance of documents such as requirements definitions, architecture definitions or user manuals. Very few SEE tools meet all the developers' requirements. Some requirements that are important in practice have not been appropriately addressed. These are inter-document consistency handling, version and configuration management and cooperative work. We claim that the reason for current tools not meeting these requirements is the fact that the required database support for maintaining documents is only now becoming available. The British Airways SEE meets these new requirements. Its tools were constructed using the O2 object database management system, which has been extended to become a database management system for software engineering. We discuss the experiences we made during tool construction for this SEE