Database management system based on off-line state of ship hybrid power system

By designing an offline database management system based on the marine hybrid system, using Oracle database and specific topology, the power switching problem of the marine hybrid system in the offline state is solved, efficient resource utilization and shipping safety are achieved, and the system reliability is enhanced Sex and business value.

CN118964328APending Publication Date: 2024-11-15CHONGQING JIAOTONG UNIV
View PDF 1 Cites 0 Cited by

Patent Information

Application Number
CN202411032182.0
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-07-30
Publication Date
2024-11-15

AI Technical Summary

Technical Problem

The prior art cannot independently switch power modes in the offline state of the marine hybrid system, resulting in the inability to effectively manage navigation information under special circumstances, affecting safety and efficiency.

Method used

Design a database management system based on the offline state of the marine hybrid system, using Oracle database, star topology sensors and tree topology with high processing performance, to establish a complete database system by collecting and storing navigation information, and provide users with Management and data backup capabilities to ensure data stability and consistency.

Benefits of technology

It achieves maximizing resource utilization in offline state, reducing mechanical reaction time, ensuring shipping safety, enhancing the reliability and intelligence of the system, and providing commercial value.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN118964328A_ABST
    Figure CN118964328A_ABST
Patent Text Reader

Abstract

The invention relates to a database management system based on an off-line state of a ship hybrid power system. The system depends on an oracle database system with high processing performance, a client, a console, a total server, a help button and a latch. Through a star topology structure, a simple and friendly operation interface which can store valuable data, is used for managing system users and a database and storing navigation information is formed, and a main window can complete all operations; and the navigation database system can help a user to provide a latch and lock which can solve problems and guarantee the stability of database objects and the consistency of data during use.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of ship hybrid power and computer science and technology, and in particular to a database management system based on an offline ship hybrid system, wherein the database has the function of recording and storing the working status of the ship hybrid system during navigation. Background Art

[0002] In recent years, with the continuous development of the shipping industry, various electronic equipment and new energy power drive methods have emerged in large numbers. The demand for intelligent, green, information-based and real-time control systems in the field of ship control systems has become more and more urgent.

[0003] In order to solve the above-mentioned problems, the Chinese patent with publication number CN202211471061.7 discloses a hybrid power system for inland vessels and an operation control method, and for this hybrid power system for ships, a database management system that can be used in an offline state is designed. The present invention can be used in special circumstances (special circumstances include but are not limited to: due to force majeure factors, the coast radio station is unable to send important navigation information such as weather and river flow to the ship in sailing; the ship itself is unable to contact the satellite or coast radio station due to unexpected circumstances) The purpose is to more conveniently and directly mobilize the existing navigation information in the database so that the central controller can control the ship hybrid system.

[0004] At present, there is no inland ship management system that can switch the power mode autonomously in an offline state at home and abroad. Therefore, a database management system based on the offline state of the ship hybrid system is designed. The system of the present invention can make great use of effective resources and avoid the occurrence of dangerous situations. In addition, due to its intelligent intelligence, it can also greatly shorten the mechanical reaction time and ensure the safe development of the inland shipping industry. Summary of the invention

[0005] The present invention aims to provide a database management system based on an offline ship hybrid system.

[0006] The object of the present invention is achieved in this way: the system includes a relational database management system oracle with high processing performance, a client for storing valuable data, a database system for collecting complete and comprehensive data, a console for managing system users and databases, two main servers for storing navigation information, an operation interface with a main window that can complete all operations, and contains a help button that can help users solve problems, and a latch and lock that ensure the stability of database objects and the consistency of data during use.

[0007] Optionally, by collecting and recording each voyage information and working status, the content in the database system is continuously improved to establish a complete and comprehensive database system.

[0008] Optionally, the main server stores all the navigation data, and after screening all the navigation data, stores the remaining valuable data in the client so that the client can use it in an offline state.

[0009] Optionally, the navigation data can be sold based on a complete and comprehensive database system established by collecting various data.

[0010] Optionally, the console of the system is used to manage system users and databases, namely, database backup, user addition and deletion, and user password initialization.

[0011] Optionally, when the ship docks or can be connected to the main server through a local area network, the main server sends new data to the client for timely updating.

[0012] Optionally, the established database tables include a work status table, an external environment information table, and a login table.

[0013] Optionally, the inquiry desk software used by the user has an operation interface, and the main window is used to complete all operations and contains a help button that can help the user solve the problem.

[0014] Optionally, the operation and maintenance of the system includes maintaining the security and integrity of the database and timely backing up the data stored in the main server, while monitoring and continuously improving the database operation performance.

[0015] Optionally, the Oracle database software used by the system has two database backup methods: one is cold backup, that is, when the database is closed, critical files are copied to another location; the other is hot backup, that is, when the database is running, the database is backed up in archive log mode.

[0016] Optionally, in the process of optimizing the performance of the Oracle database, a mechanism may be used to ensure the stability of database objects and the consistency of data during use, and the mechanism includes a latch and a lock.

[0017] The present invention also includes such structural features:

[0018] 1. Mechatronics is used to ensure the accuracy of the system of the present invention.

[0019] 2. The star topology sensor improves the efficiency of data acquisition and transmission.

[0020] 3. The tree topology formed by the various parts connected by the central controller has strong scalability, energy saving and high efficiency, and is suitable for large-scale, multi-level hybrid power control systems.

[0021] 4. It has a database system that continuously learns and improves by collecting and recording navigation information.

