Streaming media transmission method and system based on security isolation device

Abstract

The invention discloses a streaming media transmission method and system based on a security isolation device. The method comprises the following steps: connecting an intranet database through the security isolation device; obtaining a streaming media identity identifier in a request information table of the intranet database; converting the streaming media identity into an intranet real streaming media address, accessing the intranet real streaming media address and caching the streaming media information; and forwarding the cached streaming media information to an external network client. By using the security isolation device and the streaming media transmission technology, the problem that the streaming media service cannot be directly accessed in a cross-network environment is solved.

Description

Technical Field

[0001] The present invention relates to the technical field of streaming media transmission, and in particular to a streaming media transmission method and system based on a safety isolation device. Background Art

[0002] In recent years, the power system has attached increasing importance to the accumulation of knowledge and the construction of knowledge bases. However, the internal LAN environment limits the efficiency and convenience of knowledge sharing, especially in today's highly popular mobile devices. More and more users want to access the knowledge base and the video materials therein through their mobile phones at any time and any place. In this case, network isolation has become the biggest obstacle. To solve this problem, the power system provides security isolation devices for external network products to solve the problem of accessing the database through network barriers, but it still faces the challenge of not being able to directly request streaming media services.

[0003] Therefore, there is an urgent need for a technical component that can integrate the characteristics of secure isolation devices and the advantages of streaming media transmission to achieve a streaming video playback experience that spans the network and is imperceptible to users. Summary of the invention

[0004] In order to solve the problems in the prior art that the internal local area network of the power system limits the efficiency and convenience of knowledge sharing, the knowledge base and the video materials therein cannot be accessed through a mobile phone, and the streaming media service cannot be directly requested, the present invention provides a streaming media transmission method and system based on a safety isolation device.

[0005] The technical solution provided by the present invention is:

[0006] Connect to the intranet database through a secure isolation device;

[0007] Obtaining a streaming media identity in a request information table of the intranet database;

[0008] Convert the streaming media identity to a real streaming media address in the intranet, access the real streaming media address in the intranet and cache the streaming media information;

[0009] Forward the cached streaming media information to the external network client.

[0010] Preferably, the step of obtaining the streaming media identity in the request information table of the intranet database includes:

[0011] If the corresponding streaming media identifier exists in the request information table in the intranet database, the request address is used as a query condition to obtain the streaming media identity identifier in the intranet database;

[0012] If the corresponding streaming media identifier does not exist in the request information table in the intranet database, the request address related information is stored in the request information table and the stored streaming media identity identifier is obtained.

[0013] Preferably, after converting the streaming media identity identifier into an intranet real streaming media address, accessing the intranet real streaming media address and caching the streaming media information, and before the forwarding component forwards the cached streaming media information to the external network client, the method further includes:

[0014] After accessing the real streaming media address of the intranet for the first time, if the real streaming media address provider responds that it supports breakpoint resuming, the request is actively interrupted, and the returned streaming media basic information is stored in the request information table, and then the video clips are requested again in batches;

[0015] The basic information of the streaming media includes at least one or more of the following: the total size of the streaming media and whether breakpoint resume is supported.

[0016] Preferably, requesting video clips in batches includes:

[0017] If the external client request header does not contain the Range keyword, add the Accept-Ranges keyword to the HTTP response header and return it;

[0018] When receiving the external client request again, the video clip is obtained from the internal database according to the interval specified by the Range keyword in the request header and returned.

[0019] Preferably, after converting the streaming media identity identifier into an intranet real streaming media address, accessing the intranet real streaming media address and caching the streaming media information, and before the forwarding component forwards the cached streaming media information to the external network client, the method further includes:

[0020] If a video segment jumps in the queue during the caching of streaming media information, after the queue-jumping information is monitored, the video segment that needs to be cached first and the subsequent video segments are moved forward to the head of the cache queue;

[0021] The queue cutting refers to lowering the priority values ​​of all caches before a specific video segment, and the operation method is to move the video segments with low priority values ​​to the end of the queue as a whole.

[0022] Preferably, the safety isolation device adopts SG-JDBC database driver.

[0023] Preferably, the streaming media identity is a digital sequence string generated using a snowflake algorithm.

[0024] Preferably, the monitoring is implemented by using a trigger of an intranet database or by timing querying table data.

[0025] Based on the same inventive concept, the present invention also provides a streaming media transmission system based on a security isolation device, comprising: a connection module, a streaming media identity acquisition module, a cache module and a forwarding module;

