What is a Database?
Database – Collection of information organized so a computer program can quickly select desired pieces of data. Think of a databases as an electronic filing system.
A database is a data structure that stores organized information. Most databases contain multiple tables, which may each include several different fields. For example, a company databases may include tables for products, employees, and financial records. Each of these tables would have different fields that are relevant to the information stored in the table.
Nearly all e-commerce sites uses databases to store product inventory and customer information. These sites use a database management system (or DBMS), such as Microsoft Access, FileMaker Pro, or MySQL as the “back end” to the website. By storing website data in a database, the data can be easily searched, sorted, and updated. This flexibility is important for e-commerce sites and other types of dynamic websites.
Early databases were relatively “flat,” which means they were limited to simple rows and columns, like a spreadsheet. (See also “flat file database”). However, today’s relational databases allow users to access, update, and search information based on the relationship of data stored in different tables. Relational databases can also run queries that involve multiple databases. While early databases could only store text or numeric data, modern databases also let users store other data types such as sound clips, pictures, and videos.
Free Merchant Terminal explains Database (DB)
Software programmers are well acquainted with database concepts through relational databases like Oracle, SQL SERVER and MySQL, etc. Typically, a database structure stores data in a tabular format.Database architecture may be external, internal or conceptual. The external level specifies the way in which every end-user type comprehends the organization of its corresponding relevant data in the database. The internal level deals with the performance, scalability, cost and other operational matters. The conceptual level perfectly unifies the different external views into a defined and wholly global view. It consists of every end-user required generic data.
« Back to Glossary Index