Knowledge (XXG)

Database-centric architecture

Source đź“ť

843: 833: 34:
play a crucial role. Often this description is meant to contrast the design to an alternative approach. For example, the characterization of an architecture as "database-centric" may mean any combination of the following:
136:
architectures that vary in the placement of business logic, concluding that a database-centric approach has practical advantages from the standpoint of ease of development and maintainability.
85:. The use of table-driven logic, i.e. behavior that is heavily dictated by the contents of a database, allows programs to be simpler and more flexible. This capability is a central feature of 738: 132:
should be placed at the back-end versus another tier is a subject of ongoing debate. For example, Toon Koppelaars presents a detailed analysis of alternative
876: 224: 635: 359: 40: 768: 578: 256: 206:. This architecture heavily uses the DBPL (Database Programming Language) of the RDBMS. An example of software with this architecture is 753: 450: 836: 866: 763: 748: 677: 631: 68: 743: 598: 545: 86: 656: 540: 156: 148: 799: 672: 568: 488: 207: 60: 67:, application developers have become increasingly reliant on standard database tools, especially for the sake of 871: 758: 563: 693: 230: 191: 160: 125: 641: 530: 443: 164: 715: 194:
that favors shared data models over allowing each application to have its own, idiosyncratic data model.
144: 27: 789: 651: 508: 809: 513: 846: 730: 720: 608: 414: 365: 140: 121: 44: 814: 794: 613: 590: 436: 406: 355: 285: 703: 523: 493: 396: 347: 277: 180: 168: 113: 82: 75: 64: 202:
has been proposed, in which the three classic layers of an application are kept within the
698: 646: 623: 535: 503: 498: 478: 152: 133: 117: 94: 52: 183:
computing, and explains how this design provides enhanced security, fault-tolerance, and
710: 603: 573: 483: 176: 129: 860: 418: 369: 219: 90: 56: 48: 314: 819: 351: 233:
paradigm, which makes the information used in a system the primary design driver.
171:
to achieve a high degree of reliability, performance, and capacity. For example,
184: 106: 339: 518: 410: 804: 98: 289: 555: 473: 459: 172: 102: 79: 31: 401: 384: 281: 268:
Lind P, Alm M (2006), "A database-centric virtual chemistry system",
175:
describes a database-centric distributed computing architecture for
237: 97:(i.e. not compiled statements) but could equally be read in from a 93:
for tables that are normally coded and embedded within programs as
203: 302: 120:, as opposed to greater reliance on logic running in middle-tier 432: 338:
Vicente, Alfonso; Etcheverry, Lorena; Sabiguero, Ariel (2021).
139:
using a shared database as the basis for communicating between
163:
is that it simplifies the design by utilizing DBMS-provided
63:
software, much of which is either free or included with the
428: 258:
A Database-centric approach to J2EE Application Development
159:. A potential benefit of database-centric architecture in 78:-driven logic, as opposed to logic embodied in previously 385:"In defense of extreme database-centric architecture" 344:
2021 XLVII Latin American Computing Conference (CLEI)
198:
Even an extreme database-centric architecture called
26:
has several distinct meanings, generally relating to
777: 729: 686: 665: 622: 589: 554: 466: 340:"An RDBMS-only architecture for web applications" 444: 8: 303:Database-Centric Grid and Cluster Computing 451: 437: 429: 400: 249: 59:. With the evolution of sophisticated 389:Memoria Investigaciones en IngenierĂ­a 41:relational database management system 7: 832: 147:applications, as opposed to direct 877:Distributed computing architecture 225:Data-centric programming languages 39:using a standard, general-purpose 14: 842: 841: 831: 383:Vicente, Alfonso (2023-06-30). 352:10.1109/CLEI53233.2021.9640017 43:, as opposed to customized in- 1: 785:Database-centric architecture 315:"The Data Centric Revolution" 87:dynamic programming languages 69:rapid application development 20:Database-centric Architecture 157:message-oriented middleware 149:inter-process communication 893: 800:Locks with ordered sharing 632:Entities and relationships 489:Database management system 208:Oracle Application Express 828: 678:Object–relational mapping 105:or even retrieved from a 24:data-centric architecture 238:datacentricmanifesto.org 161:distributed applications 231:data-driven programming 200:RDBMS-only architecture 192:enterprise architecture 126:multi-tier architecture 165:transaction processing 128:. The extent to which 28:software architectures 867:Software architecture 579:information retrieval 145:distributed computing 16:Software architecture 790:Intelligent database 599:Activity monitoring 122:application servers 769:Online real estate 141:parallel processes 854: 853: 815:Halloween Problem 795:Two-phase locking 754:Facial expression 673:Abstraction layer 614:Negative database 569:Data manipulation 402:10.36561/ing.24.9 361:978-1-6654-9503-5 282:10.1021/ci050360b 114:stored procedures 884: 845: 844: 835: 834: 453: 446: 439: 430: 423: 422: 404: 380: 374: 373: 346:. pp. 1–9. 335: 329: 328: 326: 325: 311: 305: 300: 294: 293: 270:J Chem Inf Model 265: 259: 254: 118:database servers 65:operating system 892: 891: 887: 886: 885: 883: 882: 881: 872:Data management 857: 856: 855: 850: 824: 773: 725: 682: 661: 618: 585: 564:Data definition 550: 462: 457: 427: 426: 382: 381: 377: 362: 337: 336: 332: 323: 321: 313: 312: 308: 301: 297: 267: 266: 262: 255: 251: 246: 216: 153:message passing 95:data structures 74:using dynamic, 53:data structures 17: 12: 11: 5: 890: 888: 880: 879: 874: 869: 859: 858: 852: 851: 829: 826: 825: 823: 822: 817: 812: 807: 802: 797: 792: 787: 781: 779: 775: 774: 772: 771: 766: 761: 756: 751: 746: 741: 735: 733: 727: 726: 724: 723: 718: 713: 708: 707: 706: 696: 694:Virtualization 690: 688: 684: 683: 681: 680: 675: 669: 667: 663: 662: 660: 659: 654: 649: 644: 639: 628: 626: 620: 619: 617: 616: 611: 606: 601: 595: 593: 587: 586: 584: 583: 582: 581: 571: 566: 560: 558: 552: 551: 549: 548: 543: 538: 533: 528: 527: 526: 521: 511: 506: 501: 496: 491: 486: 481: 476: 470: 468: 464: 463: 458: 456: 455: 448: 441: 433: 425: 424: 375: 360: 330: 306: 295: 260: 248: 247: 245: 242: 241: 240: 234: 227: 222: 220:Control tables 215: 212: 196: 195: 188: 155:functions and 137: 130:business logic 110: 91:control tables 72: 57:access methods 15: 13: 10: 9: 6: 4: 3: 2: 889: 878: 875: 873: 870: 868: 865: 864: 862: 849: 848: 839: 838: 827: 821: 818: 816: 813: 811: 808: 806: 803: 801: 798: 796: 793: 791: 788: 786: 783: 782: 780: 776: 770: 767: 765: 762: 760: 757: 755: 752: 750: 747: 745: 742: 740: 737: 736: 734: 732: 728: 722: 719: 717: 714: 712: 709: 705: 702: 701: 700: 697: 695: 692: 691: 689: 685: 679: 676: 674: 671: 670: 668: 664: 658: 655: 653: 650: 648: 645: 643: 642:Normalization 640: 637: 633: 630: 629: 627: 625: 621: 615: 612: 610: 607: 605: 602: 600: 597: 596: 594: 592: 588: 580: 577: 576: 575: 572: 570: 567: 565: 562: 561: 559: 557: 553: 547: 544: 542: 539: 537: 534: 532: 531:Administrator 529: 525: 522: 520: 517: 516: 515: 512: 510: 507: 505: 502: 500: 497: 495: 492: 490: 487: 485: 482: 480: 477: 475: 472: 471: 469: 465: 461: 454: 449: 447: 442: 440: 435: 434: 431: 420: 416: 412: 408: 403: 398: 394: 390: 386: 379: 376: 371: 367: 363: 357: 353: 349: 345: 341: 334: 331: 320: 316: 310: 307: 304: 299: 296: 291: 287: 283: 279: 276:(3): 1034–9, 275: 271: 264: 261: 257: 253: 250: 243: 239: 235: 232: 228: 226: 223: 221: 218: 217: 213: 211: 209: 205: 201: 193: 189: 186: 182: 178: 174: 170: 166: 162: 158: 154: 150: 146: 142: 138: 135: 131: 127: 123: 119: 115: 111: 108: 104: 100: 96: 92: 88: 84: 81: 77: 73: 70: 66: 62: 58: 54: 50: 46: 42: 38: 37: 36: 33: 29: 25: 21: 840: 830: 820:Log shipping 784: 764:Online music 749:Biodiversity 716:Preservation 474:Requirements 392: 388: 378: 343: 333: 322:. Retrieved 318: 309: 298: 273: 269: 263: 252: 199: 197: 134:Oracle-based 116:that run on 23: 19: 18: 837:WikiProject 666:Programming 657:Cardinality 652:Refactoring 509:Application 190:an overall 185:scalability 107:spreadsheet 89:. See also 861:Categories 810:Publishing 744:Biological 687:Management 519:datasource 514:Connection 324:2017-01-09 244:References 805:Load file 721:Integrity 711:Migration 638:notation) 609:Forensics 556:Languages 419:259690085 411:2301-1106 370:245387844 99:flat file 32:databases 30:in which 847:Category 778:See also 739:Academic 731:Lists of 636:Enhanced 591:Security 460:Database 319:TDAN.com 290:16711722 236:See the 214:See also 210:(APEX). 173:Base One 169:indexing 103:database 83:programs 80:compiled 704:caching 494:Machine 181:cluster 51:-based 759:Online 699:Tuning 647:Schema 624:Design 504:Server 499:Engine 484:Models 479:Theory 417:  409:  368:  358:  288:  112:using 45:memory 634:(and 604:Audit 574:Query 546:Tools 541:Types 415:S2CID 366:S2CID 204:RDBMS 124:in a 76:table 536:Lock 467:Main 407:ISSN 356:ISBN 286:PMID 229:The 179:and 177:grid 167:and 151:via 61:DBMS 55:and 49:file 524:DSN 397:doi 348:doi 278:doi 143:in 47:or 22:or 863:: 413:. 405:. 395:. 393:24 391:. 387:. 364:. 354:. 342:. 317:. 284:, 274:46 272:, 101:, 452:e 445:t 438:v 421:. 399:: 372:. 350:: 327:. 292:. 280:: 187:. 109:. 71:.

Index

software architectures
databases
relational database management system
memory
file
data structures
access methods
DBMS
operating system
rapid application development
table
compiled
programs
dynamic programming languages
control tables
data structures
flat file
database
spreadsheet
stored procedures
database servers
application servers
multi-tier architecture
business logic
Oracle-based
parallel processes
distributed computing
inter-process communication
message passing
message-oriented middleware

Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.

↑