CN110457181A - A kind of the log method for optimization analysis and device of database - Google Patents
A kind of the log method for optimization analysis and device of database Download PDFInfo
- Publication number
- CN110457181A CN110457181A CN201910713092.0A CN201910713092A CN110457181A CN 110457181 A CN110457181 A CN 110457181A CN 201910713092 A CN201910713092 A CN 201910713092A CN 110457181 A CN110457181 A CN 110457181A
- Authority
- CN
- China
- Prior art keywords
- log
- database
- thread
- plug
- captures
- 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.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/3003—Monitoring arrangements specially adapted to the computing system or computing system component being monitored
- G06F11/302—Monitoring arrangements specially adapted to the computing system or computing system component being monitored where the computing system component is a software system
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/3051—Monitoring arrangements for monitoring the configuration of the computing system or of the computing system component, e.g. monitoring the presence of processing resources, peripherals, I/O links, software programs
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/3065—Monitoring arrangements determined by the means or processing involved in reporting the monitored data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/18—File system types
- G06F16/1805—Append-only file systems, e.g. using logs or journals to store data
- G06F16/1815—Journaling file systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Abstract
Description
Claims (7)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910713092.0A CN110457181B (en) | 2019-08-02 | 2019-08-02 | Log optimization analysis method and device for database |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910713092.0A CN110457181B (en) | 2019-08-02 | 2019-08-02 | Log optimization analysis method and device for database |
Publications (2)
Publication Number | Publication Date |
---|---|
CN110457181A true CN110457181A (en) | 2019-11-15 |
CN110457181B CN110457181B (en) | 2023-05-16 |
Family
ID=68484788
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910713092.0A Active CN110457181B (en) | 2019-08-02 | 2019-08-02 | Log optimization analysis method and device for database |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110457181B (en) |
Citations (15)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103678718A (en) * | 2013-12-31 | 2014-03-26 | 金蝶软件(中国)有限公司 | Database synchronization method and system |
CN106415536A (en) * | 2014-03-10 | 2017-02-15 | 甲骨文国际公司 | Instantaneous unplug of pluggable database from one container database and plug into another container database |
US20170116321A1 (en) * | 2015-10-23 | 2017-04-27 | Oracle International Corporation | Ability to group multiple container databases as a single container database cluster |
US20170116278A1 (en) * | 2015-10-23 | 2017-04-27 | Oracle International Corporation | Implementing a logically partitioned data warehouse using a container map |
US20170220271A1 (en) * | 2012-09-28 | 2017-08-03 | Oracle International Corporation | Thread groups for pluggable database connection consolidation in numa environment |
CN107357883A (en) * | 2017-06-30 | 2017-11-17 | 北京奇虎科技有限公司 | Data migration method and device |
CN107391720A (en) * | 2017-07-31 | 2017-11-24 | 郑州云海信息技术有限公司 | A kind of data summarization method and device |
US20180048717A1 (en) * | 2016-08-12 | 2018-02-15 | Oracle International Corporation | System and method for supporting live addition of a tenant in a connection pool environment |
CN107766408A (en) * | 2017-08-31 | 2018-03-06 | 西安交大捷普网络科技有限公司 | The storage method of audit log |
CN107918621A (en) * | 2016-10-10 | 2018-04-17 | 阿里巴巴集团控股有限公司 | Daily record data processing method, device and operation system |
CN108255623A (en) * | 2018-01-22 | 2018-07-06 | 深圳市卓讯信息技术有限公司 | Realize the data exchange monitoring method and device of thread inside and outside dual reconciliation mechanism |
CN109241174A (en) * | 2018-06-26 | 2019-01-18 | 东软集团股份有限公司 | Method of data synchronization, device, readable storage medium storing program for executing and electronic equipment |
CN109271448A (en) * | 2018-09-25 | 2019-01-25 | 武汉达梦数据库有限公司 | It is the data synchronous system and method for platform based on database |
CN109656934A (en) * | 2018-11-19 | 2019-04-19 | 武汉达梦数据库有限公司 | Source oracle database DDL synchronous method and equipment based on log parsing |
CN110019498A (en) * | 2017-08-14 | 2019-07-16 | 北京京东尚科信息技术有限公司 | Log synchronous method and device, storage medium, electronic equipment |
-
2019
- 2019-08-02 CN CN201910713092.0A patent/CN110457181B/en active Active
Patent Citations (15)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20170220271A1 (en) * | 2012-09-28 | 2017-08-03 | Oracle International Corporation | Thread groups for pluggable database connection consolidation in numa environment |
CN103678718A (en) * | 2013-12-31 | 2014-03-26 | 金蝶软件(中国)有限公司 | Database synchronization method and system |
CN106415536A (en) * | 2014-03-10 | 2017-02-15 | 甲骨文国际公司 | Instantaneous unplug of pluggable database from one container database and plug into another container database |
US20170116321A1 (en) * | 2015-10-23 | 2017-04-27 | Oracle International Corporation | Ability to group multiple container databases as a single container database cluster |
US20170116278A1 (en) * | 2015-10-23 | 2017-04-27 | Oracle International Corporation | Implementing a logically partitioned data warehouse using a container map |
US20180048717A1 (en) * | 2016-08-12 | 2018-02-15 | Oracle International Corporation | System and method for supporting live addition of a tenant in a connection pool environment |
CN107918621A (en) * | 2016-10-10 | 2018-04-17 | 阿里巴巴集团控股有限公司 | Daily record data processing method, device and operation system |
CN107357883A (en) * | 2017-06-30 | 2017-11-17 | 北京奇虎科技有限公司 | Data migration method and device |
CN107391720A (en) * | 2017-07-31 | 2017-11-24 | 郑州云海信息技术有限公司 | A kind of data summarization method and device |
CN110019498A (en) * | 2017-08-14 | 2019-07-16 | 北京京东尚科信息技术有限公司 | Log synchronous method and device, storage medium, electronic equipment |
CN107766408A (en) * | 2017-08-31 | 2018-03-06 | 西安交大捷普网络科技有限公司 | The storage method of audit log |
CN108255623A (en) * | 2018-01-22 | 2018-07-06 | 深圳市卓讯信息技术有限公司 | Realize the data exchange monitoring method and device of thread inside and outside dual reconciliation mechanism |
CN109241174A (en) * | 2018-06-26 | 2019-01-18 | 东软集团股份有限公司 | Method of data synchronization, device, readable storage medium storing program for executing and electronic equipment |
CN109271448A (en) * | 2018-09-25 | 2019-01-25 | 武汉达梦数据库有限公司 | It is the data synchronous system and method for platform based on database |
CN109656934A (en) * | 2018-11-19 | 2019-04-19 | 武汉达梦数据库有限公司 | Source oracle database DDL synchronous method and equipment based on log parsing |
Non-Patent Citations (1)
Title |
---|
杨永娇: "电网EM平台可插拔式PDB数据库资源池优化设计", 《自动化与仪器仪表》 * |
Also Published As
Publication number | Publication date |
---|---|
CN110457181B (en) | 2023-05-16 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN109739929B (en) | Data synchronization method, device and system | |
CN108536761B (en) | Report data query method and server | |
CN110188096B (en) | Index creating method, device and equipment for data record | |
CN110162526B (en) | Method, device and equipment for inquiring data records in block chain type account book | |
CN110046168B (en) | Incremental data consistency implementation method and device | |
US20110113117A1 (en) | Asynchronous Collection and Correlation of Trace and Communications Event Data | |
CN111125260A (en) | Data synchronization method and system based on SQL Server | |
US8880463B2 (en) | Standardized framework for reporting archived legacy system data | |
CN107977396B (en) | Method and device for updating data table of KeyValue database | |
CN103559217A (en) | Heterogeneous database oriented massive multicast data storage implementation method | |
CN111125214A (en) | Lightweight incremental data synchronization method and device and computer readable medium | |
CN112395157B (en) | Audit log acquisition method and device, computer equipment and storage medium | |
CN107992492B (en) | Data block storage method, data block reading method, data block storage device, data block reading device and block chain | |
CN111241177B (en) | Data acquisition method, system and network equipment | |
WO2021012868A1 (en) | Transaction rollback method and apparatus, database, system, and computer storage medium | |
CN112825069A (en) | Method, device and system for analyzing database data and storage medium | |
CN111831755B (en) | Cross-database data synchronization method, system, medium and device | |
US20180276267A1 (en) | Methods and system for efficiently performing eventual and transactional edits on distributed metadata in an object storage system | |
CN115858488A (en) | Parallel migration method and device based on data governance and readable medium | |
CN111753015B (en) | Data query method and device of payment clearing system | |
CN113760922A (en) | Service data processing system, method, server and storage medium | |
CN112527411A (en) | Real-time data visualization system based on plug-in and topic subscription mode | |
CN111581227A (en) | Event pushing method and device, computer equipment and storage medium | |
CN110457181A (en) | A kind of the log method for optimization analysis and device of database | |
CN115344633A (en) | Data processing method, device, equipment and storage medium |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
CB02 | Change of applicant information | ||
CB02 | Change of applicant information |
Address after: 430000 16-19 / F, building C3, future technology building, 999 Gaoxin Avenue, Donghu New Technology Development Zone, Wuhan, Hubei Province Applicant after: Wuhan dream database Co.,Ltd. Address before: 430000 16-19 / F, building C3, future technology building, 999 Gaoxin Avenue, Donghu New Technology Development Zone, Wuhan, Hubei Province Applicant before: WUHAN DAMENG DATABASE Co.,Ltd. |
|
CB03 | Change of inventor or designer information | ||
CB03 | Change of inventor or designer information |
Inventor after: Sun Feng Inventor after: Chen Yan Inventor after: Peng Qingsong Inventor after: Liu Qichun Inventor before: Sun Feng Inventor before: Fu Quan Inventor before: Chen Yan Inventor before: Peng Qingsong Inventor before: Liu Qichun |
|
GR01 | Patent grant | ||
GR01 | Patent grant |