CN110457181B - 一种数据库的日志优化分析方法及装置 - Google Patents
一种数据库的日志优化分析方法及装置 Download PDFInfo
- Publication number
- CN110457181B CN110457181B CN201910713092.0A CN201910713092A CN110457181B CN 110457181 B CN110457181 B CN 110457181B CN 201910713092 A CN201910713092 A CN 201910713092A CN 110457181 B CN110457181 B CN 110457181B
- Authority
- CN
- China
- Prior art keywords
- log
- database
- capturing
- optimization analysis
- archive
- 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
Images
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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Quality & Reliability (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Debugging And Monitoring (AREA)
Abstract
Description
Claims (7)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910713092.0A CN110457181B (zh) | 2019-08-02 | 2019-08-02 | 一种数据库的日志优化分析方法及装置 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910713092.0A CN110457181B (zh) | 2019-08-02 | 2019-08-02 | 一种数据库的日志优化分析方法及装置 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN110457181A CN110457181A (zh) | 2019-11-15 |
CN110457181B true CN110457181B (zh) | 2023-05-16 |
Family
ID=68484788
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910713092.0A Active CN110457181B (zh) | 2019-08-02 | 2019-08-02 | 一种数据库的日志优化分析方法及装置 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110457181B (zh) |
Citations (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103678718A (zh) * | 2013-12-31 | 2014-03-26 | 金蝶软件(中国)有限公司 | 数据库同步方法及*** |
CN106415536A (zh) * | 2014-03-10 | 2017-02-15 | 甲骨文国际公司 | 可插拔数据库从一个容器数据库的即时拔出以及到另一个容器数据库中的*** |
CN107357883A (zh) * | 2017-06-30 | 2017-11-17 | 北京奇虎科技有限公司 | 数据迁移方法及装置 |
CN107391720A (zh) * | 2017-07-31 | 2017-11-24 | 郑州云海信息技术有限公司 | 一种数据汇总方法及装置 |
CN107766408A (zh) * | 2017-08-31 | 2018-03-06 | 西安交大捷普网络科技有限公司 | 审计日志的存储方法 |
CN107918621A (zh) * | 2016-10-10 | 2018-04-17 | 阿里巴巴集团控股有限公司 | 日志数据处理方法、装置及业务*** |
CN108255623A (zh) * | 2018-01-22 | 2018-07-06 | 深圳市卓讯信息技术有限公司 | 实现线程内外双重对账机制的数据交换监控方法及装置 |
CN109241174A (zh) * | 2018-06-26 | 2019-01-18 | 东软集团股份有限公司 | 数据同步方法、装置、可读存储介质和电子设备 |
CN109271448A (zh) * | 2018-09-25 | 2019-01-25 | 武汉达梦数据库有限公司 | 基于数据库为平台的数据同步***及方法 |
CN109656934A (zh) * | 2018-11-19 | 2019-04-19 | 武汉达梦数据库有限公司 | 基于日志解析的源端Oracle数据库DDL同步方法及设备 |
CN110019498A (zh) * | 2017-08-14 | 2019-07-16 | 北京京东尚科信息技术有限公司 | 日志同步方法及装置、存储介质、电子设备 |
Family Cites Families (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US9239763B2 (en) * | 2012-09-28 | 2016-01-19 | Oracle International Corporation | Container database |
WO2017070580A1 (en) * | 2015-10-23 | 2017-04-27 | Oracle International Corporation | Ability to group multiple container databases as a single container database cluster |
EP3365808B1 (en) * | 2015-10-23 | 2021-08-25 | Oracle International Corporation | Proxy databases |
US10742748B2 (en) * | 2016-08-12 | 2020-08-11 | Oracle International Corporation | System and method for supporting live addition of a tenant in a connection pool environment |
-
2019
- 2019-08-02 CN CN201910713092.0A patent/CN110457181B/zh active Active
Patent Citations (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103678718A (zh) * | 2013-12-31 | 2014-03-26 | 金蝶软件(中国)有限公司 | 数据库同步方法及*** |
CN106415536A (zh) * | 2014-03-10 | 2017-02-15 | 甲骨文国际公司 | 可插拔数据库从一个容器数据库的即时拔出以及到另一个容器数据库中的*** |
CN107918621A (zh) * | 2016-10-10 | 2018-04-17 | 阿里巴巴集团控股有限公司 | 日志数据处理方法、装置及业务*** |
CN107357883A (zh) * | 2017-06-30 | 2017-11-17 | 北京奇虎科技有限公司 | 数据迁移方法及装置 |
CN107391720A (zh) * | 2017-07-31 | 2017-11-24 | 郑州云海信息技术有限公司 | 一种数据汇总方法及装置 |
CN110019498A (zh) * | 2017-08-14 | 2019-07-16 | 北京京东尚科信息技术有限公司 | 日志同步方法及装置、存储介质、电子设备 |
CN107766408A (zh) * | 2017-08-31 | 2018-03-06 | 西安交大捷普网络科技有限公司 | 审计日志的存储方法 |
CN108255623A (zh) * | 2018-01-22 | 2018-07-06 | 深圳市卓讯信息技术有限公司 | 实现线程内外双重对账机制的数据交换监控方法及装置 |
CN109241174A (zh) * | 2018-06-26 | 2019-01-18 | 东软集团股份有限公司 | 数据同步方法、装置、可读存储介质和电子设备 |
CN109271448A (zh) * | 2018-09-25 | 2019-01-25 | 武汉达梦数据库有限公司 | 基于数据库为平台的数据同步***及方法 |
CN109656934A (zh) * | 2018-11-19 | 2019-04-19 | 武汉达梦数据库有限公司 | 基于日志解析的源端Oracle数据库DDL同步方法及设备 |
Non-Patent Citations (1)
Title |
---|
电网EM平台可插拔式PDB数据库资源池优化设计;杨永娇;《自动化与仪器仪表》;20190731;全文 * |
Also Published As
Publication number | Publication date |
---|---|
CN110457181A (zh) | 2019-11-15 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN108170768B (zh) | 数据库同步方法、装置及可读介质 | |
CN109460349B (zh) | 一种基于日志的测试用例生成方法和装置 | |
US9953102B2 (en) | Creating NoSQL database index for semi-structured data | |
CN101719149B (zh) | 数据同步方法及装置 | |
EP1540527B1 (en) | Method and system for moving data objects using locks | |
CN103019890B (zh) | 一种块级别的磁盘数据保护***及其方法 | |
CN110879813A (zh) | 一种基于二进制日志解析的MySQL数据库增量同步实现方法 | |
CN104376082A (zh) | 一种把数据源文件中的数据导入到数据库中的方法 | |
WO2021012868A1 (zh) | 事务回滚方法及装置、数据库、***、计算机存储介质 | |
CN104699723A (zh) | 数据交换适配器、异构***之间数据同步***和方法 | |
CN111008246A (zh) | 数据库日志同步方法、装置、计算机设备及可读存储介质 | |
CN111753015B (zh) | 支付清算***的数据查询方法及装置 | |
WO2020238860A1 (zh) | 分布式文件批处理方法、装置、与可读存储介质 | |
CN114385760A (zh) | 增量数据实时同步的方法、装置、计算机设备及存储介质 | |
KR20160012388A (ko) | 파일 단위 순서 모드 저널링 기법을 이용한 fsync 시스템 호출 처리 장치 및 방법 | |
EP2904520B1 (en) | Reference data segmentation from single to multiple tables | |
CN108304527B (zh) | 一种数据提取方法 | |
CN110457181B (zh) | 一种数据库的日志优化分析方法及装置 | |
CN113792038A (zh) | 用于存储数据的方法和装置 | |
CN108959497A (zh) | 分布式文件***日志处理方法、装置、设备及存储介质 | |
CN110309206B (zh) | 订单信息采集方法及*** | |
Membrey et al. | A disk based stream oriented approach for storing big data | |
CN102567544A (zh) | 数据库查询方法及装置 | |
CN112148705A (zh) | 数据迁移的方法和装置 | |
CN106802922B (zh) | 一种基于对象的溯源存储***及方法 |
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 |
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. |
|
CB02 | Change of applicant 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 |
|
CB03 | Change of inventor or designer information | ||
GR01 | Patent grant | ||
GR01 | Patent grant |