With the advent of computer and internet technology, many companies and large industries have computerized their system of doing business. As the businesses are large, the amount of data that are processed is also large. There should be some means to store the data. This is where the database is needed. Many small business owners you haven’t used digital processing of data, doesn’t know “what is database”. Database is generally a table, which consists of rows and columns. Each column header is called “field” and each row is called a “record”. In the past few years, significant number of small scale industries has moved on to the digital processing of the data. Large scale industries process lot of data and the number of employees working in it will be many; they use databases to store all the information.
It all started in the year 1960s. It was mainly designed to make the process of handling huge information system effortlessly. If you are running a small scale industry and you haven’t computerized the processing system, then it’s high time that you should have it installed. Companies, which have its branches in different location all around world, have a centralized database system to store their data. The Database Administrator (DBA) and other employees of the company are capable of accessing data from the centralized database from anywhere from the world. Unlike the distributed databases, the data is stored in a single place. This is an advantage that any information can be accessed from anywhere from the worlds. But there are also some disadvantages in it. As the data resides in one place, no two persons can access the same data. Sometimes, data is unavailable and is also not efficient as that of the distributed database systems. Another drawback is that if the data stored in it gets lost, then you cannot access the data but whereas in the distributed system, a copy of the data is maintained in every database and so even if the data gets deleted in one place, can be easily recovered.Example of database are sql,mysql,oracle,access and many
You can easily store the information in the database and to retrieve the information, you will need some software. To manage the data present in the database, you will need a database management system. Database software stores the data in tables. Each column or field has separate information about the item and each record incorporates the entire information of the particular item. The most commonly used database software used by small enterprises is the desktop database software. The advantages of database are many in number. Firstly, it alleviates the problem of having hard copies of different data. As the data is stored in digital media, you do not have to maintain file systems. Thus, you can save lot of environmental space. Secondly, data related to different applications are stored in the same place. This makes easier to share the data from anywhere. Secondly, as sometimes, same data are required for different application, it eliminates the problem of storing the information again and again. Thirdly, unlike traditional systems, where you have to go on purchasing shelves to maintain the records, here you can simply upgrade your database. Up gradation of the database is nothing but upgrading the hard drive of the database. Fourthly, the data and programs are independent of each other. Change made in one area will have a minimum or no effect on other data. Next, there is no possibility of having duplicate values or redundant values. With these many advantages, one should switch over to database systems to store their valuable transactions and other information.