[0026] The connection module is used to connect to the intranet database through the safety isolation device;

[0027] The streaming media identity acquisition module is used to acquire the streaming media identity in the request information table of the intranet database;

[0028] The cache module is used to convert the streaming media identity into a real streaming media address in the intranet, access the real streaming media address in the intranet and cache the streaming media information;

[0029] The forwarding module is used to forward the cached streaming media information to the external network client.

[0030] Preferably, the module for obtaining a streaming media identity is specifically used for:

[0031] If the corresponding streaming media identifier exists in the request information table in the intranet database, the request address is used as a query condition to obtain the streaming media identity identifier in the intranet database;

[0032] If the corresponding streaming media identifier does not exist in the request information table in the intranet database, the request address related information is stored in the request information table and the stored streaming media identity identifier is obtained.

[0033] Preferably, the system further comprises a breakpoint resume module, the breakpoint resume module being used for, after the real streaming media address of the intranet is accessed for the first time, after the real streaming media address of the intranet is accessed, after the real streaming media address of the intranet is accessed and the streaming media information is cached, and before the forwarding component forwards the cached streaming media information to the external network client, if the real streaming media address provider responds that breakpoint resume is supported, actively interrupting the request, storing the returned streaming media basic information in the request information table, and then re-requesting the video clips in batches;

[0034] The basic information of the streaming media includes at least one or more of the following: the total size of the streaming media and whether breakpoint resume is supported.

[0035] Preferably, the requesting video clips in batches in the breakpoint resuming module includes:

[0036] If the external client request header does not contain the Range keyword, add the Accept-Ranges keyword to the HTTP response header and return it;

[0037] When receiving the external client request again, the video clip is obtained from the internal database according to the interval specified by the Range keyword in the request header and returned.

[0038] Preferably, the system further comprises a queue-jumping module, which is used for, after converting the streaming media identity identifier into an intranet real streaming media address, accessing the intranet real streaming media address and caching the streaming media information, and before the forwarding component forwards the cached streaming media information to the external network client, if a video segment is queued up during the caching of the streaming media information, after monitoring the queue-jumping information, moving the video segment that needs to be cached first and the subsequent video segment forward to the head of the cache queue together;

[0039] The queue cutting refers to lowering the priority values ​​of all caches before a specific video segment, and the operation method is to move the video segments with low priority values ​​to the end of the queue as a whole.

[0040] Preferably, the safety isolation device in the connection module adopts SG-JDBC database driver.

[0041] Preferably, the streaming media identity in the module for obtaining the streaming media identity is a digital sequence string generated by a snowflake algorithm.

[0042] Preferably, the monitoring in the queue-jumping module is implemented by using triggers of an intranet database and timing query table data.

[0043] Compared with the prior art, the present invention has the following beneficial effects:

[0044] The present invention provides a streaming media transmission method and system based on a security isolation device, comprising: connecting to an intranet database through a security isolation device; obtaining a streaming media identity in a request information table of the intranet database; converting the streaming media identity into a real streaming media address of the intranet, accessing the real streaming media address of the intranet and caching the streaming media information; forwarding the cached streaming media information to an external network client. The present invention solves the problem of being unable to directly access streaming media services in a cross-network environment by using a security isolation device, streaming media transmission technology and file segmentation storage technology. BRIEF DESCRIPTION OF THE DRAWINGS

[0045] Figure 1 It is a flow chart of the streaming media transmission method based on the security isolation device of the present invention;

[0046] Figure 2 It is an isolation device architecture diagram of the streaming media transmission method based on the security isolation device of the present invention;

[0047] Figure 3 It is a schematic flow chart of the main steps of the streaming media transmission method based on the safety isolation device of the present invention;

[0048] Figure 4 It is a timing diagram of the streaming media transmission method and system based on the safety isolation device of the present invention;

[0049] Figure 5 It is a schematic diagram of a streaming media transmission system based on a safety isolation device of the present invention.

[0050] Figure 6 This is a principle architecture diagram of the streaming media transmission method and system based on the security isolation device of the present invention; DETAILED DESCRIPTION

[0051] The specific implementation modes of the present invention are further described in detail below with reference to the accompanying drawings.

[0052] Example 1

[0053] The present invention proposes a streaming media transmission method based on a safety isolation device, the flow chart is as follows Figure 1 As shown, including:

