Talk:Database model

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.Computer scienceWikipedia:WikiProject Computer scienceTemplate:WikiProject Computer scienceComputer science articles

High

This article has been rated as High-importance on the project's importance scale.

Things you can help WikiProject Computer science with:

Here are some tasks awaiting attention:

Article requests :
- Requested articles/Applied arts and sciences/Computer science, computing, and Internet
Cleanup :
- Computer science articles needing attention
- Computer science articles needing expert attention
Copyedit :
- Computing
Expand :
- Computer science
Infobox :
- Computer science articles without infoboxes
Maintain :
- Timeline of computing 2020–present
Photo :
- Find pictures for the biographies of computer scientists (see List of computer scientists)
- Computing articles needing images
Stubs :
- Computer science stubs
Unreferenced :
- WikiProject Computer science/Unreferenced BLPs
Project-related :
- Tag all relevant articles in Category:Computer science and sub-categories with {{WikiProject Computer science}}

Computing High‑importance

	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.ComputingWikipedia:WikiProject ComputingTemplate:WikiProject ComputingComputing articles
High	This article has been rated as High-importance on the project's importance scale.

Databases (inactive)

This article is within the scope of WikiProject Databases, a project which is currently considered to be inactive.DatabasesWikipedia:WikiProject DatabasesTemplate:WikiProject DatabasesDatabases articles

Systems Mid‑importance

	Systems science portal This article is within the scope of WikiProject Systems, which collaborates on articles related to systems and systems science.SystemsWikipedia:WikiProject SystemsTemplate:WikiProject SystemsSystems articles
Mid	This article has been rated as Mid-importance on the project's importance scale.
	This article is within the field of Software engineering.

Key:Value Store and "Document" Models

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 (talk • contribs) 18:28, 1 October 2010 (UTC)[reply]

XML Data Models

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

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?

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

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!

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

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]

Caboodle Link and Other Misinformation

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. Mind matrix 21:06, 3 August 2009 (UTC)[reply]

Apparently, Mdd beat me to it... Mind matrix 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

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

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

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

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

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