do you know what is DATABASE?

hello everybody.

previously, we have learned about  database right? remember or not? okay, let me recall it back.

in chapter 12: databases. There are one subtopic about type of databases.

so what do you expected me to talk about, guys???

naa!!.. i wanna focus in type of databases.

                          what is database, anyway??

google courtesy

A database is a system intended to organize, store, and retrieve large amounts of data easily.

It consists of an organized collection of data for one or more uses, typically in digital form.

One way of classifying databases involves the type of their contents,

for example: bibliographic, document-text, statistical. Digital databases are managed using database management systems, which store database contents, allowing data creation and maintenance, and search and other access

                                                      Type of Databases

1. Analytical database

google courtesy

Analysts may do their work directly against a data warehouse or create a separate analytic database for Online Analytical Processing. For example, a company might extract sales records for analyzing the effectiveness of advertising and other sales promotions at an aggregate level.

2. Data warehouse

 

google courtesy

 

Data warehouses archive modern data from operational databases and often from external sources such as market research firms. Often operational data undergoes transformation on its way into the warehouse, getting summarized, anonymized, reclassified, etc. The warehouse becomes the central source of data for use by managers and other end-users who may not have access to operational data. For example, sales data might be aggregated to weekly totals and converted from internal product codes to use UPC codes so that it can be compared with ACNielsen data.Some basic and essential components of data warehousing include retrieving and analyzing data, transforming,loading and managing data so as to make it available for further use.

Operations in a data warehouse are typically concerned with bulk data manipulation, and as such, it is unusual and inefficient to target individual rows for update, insert or delete. Bulk native loaders for input data and bulk SQL passes for aggregation are the norm.

3. Distributed database

 

google courtesy

 

These are databases of local work-groups and departments at regional offices, branch offices, manufacturing plants and other work sites. These databases can include segments of both common operational and common user databases, as well as data generated and used only at a user’s own site.

4. End-user database

 

google courtesy

 

These databases consist of data developed by individual end-users. Examples of these are collections of documents in spreadsheets, word processing and downloaded files, even managing their personal baseball card collection.

5. External database

 

google courtesy

 

These databases contain data collected for use across multiple organizations, either freely or via subscription. The Internet Movie Database is one example. Hypermedia databases

The World Wide Web can be thought of as a database, albeit one spread across millions of independent computing systems. Web browsers "process" this data one page at a time, while Web crawlers and other software provide the equivalent of database indexes to support search and other activities.

6. Operational database

 

google courtesy

 

These databases store detailed data about the operations of an organization. They are typically organized by subject matter, process relatively high volumes of updates using transactions. Essentially every major organization on earth uses such databases. Examples include customer databases that record contact, credit, and demographic information about a business' customers, personnel databases that hold information such as salary, benefits, skills data about employees, Enterprise resource planning that record details about product components, parts inventory, and financial databases that keep track of the organization's money, accounting and financial dealings.

im referring to :

google image, and

http://en.wikipedia.org/wiki/Database

p/s: dengar cerita group we all dapat first place this week untuk project work blog ni., kalau betul, alhamdulillah. kalau sekadar khabar angin sepoi sepoi tak reti bahasa je, harus kerja lebih gigih la nampaknye ye.. huu~

entry by: hazarina haron