[0054] S1. Connect to the intranet database through a security isolation device;

[0055] S2, obtaining a streaming media identity in the request information table of the intranet database;

[0056] S3, converting the streaming media identity into a real streaming media address in the intranet, accessing the real streaming media address in the intranet and caching the streaming media information;

[0057] S4. Forward the cached streaming media information to the external network client.

[0058] In step S1, a special security isolation device (such as an SQL proxy isolation device) is used to allow the external network business system to access the internal network database under the dual network isolation condition, thereby solving the problem of being unable to directly access the streaming media service in a cross-network environment. The streaming media transmission method based on the security isolation device includes receiving requests, connecting to the database, obtaining or updating streaming media information, calculating and managing video clip download tasks, and processing user specific requests (such as fast forward). The security isolation device adopts SG-JDBC database driver, such as Figure 2As shown, the SQL proxy isolation device architecture consists of three parts: the device, the management software client, and the SG-JDBC driver. The device receives SQL requests from external network business applications to access the database through the external network processing unit, performs necessary security checks and SQL statement reconstruction according to the set rules, and then sends the request to the real database server in the internal network through the built-in corresponding database driver and the internal network processing unit, and finally sends the access response result to the external network business application. The SQL proxy isolation device is a database server relative to the application server. On the application server, the SQL proxy server's JDBC (Java Database Connection) driver is needed to communicate with the SQL proxy server.

[0059] Step S2 specifically includes: using the request address as a query condition to obtain the corresponding streaming media ID in the request information table of the database; if such information does not exist, storing the request address and other related information in the request information table and obtaining the stored streaming media ID.

[0060] Step S3 specifically includes: receiving a client request through a front-end service, interacting with an intranet database to obtain or store streaming media information, and processing an actual video stream download task through a back-end service.

[0061] Listen to the request information table for new data insertion, read the data and convert it into the real streaming address of the intranet, request the address once, obtain the streaming status, file size and other information, and then update the data in the request information table. Then calculate the start and end index of each piece according to the actual video volume information, and generate the default cache task from front to back. Finally, access the streaming address and cache the streaming information, and store it in the media cache table, with the foreign key being the streaming ID.

[0062] If the streaming media ID data in the request information table is updated to an available state, the Accept-Ranges keyword is added to the response header and returned.

[0063] The request is received again, and the request header contains the Range keyword. The corresponding segment is obtained from the media cache table of the database according to the request range and returned. At the same time, the status code is set to 206 in the response header, as well as the index start and end coordinates of the segment, the length of this segment, and the total length. Segment storage stores the video stream segments obtained from the third-party streaming service in the database to support breakpoint resuming and efficient management of video segments.

[0064] In the previous step, if the video segment cannot be obtained in the first query, a queue interruption information containing the streaming media ID, segment range, etc. will be inserted into the queue table, and then the media cache table will be queried continuously until the video segment is obtained.

[0065] When queue-jumping information is detected, the cache task order will be adjusted immediately, and the fragment tasks that need to be cached first and subsequent tasks will be moved forward to the head of the queue.

[0066] Continue to transmit multimedia data to the requesting end until all content output is completed.

[0067] In this step, the streaming media ID uses a digital sequence string generated by a snowflake algorithm.

[0068] In this step, the monitoring is implemented by using a trigger of a database and a timed query table data.

[0069] In this step, the address is requested once, and the data in the request information table is updated after obtaining the available status of the streaming media, the file size and other information. The HttpClient is used to request the target address, and the cache is stopped immediately after the basic information is obtained.

[0070] In this step, the start and end indexes of each segment are calculated based on the actual video volume information, where the maximum length of a single segment is 1024*1024*3 bytes, and the calculated cache queue

[0071] [[0,3145727],[3145728,6291455],[6291456,9437183]...], and then bind this queue and streaming media ID and put them into system memory.

[0072] In this step, the caching means obtaining the first piece of data from the head of the cache queue, and then requesting the streaming media segment data of this range from the target system.

[0073] In this step, queue jumping refers to lowering the priority values ​​of all caches before the target segment. The operation method is to move the cache plans with low priority values ​​to the end of the queue as a whole, so as to provide a better experience for fast forwarding and skipping. In response to user operations such as fast forwarding, the intranet service can adjust the download order and give priority to downloading the content required by the user to ensure smooth playback.

