{"id":"https://openalex.org/W4387457622","doi":"https://doi.org/10.1134/s0361768823050055","title":"Database Migration from ORACLE to PostgreSQL","display_name":"Database Migration from ORACLE to PostgreSQL","publication_year":2023,"publication_date":"2023-10-01","ids":{"openalex":"https://openalex.org/W4387457622","doi":"https://doi.org/10.1134/s0361768823050055"},"language":"en","primary_location":{"id":"doi:10.1134/s0361768823050055","is_oa":false,"landing_page_url":"https://doi.org/10.1134/s0361768823050055","pdf_url":null,"source":{"id":"https://openalex.org/S150218641","display_name":"Programming and Computer Software","issn_l":"0361-7688","issn":["0361-7688","1608-3261"],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/P4310320267","host_organization_name":"Pleiades Publishing","host_organization_lineage":["https://openalex.org/P4310320267","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Pleiades Publishing","Springer Nature"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Programming and Computer Software","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5015028283","display_name":"Evgeny Kurako","orcid":"https://orcid.org/0009-0008-4746-1943"},"institutions":[{"id":"https://openalex.org/I4210157430","display_name":"V. A. Trapeznikov Institute of Control Sciences","ror":"https://ror.org/05f3yt521","country_code":"RU","type":"facility","lineage":["https://openalex.org/I1313323035","https://openalex.org/I4210157430","https://openalex.org/I4210164537"]}],"countries":["RU"],"is_corresponding":true,"raw_author_name":"E. A. Kurako","raw_affiliation_strings":["V. A. Trapeznikov Institute of Control Sciences, Russian Academy of Sciences, Profsoyuznaya ul. 65, 117997, Moscow, Russia"],"affiliations":[{"raw_affiliation_string":"V. A. Trapeznikov Institute of Control Sciences, Russian Academy of Sciences, Profsoyuznaya ul. 65, 117997, Moscow, Russia","institution_ids":["https://openalex.org/I4210157430"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5039053462","display_name":"\u0412. \u041b. \u041e\u0440\u043b\u043e\u0432","orcid":null},"institutions":[{"id":"https://openalex.org/I4210157430","display_name":"V. A. Trapeznikov Institute of Control Sciences","ror":"https://ror.org/05f3yt521","country_code":"RU","type":"facility","lineage":["https://openalex.org/I1313323035","https://openalex.org/I4210157430","https://openalex.org/I4210164537"]}],"countries":["RU"],"is_corresponding":false,"raw_author_name":"V. L. Orlov","raw_affiliation_strings":["V. A. Trapeznikov Institute of Control Sciences, Russian Academy of Sciences, Profsoyuznaya ul. 65, 117997, Moscow, Russia"],"affiliations":[{"raw_affiliation_string":"V. A. Trapeznikov Institute of Control Sciences, Russian Academy of Sciences, Profsoyuznaya ul. 65, 117997, Moscow, Russia","institution_ids":["https://openalex.org/I4210157430"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5015028283"],"corresponding_institution_ids":["https://openalex.org/I4210157430"],"apc_list":null,"apc_paid":null,"fwci":0.9391,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.75352514,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":95,"max":97},"biblio":{"volume":"49","issue":"5","first_page":"455","last_page":"463"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T14470","display_name":"Advanced Data Processing Techniques","score":0.979200005531311,"subfield":{"id":"https://openalex.org/subfields/2207","display_name":"Control and Systems Engineering"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T14470","display_name":"Advanced Data Processing Techniques","score":0.979200005531311,"subfield":{"id":"https://openalex.org/subfields/2207","display_name":"Control and Systems Engineering"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/oracle","display_name":"Oracle","score":0.8495416641235352},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7633747458457947},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6787296533584595},{"id":"https://openalex.org/keywords/data-migration","display_name":"Data migration","score":0.6321641802787781},{"id":"https://openalex.org/keywords/transfer","display_name":"Transfer (computing)","score":0.5692122578620911},{"id":"https://openalex.org/keywords/transformation","display_name":"Transformation (genetics)","score":0.5605813264846802},{"id":"https://openalex.org/keywords/pl/sql","display_name":"PL/SQL","score":0.5419259071350098},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.4844946563243866},{"id":"https://openalex.org/keywords/oracle-database","display_name":"Oracle database","score":0.43098700046539307},{"id":"https://openalex.org/keywords/distributed-database","display_name":"Distributed database","score":0.4254935681819916},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.3124351501464844},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.21843627095222473},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.18194296956062317},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.162818044424057},{"id":"https://openalex.org/keywords/chemistry","display_name":"Chemistry","score":0.0959312915802002},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.06450453400611877}],"concepts":[{"id":"https://openalex.org/C55166926","wikidata":"https://www.wikidata.org/wiki/Q2892946","display_name":"Oracle","level":2,"score":0.8495416641235352},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7633747458457947},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6787296533584595},{"id":"https://openalex.org/C146152329","wikidata":"https://www.wikidata.org/wiki/Q1932543","display_name":"Data migration","level":2,"score":0.6321641802787781},{"id":"https://openalex.org/C2776175482","wikidata":"https://www.wikidata.org/wiki/Q1195816","display_name":"Transfer (computing)","level":2,"score":0.5692122578620911},{"id":"https://openalex.org/C204241405","wikidata":"https://www.wikidata.org/wiki/Q461499","display_name":"Transformation (genetics)","level":3,"score":0.5605813264846802},{"id":"https://openalex.org/C32145003","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"PL/SQL","level":5,"score":0.5419259071350098},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.4844946563243866},{"id":"https://openalex.org/C2987003710","wikidata":"https://www.wikidata.org/wiki/Q185524","display_name":"Oracle database","level":3,"score":0.43098700046539307},{"id":"https://openalex.org/C70061542","wikidata":"https://www.wikidata.org/wiki/Q989016","display_name":"Distributed database","level":2,"score":0.4254935681819916},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.3124351501464844},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.21843627095222473},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.18194296956062317},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.162818044424057},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0959312915802002},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.06450453400611877},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1134/s0361768823050055","is_oa":false,"landing_page_url":"https://doi.org/10.1134/s0361768823050055","pdf_url":null,"source":{"id":"https://openalex.org/S150218641","display_name":"Programming and Computer Software","issn_l":"0361-7688","issn":["0361-7688","1608-3261"],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/P4310320267","host_organization_name":"Pleiades Publishing","host_organization_lineage":["https://openalex.org/P4310320267","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Pleiades Publishing","Springer Nature"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Programming and Computer Software","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.7099999785423279,"id":"https://metadata.un.org/sdg/10","display_name":"Reduced inequalities"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2184771611","https://openalex.org/W23253958","https://openalex.org/W4253488555","https://openalex.org/W4214762111","https://openalex.org/W2327539013","https://openalex.org/W101461791","https://openalex.org/W4254465967","https://openalex.org/W2390871166","https://openalex.org/W2386653081","https://openalex.org/W2357628113"],"abstract_inverted_index":{"Methods":[0,44],"of":[1,15,19,22,32,35,73,94,98,109],"data":[2,37],"transfer":[3,82],"from":[4],"the":[5,9,20,30,33,68,81,96],"Oracle":[6],"environment":[7,11],"to":[8,83],"PostgreSQL":[10],"with":[12,67],"stage-by-stage":[13],"organization":[14],"actions":[16],"and":[17,39,49,56,71,89,102],"determination":[18],"sequence":[21],"migration":[23,76,104],"are":[24,42,58,77,105],"considered.":[25],"The":[26],"main":[27],"directions":[28],"for":[29,45,86,107],"transformation":[31],"structure":[34],"databases,":[36],"formats":[38],"executed":[40],"objects":[41],"identified.":[43],"converting":[46],"stored":[47],"procedures":[48],"triggers":[50],"written":[51],"in":[52],"procedural":[53],"languages":[54],"(PL/SQL":[55],"PL/pgSQL)":[57],"specified.":[59],"Software":[60],"change":[61],"on":[62],"nodes":[63],"directly":[64],"connected":[65],"(associated)":[66],"database":[69],"server":[70],"minimization":[72],"downtimes":[74],"during":[75],"considered,":[78],"which":[79],"allows":[80],"be":[84],"performed":[85],"geographically":[87],"distributed":[88],"round-the-clock":[90],"functioning":[91],"objects.":[92],"Examples":[93],"changing":[95],"speed":[97],"query":[99],"execution":[100],"before":[101],"after":[103],"given":[106],"systems":[108],"various":[110],"types.":[111]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":3}],"updated_date":"2026-01-23T23:20:30.427331","created_date":"2025-10-10T00:00:00"}