{"id":"https://openalex.org/W2149343370","doi":"https://doi.org/10.1109/tkde.2002.1019216","title":"Exploring into programs for the recovery of data dependencies designed","display_name":"Exploring into programs for the recovery of data dependencies designed","publication_year":2002,"publication_date":"2002-07-01","ids":{"openalex":"https://openalex.org/W2149343370","doi":"https://doi.org/10.1109/tkde.2002.1019216","mag":"2149343370"},"language":"en","primary_location":{"is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2002.1019216","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_indexed_in_scopus":true,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false},"type":"article","type_crossref":"journal-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/A5110248023","display_name":"Hee Beng Kuan Tan","orcid":null},"institutions":[{"id":"https://openalex.org/I172675005","display_name":"Nanyang Technological University","ror":"https://ror.org/02e7b5302","country_code":"SG","type":"funder","lineage":["https://openalex.org/I172675005"]}],"countries":["SG"],"is_corresponding":false,"raw_author_name":"None Hee Beng Kuan Tan","raw_affiliation_strings":["School of Electrical and Electronic Engineering, Nanyang Technological University, Singapore"],"affiliations":[{"raw_affiliation_string":"School of Electrical and Electronic Engineering, Nanyang Technological University, Singapore","institution_ids":["https://openalex.org/I172675005"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5037961481","display_name":"Tok Wang Ling","orcid":"https://orcid.org/0000-0002-0496-0565"},"institutions":[{"id":"https://openalex.org/I165932596","display_name":"National University of Singapore","ror":"https://ror.org/01tgyzw49","country_code":"SG","type":"funder","lineage":["https://openalex.org/I165932596"]}],"countries":["SG"],"is_corresponding":false,"raw_author_name":"None Tok Wang Ling","raw_affiliation_strings":["National Department of Computer Science, University of Singapore, Singapore"],"affiliations":[{"raw_affiliation_string":"National Department of Computer Science, University of Singapore, Singapore","institution_ids":["https://openalex.org/I165932596"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5110147715","display_name":"Cheng Hian Goh","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"None Cheng Hian Goh","raw_affiliation_strings":[],"affiliations":[]}],"institution_assertions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.579,"has_fulltext":true,"fulltext_origin":"ngrams","cited_by_count":11,"citation_normalized_percentile":{"value":0.835801,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":80,"max":81},"biblio":{"volume":"14","issue":"4","first_page":"825","last_page":"835"},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T12127","display_name":"Software System Performance and Reliability","score":0.9994,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T12127","display_name":"Software System Performance and Reliability","score":0.9994,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","score":0.9991,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10743","display_name":"Software Testing and Debugging Techniques","score":0.9984,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/database-administrator","display_name":"Database administrator","score":0.4670291},{"id":"https://openalex.org/keywords/physical-data-model","display_name":"Physical data model","score":0.43241256}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8482845},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.7365788},{"id":"https://openalex.org/C78161392","wikidata":"https://www.wikidata.org/wiki/Q5227414","display_name":"Database testing","level":4,"score":0.69078887},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.65560585},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6458272},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.5789592},{"id":"https://openalex.org/C107535962","wikidata":"https://www.wikidata.org/wiki/Q2459880","display_name":"Database tuning","level":4,"score":0.5454801},{"id":"https://openalex.org/C12439846","wikidata":"https://www.wikidata.org/wiki/Q4809258","display_name":"Database theory","level":3,"score":0.48818165},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.46905947},{"id":"https://openalex.org/C70236469","wikidata":"https://www.wikidata.org/wiki/Q1078262","display_name":"Database administrator","level":2,"score":0.4670291},{"id":"https://openalex.org/C26320393","wikidata":"https://www.wikidata.org/wiki/Q597053","display_name":"Functional dependency","level":3,"score":0.45441377},{"id":"https://openalex.org/C187959359","wikidata":"https://www.wikidata.org/wiki/Q17113749","display_name":"Physical data model","level":5,"score":0.43241256},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.40965572},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.35049433}],"mesh":[],"locations_count":1,"locations":[{"is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2002.1019216","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_indexed_in_scopus":true,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Reduced inequalities","id":"https://metadata.un.org/sdg/10","score":0.5}],"grants":[],"datasets":[],"versions":[],"referenced_works_count":21,"referenced_works":["https://openalex.org/W1498996471","https://openalex.org/W1534315740","https://openalex.org/W1582340086","https://openalex.org/W161296925","https://openalex.org/W1893597428","https://openalex.org/W1968210840","https://openalex.org/W1984958950","https://openalex.org/W2019912855","https://openalex.org/W2025554746","https://openalex.org/W2094407133","https://openalex.org/W2094448563","https://openalex.org/W2100406636","https://openalex.org/W2110014853","https://openalex.org/W2115822498","https://openalex.org/W2144226170","https://openalex.org/W2150817871","https://openalex.org/W2156619646","https://openalex.org/W2293624369","https://openalex.org/W2414883570","https://openalex.org/W2613278123","https://openalex.org/W2914646094"],"related_works":["https://openalex.org/W4386265562","https://openalex.org/W2913707658","https://openalex.org/W2378383019","https://openalex.org/W2372613381","https://openalex.org/W2365958943","https://openalex.org/W2129469317","https://openalex.org/W2080297823","https://openalex.org/W204909595","https://openalex.org/W1603211808","https://openalex.org/W1559732633"],"abstract_inverted_index":{"Data":[0],"dependencies":[1,36,81],"play":[2],"an":[3],"important":[4],"role":[5],"in":[6,37,43,55,61,106,141],"the":[7,34,44,62,66,78,84,110,122,145,151],"design":[8],"of":[9,33,88,112,124,147],"a":[10,30,103,118,142],"database.":[11,152],"Many":[12],"legacy":[13,38],"database":[14,22,45,56,89,143],"applications":[15],"have":[16],"been":[17,98],"developed":[18,99],"on":[19,157],"old":[20],"generation":[21],"management":[23,46],"systems":[24],"and":[25,58,72,86,100,137],"conventional":[26],"file":[27],"systems.":[28,47],"As":[29,48],"result,":[31],"most":[32,164],"data":[35,80,126,171],"databases":[39],"are":[40,51,59],"not":[41,52],"enforced":[42,60],"such,":[49],"they":[50],"explicitly":[53],"defined":[54],"schema":[57],"transactions,":[63,148],"which":[64,149],"update":[65,150],"databases.":[67],"It":[68],"is":[69,155],"very":[70],"difficult":[71],"time":[73],"consuming":[74],"to":[75,168],"find":[76],"out":[77],"designed":[79,140],"manually":[82],"during":[83],"maintenance":[85],"reengineering":[87],"applications.":[90],"In":[91],"software":[92],"engineering,":[93],"program":[94,113,159],"analysis":[95],"has":[96],"long":[97],"proven":[101],"as":[102],"useful":[104],"aid":[105],"many":[107],"areas.":[108],"With":[109],"use":[111],"analysis,":[114],"this":[115],"paper":[116],"proposes":[117],"novel":[119],"approach":[120,154],"for":[121,162],"recovery":[123],"common":[125],"dependencies,":[127,130,134,139],"i.e.,":[128],"functional":[129],"key":[131],"constraints,":[132,136],"inclusion":[133],"referential":[135],"sum":[138],"from":[144],"behavior":[146],"The":[153],"based":[156],"detecting":[158],"path":[160],"patterns":[161],"implementing":[163],"commonly":[165],"used":[166],"methods":[167],"enforce":[169],"these":[170],"dependencies.":[172]},"abstract_inverted_index_v3":null,"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2149343370","counts_by_year":[{"year":2016,"cited_by_count":1},{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":2}],"updated_date":"2025-04-16T05:27:54.806419","created_date":"2016-06-24"}