[0022] Compared with the prior art, the beneficial effects of the present invention are: 1. Relying on the ship hybrid power system, by collecting and recording each navigation information and working status, the content in the database system is continuously improved, and finally a complete and comprehensive database system is established, which is reliable and highly learnable; 2. Relying on this database system, the difficulty of users operating the ship hybrid power system can be reduced to the greatest extent, and it has a certain degree of intelligence; 3. Relying on a complete and comprehensive database system established by collecting various data, the navigation data therein can be sold, which is commercial. BRIEF DESCRIPTION OF THE DRAWINGS

[0023] Figure 1 The present invention is a flowchart of the use of the present invention. DETAILED DESCRIPTION

[0024] The present invention is further described in detail below in conjunction with the accompanying drawings and implementation modes.

[0025] In the embodiment of the present invention, Figure 1 As shown, the present invention includes an oracle relational database management system with high processing performance, a client for storing valuable data, a database system for collecting complete and comprehensive data, a console for managing system users and databases, two main servers for storing navigation information, a simple and friendly operation interface, a main window that can complete all operations and contains help buttons that can help users solve problems, and latches and locks that ensure the stability of database objects and the consistency of data during use.

[0026] In an embodiment of the present invention, a complete and comprehensive database system is established by collecting and recording each navigation information and working status and continuously improving the content in the database system, and finally establishing a complete and comprehensive database system, and a database management system based on the offline state of the ship hybrid system; after screening all the navigation data stored in the main server, valuable data is retained and stored in the client to ensure that the client runs in an offline state; the saleable navigation data relies on a complete and comprehensive database system established by collecting various data; the console used to manage system users and databases, that is, database backup, user addition and deletion, and user password initialization; the main server that sends new data to the client for timely update when the ship is docked or can be connected to the main server through a local area network; the database management system software Oracle The database tables established by Database19c include a working status table (operating status such as the motor and diesel engine running at the same time, the diesel engine running, etc.), an external environment information table (temperature, ocean currents, air pressure, wind speed, navigation marks, islands, etc.), and a login table (saving the account and login password of each system user); the query desk software used by the user has a simple and friendly operating interface, and the main window can complete all operations and contains help buttons that can help users solve problems; the maintenance of the database security and integrity and timely back up the data stored in the main server, while monitoring and continuously improving the database operation performance; the Oracle database software with two database backup methods, one is cold backup, that is, when the database is closed, the key files are copied to another location; the other is hot backup, that is, when the database is running, the archive log mode is used to back up the database; the use of some mechanisms to ensure the stability of database objects and the consistency of data during use to optimize the Oracle database performance process, the mechanism includes latches and locks.

[0027] This system relies on the Oracle database system with high processing performance and clients, consoles, main servers, help buttons, and latches. Through the star topology structure, it can store valuable data, manage system users and databases, save navigation information, and has a simple and friendly operation interface. The main window can complete all operations, and can help users solve problems. The navigation database system has latches and locks to ensure the stability of database objects and data consistency during use.

Claims

1. A database management system based on an offline ship hybrid system, characterized in that: It includes a relational database management system Oracle with high processing performance, a client for storing valuable data, a database system for collecting complete and comprehensive data, a console for managing system users and databases, two main servers for storing navigation information, an operation interface with a main window that can complete all operations and contains a help button that can help users solve problems, and latches and locks that ensure the stability of database objects and the consistency of data during use.

2. A database management system based on an offline ship hybrid system according to claim 1, characterized in that: By collecting and recording each voyage information and working status, the content in the database system is continuously improved to establish a complete and comprehensive database system.

3. The database management system based on the offline state of the ship hybrid system according to claim 1 is characterized by: The main server stores and filters all navigation data according to the real-time channel information required by the ship, and stores the remaining valuable data in the client so that the client can use it in an offline state.

4. The database management system based on the offline state of the ship hybrid system according to claim 1 is characterized by: Relying on a complete and comprehensive database system established by collecting various data, the navigation data is sold.

5. The database management system based on the offline state of the ship hybrid system according to claim 1 is characterized by: The console of the system is used to manage system users and databases, namely, database backup, user addition and deletion, and user password initialization.

6. The database management system based on the offline state of the ship hybrid system according to claim 1 is characterized by: When the ship docks or can connect to the main server through the local area network, the main server sends new data to the client for timely updating.

7. The database management system based on the offline state of the ship hybrid system according to claim 1 is characterized by: The established database tables include work status table, external environment information table, and login table.

8. The database management system based on the offline state of the ship hybrid system according to claim 1 is characterized by: The inquiry desk software used by users has an operation interface, and the main window is used to complete all operations and contains a help button that can help users solve problems.

9. The database management system based on the offline state of the ship hybrid system according to claim 1 is characterized by: The operation and maintenance of the system includes maintaining the security and integrity of the database and timely backing up the data stored in the main server, while monitoring and continuously improving the database operation performance.

10. The database management system based on the offline state of the ship hybrid system according to claim 1, characterized in that: The Oracle database software used in the system has two database backup methods: one is cold backup, that is, when the database is closed, the key files are copied to another location; the other is hot backup, that is, when the database is running, the database is backed up in archive log mode.

11. The database management system based on the offline state of the ship hybrid system according to claim 1, characterized in that: In the process of optimizing the performance of Oracle database, a mechanism may be used to ensure the stability of database objects and the consistency of data during use, and the mechanism includes latches and locks.

Citation Information

Patent Citations

  • Front-end visible ship hybrid power system equipped with database

    CN118343283A