Talk:Database model

From Wikipedia, the free encyclopedia
Jump to: navigation, search
          This article is of interest to the following WikiProjects:
WikiProject Computer science (Rated C-class, Top-importance)
WikiProject icon This article is within the scope of WikiProject Computer science, a collaborative effort to improve the coverage of Computer science related articles on Wikipedia. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks.
C-Class article C  This article has been rated as C-Class on the project's quality scale.
 Top  This article has been rated as Top-importance on the project's importance scale.
 
WikiProject Computing (Rated C-class)
WikiProject icon This article is within the scope of WikiProject Computing, a collaborative effort to improve the coverage of computers, computing, and information technology on Wikipedia. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks.
C-Class article C  This article has been rated as C-Class on the project's quality scale.
 ???  This article has not yet received a rating on the project's importance scale.
 
WikiProject Databases / Computer science  (Rated C-class, Top-importance)
WikiProject icon This article is within the scope of WikiProject Databases, a collaborative effort to improve the coverage of database related articles on Wikipedia. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks.
C-Class article C  This article has been rated as C-Class on the project's quality scale.
 Top  This article has been rated as Top-importance on the project's importance scale.
Taskforce icon
This article is supported by WikiProject Computer science (marked as Top-importance).
 
WikiProject Systems (Rated C-class, Mid-importance)
WikiProject icon This article is within the scope of WikiProject Systems, which collaborates on articles related to systems and systems science.
C-Class article C  This article has been rated as C-Class on the project's quality scale.
 Mid  This article has been rated as Mid-importance on the project's importance scale.
Taskforce icon
This article is within the field of Software engineering.
 

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")

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)

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)

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)

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)

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)

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

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

Caboodle Link and Other Misinformation[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)

I've removed the link, but haven't looked at the other things you've mentioned. Mindmatrix 21:06, 3 August 2009 (UTC)
Apparently, Mdd beat me to it... Mindmatrix 21:07, 3 August 2009 (UTC)
Yes sorry. Thanks for mentioning. -- Marcel Douwe Dekker (talk) 21:11, 3 August 2009 (UTC)
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)
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)

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)