Jump to content

Talk:Database model

Page contents not supported in other languages.
From Wikipedia, the free encyclopedia

Key:Value Store and "Document" Models

[edit]

Used in recent (21st century) "NoSQL" DBMS such as MongoDB and CouchDB. Might be a version of the Object database models? Key:Value Stores store and retrieve "records" containing an Associative_array. DBMS using the Document Model store multi-dimensional associative arrays in a record ("document") — Preceding unsigned comment added by 204.16.153.250 (talkcontribs) 18:28, 1 October 2010 (UTC)[reply]

XML Data Models

[edit]

What about native XML data models? These are becoming more common and should probably be included. Can someone spearhead adding that? (I know I am bringing it up but don't have the space right now to do a good job... unless people think it is worth starting a stub? Alex Jackl 15:24, 12 January 2007 (UTC)[reply]

Entity-Relationship model

[edit]

Sorry, I'm a newibie with a bad english .... I think that must be a page about this, with this name... Carpani 12:12, 20 August 2007 (UTC)[reply]

Star Schema?

[edit]

Is star schema really a database model? If so, should snowflake schema be added to the list? They seem more like schema design patterns based on the relational model to me. Just wondering... SqlPac (talk) 05:19, 24 June 2008 (UTC)[reply]

Merge Database models and List of database models in this article

[edit]

I propose to merge the Database models into this article (which is a sort of move proposal since at the moment this article is only a redirect) for the following reasons:

  • There should be only one general article about data base models
  • At the moment it is only confusing that both the List of database models and the Database models give an overview of data base models.
  • In Wikipedia it is usual to create such an in the singular form
  • And maybe more important. This article should focuss more on the common properties of the data base model. That is what this article should explain in the first place.

-- Marcel Douwe Dekker (talk) 21:22, 7 October 2008 (UTC)[reply]

Terms mixed up!

[edit]

data(base) model and database schema are two completely different things, which are mixed up in this article. A database schema is the description of a specific database (e.g. which tables and attributes exist in this database). A data model is the set of mechanisms for structuring data, which is provided by a database management system. The most prominent example is the relational data model —Preceding unsigned comment added by 131.188.36.28 (talk) 11:22, 7 May 2009 (UTC)[reply]

fixed 87.179.70.186 (talk) 10:42, 9 November 2010 (UTC)[reply]

Database Model and Database Schema

[edit]

I agree, the terms are messed up. It should be changed. A database schema is constructed using a database model, and it defines the logical structure of a database. A schema changes as you go from one (relational) database to another. The (relational) database model does not change as you go from one (relational) database to another.

The person who referenced that Department of Transportation article obviously misinterpreted the section title "database model/schema" on page 10 to mean "database model = database schema." If that were true, in that article, the quote, "Schemas are generally stored in a data dictionary" could also be translated as "Database models are generally stored in a data dictionary," which doesn't make any sense. 69.224.58.213 (talk) 08:46, 27 June 2009 (UTC)Steven[reply]

[edit]

Can someone get rid of that Caboodle link referenced in the Hierarchical Model section. It is obvious spam and doesn't provide useful information about the hierarchical model.

Also, the relational model was actually first introduced in the 1969 IBM technical paper, "Derivability, Redundancy, and Consistency of Relations Stored in Large Data Banks," IBM Research Report RJ599 (August 19th, 1969). The link on the bottom of the wiki page that is supposed to reference the 1970 CACM paper actually references Codd's classic book on his relational model 2.0, which was written in 1990!

A database model is also not a database schema!

208.127.227.63 (talk) 18:35, 3 August 2009 (UTC)[reply]

I've removed the link, but haven't looked at the other things you've mentioned. Mindmatrix 21:06, 3 August 2009 (UTC)[reply]
Apparently, Mdd beat me to it... Mindmatrix 21:07, 3 August 2009 (UTC)[reply]
Yes sorry. Thanks for mentioning. -- Marcel Douwe Dekker (talk) 21:11, 3 August 2009 (UTC)[reply]
Cool thanks, that was fast. Reference 2 should point to the following link instead Link to 1970 CACM (the second) Article, although it was first introduced in 1969 here. 208.127.227.63 (talk) 23:08, 3 August 2009 (UTC)[reply]
I think I got it all right this time (We (I) don't add a link to a provider, only is to the real article). Thanks again. -- Marcel Douwe Dekker (talk) 23:51, 3 August 2009 (UTC)[reply]

References/Relational Database

[edit]

There's only one reference in this article, and that's to Codd and relational databases. That section seems to repeat a lot of the information that's already in the relational database article. Perhaps someone could add a few more references? Katharine908 (talk) 17:21, 7 February 2011 (UTC)[reply]

Object-oriented databases predate the 1990s

[edit]

There are a couple of claims in the article that object databases started in the 1990s.

http://en.wikipedia.org/wiki/Object_database says "early 1980s". In 1982, Servio Logic started work on their database machine, and in 1986 published version 1.0 of the GemStone object database product.

ResearchGate points out the 1985 publication of an article entitled "Object-Oriented Database Development at Servio Logic".

Rjsargent (talk) 23:33, 3 November 2014 (UTC)[reply]

Clarification

[edit]

The text says, "A given database management system may provide one or more of the five models." Which five models? The list above this quote gives over a dozen types, not just five. 71.46.106.61 (talk) 04:42, 31 October 2015 (UTC)[reply]

"Examples" paragraph

[edit]

Wouldn't it be more correct to name it as the listing of the existing models. Is this list incomplete? If so, the "incomplete" template may be added at the top of the paragraph, after renaming its title, instead of calling it "Examples". It's also a problem for mobile viewers, the title isn't really referring to the content. Examples may imply that the paragraph includes examples for a few models - including data and graphs and textual explanation which describes how the model works. Galzigler (talk) 10:21, 25 February 2019 (UTC)[reply]

Notice of blank and redirect

[edit]

RomeshKubajali (talk) 23:30, 20 May 2024 (UTC)[reply]