[0074] To sum up, the main steps of the whole process are as follows: Figure 3 As shown in the timing diagram, Figure 4 shown.

[0075] Example 2

[0076] The present invention based on the same inventive concept also provides a streaming media transmission system based on a safety isolation device, the schematic diagram of the system is shown in FIG. Figure 5 As shown, it includes: a connection module, a streaming media identity acquisition module, a cache module and a forwarding module;

[0077] The connection module is used to connect to the intranet database through the safety isolation device;

[0078] The streaming media identity acquisition module is used to acquire the streaming media identity in the request information table of the intranet database;

[0079] The cache module is used to convert the streaming media identity into a real streaming media address in the intranet, access the real streaming media address in the intranet and cache the streaming media information;

[0080] The forwarding module is used to forward the cached streaming media information to the external network client.

[0081] Preferably, the module for obtaining a streaming media identity is specifically used for:

[0082] If the corresponding streaming media identifier exists in the request information table in the intranet database, the request address is used as a query condition to obtain the streaming media identity identifier in the intranet database;

[0083] If the corresponding streaming media identifier does not exist in the request information table in the intranet database, the request address related information is stored in the request information table and the stored streaming media identity identifier is obtained.

[0084] Preferably, the system further comprises a breakpoint resume module, the breakpoint resume module being used for, after the real streaming media address of the intranet is accessed for the first time, after the real streaming media address of the intranet is accessed, after the real streaming media address of the intranet is accessed and the streaming media information is cached, and before the forwarding component forwards the cached streaming media information to the external network client, if the real streaming media address provider responds that breakpoint resume is supported, actively interrupting the request, storing the returned streaming media basic information in the request information table, and then re-requesting the video clips in batches;

[0085] The basic information of the streaming media includes at least one or more of the following: the total size of the streaming media and whether breakpoint resume is supported.

[0086] Preferably, the requesting video clips in batches in the breakpoint resuming module includes:

[0087] If the external client request header does not contain the Range keyword, add the Accept-Ranges keyword to the HTTP response header and return it;

[0088] When receiving the external client request again, the video clip is obtained from the internal database according to the interval specified by the Range keyword in the request header and returned.

[0089] Preferably, the system further comprises a queue-jumping module, which is used for, after converting the streaming media identity identifier into an intranet real streaming media address, accessing the intranet real streaming media address and caching the streaming media information, and before the forwarding component forwards the cached streaming media information to the external network client, if a video segment is queued up during the caching of the streaming media information, after monitoring the queue-jumping information, moving the video segment that needs to be cached first and the subsequent video segment forward to the head of the cache queue together;

[0090] The queue cutting refers to lowering the priority values ​​of all caches before a specific video segment, and the operation method is to move the video segments with low priority values ​​to the end of the queue as a whole.

[0091] Preferably, the safety isolation device in the connection module adopts SG-JDBC database driver.

[0092] Preferably, the streaming media identity in the module for obtaining the streaming media identity is a digital sequence string generated by a snowflake algorithm.

[0093] Preferably, the monitoring in the queue-jumping module is implemented by using triggers of an intranet database and timing query table data.

[0094] Example 3

[0095] In a specific application scenario of a streaming media transmission method based on a security isolation device provided by the present invention, a system consisting of an external network subsystem, an internal network subsystem and an optional monitoring subsystem is used to implement the above method. The external network subsystem is responsible for communicating with the client, the internal network subsystem is responsible for video loading and management, and the monitoring subsystem ensures timely response to newly inserted data. The principle architecture diagram is shown in FIG. Figure 6 As shown, including:

[0096] The external network subsystem is deployed in the Internet area and needs to communicate with the database through an isolation device; it includes request parsing, querying basic information, adding new request information, querying fragmentation information, adding queue-jumping information and fragment processing functions.

[0097] The intranet subsystem is deployed in the management information area. It can directly connect to the database or directly access the third-party video service address. It includes preloading, video loading, creating download tasks, adjusting download order, video clip downloading and storage, and scheduled cleanup functions.

[0098] The monitoring subsystem is optional. When the actual deployment environment cannot use the trigger function of the table, this subsystem can be used to implement data insertion monitoring. The specific operation is to read the table continuously and request the relevant interface when new data is found.

