Online transaction log recording method and device based on oracle database

An online transaction and database technology, applied in the field of computer information, can solve the problems of unsuccessful log recording, poor log availability, time-consuming and labor-intensive viewing, etc., to achieve the effect of quick positioning and query, comprehensive records, and no resource bottlenecks

Inactive Publication Date: 2017-03-15
BANK OF CHINA
View PDF4 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] 1. There is a size limit for the text file. If the size of the text file is too large, the subsequent log records will fail. Therefore, the content of the log records is often reduced to avoid the size of the log file being too large, which is not conducive to maintenance.
[0005] 2. Due to the irregular data structure and index, when the log file is large, it may take time and effort to view it or even fail to open it.
[0006] 3. The log will have serial records in multiple instances of the same transaction, resulting in poor log availability

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Online transaction log recording method and device based on oracle database
  • Online transaction log recording method and device based on oracle database
  • Online transaction log recording method and device based on oracle database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0062] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0063] Those skilled in the art know that the embodiments of the present invention can be implemented as a system, device, device, method or computer program product. Therefore, the present disclosure may be embodied in the form of complete hardware, complete software (including firmware, resident software, microcode, etc.), or a combination of hardware and software.

[0064] The principle and spirit of the present invention will be explained in detail below w...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention provides an online transaction log recording method and device based on oracle database, and relates to the technical field of computer information. The method comprises the steps of receiving the online transaction log of an online transaction system, using oracle autonomous things to record the online transaction log in the log table, storing the log table in an oracle database. The log record is independent from the online transaction, and is submitted and enters into effectiveness in a singular manner, thus having no influence on the online transaction. The log record has no resource bottleneck, and has high concurrency. The method and device has the advantages of being complete in record, preserving the primary scene, being regular and orderly in log format, high in monitoring efficiency, being able to fast position and check related logs, being able to replay the input and output conditions of a transaction.

Description

technical field [0001] The present invention relates to the field of computer information technology, in particular to the data processing technology of an open platform, and specifically relates to a recording method and equipment for an online transaction log based on an oracle database. Background technique [0002] This section is intended to provide a background or context for implementations of the invention that are recited in the claims. The descriptions herein are not admitted to be prior art by inclusion in this section. [0003] Most of the online application system logs of open platforms in the prior art (such as minicomputers) are recorded in text form, which mainly has the following disadvantages: [0004] 1. There is a size limit for the text file, and if it is too large, the subsequent log records will fail. Therefore, the content of the log records is often reduced to avoid the log file being too large, which is not conducive to maintenance. [0005] 2. Du...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/2272G06F16/2282
Inventor 李江博
Owner BANK OF CHINA
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap