Computer is a fast growing field. With the Increase of the Application and system software there is a need to save the information for reporting purposes. This can be done by using databases at the back applications.
Technology is growing day by day. Roughtly estimated there is a 1000 pages addition every day. Computer is one of the most important piece of technology now a days. Almost every researh, business, communication, new developments, study materials, books etc are computer based, and life seems to be out of track without a computer. Computers itself is divided into so many branches, for example software development, web development, Client server technology, processor technologies which are gaing speed day by day. Almost everything which is done using computers must be saved some where inorder to make reports, future references. Docmentations and office works also needs to be saved in some way. As the data is building day by day, the technology which is generally use to pull the current and historical data from the company is know as the Database.
Depending upon the business, there are certain types of databases which are very popular in market. Generally databases which save information for years is called the datawarehouse. Generally very expensive to purchase so the large enterprises, and the companies who have businesses all over the world usually afford it. The datawarehouses generally have a operational databases. From operational database the data travels to the dataware through the mounting area of the database. This is the reason these dataware houses are so expensive to purchase and operate.
The other type of database is the operational database. The operatonal databases are fast in nature becuase of the speedy flow of the business. The client requests the information for example logging into the web system or a client server system, and the request is returned to the client with in the matter of seconds with the logging successful screen or returns a login failed message. These operational databases generally knows as the “transaction processing system”. The Business operations are in the form of a “transaction” . this single operation is a boolean if completes then it completes every thing in the transaction block, if any piece of information is failed in processing the transaction then the whole block if failed and returns a false.
Generally the transactional proccessing databases are expensive depending up the work load they can carry on a perticular time. They are suited with backup and recovery tools to backup data for the of failure. The cost can vary from thousands to millions of dollars. The support is also an important factor in maintaing a Trasactional processing database. Companies use to charge millions of dollars annually to give support to the databases of this type.
There are some databases which are used in small scale for small business purpuses. They are easily to setup. Generally they are less complex and easily to maintain. They are well versed in reporting purposes. They dont require more cost in maintenance. Almost most of the small business organizations use this database to use mainly with their accounting operations to know how much profits they earn within the domain of the small business. since the operations are easy, the help file associated with them are well enough to learn them but requires some Computer information systems background to work with it. They are best for small business organizations.












Leave Your Response