Category Database

A tag for pages describing databases and database technology. Includes Relational, Hierarchical, OO, and other database technologies.

This tag is also used for pages about ObjectPersistence, even though that concept is not necessarily synonomous with "database technology".

Click on the "Category Database" title to see a list of pages that fit into this category.

Related categories: CategoryQueryLanguage CategoryTql CategoryRelationalDatabase CategoryPersistence

---

The first things first...

• DatabaseDefinition

Implementation aspects

• MultiversionConcurrencyControl - used by FireBird (formerly InterBase), Oracle, Gemstone, MySql's InnoDB engine, and PostgreSql
• SnapshotIsolation - ditto

Object -vs- Relational discussion

• ObjectRelationalImpedanceMismatch (...and if it exists or not. ;-)
• ObjectsVsRdbmsPerformance
• LetsUseAnObjectOrientedDatabase
• "Object Database vs. Object-Relational Databases" by Steve McClure? of Jasmine -- http://www.cai.com/products/jasmine/analyst/idc/14821E.htm
• OoLacksMathArgument
• MultiParadigmDatabase

Database Paradigms

• RelationalDatabase
• NetworkDatabase
• HierarchicalDatabase
• NavigationalDatabase
• SemanticBinaryModel

RelationalDatabase Discussion

• AreRdbmssDead?
• PortableSql (patterns for how to do it)
• NimbleDatabase

RelationalDatabase Products (...possibly with some "object oriented" features)

• Oracle: OracleDatabase
• Sybase System 10/11
• MicroSoft: SqlServer
• Informix: InformixDynamicServer?, InformixUniversalServer? (InformixIllustra?)
• IBM: DB2 (DbTwo)
• UniSQL/X
• Unisys: OSMOS
• ComputerAssociates: OpenIngres
• RedBrick? (specialized for DataWarehousing?)
• SuneidoDatabase
• InterBase
• FireBird
• PostgreSql
• MySql
• SqLite
• AxionDB : AxionDatabase
• NiLOSTEP : XlSql
• TdbEngine
• EnterpriseDb? (OracleDatabase clone based on PostgreSql)
• RelProject

• See also http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems

RelationalDatabase Languages

• StructuredQueryLanguage
• TutorialDee
• TqlRoadmap (experimental)

ObjectOrientedDatabase Discussion

• ArchitectureAndObjectDatabases (...with comments on serveral of the following OODB servers.)

ObjectOrientedDatabase Products

• ComputerAssociates: JasmineObjectOrientedDatabase
• db4objects: db4o (DeeBeeFourOh) http://www.db4o.com (open source)
• Gemstone: GemStone
• O2 (see also OhTwoUnit)
• ObjectDesignInc: ObjectStore
• Objectivity: Objectivity/DB
• Versant: VersantODBMS

Object-Relational Mapping

• TopLink
• Bold
• EnterpriseObjectsFramework (part of WebObjects)
• MultiParadigmDatabase
• HiberNate

Traditional HierarchicalDatabase Products

• IBM: IMS (IbmIms)

Other Database Products

• XmlDatabaseServers

End User Database or DesktopDatabase A DBMS, including a user interface intended for non technical users.

• CornerStone
• MicrosoftAccess
• FileMakerPro

Techniques

• DatabaseBestPractices
• FirstNormalForm
• SecondNormalForm
• ThirdNormalForm
  • BoyceCoddNormalForm? (BCNF)
• FourthNormalForm?
• FifthNormalForm? AKA Project-join normal form (PJ/NF)
  • DomainKeyNormalForm?

Speculation

• SimplifyingRdbms
• DynamicRelational

---

CategoryCategory