Knowledge

Multi-model database

Source đź“ť

145:" approach of knitting together multiple database products, each handing a different model, to achieve a multi-model capability as described by Martin Fowler. This strategy has two major disadvantages: it leads to a significant increase in operational complexity, and there is no support for maintaining data consistency across the separate data stores, so multi-model databases have begun to fill in this gap. 194:
must be able to synchronize updates across multiple keys. ACID transactions, if they are sufficiently performant, allow such synchronization. JSON documents, graphs, and relational tables can all be implemented in a manner that inherits the horizontal scalability and fault-tolerance of the underlying data store.
193:
In addition to offering multiple data models in a single data store, some databases allow developers to easily define custom data models. This capability is enabled by ACID transactions with high performance and scalability. In order for a custom data model to support concurrent updates, the database
157:
As more and more platforms are proposed to deal with multi-model data, there are a few works on benchmarking multi-model databases. For instance, Pluciennik, Oliveira, and UniBench reviewed existing multi-model databases and made an evaluation effort towards comparing multi-model databases and other
140:
in the early 1990s and in a more broader scope even to federated and integrated DBMSs in the early 1980s. An ORDBMS system manages different types of data such as relational, object, text and spatial by plugging domain specific data types, functions and index implementations into the DBMS kernels. A
180:
The main difference between the available multi-model databases is related to their architectures. Multi-model databases can support different models either within the engine or via different layers on top of the engine. Some products may provide an engine which supports documents and graphs while
117:
models that are non-relational, including documents, triples, key–value stores and graphs are popular. Arguably, geospatial data, temporal data, and text data are also separate models, though indexed, queryable text data is generally termed a
148:
Multi-model databases are intended to offer the data modeling advantages of polyglot persistence, without its disadvantages. Operational complexity, in particular, is reduced through the use of a single data store.
166:
they can employ a unified query language such as AQL, Orient SQL, SQL/XML, SQL/JSON to retrieve correlated multi-model data, such as graph-JSON-key/value, XML-relational, and JSON-relational in a single
31:
against a single, integrated backend. In contrast, most database management systems are organized around a single data model that determines how data can be organized, stored, and manipulated.
86:
A multi-model database is a database that can store, index and query data in more than one model. For some time, databases have primarily supported only one model, such as:
105:
For some time, it was all but forgotten (or considered irrelevant) that there were any other database models besides relational. The relational model and notion of
133:". Luca Garulli envisioned the evolution of the 1st generation NoSQL products into new products with more features able to be used by multiple use cases. 158:
SQL and NoSQL databases respectively. They pointed out that the advantages of multi-model databases over single-model databases are as follows :
414: 427: 487: 126: 462: 163:
they are able to ingest a variety of data formats such as CSV (including Graph, Relational), JSON into storage without any additional efforts.
377:
Fábio Roberto Oliveira, Luis del Val Cura. "Performance Evaluation of NoSQL Multi-Model Data Stores in Polyglot Persistence Applications".
109:
were the default standard for all data storage. However, prior to the dominance of relational data modeling, from about 1980 to 2005, the
502: 223: 307: 125:
The first time the word "multi-model" has been associated to the databases was on May 30, 2012 in Cologne, Germany, during the
472: 295: 182: 321: 203: 457: 281: 181:
others provide layers on top of a key-key store. With a layered architecture, each data model is provided via its own
507: 522: 137: 467: 438: 517: 110: 64: 24: 253: 91: 76: 32: 497: 248: 527: 44: 408: 393: 238: 228: 142: 75:
databases became prominent after 2009. NoSQL databases use a variety of data models, with
8: 452: 350: 87: 40: 492: 532: 106: 47:
models are examples of data models that may be supported by a multi-model database.
463:
ODBMS, "On Multi-Model Databases. Interview with Martin Schönert and Frank Celler."
263: 56: 243: 68: 512: 258: 170:
they are able to support multi-model ACID transactions in the stand-alone mode.
95: 80: 36: 28: 481: 233: 119: 60: 362:
Ewa Pluciennik and Kamil Zgorzalek. "The Multi-model Databases - A Review".
391: 458:
The 451 Group, "Neither Fish Nor Fowl: The Rise of Multi-Model Databases"
282:
The 451 Group, "Neither Fish Nor Fowl: The Rise of Multi-Model Databases"
99: 376: 394:"UniBench: A Benchmark for Multi-Model Database Management Systems" 213: 361: 218: 114: 72: 208: 141:
multi-model database is most directly a response to the "
102:. A database that combines many of these is multi-model. 322:"Nosql Matters Conference 2012 | NoSQL Matters CGN 2012" 136:
The idea of multi-model databases can be traced back to
468:
ODBMS, "Polyglot Persistence or Multiple Data Models?"
439:
ODBMS, "Polyglot Persistence or Multiple Data Models?"
152: 59:data model became popular after its publication by 138:Object–Relational Data Management Systems (ORDBMS) 473:Infoworld, "The Rise of the Multi-Model Database" 392:Chao Zhang, Jiaheng Lu, Pengfei Xu, Yuxing Chen. 296:Infoworld, "The Rise of the Multi-Model Database" 479: 413:: CS1 maint: multiple names: authors list ( 113:was commonly used. Since 2000 or 2010, many 63:in 1970. Due to increasing requirements for 188: 346: 344: 224:Comparison of structured storage software 432: 341: 480: 291: 289: 275: 131:NoSQL Adoption – What’s the Next Step? 83:, and key–value models being popular. 488:Applications of distributed computing 308:"Multi-Model storage 1/2 one product" 286: 204:Comparison of multi-model databases 19:In the field of database design, a 13: 503:Distributed computing architecture 153:Benchmarking multi-model databases 14: 544: 446: 175: 421: 385: 370: 355: 314: 300: 1: 269: 50: 27:designed to support multiple 7: 197: 111:hierarchical database model 10: 549: 254:Document-oriented database 122:" rather than a database. 92:document-oriented database 25:database management system 16:Database management system 189:User-defined data models 508:Distributed data stores 249:Distributed transaction 523:Transaction processing 329:2012.nosql-matters.org 65:horizontal scalability 453:Polyglot Persistence 351:Polyglot Persistence 239:Distributed database 229:Database transaction 143:polyglot persistence 21:multi-model database 88:relational database 518:Structured storage 107:third normal form 540: 441: 436: 430: 425: 419: 418: 412: 404: 398: 389: 383: 382: 374: 368: 367: 359: 353: 348: 339: 338: 336: 335: 326: 318: 312: 311: 304: 298: 293: 284: 279: 264:Relational model 548: 547: 543: 542: 541: 539: 538: 537: 498:Data management 478: 477: 449: 444: 437: 433: 426: 422: 406: 405: 396: 390: 386: 375: 371: 360: 356: 349: 342: 333: 331: 324: 320: 319: 315: 306: 305: 301: 294: 287: 280: 276: 272: 244:Distributed SQL 200: 191: 178: 173: 155: 69:fault tolerance 53: 17: 12: 11: 5: 546: 536: 535: 530: 525: 520: 515: 510: 505: 500: 495: 490: 476: 475: 470: 465: 460: 455: 448: 447:External links 445: 443: 442: 431: 420: 384: 369: 354: 340: 313: 299: 285: 273: 271: 268: 267: 266: 261: 259:Graph database 256: 251: 246: 241: 236: 231: 226: 221: 216: 211: 206: 199: 196: 190: 187: 177: 174: 172: 171: 168: 164: 160: 154: 151: 96:graph database 52: 49: 15: 9: 6: 4: 3: 2: 545: 534: 531: 529: 528:Data analysis 526: 524: 521: 519: 516: 514: 511: 509: 506: 504: 501: 499: 496: 494: 491: 489: 486: 485: 483: 474: 471: 469: 466: 464: 461: 459: 456: 454: 451: 450: 440: 435: 429: 424: 416: 410: 402: 395: 388: 380: 373: 365: 358: 352: 347: 345: 330: 323: 317: 310:. 2012-06-01. 309: 303: 297: 292: 290: 283: 278: 274: 265: 262: 260: 257: 255: 252: 250: 247: 245: 242: 240: 237: 235: 234:Data analysis 232: 230: 227: 225: 222: 220: 217: 215: 212: 210: 207: 205: 202: 201: 195: 186: 184: 169: 165: 162: 161: 159: 150: 146: 144: 139: 134: 132: 129:'s key note " 128: 123: 121: 120:search engine 116: 112: 108: 103: 101: 97: 93: 89: 84: 82: 78: 74: 70: 66: 62: 61:Edgar F. Codd 58: 48: 46: 42: 38: 34: 30: 26: 22: 434: 423: 409:cite journal 400: 387: 378: 372: 363: 357: 332:. Retrieved 328: 316: 302: 277: 192: 179: 176:Architecture 156: 147: 135: 130: 127:Luca Garulli 124: 104: 85: 54: 20: 18: 100:triplestore 29:data models 482:Categories 401:TPCTC 2018 381:: 230–235. 366:: 141–152. 334:2017-01-12 270:References 57:relational 51:Background 41:relational 493:Databases 379:Ideas '16 364:Bdas 2017 183:component 167:platform. 45:key–value 533:Big data 214:Big data 198:See also 77:document 33:Document 428:"layer" 43:, and 513:NoSQL 397:(PDF) 325:(PDF) 219:NoSQL 115:NoSQL 81:graph 73:NoSQL 37:graph 23:is a 415:link 209:ACID 67:and 55:The 98:or 484:: 411:}} 407:{{ 399:. 343:^ 327:. 288:^ 185:. 94:, 90:, 79:, 71:, 39:, 35:, 417:) 403:. 337:. 118:"

Index

database management system
data models
Document
graph
relational
key–value
relational
Edgar F. Codd
horizontal scalability
fault tolerance
NoSQL
document
graph
relational database
document-oriented database
graph database
triplestore
third normal form
hierarchical database model
NoSQL
search engine
Luca Garulli
Object–Relational Data Management Systems (ORDBMS)
polyglot persistence
component
Comparison of multi-model databases
ACID
Big data
NoSQL
Comparison of structured storage software

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

↑