[0099] In summary, the present invention provides a method and system for streaming media transmission based on a security isolation device, comprising: connecting to an intranet database through a security isolation device; obtaining a streaming media identity in a request information table of the intranet database; converting the streaming media identity into an intranet real streaming media address, accessing the intranet real streaming media address and caching the streaming media information; and forwarding the cached streaming media information to an external network client. The present invention solves the problem of being unable to directly access streaming media services in a cross-network environment by using a security isolation device and streaming media transmission technology.

[0100] Those skilled in the art will appreciate that embodiments of the present invention may be provided as methods, systems, or computer program products. Therefore, the present invention may take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware. Moreover, the present invention may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0101] The present invention is described with reference to flowcharts and / or block diagrams of methods, devices (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and / or block in the flowchart and / or block diagram, as well as the combination of processes and / or blocks in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0102] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0103] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process. Figure 1 A process or multiple processes and / or boxes Figure 1The steps for the functions specified in one or more boxes.

[0104] The above are merely embodiments of the present invention and are not intended to limit the present invention. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present invention are included in the scope of the claims of the present invention to be approved.

Claims

1. A streaming media transmission method based on a security isolation device, characterized in that: include: Connect to the intranet database through a secure isolation device; Obtaining a streaming media identity in a request information table of the intranet database; Convert the streaming media identity to a real streaming media address in the intranet, access the real streaming media address in the intranet and cache the streaming media information; Forward the cached streaming media information to the external network client.

2. The method according to claim 1, characterized in that The step of obtaining the streaming media identity in the request information table of the intranet database includes: If the corresponding streaming media identifier exists in the request information table in the intranet database, the request address is used as a query condition to obtain the streaming media identity identifier in the intranet database; If the corresponding streaming media identifier does not exist in the request information table in the intranet database, the request address related information is stored in the request information table and the stored streaming media identity identifier is obtained.

3. The method according to claim 1, characterized in that After converting the streaming media identity identifier into an intranet real streaming media address, accessing the intranet real streaming media address and caching the streaming media information, and before the forwarding component forwards the cached streaming media information to the external network client, the method further includes: After accessing the real streaming media address of the intranet for the first time, if the real streaming media address provider responds that it supports breakpoint resuming, the request is actively interrupted, and the returned streaming media basic information is stored in the request information table, and then the video clips are requested again in batches; The basic information of the streaming media includes at least one or more of the following: the total size of the streaming media and whether breakpoint resume is supported.

4. The method according to claim 3, characterized in that The step of requesting video clips in batches includes: If the external client request header does not contain the Range keyword, add the Accept-Ranges keyword to the HTTP response header and return it; When receiving the external client request again, the video clip is obtained from the internal database according to the interval specified by the Range keyword in the request header and returned.

5. The method according to claim 1, characterized in that After converting the streaming media identity identifier into an intranet real streaming media address, accessing the intranet real streaming media address and caching the streaming media information, and before the forwarding component forwards the cached streaming media information to the external network client, the method further includes: If a video segment jumps in the queue during the caching of streaming media information, after the queue-jumping information is monitored, the video segment that needs to be cached first and the subsequent video segments are moved forward to the head of the cache queue; The queue cutting refers to lowering the priority values ​​of all caches before a specific video segment, and the operation method is to move the video segments with low priority values ​​to the end of the queue as a whole.

6. The method according to claim 1, characterized in that The safety isolation device is driven by the SG-JDBC database.

7. The method according to claim 1, characterized in that The streaming media identity is a digital sequence string generated by a snowflake algorithm.

8. The method according to claim 5, characterized in that The monitoring is implemented by using a trigger of an intranet database or by timing querying table data.

9. A streaming media transmission system based on a safety isolation device, characterized in that: include: Connection module, streaming media identity acquisition module, cache module and forwarding module; The connection module is used to connect to the intranet database through the safety isolation device; The streaming media identity acquisition module is used to acquire the streaming media identity in the request information table of the intranet database; The cache module is used to convert the streaming media identity into a real streaming media address in the intranet, access the real streaming media address in the intranet and cache the streaming media information; The forwarding module is used to forward the cached streaming media information to the external network client.

10. The system according to claim 9, characterized in that The module for obtaining a streaming media identity is specifically used for: If the corresponding streaming media identifier exists in the request information table in the intranet database, the request address is used as a query condition to obtain the streaming media identity identifier in the intranet database; If the corresponding streaming media identifier does not exist in the request information table in the intranet database, the request address related information is stored in the request information table and the stored streaming media identity identifier is obtained.

Images