about the data base

about the data base
Since there are courses Database, so I'm going ga would (should not!! Hehehehe) at least know the ins and outs of the Database. This is the beginning I started to investigate about the Database. Let us see the definition ..What the Data Base System Sih?The integration consists of a number of functional components that are interconnected and together aim to meet a particular process. Functional component or relation is usually shown with a key from each file that exists. In one file there are records of the same type, same size, same shape, which is a uniform set of entities. One record consists of fields that are interconnected shows that the field is in one sense a complete and recorded in one record.Hmmm .. from above there are several important points that we can take. Hayoo hell? Ask Why? (Halah.. So digress not clear). The following important points:

    * Is data oriented and not oriented programs.
    * Can be used by several application programs without the need to change its data base.
    * Can be developed with ease, both the volume and structure.
    * Able to meet the needs of new systems easily.
    * Can be used in different ways.
Do not be confused .. (O_O), grab a coffee .. sit .. medhang .. while reading this article ..Key Principles and purpose
 but the point setting data. If the goal is:

    * Efficiency of storage space (Space)
Conducting a number of suppression of data redundancy (duplicate data).

    * Accuracy (Accuracy)
Performed coding or the formation of relationships among the data along with the application of rules / constraints (constraint) data type, data domain, the uniqueness of the data, which can be applied strictly in a database.

    * Availability (Availability)
Because the interests of a usage data, a database may have data that spread in many geographical locations. With the use of computer networking technologies that are disuatu location / branch, can also be accessed (that would be available / available) for locations and other branches.

    * Completeness (Completeness)
Complete absence of data we manage in a data base is relative (both to the needs of users as well as with respect to time).

    * Security (Security)
Determining a nobody (user) who may use the data base along with the objects therein and determine the types of operations are allowed by that user.

    * Togetherness User (Sharbility)
The user database is often not limited to one user only, or in a single location or by a system / application only. The database can be used by multiple users, for example by a number of departments within the company or by multiple systems such as payroll systems, inventory systems, system sales of goods, and so forth. To meet the goal should be managed by the system (application) that support multiuser environment.Database system is a combination of database and database management system (DBMS). The components of the database system include:

    * Hardware (Hardware) as a supporting data processing operations.
    * Operating System (Operating System) or software to manage databases.
    * Data Base (database) as the core of the system database.
    * Database Management System (DBMS).
    * Users (Users).
    * Other applications.
Device to maintain data abstraction known as the data model. The data model is a collection of concepts that can be used to draw the structure of the data.The structure of the database includes data type, relationship, and several conditions must be fulfilled database.There are some common definitions used in the database, namely:

    * Entity: Entity is a person, place, event or concept that information is recorded. In the field of Student Administration, for example, students, books, payment.

    * Attributes: Attributes are also called data elements, data fields or data items used to describe an entity and have certain values, such as attributes of an entity described by the employee, name, age, address, occupation.

    * Data Value (Value Data): Data Value is the actual data or information stored on each data element, or attribute. The attribute name of the employee indicates the place where information is stored employee name, the value of such data is Anjang, Arif, Suryo, and others which is the content of the employee's name.

    * File / Table: Collection of similar records that have the same length of elements, attributes the same, but different data values.

    * Record / tuple: A collection of elements related to each other informed about a complete entity. One record represents one data or information.
Data AbstractionThe main purpose of the database system is that users are able to compile an abstract view of data. Shadow of the data is no longer considering how one actual condition data entered into the database is stored in which sector, but involves a whole how this data can be abstracted on the conditions faced by everyday users. Real system, the technical how data is stored and maintained as if the hidden complexity and then expressed in the language and images are easily understood by the layman.There are three user groups in the level of abstraction when looking at a database, namely:

    * Physical Level: This level represents the lowest level of abstraction for describing how data is stored in real conditions.
    * Conceptual Level: This level describes what data is stored in a database and relationships between data from the entire database. Users do not care for the physical level of complexity in the structure again, drawing simply by using boxes, lines, and the relationship sufficiently.
    * Level Users view (View level): This level represents the highest level of abstraction that describes the data only partially viewed and used from the entire database, it is because some database users do not need all the contents of the database.
Anybody want to add style gan?