CN102043620B - A kind of method for designing of data sharing interface for vessel traffic management system - Google Patents
A kind of method for designing of data sharing interface for vessel traffic management system Download PDFInfo
- Publication number
- CN102043620B CN102043620B CN201010556685.XA CN201010556685A CN102043620B CN 102043620 B CN102043620 B CN 102043620B CN 201010556685 A CN201010556685 A CN 201010556685A CN 102043620 B CN102043620 B CN 102043620B
- Authority
- CN
- China
- Prior art keywords
- data
- vts
- char
- information
- type
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 29
- 238000013461 design Methods 0.000 claims abstract description 18
- 230000003068 static effect Effects 0.000 claims abstract description 5
- 230000002452 interceptive effect Effects 0.000 claims description 9
- 230000008569 process Effects 0.000 claims description 6
- 238000011161 development Methods 0.000 claims description 4
- 238000006243 chemical reaction Methods 0.000 claims description 3
- 230000006837 decompression Effects 0.000 claims description 3
- 239000011159 matrix material Substances 0.000 claims description 3
- 230000005540 biological transmission Effects 0.000 claims description 2
- 238000012545 processing Methods 0.000 claims description 2
- 230000000694 effects Effects 0.000 abstract description 6
- 239000004575 stone Substances 0.000 abstract description 3
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 abstract description 3
- 238000005516 engineering process Methods 0.000 description 2
- 102100023727 Mitochondrial antiviral-signaling protein Human genes 0.000 description 1
- 101710142315 Mitochondrial antiviral-signaling protein Proteins 0.000 description 1
- 230000002159 abnormal effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000013479 data entry Methods 0.000 description 1
- 230000003111 delayed effect Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
Abstract
The invention provides a kind of method for designing of data sharing interface for vessel traffic management system; VTS is at promotion marine traffic safety; improve navigation order, improve traffic efficiency and protect the aspects such as water environment to play an important role; the foundation stone of its effect, depend on boats and ships quiet/multidate information and navigation environment information.Realize VTS data sharing, eliminate information island, comprise the data exchanging function of both direction: 1, TO? VTS-the boats and ships static information in the third party system, navigation environment information sharing is to VTS, improve VTS competent authorities work efficiency and service quality, promote VTS job information level on duty; 2, FROM? VTS-vessel traffic multidate information shares to the third party system and browses viewing, expands the usable range of VTS information, plays the effect of VTS system fully.VTS data sharing relates to exploitation unit or system is assorted, content is many, and what the design's method had evaded that Third party system selects the different or upgrading in the future of developing instrument, type of database on VTS data sharing interface affects risk.
Description
Technical field
The present invention relates to a kind of computer information data administrative skill, specifically a kind of method for designing of data sharing interface for vessel traffic management system.
Background technology
Definition: vesseltrafficservices (being called for short VTS) means Ship Traffic Service, and China is commonly referred to VTS.VTS, at promotion marine traffic safety, improves navigation order, improves traffic efficiency and aspect such as protection water environment etc. plays an important role, the foundation stone of its effect, depend on boats and ships quiet/multidate information and navigation environment information.VTS data sharing interface, only has and the data sharing in Third party system is come timely and effectively, could improve efficiency and level that competent authorities supervise vessel traffic; VTS vessel traffic multidate information is exported to third party, is used for serving the supplementary means of boats and ships as relevant unit.If it is delayed to share data time, data, by ineffective, become junk data.
Summary of the invention
The object of the invention is to realize in the following manner, comprise following content:
1) design of data sharing interface, is that runtime Dynamic Definition exchanges adapter, disposes, need to be driven by defined parameters for data layout, data processing to type of database, data item and data type dynamic-configuration;
2) method of service is run, and reads configuration definition content, automatically organizes SQl to realize data transmission and shares;
3) data characteristic classification and exchanged form design, comprising: characteristic analytical data, classify to data, and by class correspondence design exchanged form; Wherein:
(1) basic data is mainly exchanged for master with timing, and the cycle is slightly long, allows interactive visit;
(2) static data is mainly exchanged for master with timing, and the cycle is slightly short, allows interactive visit;
(3) dynamic data is mainly based on real-time exchange, and regularly, interactive mode is secondary;
(4) picture/Long Binary/phonetic matrix data, exchange after palpus compressing data/decompression or format conversion;
(5) confidentiality height categorical data, is encrypted data and exchanges;
(6) fixed point is transmitted or is needed route-type data, exchanges after formulating node address information in exchange;
4) man-machine interface operation program is designed, configuration definition exchanges adapter, comprise needing the type of database exchanged: Oracle, Sybase, DB2, SqlServer, data item and data type comprise: floating type, character type, Blob, carry out dynamic-configuration definition, and corresponding configuration definition exchanges authority, data layout, routing node;
5) design method of service working procedure, read configuration definition adapter, automatically organize SQl, access data sources, extracted data is to destination data storehouse;
6) design supplies the dynamic link libraries that Third party system calls, and support secondary development, dynamic link libraries issues two methods:
1. from VTS system, data are obtained
LongGetData(char*userID,
char*userPwd,
char*businessID,
char*parameters,
char*relData);
Parameter:
UserID: the operating right of the corresponding business of this user
UserPwd: the password that user is corresponding
BusinessID: to the service code in requisition for process
Parameters: the range of condition of corresponding service needed
Note: wherein need before field name to increase, use SQL logical operator between multiple condition, such as:
IMO=’A1234’orMMSI=’876543210’
RelData: the data set returned
2. to VTS system input data
longputData(char*userID,
char*userPwd,
char*businessID,
char*parameters);
Parameter:
UserID: the operating right of the corresponding business of this user
UserPwd: the password that user is corresponding
BusinessID: to the service code in requisition for process
Parameters: the data set imported into.
Excellent effect of the present invention
1) specification and standard are based on specification and standard, can the development and change of adaption demand fast, and system can according to demand data, and on the basis not changing original framework, fast open sends corresponding exchanges data adapter, changes with adaption demand.
2) Dynamic data exchange of Dynamic data exchange exchanges data both sides, ensures that inter-system data is consistent, safe, complete, effective.
3) access rights of authority configurable data, scope are configurable.
4) can manage exchanges data based on service based on Service Management, as created, revise or stopping service etc.
Accompanying drawing explanation
Accompanying drawing 1 is relation schematic diagram between table inventory and mark;
Embodiment
With reference to Figure of description, method of the present invention is described in detail below.
VTS data sharing, system architecture, developing instrument or type of database that the Third party system related to is selected are different, share interface to want to ensure the data of these systems to exchange, and if will ensure that Third party system is upgraded, the graceful upgrade of VTS data sharing interface and normal use.
VTS, at promotion marine traffic safety, improves navigation order, improves traffic efficiency and aspect such as protection water environment etc. plays an important role, the foundation stone of its effect, depend on boats and ships quiet/multidate information and navigation environment information.Realize VTS data sharing, eliminate information island, current general data exchanges the data that information category comprises both direction:
1, TOVTS---the boats and ships static information in the third party system, navigation environment information sharing to VTS, improve VTS competent authorities work efficiency and service quality, promote VTS job information level on duty;
The kind of the information of sharing comprises: boats and ships essential information; International Voyage Ship import bank application information; Cabotage boats and ships arrival & departure port forecast information; Boats and ships are arrive in Hong Kong forecast information; Ship Navigational Plan; Ship piloting information; Ship detention information; Emphasis follows the tracks of ship information; Important mornitoring ship information; Boats and ships examination information; Ship certification information; Regular examination or VISAs; Nationality's information; Port of registry information; Description of Ship information; Berth information; Shipping Company or proxy information; Mechanism information; Ship tracking cause information.
2, FROMVTS---vessel traffic multidate information shares to the third party system and browses viewing, expands the usable range of VTS information, plays the effect of VTS system fully.
Vessel traffic multidate information comprises: mooring steamer of arriving in Hong Kong; Ship's navigation is dynamic; Berth boats and ships; Ship's navigation track.
VTS data sharing relates to exploitation unit or system is assorted, content is many, and what the design's method had evaded that Third party system selects the different or upgrading in the future of developing instrument, type of database on VTS data sharing interface affects risk.
Embodiment
The object of this invention is to provide a kind of VTS (being called for short VTS) data sharing method for designing, VTS system and many Third party system are realized data sharing, ensure promptness, the accuracy of sharing data; And setting data can exchange authority, data layout, switching and routing etc.Technic relization scheme is as follows:
1) data characteristic classification and exchanged form design, characteristic analytical data, classifies to data, and by class correspondence design exchanged form.
Sequence number | Data characteristic is classified | Exchanged form designs |
1 | Basic data | Mainly be exchanged for master with timing, the cycle is slightly long, allows interactive visit |
2 | Static data | Mainly be exchanged for master with timing, the cycle is slightly short, allows interactive visit |
3 | Dynamic data | Main based on real-time exchange, regularly, interactive mode be pair |
4 | Picture/Long Binary/phonetic matrix data | Exchange after palpus compressing data/decompression or format conversion |
5 | Confidentiality height categorical data | Data are encrypted and exchange |
6 | Fixed point is transmitted or is needed route-type data | Exchange formulate node address information in exchange after |
2) design man-machine interface operation program, configuration definition exchanges adapter
To the type of database (as Oracle, Sybase, DB2, SqlServer etc.), data item and the data type (floating type, character type, Blob etc.) that need to exchange, carry out dynamic-configuration definition, and corresponding configuration definition exchanges authority, data layout, routing node.Adapter arrangement definition storage organization is described as follows:
(1) relation between inventory and table is shown
Title | Annotation |
System code table | The information such as Third party system coding, system name |
Service code table | Information category service code table |
Field famous-brand clock | Information category data entry field name code table |
User organizes authority | User organizes corresponding traffic table |
Subscriber group information | User organizes essential information |
(2) list area name inventory
1. system code table
Title | Data type | Annotation |
Subsystem code | char(2) | Service sub-system internal code |
Subsystem title | varchar(20) | Service sub-system title (explanation) |
Database-name | varchar(20) | |
Database service name | varchar(50) | |
Database account number | varchar(50) | |
Database password | varchar(50) | Cryptographic storage |
2. service code table
3. field code table
4. user organizes table
Title | Data type | Annotation |
User organizes code | char(4) | |
User's group name claims | varchar(100) | |
Remarks | varchar(255) |
5. user's group permission table
Title | Data type | Annotation |
User organizes code | char(4) | |
Service code | char(6) | |
Access level | char(1) | 1: limit priority; 2: secondary |
First exchanges the start time | char(8) | Form: HH:MM:SS |
First exchanges the end time | char(8) | Form: HH:MM:SS |
Second exchanges the start time | char(8) | Form: HH:MM:SS |
Second exchanges the end time | char(8) | Form: HH:MM:SS |
Remarks | varchar(255) |
3) design method of service working procedure, read configuration definition adapter, automatically organize SQl, access data sources, extracted data is to destination data storehouse;
4) design supplies the dynamic link libraries that Third party system calls, and supports secondary development.Dynamic link libraries issues two methods:
1. from VTS system, data are obtained
LongGetData(char*userID,
char*userPwd,
char*businessID,
char*parameters,
char*relData);
Parameter:
UserID: the operating right of the corresponding business of this user
UserPwd: the password that user is corresponding
BusinessID: to the service code in requisition for process
Parameters: the range of condition of corresponding service needed
Note: wherein need before field name to increase, use SQL logical operator between multiple condition, such as:
IMO=’A1234’orMMSI=’876543210’
RelData: the data set returned
2. to VTS system input data
longputData(char*userID,
char*userPwd,
char*businessID,
char*parameters);
Parameter:
UserID: the operating right of the corresponding business of this user
UserPwd: the password that user is corresponding
BusinessID: to the service code in requisition for process
Parameters: the data set imported into
Another application JNI technology, data sharing interface realizes the dynamic link library supporting that Java calls.
Two method rreturn values are defined as follows:
Code | Annotation |
When being more than or equal to 0 | Return the number of application record |
-1 | Occur abnormal |
-10 | Authority is not had to access |
-20~-50 | Adapter definition or database access make mistakes |
Be less than-50 | Expansion is used |
Claims (1)
1. a method for designing for data sharing interface for vessel traffic management system, is characterized in that comprising following content:
1) design of data sharing interface, is that runtime Dynamic Definition exchanges adapter, disposes, need to be driven by defined parameters for data layout, data processing to type of database, data item and data type dynamic-configuration;
2) method of service is run, and reads configuration definition content, automatically organizes SQl to realize data transmission and shares;
3) data characteristic classification and exchanged form design, comprising: characteristic analytical data, classify to data, and by class correspondence design exchanged form; Wherein:
(1) basic data is mainly exchanged for master with timing, and the cycle is slightly long, allows interactive visit;
(2) static data is mainly exchanged for master with timing, and the cycle is slightly short, allows interactive visit;
(3) dynamic data is mainly based on real-time exchange, and regularly, interactive mode is secondary;
(4) picture/Long Binary/phonetic matrix data, exchange after palpus compressing data/decompression or format conversion;
(5) confidentiality height categorical data, is encrypted data and exchanges;
(6) fixed point is transmitted or is needed route-type data, exchanges after formulating node address information in exchange;
4) man-machine interface operation program is designed, configuration definition exchanges adapter, comprise needing the type of database exchanged: Oracle, Sybase, DB2, SqlServer, data item and data type comprise: floating type, character type, Blob, carry out dynamic-configuration definition, and corresponding configuration definition exchanges authority, data layout, routing node;
5) design method of service working procedure, read configuration definition adapter, automatically organize SQl, access data sources, extracted data is to destination data storehouse;
6) design supplies the dynamic link libraries that Third party system calls, and support secondary development, dynamic link libraries issues two methods:
Wherein 1. method obtains data from VTS system, and step is as follows:
Use LongGetData () function, this function comprises parameter char*userID, char*userPwd, char*businessID, char*parameters, char*relData; Described Parameter represents respectively: userID: the operating right of the corresponding business of this user; UserPwd: the password that user is corresponding; BusinessID: to the service code in requisition for process; Parameters: the range of condition of corresponding service needed; RelData: the data set returned;
Use SQL logical operator between multiple condition, wherein need before field name to increase, comprising: IMO=' A1234 ' orMMSI=' 876543210 '
Method is 2. to VTS system input data, and step is as follows:
Use longputData () function, this function comprises parameter char*userID, char*userPwd, char*businessID, char*parameters);
Described parameter represents respectively: userID: the operating right of the corresponding business of this user; UserPwd: the password that user is corresponding
BusinessID: to the service code in requisition for process; Parameters: the data set imported into.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201010556685.XA CN102043620B (en) | 2010-11-24 | 2010-11-24 | A kind of method for designing of data sharing interface for vessel traffic management system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201010556685.XA CN102043620B (en) | 2010-11-24 | 2010-11-24 | A kind of method for designing of data sharing interface for vessel traffic management system |
Publications (2)
Publication Number | Publication Date |
---|---|
CN102043620A CN102043620A (en) | 2011-05-04 |
CN102043620B true CN102043620B (en) | 2016-04-06 |
Family
ID=43909779
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201010556685.XA Active CN102043620B (en) | 2010-11-24 | 2010-11-24 | A kind of method for designing of data sharing interface for vessel traffic management system |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN102043620B (en) |
Families Citing this family (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102811199B (en) * | 2011-05-30 | 2015-10-28 | 深圳市金蝶友商电子商务服务有限公司 | A kind of method for interface adaptation, Apparatus and system |
CN106096816A (en) * | 2016-05-31 | 2016-11-09 | 北京交通大学 | Port enterprise and port office work in coordination with the ship dispatch method and system carried out |
CN106097779A (en) * | 2016-06-27 | 2016-11-09 | 嘉兴星网通信技术有限公司 | The sharing method of navigation channel information |
CN111276010A (en) * | 2020-01-20 | 2020-06-12 | 吉林农业大学 | Comprehensive information platform of ship traffic service system |
CN115619414A (en) * | 2022-12-16 | 2023-01-17 | 亿海蓝(北京)数据技术股份公司 | Method and device for verifying whether ship and trade background thereof are sensitive or not |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1206156A (en) * | 1998-08-06 | 1999-01-27 | 交通部天津海上安全监督局 | Ship data processing system |
CN1949763A (en) * | 2005-10-11 | 2007-04-18 | 北京航空航天大学 | Shared message server system |
KR100785335B1 (en) * | 2006-07-14 | 2007-12-17 | 한국해양연구원 | Managing method of ship using information of synthetic aperture radar and vessel traffic service and system thereof |
KR100813315B1 (en) * | 2007-03-14 | 2008-03-13 | 한국해양연구원 | Vessel idetification system interoperable with ais and trs |
CN101615349A (en) * | 2009-07-24 | 2009-12-30 | 姚和平 | System of monitoring fishing boats for anti-collision alarm |
-
2010
- 2010-11-24 CN CN201010556685.XA patent/CN102043620B/en active Active
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1206156A (en) * | 1998-08-06 | 1999-01-27 | 交通部天津海上安全监督局 | Ship data processing system |
CN1949763A (en) * | 2005-10-11 | 2007-04-18 | 北京航空航天大学 | Shared message server system |
KR100785335B1 (en) * | 2006-07-14 | 2007-12-17 | 한국해양연구원 | Managing method of ship using information of synthetic aperture radar and vessel traffic service and system thereof |
KR100813315B1 (en) * | 2007-03-14 | 2008-03-13 | 한국해양연구원 | Vessel idetification system interoperable with ais and trs |
CN101615349A (en) * | 2009-07-24 | 2009-12-30 | 姚和平 | System of monitoring fishing boats for anti-collision alarm |
Also Published As
Publication number | Publication date |
---|---|
CN102043620A (en) | 2011-05-04 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US10681133B2 (en) | Methods and systems for endpoint device operating system in an asset intelligence platform | |
CN102043620B (en) | A kind of method for designing of data sharing interface for vessel traffic management system | |
US10013573B2 (en) | Personal ledger blockchain | |
CN103268455B (en) | The access method of data and device | |
CN104252375B (en) | Method and system for sharing USB Key positioned at multiple virtual machines of different main frames | |
CN102725753B (en) | Method and apparatus for optimizing data access, method and apparatus for optimizing data storage | |
CN104091129B (en) | A kind of data processing method and device | |
CN106415496A (en) | Unified intermediate representation | |
TW201140350A (en) | High throughput, reliable replication of transformed data in information systems | |
US20150356149A1 (en) | Re-sizing data partitions for ensemble models in a mapreduce framework | |
CN103003798B (en) | Virtual computer system, and control method for virtual computer system | |
CN102567399A (en) | Method and device for accessing database | |
CN102831069A (en) | Memory processing method and memory management equipment | |
CN107391611A (en) | A kind of process model generation method of the General ETL Tool based on workflow | |
CN104834484A (en) | Data processing system and processing method based on embedded type programmable logic array | |
Fal’ | Standardization in information security management | |
CN111651453A (en) | User historical behavior query method and device, electronic equipment and storage medium | |
CN102687126B (en) | Assigning efficiently referenced globally unique identifiers in a multi-core environment | |
US20130067595A1 (en) | Data Isolation Service for Data and Information Sharing | |
CN102681790A (en) | Data dump device and method and system for data dump by same | |
CN114036538A (en) | Database transparent encryption and decryption implementation method and system based on virtual block device | |
WO2019138542A1 (en) | Countermeasure formulation assistance device, countermeasure formulation assistance method, and countermeasure formulation assistance program | |
CN104346575A (en) | Software defined security architecture | |
CN101477647A (en) | Service process exhibition control system | |
CN112330257B (en) | Whole-course logistics information service system under comprehensive traffic system |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
CB02 | Change of applicant information |
Address after: 250100 Ji'nan high tech Zone, Shandong, No. 1036 wave road Applicant after: Tide software incorporated company Address before: 250014 Shandong Province, Ji'nan City hi tech Development Zone, Nga Road No. 1036 Applicant before: Langchao Qilu Software Industry Co., Ltd., Shandong |
|
COR | Change of bibliographic data | ||
C14 | Grant of patent or utility model | ||
GR01 | Patent grant |