Skip to main content

Database Definition

(database).They store data related to different modes of organization.A database represents some aspects of the real world, those that interest the designer.Data is designed and stored for a specific purpose.The word "data" is made reference to known facts that can be recorded, such as telephone numbers, addresses, names, etc.

Databases store data, allowing them to be easily manipulated and displayed in various ways.

The process of building a database is called database design.

Database management

A database can be maintained manually or computerized (the latter is the one that interests us).The computerized database is created and maintained by a set of applications designed for those tasks specifically or, can be managed using a DBMS.

DBMS is a set of programs responsible for defining, building and manipulating a database, and maintaining its in tegrity and redundancies.

* Define a database: it consists of specifying the types of data, structures and restrictions for the data to be stored.

* Build a database: It is the process of storing data on some storage medium.

* Manipulate a database: it includes functions such as querying, updating, etc.of databases.

Handling of databases

The most common query language for online databases is SQL.See database query.

Some popular databases are MS Access, dBase , FoxPro, Paradox, Approach, Oracle and Open Office Base.

The databases contain tables, each table has records that in turn contain fields.

Traditional database applications

We are currently using databases continuously, many times without noticing, for example, when withdrawing or depositing money at an ATM, booking an air flight, by subscribing go to a service, or if we consult a catalog of books in a library, or when searching in an internet search engine, etc.In all these cases, computerized databases are being used.

Actors on bases of data

The actors or persons related to the databases are:

* Database administrator (ABD).* Database designer.* End user: en the person whose job requires access to the database either to consult, update and/or generate reports.* Systems analyst and application programmer.

Database storage (see database storage of data)

The databases are conceptual, they describe different entities with their attributes and relationships.But basically the databases end up being stored in the form of files, usually on magnetic disks.

Then it will depend on the type of database, the type of DBMS and the structure created, the way in which the organizations are organized.files and techniques to access the data they contain.

Related: • Database design • DBMS • Database query • SQL query • Database designer.• Database Administrator.

Labels

Etiquetas:

Comments

Post a Comment

Popular posts from this blog

Definition of Macrocomputer (macrocomputer)

A macrocomputer is a large, powerful and expensive computer used primarily in companies that need to process large amounts of data or support large numbers of users.It contrasts with the concept of microcomputer (or microcomputer).Sometimes called macrocomputers. In English: mainframe and macrocomputer. For more information see: Mainframe What is a macrocomputer or mainframe? A large and powerful computer capable of managing a large number of simultaneous tasks and of communicating with a large number of connected terminals; used by large and complex organizations (such as banks and supermarkets) in which continuous operation is vital. Characteristics of macromputers Macrocomputers are a type of computer that are generally known Due to their large size, storage quantity, processing power and high level of reliability, they are mainly used by large organizations for critical mission applications that require large volumes of data processing.In general, there are some characte...
3 comments
Read more

Definition of DPI or PPP (print quality)

(dots per inch, dots per inch).The DPI or PPP is a unit of measurement of the resolution of an image (related to quality) of a scanner, a printer, etc.It serves to measure the resolution, which is the amount of dots that enter an inch.It is expressed like this: (number) x (number) dpi. A resolution of 300 dpi will produce a text that will show broken lines visible under a magnifying glass.Even larger resolutions are necessary to obtain reproductions of smooth photographs.Professional graphics use printers with resolutions from 1200 to 2400 dpi. Pixels or resolution of a photo and printing in centimeters There is no direct equivalence between the pixels of a digital image and the centimeter of printing that correspond to it.A very small image can be printed very large on paper, but the pixels of the printed image will begin to be noticed at first glance.There are techniques to "enlarge" the digital image and soften it a bit the pixels, but these do not make ma ravillas. ...
Post a Comment
Read more

Monoprogramming Definition

