What is Database

What is database?

  • Database is an organized collection of information about an entity having controlled
    redundancy and serves multiple applications.
  • DBMS (database management system) is an application software that is developed to create and manipulate the data in database.
  • A query language can easily access a data in a database. SQL (Structured Query Language) is language used by most relational database systems.
  • IBM developed the SQL language in mid-1979.
  • All communication with the clients and the RDBMS, or between RDBMS is via SQL. Whether the client is a basic SQL engine or a disguised engine such as a GUI, report writer or one RDBMS talking to another, SQL statements pass from the client to the server.
  • The server responds by processing the SQL and returning the results. The advantage of this approach is that the only network traffic is the initial query and the resulting response. The processing power of
    the client is reserved for running the application.

SQL is a data sub-language consisting of three built-in languages:

Data definition language (DDL),
Data manipulation language (DML) and
Data control language (DCL).

It is a fourth generation language. SQL has many more features and advantages. Let us discuss the SQL in more detail in this unit. It should be noted that many commercial DBMS may or may not implement all the details given in this unit.

in other words, you can say that:

A database program is a type of computer software that is designed to handle lots of data, but to store them in such a way that finding (and thus retrieving) any snippet of data is more efficient than it would have been if you simply dumped them willy nilly all over the place.

With such a database software, if you (say) keep a list of customers and their shipping addresses, entering and retrieving information about your one millionth customer will not take much longer (if at all) than entering and retrieving information about your 1st customer.

Related Posts

  • 67
    To learn more about what is binary log and how to setup Click here MySQL binary log : mysqlbinlog utility mysqldump – MySQL Database Backup and restore program Purge Binary log MySQL Master-Master-Slave-Slave Replication Database Recover from MySQL binary log: Binary logs store all the queries (in STATEMENT format) or…
    Tags: database, mysql, data, db
  • 54
    Create mysql user id after logging through root user. mysql -u root -p yourpasswordforroot CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass'; GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON bankaccount*. TO 'monty'@'localhost'; FLUSH PRIVILEGES;  
    Tags: mysql, database
  • 53
    Applications that access MySQL should not trust any data entered by users, who can try to trick your code by entering special or escaped character sequences in Web forms, URLs, or whatever application you have built. Be sure that your application remains secure if a user enters something like “;…
    Tags: mysql, application, data, server, database, query, client
  • 52
    MySql export schema without data Login to DB server Run the below command to take backup of schema of database without data. # mysqldump -u root –p  -d olddb > backup.sql OR # mysqldump -u root -p --no-data dbname > schema.sql    
    Tags: data, database, mysql, server, db
  • 52
    SHOW GLOBAL VARIABLES LIKE 'storage_engine'
    Tags: database, mysql, engine, db

Satya Prakash

VOIP Expert: More than 8 years of experience in Asterisk Development and Call Center operation Management. Unique Combination of Skill Set as IT, Analytics and operation management.

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: