{"id":"https://openalex.org/W2211230442","doi":"https://doi.org/10.1061/jtcedl.0000019","title":"Introduction to Relational Databases Using Structural Engineering Examples","display_name":"Introduction to Relational Databases Using Structural Engineering Examples","alternate_titles":[],"publication_year":1984,"publication_date":"1984-05-01","ids":{"openalex":"https://openalex.org/W2211230442","doi":"https://doi.org/10.1061/jtcedl.0000019","mag":"2211230442"},"language":"en","primary_location":{"id":"doi:10.1061/jtcedl.0000019","doi":"https://doi.org/10.1061/jtcedl.0000019","is_oa":false,"landing_page_url":"https://doi.org/10.1061/jtcedl.0000019","pdf_url":null,"source":{"id":"https://openalex.org/S4210239169","display_name":"Journal of Technical Topics in Civil Engineering","issn_l":"0733-9461","issn":["0733-9461","2694-0213"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310315747","host_organization_name":"American Society of Civil Engineers","host_organization_lineage":["https://openalex.org/P4310315747"],"host_organization_lineage_names":["American Society of Civil Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Technical Topics in Civil Engineering","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W2211230442"],"child_works_count":0,"type":"article","is_traditional":true,"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/A5088290532","display_name":"Michael J. Schaefer","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I74973139","display_name":"Carnegie Mellon University","ror":"https://ror.org/05x2bcf33","country_code":"US","type":"education","lineage":["https://openalex.org/I74973139"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Michael J. Schaefer","raw_affiliation_strings":["Research Asst., Dept. of Civ. Engrg., Carnegie-Mellon Univ., Pittsburgh, Pa. 15213"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Research Asst., Dept. of Civ. Engrg., Carnegie-Mellon Univ., Pittsburgh, Pa. 15213","institution_ids":["https://openalex.org/I74973139"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5050043914","display_name":"Daniel R. Rehak","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I74973139","display_name":"Carnegie Mellon University","ror":"https://ror.org/05x2bcf33","country_code":"US","type":"education","lineage":["https://openalex.org/I74973139"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Daniel R. Rehak","raw_affiliation_strings":["Asst. Prof. of Civ. Engrg., Carnegie-Mellon Univ., Pittsburgh, Pa. 15213"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Asst. Prof. of Civ. Engrg., Carnegie-Mellon Univ., Pittsburgh, Pa. 15213","institution_ids":["https://openalex.org/I74973139"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5111429218","display_name":"Steven J. Fenves","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I74973139","display_name":"Carnegie Mellon University","ror":"https://ror.org/05x2bcf33","country_code":"US","type":"education","lineage":["https://openalex.org/I74973139"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Steven J. Fenves","raw_affiliation_strings":["Univ. Prof. of Civ. Engrg., Carnegie-Mellon Univ., Pittsburgh, Pa. 15213"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Univ. Prof. of Civ. Engrg., Carnegie-Mellon Univ., Pittsburgh, Pa. 15213","institution_ids":["https://openalex.org/I74973139"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I74973139"],"apc_list":null,"apc_paid":null,"fwci":0.604,"has_fulltext":false,"cited_by_count":8,"citation_normalized_percentile":{"value":0.67040732,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"110","issue":"1","first_page":"1","last_page":"18"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9901999831199646,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9901999831199646,"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/T13681","display_name":"Engineering and Information Technology","score":0.00839999970048666,"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"}},{"id":"https://openalex.org/T11734","display_name":"Decision Support System Applications","score":0.00019999999494757503,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/relational-databases","display_name":"relational databases","score":0.9269999861717224},{"id":"https://openalex.org/keywords/database-management-systems","display_name":"database management systems","score":0.9210000038146973},{"id":"https://openalex.org/keywords/relational-model","display_name":"relational model","score":0.7820000052452087},{"id":"https://openalex.org/keywords/relational-operations","display_name":"relational operations","score":0.8100000023841858},{"id":"https://openalex.org/keywords/data-retrieval","display_name":"data retrieval","score":0.9259999990463257},{"id":"https://openalex.org/keywords/database-normalization","display_name":"database normalization","score":0.7559999823570251},{"id":"https://openalex.org/keywords/normal-forms","display_name":"normal forms","score":0.9869999885559082},{"id":"https://openalex.org/keywords/database-design","display_name":"database design","score":0.9229999780654907}],"concepts":[{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.7647514343261719},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.7266383767127991},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7199738621711731},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.6089679002761841},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.593376636505127},{"id":"https://openalex.org/C103593891","wikidata":"https://www.wikidata.org/wiki/Q624546","display_name":"Entity\u2013relationship model","level":3,"score":0.573189914226532},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.5570717453956604},{"id":"https://openalex.org/C136886441","wikidata":"https://www.wikidata.org/wiki/Q926129","display_name":"Normalization (sociology)","level":2,"score":0.5442938208580017},{"id":"https://openalex.org/C162984825","wikidata":"https://www.wikidata.org/wiki/Q339072","display_name":"Database normalization","level":3,"score":0.529988706111908},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5037204623222351},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.45690053701400757},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4155942499637604},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.337928831577301},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.15674471855163574},{"id":"https://openalex.org/C73555534","wikidata":"https://www.wikidata.org/wiki/Q622825","display_name":"Cluster analysis","level":2,"score":0.08630281686782837},{"id":"https://openalex.org/C144024400","wikidata":"https://www.wikidata.org/wiki/Q21201","display_name":"Sociology","level":0,"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.1061/jtcedl.0000019","doi":"https://doi.org/10.1061/jtcedl.0000019","is_oa":false,"landing_page_url":"https://doi.org/10.1061/jtcedl.0000019","pdf_url":null,"source":{"id":"https://openalex.org/S4210239169","display_name":"Journal of Technical Topics in Civil Engineering","issn_l":"0733-9461","issn":["0733-9461","2694-0213"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310315747","host_organization_name":"American Society of Civil Engineers","host_organization_lineage":["https://openalex.org/P4310315747"],"host_organization_lineage_names":["American Society of Civil Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Technical Topics in Civil Engineering","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W142415471","https://openalex.org/W2359465177","https://openalex.org/W1574818954","https://openalex.org/W2514543912","https://openalex.org/W2241927008","https://openalex.org/W36342825","https://openalex.org/W2384223603","https://openalex.org/W2602282026","https://openalex.org/W2356481761","https://openalex.org/W2393138885"],"abstract_inverted_index":{"An":[0],"introduction":[1],"to":[2,10,25,64],"the":[3,11,14,27],"basic":[4],"issues":[5],"of":[6,13,35,53],"database":[7,16,46,68],"management":[8,47],"and":[9,57],"concepts":[12],"relational":[15,29,38],"model":[17],"is":[18,55],"presented.":[19],"Structural":[20],"engineering":[21],"examples":[22],"are":[23,49,62],"used":[24],"describe":[26],"principal":[28],"operations":[30],"for":[31,43,67],"data":[32,39],"retrieval.":[33],"Examples":[34],"an":[36],"available":[37],"retrieval":[40],"language":[41],"developed":[42],"a":[44],"current":[45],"system":[48],"provided.":[50],"The":[51],"process":[52],"normalization":[54],"analyzed,":[56],"6":[58],"different":[59],"normal":[60],"forms":[61],"described,":[63],"provide":[65],"guidelines":[66],"design.":[69]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2211230442","counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2016-06-24T00:00:00"}
