Publication Information

{'id': 'https://openalex.org/W2132476035', 'doi': None, 'title': "A Developer's Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008", 'display_name': "A Developer's Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008", 'publication_year': 2008, 'publication_date': '2008-06-24', 'ids': {'openalex': 'https://openalex.org/W2132476035', 'mag': '2132476035'}, 'language': 'en', 'primary_location': {'is_oa': False, 'landing_page_url': "https://openlibrary.org/books/OL18743310M/A_developer's_guide_to_data_modeling_for_SQL_server", 'pdf_url': None, 'source': None, 'license': None, 'license_id': None, 'version': None, 'is_accepted': False, 'is_published': False}, 'type': 'book', 'type_crossref': 'book', 'indexed_in': [], 'open_access': {'is_oa': False, 'oa_status': 'closed', 'oa_url': None, 'any_repository_has_fulltext': False}, 'authorships': [{'author_position': 'first', 'author': {'id': 'https://openalex.org/A5103278816', 'display_name': 'Eric F. Johnson', 'orcid': 'https://orcid.org/0000-0001-9028-4251'}, 'institutions': [], 'countries': [], 'is_corresponding': False, 'raw_author_name': 'Eric Johnson', 'raw_affiliation_strings': [], 'affiliations': []}, {'author_position': 'last', 'author': {'id': 'https://openalex.org/A5086540292', 'display_name': 'J. Steven Jones', 'orcid': None}, 'institutions': [], 'countries': [], 'is_corresponding': False, 'raw_author_name': 'Joshua Jones', 'raw_affiliation_strings': [], 'affiliations': []}], 'institution_assertions': [], 'countries_distinct_count': 0, 'institutions_distinct_count': 0, 'corresponding_author_ids': [], 'corresponding_institution_ids': [], 'apc_list': None, 'apc_paid': None, 'fwci': 0.0, 'has_fulltext': False, 'cited_by_count': 1, 'citation_normalized_percentile': {'value': 0.431018, 'is_in_top_1_percent': False, 'is_in_top_10_percent': False}, 'cited_by_percentile_year': {'min': 63, 'max': 71}, 'biblio': {'volume': None, 'issue': None, 'first_page': None, 'last_page': None}, 'is_retracted': False, 'is_paratext': False, 'primary_topic': {'id': 'https://openalex.org/T10317', 'display_name': 'Data Stream Management Systems and Techniques', 'score': 0.8245, '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': 'Data Stream Management Systems and Techniques', 'score': 0.8245, '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'}}], 'keywords': [{'id': 'https://openalex.org/keywords/column-oriented-database-systems', 'display_name': 'Column-oriented Database Systems', 'score': 0.553868}, {'id': 'https://openalex.org/keywords/relational-database-systems', 'display_name': 'Relational Database Systems', 'score': 0.546964}, {'id': 'https://openalex.org/keywords/boss', 'display_name': 'Boss', 'score': 0.5283126}, {'id': 'https://openalex.org/keywords/sql-server', 'display_name': 'Sql server', 'score': 0.45840222}, {'id': 'https://openalex.org/keywords/database-administrator', 'display_name': 'Database administrator', 'score': 0.41087103}], 'concepts': [{'id': 'https://openalex.org/C41008148', 'wikidata': 'https://www.wikidata.org/wiki/Q21198', 'display_name': 'Computer science', 'level': 0, 'score': 0.68432766}, {'id': 'https://openalex.org/C510870499', 'wikidata': 'https://www.wikidata.org/wiki/Q47607', 'display_name': 'SQL', 'level': 2, 'score': 0.6615738}, {'id': 'https://openalex.org/C136764020', 'wikidata': 'https://www.wikidata.org/wiki/Q466', 'display_name': 'World Wide Web', 'level': 1, 'score': 0.5811032}, {'id': 'https://openalex.org/C2777020290', 'wikidata': 'https://www.wikidata.org/wiki/Q4947493', 'display_name': 'Boss', 'level': 2, 'score': 0.5283126}, {'id': 'https://openalex.org/C5655090', 'wikidata': 'https://www.wikidata.org/wiki/Q192588', 'display_name': 'Relational database', 'level': 2, 'score': 0.50849926}, {'id': 'https://openalex.org/C77088390', 'wikidata': 'https://www.wikidata.org/wiki/Q8513', 'display_name': 'Database', 'level': 1, 'score': 0.4875981}, {'id': 'https://openalex.org/C554936623', 'wikidata': 'https://www.wikidata.org/wiki/Q199657', 'display_name': 'Reading (process)', 'level': 2, 'score': 0.46683633}, {'id': 'https://openalex.org/C2984286706', 'wikidata': 'https://www.wikidata.org/wiki/Q400708', 'display_name': 'Sql server', 'level': 2, 'score': 0.45840222}, {'id': 'https://openalex.org/C24394798', 'wikidata': 'https://www.wikidata.org/wiki/Q192588', 'display_name': 'Relational database management system', 'level': 3, 'score': 0.4534292}, {'id': 'https://openalex.org/C70236469', 'wikidata': 'https://www.wikidata.org/wiki/Q1078262', 'display_name': 'Database administrator', 'level': 2, 'score': 0.41087103}, {'id': 'https://openalex.org/C127413603', 'wikidata': 'https://www.wikidata.org/wiki/Q11023', 'display_name': 'Engineering', 'level': 0, 'score': 0.20250294}, {'id': 'https://openalex.org/C78519656', 'wikidata': 'https://www.wikidata.org/wiki/Q101333', 'display_name': 'Mechanical engineering', 'level': 1, 'score': 0.0}, {'id': 'https://openalex.org/C199539241', 'wikidata': 'https://www.wikidata.org/wiki/Q7748', 'display_name': 'Law', 'level': 1, 'score': 0.0}, {'id': 'https://openalex.org/C17744445', 'wikidata': 'https://www.wikidata.org/wiki/Q36442', 'display_name': 'Political science', 'level': 0, 'score': 0.0}], 'mesh': [], 'locations_count': 1, 'locations': [{'is_oa': False, 'landing_page_url': "https://openlibrary.org/books/OL18743310M/A_developer's_guide_to_data_modeling_for_SQL_server", 'pdf_url': None, 'source': None, 'license': None, 'license_id': None, 'version': None, 'is_accepted': False, 'is_published': False}], 'best_oa_location': None, 'sustainable_development_goals': [{'score': 0.45, 'id': 'https://metadata.un.org/sdg/4', 'display_name': 'Quality education'}], 'grants': [], 'datasets': [], 'versions': [], 'referenced_works_count': 0, 'referenced_works': [], 'related_works': ['https://openalex.org/W592861676', 'https://openalex.org/W41353397', 'https://openalex.org/W2976602204', 'https://openalex.org/W2749349904', 'https://openalex.org/W2473726556', 'https://openalex.org/W2464124314', 'https://openalex.org/W2460821513', 'https://openalex.org/W2380041392', 'https://openalex.org/W2310314275', 'https://openalex.org/W2291106234', 'https://openalex.org/W2282090486', 'https://openalex.org/W2267554628', 'https://openalex.org/W2254187490', 'https://openalex.org/W2251924285', 'https://openalex.org/W2234182594', 'https://openalex.org/W2176376458', 'https://openalex.org/W2068661518', 'https://openalex.org/W189554500', 'https://openalex.org/W1854458806', 'https://openalex.org/W1582283863'], 'abstract_inverted_index': {'“Eric': [0, 378], 'and': [1, 13, 38, 49, 56, 67, 75, 94, 235, 253, 280, 297, 323, 358, 375, 380, 438, 457, 494, 523, 542, 567, 637, 650, 675, 687, 695, 706], 'Joshua': [2, 381], 'do': [3, 16, 121, 285], 'an': [4, 656], 'excellent': [5, 267], 'job': [6, 124, 288], 'explaining': [7, 290], 'the': [8, 32, 141, 147, 156, 167, 177, 212, 215, 239, 270, 291, 312, 356, 368, 388, 394, 410, 556, 591], 'importance': [9], 'of': [10, 91, 125, 137, 155, 214, 293, 360, 387, 390, 400, 555, 593, 599], 'data': [11, 89, 361, 391, 406, 443, 480, 517, 540, 558, 620, 642, 670], 'modeling': [12, 296, 362, 392, 444, 466, 481, 518, 559, 664], 'how': [14, 128, 151, 298, 309, 328, 569], 'to': [15, 30, 42, 51, 129, 144, 152, 181, 219, 225, 242, 249, 269, 310, 317, 326, 329, 349, 371, 405, 412, 447, 459, 468, 498, 504, 516, 570, 617, 626, 667], 'it': [17], 'correctly.': [18], 'Rather': [19], 'than': [20], 'relying': [21], 'only': [22], 'on': [23, 415, 470], 'academic': [24], 'concepts,': [25, 417], 'they': [26, 299], 'use': [27], 'real-world': [28, 157, 492], 'examples': [29, 603], 'illustrate': [31], 'important': [33], 'concepts': [34, 357], 'that': [35, 97, 160, 274, 315, 366, 396, 449, 486, 589, 702], 'many': [36, 602], 'database': [37, 53, 101, 271, 295, 322], 'application': [39], 'developers': [40], 'tend': [41], 'ignore.': [43], 'The': [44, 119, 283], 'writing': [45], 'style': [46], 'is': [47, 107, 173, 176, 211, 264, 420, 445, 510], 'conversational': [48], 'accessible': [50, 370], 'both': [52, 278], 'design': [54, 158, 272], 'novices': [55, 279], 'seasoned': [57], 'pros': [58], 'alike.': [59], 'Readers': [60], 'who': [61], 'are': [62, 604], 'responsible': [63], 'for': [64, 95, 109, 277, 352, 421, 507, 519, 532, 606, 659], 'designing,': [65], 'implementing,': [66], 'managing': [68], 'databases': [69, 374, 451, 467, 544], 'will': [70, 275, 452], 'benefit': [71], 'greatly': [72], 'from': [73, 133, 334, 545, 608, 624], "Joshua's": [74], "Eric's": [76], 'expertise.”': [77], '-Anil': [78], 'Desai,': [79, 82], 'Consultant,': [80, 204], 'Anil': [81], 'Inc.': [83, 207, 345], '“Almost': [84], 'every': [85, 520], 'IT': [86, 205], 'project': [87, 132, 194, 247], 'involves': [88], 'storage': [90, 625, 672], 'some': [92, 154], 'kind,': [93], 'most': [96, 592], 'means': [98], 'a': [99, 110, 122, 131, 192, 233, 250, 254, 265, 286, 321, 331, 364, 384, 511, 551, 609, 647], 'relational': [100, 294], 'management': [102], 'system': [103], '(RDBMS).': [104], 'This': [105, 175, 230, 305, 525, 613], 'book': [106, 178, 231, 306, 419, 526, 614], 'written': [108, 224], 'database-centric': [111], 'audience': [112], '(database': [113], 'modelers,': [114], 'architects,': [115], 'designers,': [116], 'developers,': [117], 'etc.).': [118], 'authors': [120, 284], 'great': [123, 251], 'showing': [126], 'us': [127, 308], 'take': [130], 'its': [134, 416], 'initial': [135], 'stages': [136], 'requirements': [138, 565, 572, 652], 'gathering': [139, 566], 'all': [140], 'way': [142, 148], 'through': [143, 166, 564, 683], 'implementation.': [145], 'Along': [146], 'we': [149, 164], 'learn': [150], 'handle': [153], 'issues': [159], 'typically': [161], 'surface': [162], 'as': [163], 'go': [165], 'process.': [168], '“The': [169, 208], 'bottom': [170], 'line': [171], 'here': [172], 'simple.': [174], 'you': [179, 528, 616], 'want': [180], 'have': [182, 191, 316], 'just': [183], 'finished': [184], 'reading': [185], 'when': [186], 'your': [187, 198, 244, 450, 619], 'boss': [188], 'says': [189], "'We": [190], 'new': [193, 404, 534], 'I': [195], 'would': [196], 'like': [197], 'help': [199], "with.'”": [200], '-Ronald': [201], 'Landers,': [202], 'Technical': [203], 'Professionals,': [206], 'Data': [209, 350, 505], 'Model': [210, 429], 'foundation': [213], 'application.': [216], "I'm": [217], 'pleased': [218], 'see': [220], 'additional': [221], 'books': [222], 'being': [223], 'address': [226], 'this': [227, 418, 600], 'critical': [228], 'phase.': [229], 'presents': [232], 'balanced': [234], 'pragmatic': [236], 'view': [237], 'with': [238, 363, 393, 398, 550], 'right': [240], 'priorities': [241], 'get': [243], 'SQL': [245, 259, 340, 353, 430, 472, 489, 508, 513, 538, 575, 594, 690], 'server': [246], 'off': [248], 'start': [252], 'long': [255], 'life.”': [256], '-Paul': [257], 'Nielsen,': [258], 'Server': [260, 341, 354, 431, 473, 509, 539, 576], 'MVP,': [261], 'SQLServerBible.com': [262], '“This': [263], 'truly': [266], 'introduction': [268], 'methodology': [273, 658], 'work': [276], 'advanced': [281], 'designers.': [282], 'good': [287], 'at': [289, 646], 'basics': [292], 'fit': [300], 'into': [301, 573, 586], 'modern': [302], 'business': [303, 313, 685], 'architecture.': [304], 'teaches': [307], 'identify': [311], 'problems': [314, 665], 'be': [318], 'satisfied': [319], 'by': [320], 'then': [324], 'proceeds': [325], 'explain': [327], 'build': [330], 'solid': [332], 'solution': [333], 'scratch.”': [335], '-Alexzander': [336], 'N.': [337], 'Nepomnjashiy,': [338], 'Microsoft': [339, 471], 'DBA,': [342], 'NeoSystems': [343], 'North-West,': [344], '“A': [346], "Developer's": [347, 502], 'Guide': [348, 503], 'Modeling': [351, 506], 'explains': [355], 'practice': [359], 'clarity': [365], 'makes': [367], 'technology': [369], 'anyone': [372], 'building': [373], 'data-driven': [376], 'applications.': [377], 'Johnson': [379], 'Jones': [382], 'combine': [383], 'deep': [385], 'understanding': [386], 'science': [389], 'art': [395], 'comes': [397], 'years': [399], 'experience.': [401], 'If': [402], "you're": [403, 465], 'modeling,': [407], 'or': [408, 475, 478], 'find': [409], 'need': [411], 'brush': [413], 'up': [414], 'you.”': [422], '-Peter': [423], 'Varhol,': [424], 'Executive': [425], 'Editor,': [426], 'Redmond': [427], 'Magazine': [428], 'Databases': [432], 'That': [433], 'Work': [434], 'Better,': [435], 'Do': [436], 'More,': [437], 'Evolve': [439], 'More': [440], 'Smoothly': [441], 'Effective': [442], 'essential': [446], 'ensuring': [448], 'perform': [453], 'well,': [454, 456], 'scale': [455], 'evolve': [458], 'meet': [460], 'changing': [461], 'requirements.': [462], 'However,': [463], 'if': [464], 'run': [469], '2008': [474], '2005,': [476], 'theoretical': [477], 'platform-agnostic': [479], 'knowledge': [482], "isn't": [483], 'enough:': [484], 'models': [485, 585, 588, 662], "don't": [487], 'reflect': [488], "Server's": [490, 595, 691], 'unique': [491, 692], 'strengths': [493], 'weaknesses': [495], 'often': [496], 'lead': [497], 'disastrous': [499], 'performance.': [500], 'A': [501], 'practical,': [512], 'Server-specific': [514], 'guide': [515], 'developer,': [521], 'architect,': [522], 'administrator.': [524], 'offers': [527], 'invaluable': [529], 'start-to-finish': [530], 'guidance': [531], 'designing': [533], 'databases,': [535], 'redesigning': [536], 'existing': [537], 'models,': [541, 643], 'migrating': [543], 'other': [546], 'platforms.': [547], "You'll": [548], 'begin': [549], 'concise,': [552], 'practical': [553], 'overview': [554], 'core': [557], 'techniques.': [560], 'Next,': [561], "you'll": [562, 580], 'walk': [563], 'discover': [568], 'convert': [571], 'effective': [574, 657], 'logical': [577, 584, 661], 'models.': [578], 'Finally,': [579], 'systematically': [581], 'transform': [582], 'those': [583], 'physical': [587, 622, 678], 'make': [590], 'extended': [596], 'functionality.': [597], 'All': [598], "book's": [601], 'available': [605], 'download': [607], 'companion': [610], 'Web': [611], 'site.': [612], 'enables': [615], 'Understand': [618], "model's": [621], 'elements,': [623], 'referential': [627], 'integrity': [628], 'Provide': [629], 'programmability': [630], 'via': [631], 'stored': [632], 'procedures,': [633], 'user-defined': [634], 'functions,': [635], 'triggers,': [636], '.NET': [638], 'CLR': [639], 'integration': [640], 'Normalize': [641], 'one': [644], 'step': [645], 'time': [648], 'Gather': [649], 'interpret': [651], 'more': [653], 'effectively': [654], 'Learn': [655], 'creating': [660], 'Overcome': [663], 'related': [666], 'entities,': [668], 'attribute,': [669], 'types,': [671], 'overhead,': [673], 'performance,': [674], 'relationships': [676], 'Create': [677, 699], 'models-from': [679], 'establishing': [680], 'naming': [681], 'guidelines': [682], 'implementing': [684], 'rules': [686], 'constraints': [688], 'Use': [689], 'indexing': [693], 'capabilities,': [694], 'overcome': [696], 'their': [697], 'limitations': [698], 'abstraction': [700], 'layers': [701], 'enhance': [703], 'security,': [704], 'extensibility,': [705], 'flexibility': [707]}, 'cited_by_api_url': 'https://api.openalex.org/works?filter=cites:W2132476035', 'counts_by_year': [{'year': 2019, 'cited_by_count': 1}], 'updated_date': '2024-09-14T16:57:12.357991', 'created_date': '2016-06-24'}