{"id":"https://openalex.org/W2007153937","doi":"https://doi.org/10.1002/(sici)1097-4571(198801)39:1<2::aid-asi2>3.0.co;2-g","title":"Repetitive bibliographical information in relational databases","display_name":"Repetitive bibliographical information in relational databases","publication_year":1988,"publication_date":"1988-01-01","ids":{"openalex":"https://openalex.org/W2007153937","doi":"https://doi.org/10.1002/(sici)1097-4571(198801)39:1<2::aid-asi2>3.0.co;2-g","mag":"2007153937"},"language":"en","primary_location":{"id":"doi:10.1002/(sici)1097-4571(198801)39:1<2::aid-asi2>3.0.co;2-g","is_oa":false,"landing_page_url":"https://doi.org/10.1002/(sici)1097-4571(198801)39:1<2::aid-asi2>3.0.co;2-g","pdf_url":null,"source":{"id":"https://openalex.org/S4210220780","display_name":"Journal of the American Society for Information Science","issn_l":"0002-8231","issn":["0002-8231","1097-4571"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of the American Society for Information Science","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/A5005998058","display_name":"Terrence A. Brooks","orcid":null},"institutions":[{"id":"https://openalex.org/I201448701","display_name":"University of Washington","ror":"https://ror.org/00cvxb145","country_code":"US","type":"education","lineage":["https://openalex.org/I201448701"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Terrence A. Brooks","raw_affiliation_strings":["Graduate School of Library and Information Science, University of Washington, Seattle, WA 98195","Graduate School of Library and Information Science , University of Washington , Seattle, WA, 98195"],"affiliations":[{"raw_affiliation_string":"Graduate School of Library and Information Science, University of Washington, Seattle, WA 98195","institution_ids":["https://openalex.org/I201448701"]},{"raw_affiliation_string":"Graduate School of Library and Information Science , University of Washington , Seattle, WA, 98195","institution_ids":["https://openalex.org/I201448701"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5005998058"],"corresponding_institution_ids":["https://openalex.org/I201448701"],"apc_list":null,"apc_paid":null,"fwci":0.4859,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.67537771,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"39","issue":"1","first_page":"2","last_page":"7"},"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.9904999732971191,"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.9904999732971191,"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/T10286","display_name":"Information Retrieval and Search Behavior","score":0.9169999957084656,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T11719","display_name":"Data Quality and Management","score":0.9139999747276306,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.7094336748123169},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6198778748512268},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6093032956123352},{"id":"https://openalex.org/keywords/normalization","display_name":"Normalization (sociology)","score":0.5457555055618286},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.497175008058548},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.4747386574745178},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.47372332215309143},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.43872177600860596},{"id":"https://openalex.org/keywords/redundancy","display_name":"Redundancy (engineering)","score":0.4335092604160309}],"concepts":[{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.7094336748123169},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6198778748512268},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6093032956123352},{"id":"https://openalex.org/C136886441","wikidata":"https://www.wikidata.org/wiki/Q926129","display_name":"Normalization (sociology)","level":2,"score":0.5457555055618286},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.497175008058548},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.4747386574745178},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.47372332215309143},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.43872177600860596},{"id":"https://openalex.org/C152124472","wikidata":"https://www.wikidata.org/wiki/Q1204361","display_name":"Redundancy (engineering)","level":2,"score":0.4335092604160309},{"id":"https://openalex.org/C144024400","wikidata":"https://www.wikidata.org/wiki/Q21201","display_name":"Sociology","level":0,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C19165224","wikidata":"https://www.wikidata.org/wiki/Q23404","display_name":"Anthropology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1002/(sici)1097-4571(198801)39:1<2::aid-asi2>3.0.co;2-g","is_oa":false,"landing_page_url":"https://doi.org/10.1002/(sici)1097-4571(198801)39:1<2::aid-asi2>3.0.co;2-g","pdf_url":null,"source":{"id":"https://openalex.org/S4210220780","display_name":"Journal of the American Society for Information Science","issn_l":"0002-8231","issn":["0002-8231","1097-4571"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of the American Society for Information Science","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2512945146","https://openalex.org/W2044272255","https://openalex.org/W2355364777","https://openalex.org/W3085968255","https://openalex.org/W2386848747","https://openalex.org/W2393466613","https://openalex.org/W2244681254","https://openalex.org/W3211141956","https://openalex.org/W2991136526","https://openalex.org/W279222092"],"abstract_inverted_index":{"Bibliographical":[0],"databases":[1,28],"frequently":[2,83],"have":[3],"a":[4,42,53,98],"few":[5],"long,":[6,82],"repetitive":[7,49,149],"strings":[8,85],"such":[9],"as":[10],"the":[11,33,45,64,124,135,144],"recurring":[12],"names":[13],"of":[14,26,35,47,66,126,138],"voluminous":[15],"authors.":[16],"Potter":[17,139],"[Library":[18],"Trends.":[19],"30(1):":[20],"21\u201339;":[21],"1981]":[22],"observed":[23],"this":[24],"characteristic":[25],"bibliographical":[27,50,67,150],"in":[29,52,76,97,115,147,152],"his":[30],"sample":[31],"from":[32],"University":[34],"Illinois":[36],"library":[37],"catalog.":[38],"This":[39,101],"article":[40],"presents":[41],"solution":[43],"to":[44,86,142],"problem":[46],"loading":[48],"information":[51,151],"microcomputer-based":[54],"relational":[55,68,77,153],"database-management":[56],"system.":[57],"Normalization":[58],"theory":[59],"does":[60],"not":[61],"explicitly":[62],"address":[63],"characteristics":[65],"databases.":[69,154],"The":[70],"representational":[71],"redundancy":[72],"design":[73,102],"saves":[74],"space":[75],"database":[78],"tables":[79,88],"by":[80,94,105,108,123],"removing":[81],"occurring":[84],"separate":[87],"where":[89],"they":[90],"can":[91],"be":[92],"referenced":[93],"shorter":[95],"surrogates":[96],"main":[99],"table.":[100],"was":[103,140],"suggested":[104],"some":[106],"reflections":[107],"Kent":[109],"(Data":[110],"and":[111,122,134],"Reality,":[112],"Basic":[113],"Assumptions":[114],"Data":[116],"Processing":[117],"Reconsidered.":[118],"Amsterdam:":[119],"North-Holland;":[120],"1978)":[121],"example":[125],"MERLIN":[127],"[Program.":[128],"10(4):":[129],"123\u2013134;":[130],"1976].":[131],"Telephone-book":[132],"data":[133,137],"library-catalog":[136],"used":[141],"illustrate":[143],"economies":[145],"achieved":[146],"representing":[148],"\u00a9":[155],"1988":[156],"John":[157],"Wiley":[158],"&":[159],"Sons,":[160],"Inc.":[161]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}