Statistical database (original) (raw)
A statistical database is a database used for statistical analysis purposes. It is an OLAP (online analytical processing), instead of OLTP (online transaction processing) system. Modern decision, and classical statistical databases are often closer to the relational model than the multidimensional model commonly used in OLAP systems today.
| Property | Value |
|---|---|
| dbo:abstract | A statistical database is a database used for statistical analysis purposes. It is an OLAP (online analytical processing), instead of OLTP (online transaction processing) system. Modern decision, and classical statistical databases are often closer to the relational model than the multidimensional model commonly used in OLAP systems today. Statistical databases typically contain parameter data and the measured data for these parameters. For example, parameter data consists of the different values for varying conditions in an experiment (e.g., temperature, time). The measured data (or variables) are the measurements taken in the experiment under these varying conditions. Many statistical databases are sparse with many null or zero values. It is not uncommon for a statistical database to be 40% to 50% sparse. There are two options for dealing with the sparseness: (1) leave the null values in there and use compression techniques to squeeze them out or (2) remove the entries that only have null values. Statistical databases often incorporate support for advanced statistical analysis techniques, such as correlations, which go beyond SQL. They also pose unique security concerns, which were the focus of much research, particularly in the late 1970s and early to mid-1980s. (en) |
| dbo:wikiPageExternalLink | http://www.informatik.uni-trier.de/~ley/db/conf/ssdbm/ |
| dbo:wikiPageID | 1069468 (xsd:integer) |
| dbo:wikiPageLength | 5546 (xsd:nonNegativeInteger) |
| dbo:wikiPageRevisionID | 1115253526 (xsd:integer) |
| dbo:wikiPageWikiLink | dbr:SQL dbr:Statistics dbc:Statistical_databases dbr:Cynthia_Dwork dbr:Database dbr:Differential_privacy dbr:Relational_model dbr:Security dbr:OLAP dbr:Multidimensional_database dbr:OLTP dbr:Tore_Dalenius |
| dbp:wikiPageUsesTemplate | dbt:Doi dbt:Refimprove dbt:Reflist dbt:Short_description |
| dct:subject | dbc:Statistical_databases |
| gold:hypernym | dbr:Database |
| rdf:type | dbo:BiologicalDatabase |
| rdfs:comment | A statistical database is a database used for statistical analysis purposes. It is an OLAP (online analytical processing), instead of OLTP (online transaction processing) system. Modern decision, and classical statistical databases are often closer to the relational model than the multidimensional model commonly used in OLAP systems today. (en) |
| rdfs:label | Statistical database (en) |
| owl:sameAs | freebase:Statistical database wikidata:Statistical database https://global.dbpedia.org/id/bQdW |
| prov:wasDerivedFrom | wikipedia-en:Statistical_database?oldid=1115253526&ns=0 |
| foaf:isPrimaryTopicOf | wikipedia-en:Statistical_database |
| is foaf:primaryTopic of | wikipedia-en:Statistical_database |