|This article is of interest to the following WikiProjects:|
- 1 Key:Value Store and "Document" Models
- 2 XML Data Models
- 3 Entity-Relationship model
- 4 Star Schema?
- 5 Merge Database models and List of database models in this article
- 6 Terms mixed up!
- 7 Database Model and Database Schema
- 8 Caboodle Link and Other Misinformation
- 9 References/Relational Database
- 10 Object-oriented databases predate the 1990s
- 11 Clarification
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")
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)
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)
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
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.
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 18.104.22.168 (talk) 11:22, 7 May 2009 (UTC)
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. 22.214.171.124 (talk) 08:46, 27 June 2009 (UTC)Steven
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!
- I've removed the link, but haven't looked at the other things you've mentioned. Mindmatrix 21:06, 3 August 2009 (UTC)
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)
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".
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. 126.96.36.199 (talk) 04:42, 31 October 2015 (UTC)