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.

Comments

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...

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. ...

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...

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

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 ...

Floppy disk drive definition

The floppy disk drive is a physical device or drive that is responsible for reading/writing to floppy disks.In English, floppy disk drive (FDD) or floppy disk drive. In IBM PCs, they are used to write or read on floppy disks.5 1/4 or 3 1/2 inches.They are usually represented with the A: or B units: They are removable storage devices. The floppy drives were invented by the IBM company, being the versions of 8, 5¼ and 3½ inches (and all its variants) the most popular forms for the storage and exchange of data from the mid-70s to the end of the 90s.Computers gradually stopped bringing floppy drives, being replaced by readers of optical disks (CDs, DVDs...), flash memories, external hard drives, etc. Operation of the floppy drives Basically the floppy drives have a small motor that rotates a floppy disk at a controlled speed, while a second engine operates a mechanism that moves a Magnetic read-write head on the surface thereof.Both read and write operations require the head to ph...

Definition of Cognitive Computing (CC)

Cognitive computing (CC) describes technology platforms that, in general terms, are based on the scientific disciplines of artificial intelligence and signal processing.These platforms cover machine learning, reasoning, natural language processing, voice recognition and vision (object recognition), man-machine interaction, dialogue and narrative generation, among other technologies. At present, there is no widely accepted definition of cognitive computing. In general, the term computation Cognitive has been used to refer to new hardware and/or software that mimics the functioning of the human brain and helps to improve people's decision-making.In this sense, CC is a new type of informatics with the aim of obtaining more models precise how the human brain/mind detects, reasons and responds to the stimulus. Uses of Cognitive Computing -Voice Recognition -Analis is of feelings -Face detection -Risk assessment -Fraud detection -Behavioral recommendations Characteristics of...

Web Proxy Definition

A web proxy is used to intercept the navigation of web pages for reasons of security, anonymity, performance, etc. A web proxy can be accessed by an IP address, free or paid, which is added to a browser (also There are proxy programs to avoid the configuration process.) When someone uses the browser, everything that is done in it first goes through the proxy first (the proxy server).That is, if a web page is requested the remote proxy will It is in charge of looking for it and sending it to our computer.In this intermediate step the proxy can be used to: * Anonymous browsing: if the proxy is configured in this way, anyone who navigates through that proxy will do so Anonymously, the destination pages will not be able to know the IP address (identification) of the computer you are browsing; they will only see the IP address of the proxy.If a proxy is not configured to be anonymous it is said to be transparent browsing. * Safe browsing: a proxy is responsible for filtering or alertin...

Definition of residential gateway (home)

A residential or home gateway (also a home gateway), is a home network device used as a gateway to connect home devices to the Internet or another WAN network. It is a broad term that includes multiple devices used in the home that can be: a DSL modem or cable modem, a network switch, a router, a wireless access point, etc.In the past, these functions were provided by different devices, but due to technological convergence, it is often unite in a single device. There are multiple devices that can be described as "residential gateways", each with different functions.Each type of device allows the connection of a LAN (used in the home) to a WAN.The WAN can be the Internet or perhaps a larger LAN of which the home is a part (for example, a municipal WAN that provides connectivity to its residents).WAN connectivity can be provided through DSL, cablemodem, network mobile or other cone xiones. The term "residential gateway" was originally used to distinguish economic...