Differences between version 7 and predecessor to the previous major change of DataBase.
Other diffs: Previous Revision, Previous Author, or view the Annotated Edit History
| Newer page: | version 7 | Last edited on Thursday, October 16, 2003 8:34:43 pm | by StuartYeates | Revert |
| Older page: | version 1 | Last edited on Thursday, June 19, 2003 5:31:37 pm | by CraigBox | Revert |
@@ -1,7 +1,11 @@
A collection of data arranged for ease and speed of search and retrieval.
-More often than not, a database is made up of one or more 'tables' of data, and relationships can be defined between these tables - for instance you could have one table called contacts containing the names of people in an address book, and another called phones containing their various phone and fax numbers. Both of these tables would have to identify who the information was about,
and so would have the identifying piece of information in common. This commonality is known as a relationship. From this we get Relational Database Management Systems (
[RDBMS
])
.
+[FlatFile]s
and [CommaSeparatedVector
]s very simple databases
.
-Examples include
[Oracle
], MySql, [PostgreSQL], [Microsoft] [SQL] Server, Informix, [Borland] Interbase, FireBird and
[IBM
] DB2
.
+[HierarchicalDataBase
]s are one of the longest-established types of DataBase
, with
[GDBM
] being a prime example
.
-See PostgresVsMysql
+The most widely used forms database are [RelationalDataBase]s and their practical offspring [PostRelationalDataBase]s. Because a database by itself is very little use without the support infrastructure of utilities, converters, connectors, tools, tutorials and so forth most are actually Relational Database Management Systems ([RDBMS]). [RDBMS]s include [Oracle], [MySQL], [PostgreSQL], [Microsoft] [SQL] Server, Informix, [Borland] Interbase, FireBird and [IBM] [DB2].
See also
PostgresVsMysql.
+
+[InformationSystem]s such as [MG] use [InvertedIndex]es, which serve to both compress and index natural language text.
+
+[XMLDataBase]s are currently flavour of the month for all sorts of reasons.
