Keywords

1 Introduction

The Bohai Sea area is the key area of social and economic development in China. Development and use of fishery information resources in the Bohai Sea directly affects the social and economic development of the area. Currently, with the rapid development of fisheries economics, the investigation and scientific research of environmental resources in the surrounding waters of the Bohai Sea and it have accumulated rich basic data of various marine environment. These professional resources for fisheries information are distributed in maritime administrative departments, marine institutions at all levels, scientific research institutes and other services.

However, there are still many defects and deficiencies in the integration of marine fishery resources in China, such as the lack of a unified definition of basic information of fishery management; For the equipment used in construction, data resources cause fragmentation of data storage management at different levels of information technology development, and there are too many redundant data and inconsistencies. The level of data sharing cannot meet the requirements of the unit for the overall development and use of Information Resources. A large number of data does not provide a unified data interface, does not use general standards and specifications, cannot obtain A shared public data source, and is responsible for a large number of information islands.

The existence of these problems causes the management and value of Bohai Sea fisheries to be reduced, the quality of the use of increased costs, management cannot obtain effective support for decision-making data. Although the collection of maritime fishing information and statistical work have constituted an enormous database, MAS due to poor processing and analysis of information, not directly from the database system at various levels and from the collection of data and wide use.All this leads to the Marine Fishing Database system producing large amounts of data can not extract sublimated information in useful information to meet the needs of the managers, eventually making the level of use of the information resources is low, caused large amounts of waste.

2 The Research Contents

2.1 Metadata Annotations

Metadata is data about data, i.e. information on content, quality, status and other characteristics in the database (data attribute, data set or data warehouse, etc.). A semantic continuum is formed by the above classification.

2.2 Metadata Framework

Metadata can be one of two ways. One way is direct access to metadata, one type is to capture all types of database operation process of metadata. Set of metadata standards and specifications. In the process of database system operation can capture the metadata.

  1. (1)

    Design is the designer and developer used to define metadata requirements, metadata requirements, and includes data model, business transformation work design.

  2. (2)

    Physical metadata: use of tools to run establishment, management and access to metadata.

  3. (3)

    Operational metadata: When carrying out data integration activities, operational metadata will tell users what will happen to change, especially about YOUR influence on how the Data Integration Source works.

  4. (4)

    Project metadata: used to produce documents, audit development efforts, assign accountability and process change management issues. Guided: persons, responsible, tools, users and management operation.

The metadata database system can realize the following functions:

  1. (1)

    Data entry: 1) Direct Input keypad. 2) included existing text files. 3) including the original scanning image.

  2. (2)

    Preview and output: the information from the database, the results from the recovery of the query and the statistical analysis can be directly via the browser screen for a given form to the form, statement or graph of statistical analysis, Users allowed to Show changes in content can be submitted to the database server. At the same time, data can be directly through the printer output.

  3. (3)

    Edit and modify: Authorised users can edit and change the information in the database. Modifying the general process is to extract MS according to the information state, information editing, Outcome of the presentation.

  4. (4)

    Data recovery query, data consultation and recovery query refer to own metadata. Include a simple query, query consultation, merge query, Query and recovery results fulfil the conditions that will be shown As a query and data recovery. Details of the query data, respectively, using the format of the corresponding navigation. In no leak and under the premise of protection of intellectual property rights, For some data You can provide direct online download services. Data and information download will adopt the corresponding file download directly.

  5. (5)

    User access control and monitoring of user information: according to different types of users, determine user permissions for the operation of the network database, the FIM to ensure the safe operation of the system. To record user information for tracking.

  6. (6)

    System management functions: system administrators and data managers to maintain, update, system to manage the user, database registry can be added, deleted, modified, edited operation, etc.

2.3 Topic-Oriented Meta Database Building

An important step in building the Subject-oriented Meta Database is to establish the Bohai Fishery Theme Management model and obtain the modeling of metadata according to the subject model.

The modeling process of the subject is shown in Fig. 1. The Subject model is obtained from the existing business model by Specialist Persons, which can be divided into fisheries management specialists, data analysts and software developers.

Fig. 1.
figure 1

Topical metadata template

Full size image

2.4 Metadata Resource Query Algebra System

Logical calculation and query algebra is the basis of the query of data. In a relational database theory, the expression of relational calculation of security is an important problem. If a query expression cannot be evaluated within finite steps, and obtain a finite set the results of this expression are referred to as the safe. Otherwise, the expression is safe. In Metadata Resources management, there are such problems.

