Outline of databases: Difference between revisions

Content deleted Content added
JL-Bot (talk | contribs)
m removing stale CONSTRUCTION template as last edited 8 days ago
m Typo fixing and cleanup, typos fixed: the the → the, added orphan, Empty section (2) tags using AWB
Line 1:
{{Orphan|date=June 2012}}
 
<!-- Attention: NEW OUTLINE
 
Line 17 ⟶ 19:
 
{{TOClimit|2}}
 
== What type of things are databases? ==
 
Line 32 ⟶ 35:
* [[Centralized database]] &ndash; database located and maintained in one ___location, unlike a distributed database.
* [[Cloud database]] &ndash; runs on a cloud computing platform, such as Amazon EC2, GoGrid and Rackspace.
* [[Collection database]] &ndash; collection catalog of a museum or archive implemented using a computerized database, in which the the institution's objects or material are catalogued.
* [[Collective Optimization Database]] &ndash; open repository to enable sharing of benchmarks, data sets and optimization cases from the community, provide web services and Plug-in (computing)|plugins to analyze optimization data and predict program transformations or better hardware designs for multi-objective optimizations based on statistical and machine learning techniques provided there is enough information collected in the repository from multiple users.
* [[Configuration management database]] &ndash;
* [[Cooperative database]] &ndash; holds information on customers and their transactions.
* [[Correlation database]] &ndash; database management system (DBMS) that is data model independent and designed to efficiently handle unplanned, ad hoc queries in an analytical system environment.
Line 94 ⟶ 97:
** [[Datasource]] &ndash; name given to the connection set up to a database from a server. The name is commonly used when creating a query to the database. The Database Source Name (DSN) does not have to be the same as the filename for the database. For example, a database file named "friends.mdb" could be set up with a DSN of "school". Then DSN "school" would then be used to refer to the database when performing a query.
** [[Data Source Name]] (DSN) &ndash; are data structures used to describe a connection to a data source. Sometimes known as a database source name though data sources are not limited to databases.
* [[Database administrator]] (DBA) &ndash; is a person responsible for the installation, configuration, upgrade, administration, monitoring and maintenance of physical{{huhclarify|date=March 2012}} databases.
* [[Lock (database)|Lock]] &ndash;
* [[Comparison of database tools]] &ndash; (provides tables for comparing general and technical information for a number of available database administrator tools.)
Line 237 ⟶ 240:
 
=== Creating the data warehouse ===
 
==== Concepts ====
*[[Dimension (data warehouse)|Dimension]] &ndash;
Line 278 ⟶ 280:
 
=== Using the data warehouse ===
 
==== Concepts ====
* [[Business intelligence]] (BI) &ndash; is defined as the ability for an organization to take all its capabilities and convert them into knowledge, ultimately, getting the right information to the right people, at the right time, via the right channel.
Line 304 ⟶ 305:
 
== Database-related organizations ==
{{Empty section|date=June 2012}}
 
== Database-related publications ==
Line 316 ⟶ 318:
 
== Persons influential in databases ==
{{Empty section|date=June 2012}}
 
== See also ==