APPARATUS AND METHOD FOR RECOVERING DATA IN ORACLE DATABASE
The present invention relates to a device and a method for restoring data in an Oracle database. A data restoration device receives a system file from the database, checks a system table included in the system file to derive the schema information for one or more tables in the system file, and selec...
Saved in:
| Main Authors | , , , , , |
|---|---|
| Format | Patent |
| Language | English Korean |
| Published |
26.08.2015
|
| Subjects | |
| Online Access | Get full text |
Cover
Loading…
| Abstract | The present invention relates to a device and a method for restoring data in an Oracle database. A data restoration device receives a system file from the database, checks a system table included in the system file to derive the schema information for one or more tables in the system file, and selects a deleted table among the tables based on the schema information. The data restoration device then searches for and derives a data block including a deleted record through the object ID of the selected table to identify and extract the deleted record from the derived data block, thereby restoring the deleted record. |
|---|---|
| AbstractList | The present invention relates to a device and a method for restoring data in an Oracle database. A data restoration device receives a system file from the database, checks a system table included in the system file to derive the schema information for one or more tables in the system file, and selects a deleted table among the tables based on the schema information. The data restoration device then searches for and derives a data block including a deleted record through the object ID of the selected table to identify and extract the deleted record from the derived data block, thereby restoring the deleted record. |
| Author | CHOI, JONG HYUN LEE, SANG JIN LEE, KUK HEON KANG, CHEUL HOON SEO, MYUNG JIN JEONG, DOO WON |
| Author_xml | – fullname: LEE, SANG JIN – fullname: JEONG, DOO WON – fullname: CHOI, JONG HYUN – fullname: LEE, KUK HEON – fullname: KANG, CHEUL HOON – fullname: SEO, MYUNG JIN |
| BookMark | eNrjYmDJy89L5WSwdgwIcAxyDAkNVnD0c1HwdQ3x8HdRcPMPUghydfYPcw3y9HNXcHEMcVTw9FPwD3J09nEFc50cg115GFjTEnOKU3mhNDeDsptriLOHbmpBfnxqcUFicmpeakm8d5ChgaGpibmJmZmTk6ExcaoAaFUrpA |
| ContentType | Patent |
| DBID | EVB |
| DatabaseName | esp@cenet |
| DatabaseTitleList | |
| Database_xml | – sequence: 1 dbid: EVB name: esp@cenet url: http://worldwide.espacenet.com/singleLineSearch?locale=en_EP sourceTypes: Open Access Repository |
| DeliveryMethod | fulltext_linktorsrc |
| Discipline | Medicine Chemistry Sciences Physics |
| ExternalDocumentID | KR101547466BB1 |
| GroupedDBID | EVB |
| ID | FETCH-epo_espacenet_KR101547466BB13 |
| IEDL.DBID | EVB |
| IngestDate | Fri Jul 19 16:00:05 EDT 2024 |
| IsOpenAccess | true |
| IsPeerReviewed | false |
| IsScholarly | false |
| Language | English Korean |
| LinkModel | DirectLink |
| MergedId | FETCHMERGED-epo_espacenet_KR101547466BB13 |
| Notes | Application Number: KR20140036547 |
| OpenAccessLink | https://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20150826&DB=EPODOC&CC=KR&NR=101547466B1 |
| ParticipantIDs | epo_espacenet_KR101547466BB1 |
| PublicationCentury | 2000 |
| PublicationDate | 20150826 |
| PublicationDateYYYYMMDD | 2015-08-26 |
| PublicationDate_xml | – month: 08 year: 2015 text: 20150826 day: 26 |
| PublicationDecade | 2010 |
| PublicationYear | 2015 |
| RelatedCompanies | REPUBLIC OF KOREA (SUPREME PUBLIC PROSECUTOR'S OFFICE) KOREA UNIVERSITY RESEARCH AND BUSINESS FOUNDATION |
| RelatedCompanies_xml | – name: REPUBLIC OF KOREA (SUPREME PUBLIC PROSECUTOR'S OFFICE) – name: KOREA UNIVERSITY RESEARCH AND BUSINESS FOUNDATION |
| Score | 2.979162 |
| Snippet | The present invention relates to a device and a method for restoring data in an Oracle database. A data restoration device receives a system file from the... |
| SourceID | epo |
| SourceType | Open Access Repository |
| SubjectTerms | CALCULATING COMPUTING COUNTING ELECTRIC DIGITAL DATA PROCESSING PHYSICS |
| Title | APPARATUS AND METHOD FOR RECOVERING DATA IN ORACLE DATABASE |
| URI | https://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20150826&DB=EPODOC&locale=&CC=KR&NR=101547466B1 |
| hasFullText | 1 |
| inHoldings | 1 |
| isFullTextHit | |
| isPrint | |
| link | http://utb.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwfV3da8IwED_Efb5tbmMfbgQ2-lZGNa2WISNNIm7OttQqvkn6BUOoMjv27y8JOvfkYy5wXA4u95G7XwCeRJ4ndtZxzSKzExMXrm2KoiVMBW3lZlaWikKjffrOYILfZ_asBovtLIzGCf3R4IjSolJp75W-r1e7IhbTvZXr5-RTkpav_bjHjE12rMDNW47BvB4PAxZQg9LeMDL8SMa6MlboYMfxZKp0oOJoBbTPp54aS1n99yn9MzgMJbuyOofaYtmAE7r9eq0Bx6PNi3cDjnSLZrqWxI0Zri_ghYQhiUg8GSPiMzTi8SBgSOZzKOI0mGqYKMRITNCbj4KI0A-ulx4Z80t47POYDkwpz_zv9PNhtJPds9pXUC-XZX4NyHKcBFuFgt_p4m47FdjFWZ67AovC7qbJDTT3cbrdv30Hp0qfqnzacppQr76-83vpf6vkQevtF5hug44 |
| link.rule.ids | 230,309,786,891,25594,76904 |
| linkProvider | European Patent Office |
| linkToHtml | http://utb.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwfV3da8IwED_Efbi3zW3sw22Bjb6VUU2jZchIm0id2pZaxTfpJwxBZXbs318SdO7Jx1zguBxc7iN3vwC8xHmemFnb0ovMTHRcWKYeF81Yl9BWVmZkaVwotE-PuBP8MTNnFVjsZmEUTuiPAkcUFpUKey_Vfb3eF7GY6q3cvCafgrR670Vdpm2zYwlu3iQas7s88JnvaI7THYSaF4pYV8QKbUyILVKlo7bICSXQPp_acixl_d-n9M7hOBDsluUFVBarOtSc3ddrdTgdbV-863CiWjTTjSBuzXBzCW80CGhIo8kYUY-hEY9cnyGRz6GQO_5UwUQhRiOK-h7yQ-oMuVradMyv4LnHI8fVhTzzv9PPB-FedttoXUN1uVrmN4AMQhJsFBJ-p4M7rTTGFs7y3IpxXJidNLmFxiFOd4e3n6DmRqPhfNj3BvdwJnUrS6lN0oBq-fWdPwhfXCaPSoe_5TeGeQ |
| openUrl | ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Apatent&rft.title=APPARATUS+AND+METHOD+FOR+RECOVERING+DATA+IN+ORACLE+DATABASE&rft.inventor=LEE%2C+SANG+JIN&rft.inventor=JEONG%2C+DOO+WON&rft.inventor=CHOI%2C+JONG+HYUN&rft.inventor=LEE%2C+KUK+HEON&rft.inventor=KANG%2C+CHEUL+HOON&rft.inventor=SEO%2C+MYUNG+JIN&rft.date=2015-08-26&rft.externalDBID=B1&rft.externalDocID=KR101547466BB1 |