CN105787098A - 一种Oracle数据库表数据历史轨迹保存方法及系统 - Google Patents
一种Oracle数据库表数据历史轨迹保存方法及系统 Download PDFInfo
- Publication number
- CN105787098A CN105787098A CN201610156477.8A CN201610156477A CN105787098A CN 105787098 A CN105787098 A CN 105787098A CN 201610156477 A CN201610156477 A CN 201610156477A CN 105787098 A CN105787098 A CN 105787098A
- Authority
- CN
- China
- Prior art keywords
- historical track
- time
- data
- batch operation
- historical
- 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
- 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
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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
- G06F16/275—Synchronous replication
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (10)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610156477.8A CN105787098B (zh) | 2016-03-18 | 2016-03-18 | 一种Oracle数据库表数据历史轨迹保存方法及系统 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610156477.8A CN105787098B (zh) | 2016-03-18 | 2016-03-18 | 一种Oracle数据库表数据历史轨迹保存方法及系统 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN105787098A true CN105787098A (zh) | 2016-07-20 |
CN105787098B CN105787098B (zh) | 2019-10-25 |
Family
ID=56393036
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201610156477.8A Active CN105787098B (zh) | 2016-03-18 | 2016-03-18 | 一种Oracle数据库表数据历史轨迹保存方法及系统 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN105787098B (zh) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107346277A (zh) * | 2017-06-29 | 2017-11-14 | 东软集团股份有限公司 | 数据存储方法及装置 |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20060020880A1 (en) * | 2004-07-22 | 2006-01-26 | Yi-Kai Chen | System and method for synchronization of music and images |
CN103714163A (zh) * | 2013-12-30 | 2014-04-09 | 中国科学院信息工程研究所 | 一种NoSQL数据库的模式管理方法及系统 |
CN104778175A (zh) * | 2014-01-13 | 2015-07-15 | 世纪禾光科技发展(北京)有限公司 | 一种实现异构数据库数据同步的方法及系统 |
CN105159793A (zh) * | 2015-08-18 | 2015-12-16 | 上海新炬网络信息技术有限公司 | 基于GoldenGate的数据复制备份方法 |
-
2016
- 2016-03-18 CN CN201610156477.8A patent/CN105787098B/zh active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20060020880A1 (en) * | 2004-07-22 | 2006-01-26 | Yi-Kai Chen | System and method for synchronization of music and images |
CN103714163A (zh) * | 2013-12-30 | 2014-04-09 | 中国科学院信息工程研究所 | 一种NoSQL数据库的模式管理方法及系统 |
CN104778175A (zh) * | 2014-01-13 | 2015-07-15 | 世纪禾光科技发展(北京)有限公司 | 一种实现异构数据库数据同步的方法及系统 |
CN105159793A (zh) * | 2015-08-18 | 2015-12-16 | 上海新炬网络信息技术有限公司 | 基于GoldenGate的数据复制备份方法 |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107346277A (zh) * | 2017-06-29 | 2017-11-14 | 东软集团股份有限公司 | 数据存储方法及装置 |
Also Published As
Publication number | Publication date |
---|---|
CN105787098B (zh) | 2019-10-25 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US9652519B2 (en) | Replicating data across multiple copies of a table in a database system | |
US8429121B2 (en) | Apparatus and method for creating a real time database replica | |
US10235375B1 (en) | Persistent file system objects for management of databases | |
US7739547B2 (en) | Failure recovery and error correction techniques for data loading in information warehouses | |
US10565070B2 (en) | Systems and methods for recovery of consistent database indexes | |
EP2746971A2 (en) | Replication mechanisms for database environments | |
US7552150B2 (en) | Reason-based database changes | |
US8560500B2 (en) | Method and system for removing rows from directory tables | |
US8296269B2 (en) | Apparatus and method for read consistency in a log mining system | |
CN107004010A (zh) | 控制多数据库系统 | |
US11868330B2 (en) | Method for indexing data in storage engine and related apparatus | |
EP3089051B1 (en) | Database rollback using wal | |
KR102038529B1 (ko) | 인-메모리 데이터베이스의 실시간 데이터 변경 처리 시스템 | |
US7653663B1 (en) | Guaranteeing the authenticity of the data stored in the archive storage | |
CN106155838A (zh) | 一种数据库备份数据恢复方法及装置 | |
EP2797001B1 (en) | System and method for creating variants in a test database during various test stages | |
CN105787098A (zh) | 一种Oracle数据库表数据历史轨迹保存方法及系统 | |
CN106407292B (zh) | 一种空间数据库中矢量数据几何变化检测的方法及装置 | |
CN110096296A (zh) | 一种缓存对比方法及设备 | |
US6792435B1 (en) | Method and apparatus for recovering the definitions of dropped database objects | |
Silva et al. | Assisting data warehousing populating processes design through modelling using coloured petri nets | |
CN110471907A (zh) | 一种数据处理效率更高的计算机数据库数据处理方法 | |
CN117971565A (zh) | 一种恢复列存储分布式数据库误删除数据的方法及系统 | |
US20070130195A1 (en) | Modeling enumeration tables for relational databases |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20201112 Address after: Room 10242, No. 260, Jiangshu Road, Xixing street, Binjiang District, Hangzhou City, Zhejiang Province Patentee after: Hangzhou Jiji Intellectual Property Operation Co., Ltd Address before: 201616 Shanghai Songjiang District 68221988-5 Patentee before: Phicomm (Shanghai) Co.,Ltd. |
|
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20211216 Address after: Room a309, Qilu Software Park building, 1768 Xinluo street, high tech Zone, Jinan City, Shandong Province Patentee after: Shandong torch Technology Service Co.,Ltd. Address before: Room 10242, No. 260, Jiangshu Road, Xixing street, Binjiang District, Hangzhou City, Zhejiang Province Patentee before: Hangzhou Jiji Intellectual Property Operation Co., Ltd |
|
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20211228 Address after: Floor 1, building 2, Qilu Software Park, No.1 Shunhua Road, high tech Zone, Jinan City, Shandong Province Patentee after: PANSOFT Co.,Ltd. Address before: Room a309, Qilu Software Park building, 1768 Xinluo street, high tech Zone, Jinan City, Shandong Province Patentee before: Shandong torch Technology Service Co.,Ltd. |