Logical calculation and query algebra are the basis of the query of data. In the traditional theory of the relational database, relational calculus expression is an important safety problem. If the query expression cannot be evaluated in limited steps and the result set is limited, the expression is called safe expression. Otherwise, the expression is safe. There are such problems in the management of metadata resources.

Research of question algebra plays an important role in the field of data management. Common operational semantics are used to compare query definitions, query optimizations, and query capabilities for query languages. In relational databases, Codd has proposed a relational algebra that has constructed a theoretical foundation for the success of relational algebra. In the data model research, query algebra has become a part of the data model for the past decade. Whether there is a corresponding algebraic system, whether the data model that studied the XML data model of the object oriented query algebra model and the query algebra system is an important symbol of maturity.

3 Research Methods

3.1 Metadata Standards Set

Standard procedures are divided into nine stages: preliminary stage, project stage, draft form, opinion, review, approval, release stage, examination stage, and abolition stage.

Standard specification description elements:

Standard No. of China

Standard Title in China

Standard Title in English

……

Governer Code

Drafting Committee

3.2 Research on Metadata Semantic Model

Characteristics of metadata are analyzed generally. The metadata format is complex. In addition to the simple format of the data dictionary, there are many complex levels, and the metadata format is changeable. In general, read only is used during system operation. Metadata is usually used scatter with cross platform and cross process characteristics.

In order to share data and resources, it is more complicated to organize model data and fields, and to simplify the model of relational data resources provided by different organizations and to model metadata models. Obviously, conventional object oriented models cannot achieve this goal. Figure 2 shows mapping relationships between metadata and domain ontology.

Fig. 2.
figure 2

Demand of fishery management resource modeling in Bohai sea

Full size image

The semi-automatic semantic association framework between heterogeneous data sources is shown in Fig. 3. The framework takes as input semi-structured documents in the database (Web page XML documents, etc.) and unstructured documents such as this document. Through the shallow natural language processing, such as (Chinese word segmentation except stop words, part of speech tagging, key phrase identification, entity noun identification, etc.), vectorization is carried out. Then machine learning and data mining methods are used to analyze the semantic relationship of the implied concepts.

Fig. 3.
figure 3

Semi-automatic semantic association framework

Full size image

3.3 Establishment of Meta Database System for Fishery Management in Bohai Sea

Includes the use and management of metadata, the metadata database system must record the following information:

  1. (1)

    The type of it ?

  2. (2)

    Where is it?

  3. (3)

    From where?

  4. (4)

    What is it related to?

  5. (5)

    Who is responsible for it?

  6. (6)

    What terms, vocabularies, and business domains are associated with it?

  7. (7)

    What will be the impact of any changes to it?

  8. (8)

    What will be their properties and relationships when they are exported to another tool?

3.4 Constructing the Maintenance and Renewal Management Mechanism of Fishery Management Metadata Resources in the Bohai Sea

Database development technology includes database management technology and database online publishing technology.

There are many database management systems to choose from, such as Sybase SQL Server, Informix SQL Server, Oracle SQL Server and so on. The system development can use Microsoft SQL Server as the database management software on the Server, because the advantages of Microsoft SQL Server can be reflected in the following aspects: Perfect combination with the operating system, the use of Windows security mechanism and their own security mechanism combined, with safe and reliable performance; Large data volume support; Concurrency control, automatic backup; With the good combination of development tools, using VC, VB, InterDev, PowerBuilder and so on can be very convenient in SQL Server platform for database application development.

4 Conclusions

This paper can provide a unified standard for different Marine fisheries departments to add established fishery databases to the information platform. Formulate metadata specifications of physical and chemical databases, develop and release corresponding metadata management tools, assist and guide all professional data centers to complete the metadata construction of their professional databases.

Developed a high availability and high efficiency data application service system platform based on meta-directory, established data input, collection, management, inquiry, and the corresponding authority management mechanism. Realize unified management and service provision of existing scattered data through advanced metadata directory technology.

Through the metadata management control, the database management system to achieve dynamic database loading, when the structure of the data changes, can be achieved by modifying and maintaining the metadata directory library, and the corresponding data application system without reconstruction. Therefore, the system has good versatility and is easy for scientific and technical personnel to master and use. It provides an ideal soft environment for the retrieval and management of various scientific and technical data. Its application has important theoretical and practical significance.