{"id":"https://openalex.org/W1989565975","doi":"https://doi.org/10.1016/0169-023x(95)00018-n","title":"Formulating global integrity constraints during derivation of global schema","display_name":"Formulating global integrity constraints during derivation of global schema","publication_year":1995,"publication_date":"1995-09-01","ids":{"openalex":"https://openalex.org/W1989565975","doi":"https://doi.org/10.1016/0169-023x(95)00018-n","mag":"1989565975"},"language":"en","primary_location":{"id":"doi:10.1016/0169-023x(95)00018-n","is_oa":false,"landing_page_url":"https://doi.org/10.1016/0169-023x(95)00018-n","pdf_url":null,"source":{"id":"https://openalex.org/S136993123","display_name":"Data & Knowledge Engineering","issn_l":"0169-023X","issn":["0169-023X","1872-6933"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Data & Knowledge Engineering","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/A5055093815","display_name":"M. P. Reddy","orcid":"https://orcid.org/0009-0007-2561-9319"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"M.P. Reddy","raw_affiliation_strings":["Kenan Systems Corporation, Cambridge, MA 02142, USA"],"affiliations":[{"raw_affiliation_string":"Kenan Systems Corporation, Cambridge, MA 02142, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5110146617","display_name":"Biren Prasad","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"B.E. Prasad","raw_affiliation_strings":["Dow Jones Telerate, Jersey City, NJ 08902, USA"],"affiliations":[{"raw_affiliation_string":"Dow Jones Telerate, Jersey City, NJ 08902, USA","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5089511560","display_name":"Amar Gupta","orcid":"https://orcid.org/0000-0001-9306-1256"},"institutions":[{"id":"https://openalex.org/I63966007","display_name":"Massachusetts Institute of Technology","ror":"https://ror.org/042nb2s44","country_code":"US","type":"education","lineage":["https://openalex.org/I63966007"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Amar Gupta","raw_affiliation_strings":["Sloan School of Management, MIT, Cambridge, MA 02139, USA","Sloan School of Management, MIT, Cambridge, MA 02139, USA#TAB#"],"affiliations":[{"raw_affiliation_string":"Sloan School of Management, MIT, Cambridge, MA 02139, USA","institution_ids":[]},{"raw_affiliation_string":"Sloan School of Management, MIT, Cambridge, MA 02139, USA#TAB#","institution_ids":["https://openalex.org/I63966007"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5089511560"],"corresponding_institution_ids":["https://openalex.org/I63966007"],"apc_list":{"value":2590,"currency":"USD","value_usd":2590},"apc_paid":null,"fwci":3.5483,"has_fulltext":false,"cited_by_count":29,"citation_normalized_percentile":{"value":0.92624218,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":null,"biblio":{"volume":"16","issue":"3","first_page":"241","last_page":"268"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998999834060669,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998999834060669,"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/T11106","display_name":"Data Management and Algorithms","score":0.9993000030517578,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9987000226974487,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/data-integrity","display_name":"Data integrity","score":0.8350038528442383},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7350611090660095},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.6892659664154053},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.4975278675556183},{"id":"https://openalex.org/keywords/component","display_name":"Component (thermodynamics)","score":0.41768524050712585},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.34747374057769775},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3443751931190491},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.32280591130256653},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.24019959568977356},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.12989160418510437}],"concepts":[{"id":"https://openalex.org/C33762810","wikidata":"https://www.wikidata.org/wiki/Q461671","display_name":"Data integrity","level":2,"score":0.8350038528442383},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7350611090660095},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.6892659664154053},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.4975278675556183},{"id":"https://openalex.org/C168167062","wikidata":"https://www.wikidata.org/wiki/Q1117970","display_name":"Component (thermodynamics)","level":2,"score":0.41768524050712585},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.34747374057769775},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3443751931190491},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.32280591130256653},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.24019959568977356},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.12989160418510437},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C97355855","wikidata":"https://www.wikidata.org/wiki/Q11473","display_name":"Thermodynamics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1016/0169-023x(95)00018-n","is_oa":false,"landing_page_url":"https://doi.org/10.1016/0169-023x(95)00018-n","pdf_url":null,"source":{"id":"https://openalex.org/S136993123","display_name":"Data & Knowledge Engineering","issn_l":"0169-023X","issn":["0169-023X","1872-6933"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Data & Knowledge Engineering","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320324655","display_name":"University of Hyderabad","ror":"https://ror.org/04a7rxb17"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":84,"referenced_works":["https://openalex.org/W198496983","https://openalex.org/W306829911","https://openalex.org/W589111820","https://openalex.org/W1480789478","https://openalex.org/W1518351691","https://openalex.org/W1562085135","https://openalex.org/W1567150681","https://openalex.org/W1585544964","https://openalex.org/W1597618452","https://openalex.org/W1598102859","https://openalex.org/W1602772239","https://openalex.org/W1768893245","https://openalex.org/W1825250667","https://openalex.org/W1859692167","https://openalex.org/W1966052794","https://openalex.org/W1970587873","https://openalex.org/W1989625540","https://openalex.org/W1989673910","https://openalex.org/W1994845603","https://openalex.org/W1999557921","https://openalex.org/W2005649826","https://openalex.org/W2012014189","https://openalex.org/W2013893528","https://openalex.org/W2016758618","https://openalex.org/W2020649320","https://openalex.org/W2037214271","https://openalex.org/W2038002586","https://openalex.org/W2038567523","https://openalex.org/W2048001632","https://openalex.org/W2070609645","https://openalex.org/W2076898857","https://openalex.org/W2089634871","https://openalex.org/W2091753078","https://openalex.org/W2102105462","https://openalex.org/W2106565840","https://openalex.org/W2107783730","https://openalex.org/W2112223325","https://openalex.org/W2121094089","https://openalex.org/W2122347840","https://openalex.org/W2126488419","https://openalex.org/W2128211912","https://openalex.org/W2128798216","https://openalex.org/W2132610455","https://openalex.org/W2139435319","https://openalex.org/W2154110682","https://openalex.org/W2155580972","https://openalex.org/W2155645309","https://openalex.org/W2165055490","https://openalex.org/W2165332770","https://openalex.org/W2172181323","https://openalex.org/W2220190719","https://openalex.org/W2274435092","https://openalex.org/W2293540547","https://openalex.org/W2293671697","https://openalex.org/W2295562782","https://openalex.org/W2331093232","https://openalex.org/W2356580545","https://openalex.org/W2568108772","https://openalex.org/W2627013089","https://openalex.org/W3123706263","https://openalex.org/W3142858952","https://openalex.org/W6606401570","https://openalex.org/W6608206888","https://openalex.org/W6628832575","https://openalex.org/W6633565243","https://openalex.org/W6633824693","https://openalex.org/W6634891404","https://openalex.org/W6635636933","https://openalex.org/W6635780821","https://openalex.org/W6637994664","https://openalex.org/W6638949117","https://openalex.org/W6647665819","https://openalex.org/W6653208390","https://openalex.org/W6662356370","https://openalex.org/W6675589495","https://openalex.org/W6678473083","https://openalex.org/W6678671460","https://openalex.org/W6682756259","https://openalex.org/W6683008741","https://openalex.org/W6689206598","https://openalex.org/W6697094664","https://openalex.org/W6697225095","https://openalex.org/W6731286228","https://openalex.org/W6739077014"],"related_works":["https://openalex.org/W148555903","https://openalex.org/W2402550255","https://openalex.org/W2911644013","https://openalex.org/W2101601023","https://openalex.org/W2374348909","https://openalex.org/W1507426629","https://openalex.org/W2334351815","https://openalex.org/W2065338924","https://openalex.org/W2405544841","https://openalex.org/W64058425"],"abstract_inverted_index":null,"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}