{"id":"https://openalex.org/W26003341","doi":null,"title":"A relational database in neurosurgery.","display_name":"A relational database in neurosurgery.","publication_year":1995,"publication_date":"1995-01-01","ids":{"openalex":"https://openalex.org/W26003341","mag":"26003341","pmid":"https://pubmed.ncbi.nlm.nih.gov/8591240"},"language":"en","primary_location":{"id":"pmid:8591240","doi":null,"is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/8591240","pdf_url":null,"source":{"id":"https://openalex.org/S4306525036","display_name":"PubMed","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I1299303238","host_organization_name":"National Institutes of Health","host_organization_lineage":["https://openalex.org/I1299303238"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Medinfo. MEDINFO","raw_type":"Journal Article"},"volume":null,"type":"article","is_traditional":true,"indexed_in":["pubmed"],"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/A5037436639","display_name":"Francesco Sicurello","orcid":"https://orcid.org/0009-0008-7377-3916","observed_orcids":["https://orcid.org/0009-0008-7377-3916"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"F Sicurello","raw_affiliation_strings":["I.T.B.A. - C.N.R., Milano"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"I.T.B.A. - C.N.R., Milano","institution_ids":[]}]},{"author_position":"middle","author":{"id":null,"display_name":"M R Marchetti","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"M R Marchetti","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5071849640","display_name":"P Cazzaniga","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"P Cazzaniga","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.0035461,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":93},"biblio":{"volume":"8 Pt 1","issue":null,"first_page":"485","last_page":"485"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10350","display_name":"Electronic Health Records Systems","score":0.986299991607666,"subfield":{"id":"https://openalex.org/subfields/3605","display_name":"Health Information Management"},"field":{"id":"https://openalex.org/fields/36","display_name":"Health Professions"},"domain":{"id":"https://openalex.org/domains/4","display_name":"Health Sciences"}},"topics":[{"id":"https://openalex.org/T10350","display_name":"Electronic Health Records Systems","score":0.986299991607666,"subfield":{"id":"https://openalex.org/subfields/3605","display_name":"Health Information Management"},"field":{"id":"https://openalex.org/fields/36","display_name":"Health Professions"},"domain":{"id":"https://openalex.org/domains/4","display_name":"Health Sciences"}},{"id":"https://openalex.org/T14400","display_name":"Medical Coding and Health Information","score":0.01080000028014183,"subfield":{"id":"https://openalex.org/subfields/3605","display_name":"Health Information Management"},"field":{"id":"https://openalex.org/fields/36","display_name":"Health Professions"},"domain":{"id":"https://openalex.org/domains/4","display_name":"Health Sciences"}},{"id":"https://openalex.org/T12790","display_name":"Nursing Diagnosis and Documentation","score":0.0017000000225380063,"subfield":{"id":"https://openalex.org/subfields/2922","display_name":"Research and Theory"},"field":{"id":"https://openalex.org/fields/29","display_name":"Nursing"},"domain":{"id":"https://openalex.org/domains/4","display_name":"Health Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/neurosurgery","display_name":"neurosurgery","score":0.652999997138977},{"id":"https://openalex.org/keywords/relational-databases","display_name":"relational databases","score":0.9539999961853027},{"id":"https://openalex.org/keywords/electronic-health-records","display_name":"electronic health records","score":0.6610000133514404},{"id":"https://openalex.org/keywords/discharge-summaries","display_name":"discharge summaries","score":0.593999981880188},{"id":"https://openalex.org/keywords/medical-data-analysis","display_name":"medical data analysis","score":0.4300000071525574},{"id":"https://openalex.org/keywords/clinical-research-data","display_name":"clinical research data","score":0.5540000200271606},{"id":"https://openalex.org/keywords/default-values","display_name":"default values","score":0.5270000100135803},{"id":"https://openalex.org/keywords/medical-terminology-standardization","display_name":"medical terminology standardization","score":0.5139999985694885},{"id":"https://openalex.org/keywords/patient-data-retrieval","display_name":"patient data retrieval","score":0.35100001096725464}],"concepts":[{"id":"https://openalex.org/C145333580","wikidata":"https://www.wikidata.org/wiki/Q260946","display_name":"Anamnesis","level":2,"score":0.6367996335029602},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6280062198638916},{"id":"https://openalex.org/C154504017","wikidata":"https://www.wikidata.org/wiki/Q853614","display_name":"Identifier","level":2,"score":0.5464764833450317},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5087922215461731},{"id":"https://openalex.org/C2780385302","wikidata":"https://www.wikidata.org/wiki/Q367158","display_name":"Protocol (science)","level":3,"score":0.4968467056751251},{"id":"https://openalex.org/C9652623","wikidata":"https://www.wikidata.org/wiki/Q190109","display_name":"Field (mathematics)","level":2,"score":0.4689490497112274},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4646470248699188},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.4598267078399658},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.43529075384140015},{"id":"https://openalex.org/C19527891","wikidata":"https://www.wikidata.org/wiki/Q1120908","display_name":"Medical physics","level":1,"score":0.39895927906036377},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3684096932411194},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.35442522168159485},{"id":"https://openalex.org/C71924100","wikidata":"https://www.wikidata.org/wiki/Q11190","display_name":"Medicine","level":0,"score":0.2972039580345154},{"id":"https://openalex.org/C142724271","wikidata":"https://www.wikidata.org/wiki/Q7208","display_name":"Pathology","level":1,"score":0.13693976402282715},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.10451823472976685},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C126322002","wikidata":"https://www.wikidata.org/wiki/Q11180","display_name":"Internal medicine","level":1,"score":0.0},{"id":"https://openalex.org/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C204787440","wikidata":"https://www.wikidata.org/wiki/Q188504","display_name":"Alternative medicine","level":2,"score":0.0}],"mesh":[{"descriptor_ui":"D009493","descriptor_name":"Neurosurgery","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D016208","descriptor_name":"Databases, Factual","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D016347","descriptor_name":"Medical Records Systems, Computerized","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true}],"locations_count":2,"locations":[{"id":"pmid:8591240","doi":null,"is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/8591240","pdf_url":null,"source":{"id":"https://openalex.org/S4306525036","display_name":"PubMed","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I1299303238","host_organization_name":"National Institutes of Health","host_organization_lineage":["https://openalex.org/I1299303238"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Medinfo. MEDINFO","raw_type":"Journal Article"},{"id":"mag:26003341","doi":null,"is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/8591240","pdf_url":null,"source":{"id":"https://openalex.org/S4306525036","display_name":"PubMed","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I1299303238","host_organization_name":"National Institutes of Health","host_organization_lineage":["https://openalex.org/I1299303238"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"PubMed","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Good health and well-being","id":"https://metadata.un.org/sdg/3","score":0.8371999859809875}],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2418942649","https://openalex.org/W1981924258","https://openalex.org/W2407393383","https://openalex.org/W2044932582","https://openalex.org/W2404194637","https://openalex.org/W1966069420","https://openalex.org/W2152548776","https://openalex.org/W2460150973","https://openalex.org/W2412330571","https://openalex.org/W2398244273"],"abstract_inverted_index":{"UNLABELLED:":[0],"This":[1,29,121],"paper":[2],"describes":[3,287],"teh":[4],"automatic":[5],"procedure":[6],"for":[7,38,116,128,324,393,473],"a":[8,13,57,65,72,165,252,267,288,319,387,427,435,482,486,494,506,510,529,536,540,550,561],"clinical":[9,27,45,51,84,478],"record":[10,18,52,85,277],"management":[11,25,425],"in":[12,195,202,251,458,520,549],"Neurosurgery":[14],"ward.":[15],"The":[16,50,79,104,167,211,351,419,445],"automated":[17,118,215],"allows":[19,410],"the":[20,33,83,87,93,102,117,139,160,174,178,188,192,203,225,231,239,306,329,333,343,372,377,383,394,407,438,443,451,466,490,514,521,526,533,545,558,566,583],"storage,":[21],"querying":[22],"and":[23,36,41,47,64,98,150,154,176,209,216,218,236,298,309,347,364,403,437,523,552,571],"effective":[24],"of":[26,82,101,106,133,141,164,180,191,234,242,271,290,386,406,453,512,516,532,568,599],"data.":[28,142],"is":[30,53,69,109,123,228,274,303,337,357,389,456,463,497,503,518,556,573,586],"useful":[31],"during":[32,525],"patient":[34,63,129,334,388],"stay":[35],"also":[37],"data":[39,59,66,100,341,368,385,424],"processing":[40],"analysis":[42],"aiming":[43],"at":[44,535,590],"research":[46,395],"statistical":[48],"studies.":[49],"problem-oriented.":[54],"It":[55,339],"contains":[56,92,159,185,206,294,348],"minimum":[58],"set":[60,67],"regarding":[61],"every":[62],"which":[68,172,543,564,572,595],"defined":[70],"by":[71,269,575],"classification":[73,285,320,428],"nomenclature":[74,321],"(using":[75],"an":[76,126],"inner":[77],"protocol).":[78],"main":[80],"parts":[81],"are":[86,199,214,249,421,470],"following":[88],"tables:":[89],"PERSONAL":[90],"DATA:":[91],"fields":[94,108],"relating":[95],"to":[96,138,220,265,276,281,305,315,332,366,375,442,468,505,588],"personal":[97],"admission":[99],"patient.":[103,166,193],"compilation":[105,175],"some":[107,246,311],"compulsory":[110],"because":[111,423,465,501],"they":[112],"serve":[113],"as":[114,125,391,509],"input":[115],"discharge":[119],"letter.":[120],"table":[122],"used":[124,323],"identifier":[127],"retrieval.":[130],"ANAMNESIS:":[131],"composed":[132],"five":[134],"different":[135,597],"tables":[136],"according":[137],"kind":[140,233,241,452],"They":[143],"are:":[144],"familiar":[145],"anamnesis,":[146,148,153],"physiological":[147],"past":[149],"next":[151],"pathology":[152,268],"trauma":[155],"anamnesis.":[156],"GENERAL":[157],"OBJECTIVITY:":[158],"general":[161,232],"physical":[162],"information":[163,186,226,352,446,600],"field":[168],"hold":[169],"default":[170,200],"values,":[171],"quickens":[173],"assures":[177],"recording":[179,227],"normal":[181],"values.":[182],"NEUROLOGICAL":[183],"EXAMINATION:":[184],"about":[187],"neurological":[189],"status":[190],"Also":[194],"this":[196,317,367],"table,":[197],"ther":[198],"values":[201,279],"fields.":[204],"COMA:":[205],"standardized":[207],"ata":[208],"classifications.":[210],"multiple":[212],"choices":[213],"driven":[217],"belong":[219],"homogeneous":[221],"classes.":[222],"SURGICAL":[223],"OPERATIONS:":[224],"made":[229],"defining":[230,238],"operation":[235],"then":[237],"peculiar":[240],"operation.":[243],"INSTRUMENTAL":[244],"EXAMINATIONS:":[245],"examination":[247],"results":[248],"recorded":[250],"free":[253],"structure,":[254],"while":[255],"other":[256],"ones":[257],"(TAC,":[258],"etc.)":[259,363],"follow":[260],"codified":[261],"structure.":[262],"In":[263,313,476],"order":[264,314],"identify":[266],"means":[270],"TAC,":[272],"it":[273,496,502,585],"enough":[275],"three":[278,282],"corresponding":[280],"variables.":[283],"THis":[284],"fully":[286],"lot":[289],"neurosurgical":[291],"pathologies.":[292],"DISCHARGE:":[293],"conclusions,":[295],"therapies,":[296],"result,":[297],"hospital":[299],"course.":[300],"Medical":[301],"language":[302,580],"closer":[304],"natural":[307],"one":[308],"presents":[310,493],"abiguities.":[312],"solve":[316],"problem,":[318],"was":[322],"diagnosis":[325],"definition.":[326],"DISCHARGE":[327],"LETTER:":[328],"document":[330],"given":[331],"when":[335,371],"he":[336,355],"discharged.":[338],"extracts":[340],"from":[342],"previously":[344],"described":[345],"modules":[346],"standard":[349],"headings.":[350],"stored":[353],"int":[354],"database":[356],"structured":[358],"(e.g.,":[359],"diagnosis,":[360],"name,":[361],"surname,":[362],"access":[365],"takes":[369,432],"place":[370,433],"user":[373],"wants":[374],"search":[376],"database,":[378],"using":[379],"particular":[380],"queries":[381,413,420],"where":[382],"identifying":[384],"put":[390],"conditions":[392],"(SELECT":[396],"age,":[397],"name":[398],"WHERE":[399],"diagnosis=\"TRAUMA\").":[400],"Logical":[401],"operators":[402],"relational":[404,408,487,541],"algebra":[405],"DBMS":[409,439,542],"more":[411],"complex":[412],"((diagnosis=\"TRAUMA\"":[414],"AND":[415],"age=\"19\")":[416],"OR":[417],"sex=\"M\").":[418],"deterministic,":[422],"uses":[426],"nomenclature.":[429],"Data":[430],"retrieval":[431,447,461],"through":[434],"matching,":[436],"answers":[440],"directly":[441],"queries.":[444],"speed":[448],"depends":[449],"upon":[450],"system":[454,534],"that":[455],"used;":[457],"our":[459],"case":[460],"time":[462],"low":[464],"accesses":[467],"disk":[469],"few":[471],"even":[472],"big":[474],"databases.":[475],"medicine,":[477],"records":[479],"can":[480],"have":[481,589],"hierarchical":[483,491],"structure":[484],"and/or":[485],"one.":[488],"Nevertheless,":[489],"model":[492],"disadvantage:":[495],"not":[498,524],"very":[499],"flexible":[500],"linked":[504],"pre-defined":[507],"structure;":[508],"matter":[511],"fact,":[513],"definition":[515],"path":[517],"established":[519],"beginning":[522],"execution.":[527],"Thus,":[528],"better":[530],"representation":[531],"logical":[537],"level":[538],"requries":[539],"exploits":[544,565],"relationships":[546],"between":[547],"entities":[548],"vertical":[551],"horizontal":[553],"way.":[554],"That":[555],"why":[557],"developers":[559],"adopted":[560],"mixed":[562],"strategy":[563],"advantages":[567],"both":[569],"models":[570],"provided":[574],"M":[576],"Technology":[577],"with":[578],"SQL":[579],"(M/SQL).":[581],"For":[582],"future,":[584],"important":[587],"one's":[591],"disposal":[592],"multimedia":[593],"technologies,":[594],"integrate":[596],"kinds":[598],"(alp":[601]},"counts_by_year":[{"year":2019,"cited_by_count":1}],"updated_date":"2026-10-31T12:09:11.096373","created_date":"2016-06-24T00:00:00"}