Question:
what are the advantages of a database?
anonymous
2006-10-31 05:30:03 UTC
what are the advantages of a database
Eight answers:
FIREnICE
2006-10-31 05:36:34 UTC
The term database originated within the computer industry, though its meaning has been broadened by popular use, such that the European Database Directive (which creates intellectual property rights for databases) includes non-electronic databases within its definition. This article is confined to a more technical use of the term; though even amongst computing professionals, some attach a much wider meaning to the word than others. A possible definition is that a database is a collection of records stored in a computer in a systematic way, so that a computer program can consult it to answer questions. For better retrieval and sorting, each record is usually organized as a set of data elements (facts). The items retrieved in answer to queries become information that can be used to make decisions. The computer program used to manage and query a database is known as a database management system (DBMS). The properties and design of database systems are included in the study of information science.



The central concept of a database is that of a collection of records, or pieces of knowledge. Typically, for a given database, there is a structural description of the type of facts held in that database: this description is known as a schema. The schema describes the objects that are represented in the database, and the relationships among them. There are a number of different ways of organizing a schema, that is, of modeling the database structure: these are known as database models (or data models). The model in most common use today is the relational model, which in layman's terms represents all information in the form of multiple related tables each consisting of rows and columns (the true definition uses mathematical terminology). This model represents relationships by the use of values common to more than one table. Other models such as the hierarchical model and the network model use a more explicit representation of relationships.



Strictly speaking, the term database refers to the collection of related records, and the software should be referred to as the database management system or DBMS. When the context is unambiguous, however, many database administrators and programmers use the term database to cover both meanings.



Many professionals would consider a collection of data to constitute a database only if it has certain properties: for example, if the data is managed to ensure its integrity and quality, if it allows shared access by a community of users, if it has a schema, or if it supports a query language. However, there is no agreed definition of these properties.



Database management systems are usually categorized according to the data model that they support: relational, object-relational, network, and so on. The data model will tend to determine the query languages that are available to access the database. A great deal of the internal engineering of a DBMS, however, is independent of the data model, and is concerned with managing factors such as performance, concurrency, integrity, and recovery from hardware failures. In these areas there are large differences between products.
Mark B
2006-10-31 06:09:30 UTC
Before databases, everything was in a file cabinet. Security was an issue since anyone could open it and read or steal documents. Safety of the information in the file cabinet is at risk in case of a fire or natural disaster--which would cause all information to be destroyed. We haven't even mentioned that storing data this way is time-consuming to index/sort/filter and everyone knows file cabinets take up lots and lots of room!



So how did the database fix all this? Well, most databases have a security mechanism where a login/password is required before accessing a database and is even better at allowing only certain information to be seen by some rather than others (these are called table views). Safety still is an issue except it is much easier to backup the entire database within minutes to a disk/cdrom/tape backup and store it offsite rather than make xerox copies of each and every file within a file cabinet. Since all the data is digital and computers are much faster than people, indexing, sorting is a snap... coupled with the fact that a computer can hold tons and tons of information into a very very small space. Oh, and something more, databases can be replicated or centralized easily... this makes information widely available to remote locations--this is seemingly impossible to do with the file-cabinet days where physical access was required.
?
2015-09-21 00:43:37 UTC
There are many advantages of database from which some are listed below



Reduced data redundancy

Reduced updating errors and increased consistency

Greater data integrity and independence from applications programs

Improved data access to users through use of host and query languages

Improved data security
?
2015-09-20 23:38:24 UTC
Basic advantages of database are below Elastic scalability, big data application economy
anonymous
2006-10-31 05:41:56 UTC
A database allows the quick retrieval of information based on a search criteria from a storage of related data.

So its fast,

can be backed up,

theoretically unlimited,

data is cross referenced through the use of relationships.
?
2015-07-08 23:47:14 UTC
Database is a collection of retrieval data and it can managed , accessed and updated data information easily.
anonymous
2006-10-31 05:36:58 UTC
In comparison to what?



A database is better at storing data than a tablemat, but not as tasty as a sandwich. See what I mean?



Rawlyn.
James
2015-04-25 01:09:06 UTC
the term data bases


This content was originally posted on Y! Answers, a Q&A website that shut down in 2021.
Loading...