Monoprogramming, also called monoexecution, is an operating system in which only one program is executed at a time and no other is executed until the previous one is finished. In other words, only one program is executed at a time within a single address space. This type of execution practically does not exist anymore because it has been replaced by multiprogramming. Monoprogramming vs.multiprogramming In the monoprogramming, the memory only contains one program at any time, while in the multiprogramming the memory contains more than one user program. In the case of monoprogramming, when the CPU is running the program and it find an I/O operation (input-output), then the program goes to the I/O devices, during that time the CPU remains idle.Therefore, in the monogramming the CPU is not used effectively, that is, CPU utilization is poor. However, in the multiprog branch, when a user program contains I/O operations, the CPU changes to the next user program.Therefore, the CPU i...
Post a Comment
Read more

Definition of Eset

Eset is a computer security company based in Bratislava, Slovakia. Eset was founded in 1992 as a result of the merger of two private companies.Its best-known product is the NOD32 antivirus, although it also develops Smart Security, which includes the NOD32 features in addition to firewall and antispam. Compete with other security companies such as Symantec and McAfee Questions? needs more information? Write and we will respond to your email
Post a Comment
Read more

Network transparency definition

Network transparency refers to the ability of a protocol to transmit data over the network in a way that is transparent (invisible) to those who are using the applications that use the protocol.In this regard, users of a particular application they can access remote resources in the same way they would access their own local resources. An example of this is cloud storage, where remote files are presented as if they were locally accessible; also the cloud computing where the resource in question is the processing. From English: network transparency. X Windows The term is often applied partially correctly in the context of the X Windows system, which is capable of transmitting graphic data over the network and integrating it seamlessly with the applications that are running and displayed locally; however, certain extensions of the X Windows system are not able to work on the network. Firewall In firewall technology, transparency can be defined in the network layer ( or IP) or ...
Post a Comment
Read more

Definition of netmask

Combination of bits that serves to delimit the scope of a computer network.It serves for a computer (mainly the gateway, router, etc.) to determine whether it should send the data inside or outside the network.That is, the function of the network mask is to indicate to the devices that part of the IP address is the number of the network (including the subnet), and which part is that corresponding to the host.For example, if the router has ip 159.128.1.1 and network mask 255.255.255.0, understands that everything that is sent to an IP that begins with 159.128.1 goes to the local network and everything that goes to other IP addresses will go outside (Internet or other major local network). More technical definition The subnet mask, within a TCP/IP network, is a configuration parameter that defines the size (understood as the address range) of the IP subnet, or subnet, to which a host belongs, in order to reduce network traffic and facilitate the search and achievement of a particular ...
Post a Comment
Read more

Definition of Spawning (video games)

(produce, generate).In computer games, spawning is the creation of an entity within the game, such as a player character, a non-player character or other item.Respawning is the recreation of an entity after its death or destruction , or at the end of a round. In a game, there may be different points of spawning or generation of characters or items.There may also be spawning of enemies; In many games enemy spawming is unlimited, however, the main player (s) usually has a limited number of spawning (the so-called "lives" of the player). Player spawning varies depending on the mechanisms of each game.It usually starts at the beginning of a round or after a player joins the game. Meanwhile, respawning usually occurs after a player was killed or destroyed, that can happen immediately or after a while (time in seconds, next round, etc.) Apparently the term was created by the company "id Software" during the development of the Doom game. In fact games like Doom, J...
Post a Comment
Read more

Definition of Network Address Translation (NAT)

Network Address Translation, Network Address Translation and better known as NAT. Network Address Translation is a mechanism used by IP routers to exchange data packets between two networks that mutually assign incompatible addresses. It consists of converting, in real time, the addresses used in the transported packets.It is also necessary to edit the packets to allow the operation of protocols that include address information within the protocol conversation. For more information see: NAT. Questions? needs more information? Write and we will respond to your email
Post a Comment
Read more

Initialization vector definition

In cryptography, an initialization vector (IV) is a block of bits required to achieve a flow encryption or block encryption, in one of the encryption modes, with a result independent of other encryption produced by the same key.p> The size of the IV depends on the encryption algorithm and the cryptographic protocol and is often as long as the block size or the size of the key. Source: Initialization vector (CCL)
Post a Comment
Read more