Database refers to the collection of information that is organized and can be accessed according to the logical structure of the company. While relational database is a series of logically related two dimensional files that stores information. (Adriaans & Zantinge 1996)
Database is characterized by the collection of information and created with a lot of logical structures. It includes the logic within the information and the in built integrity constraints. A database has got five components.
These include; DBMS engine, Data definition system, data manipulation subsystem, application generation subsystem and data administration subsystem. Some the databases used in the functioning of the business are;
Databases resources management-This is the managerial activity applied to information system that helps in the management of organization resources.
Analytical database-This is read only data base which appears in the form of inventory catalogues. Examples are those used by the AMAZON.
Operational databases- These are databases that are used in the management of a more dynamic data. (Laudon & Laudon 2002).
Hierarchical databases- This explains the hierarchical explanations of the data. Having the data upside down is the best method to visualize it. This relates to information such as those of employers to employees. (Han & Kamber 2001).
Network databases are defined as the specific database which is meant to solve a problem. It represents the data in terms of sets.
Data mining involves taking a keen look at the given existing information from a given database that is generated as part of the ongoing business process and then peeling the data apart for a given particular insight into the business. (Loeckx, Ehrich & Wolf 1996).
This applies succinctly to the management approach. Various scenery that are available in business constantly changes all the time. Data mining helps one get in touch with information about what is going on presently and also the historical records. This will be necessary as it will help us know what has been changing. Data mining helps in the building of work and some form of knowledge.
Data house has got the characteristic of multidimensionality. It also involves support decision making and not the transaction processing which contains summaries of information and details? Some of information which can be obtained from data mining includes.
The company can obtain information about the client’s contacts. The company will be in a position to reach many clients if applies data mining technique. The firm will also ensure that marketing is done to increase market base.
Abu Dhabi Municipality can obtain the information about the prices which are charged by other companies. This will involve comparison with other firms and therefore calculating the actual prices which should be tagged for the products which are being produced. (Adriaans & Zantinge 1996)
Data mining will place Abu Dhabi Municipality with an opportunity to identify the best platform to do or advertise the company products. Research and existing data indicate that, the company will be in a position to identify the methods of advertisement which are suitable in the advertisement.
Through data mining, the firm will be in a position of knowing the specific type of distribution channel that best suites them. The data obtained will be important in calculating the costs and to quickly reach most of their customers in a short span.
Through this, it will be easy to increase sales at Abu Dhabi Municipality. Various services which are being offered will also be enhanced. This is because the decision to produce will be based on the customized results.
Management of company’s accounts is another important factor. Through data mining it will be easy to ensure that all the financial records are kept. Through this the firm will be in a position to obtain that data which will ensure transparency in the management.
Structured Data
Data can either be structured or non-structured as forms of classifications in companies. Unstructured data refers to any data which is not identifiable structure. There are a number of unstructured data that Abu Dhabi Municipality has access.
These include; excel spreadsheets, word documents, email messages, RSS feed, audio files and video files. Of all these, the company’s operations have applied the use of excel spread sheet. Excel spread sheets are associated with a myriad of benefits.
The company preferred the use of excel spreadsheets since it can contain the names, contacts and locations of their clients. Transaction and the general business have been made easier. Since excel sheet contains various formulas, the company will use this to keep various financial records. (Mena 1999)
Finally, the paper advises that Abu Dhabi Municipality may consider the use of data warehouses to ensure that information is readily available. Other forms of structured data are databases, XML data, data warehouses, Enterprises systems such as the CRP and ERP.
References
Adriaans, P., & Zantinge, D. (1996). Data mining. Harlow, England: Addison-Wesley.
Han, J., & Kamber, M. (2001). Data mining: concepts and techniques. San Francisco: Morgan Kaufmann Publishers.
Laudon, K. C., & Laudon, J. P. (2002). Management information systems: managing the digital firm (7th ed.). Upper Saddle River, N.J.: Prentice Hall.
Loeckx, J., Ehrich, H., & Wolf, M. (1996). Specification of abstract data types. Chichester: Wiley ;.
Mena, J. (1999). Data mining your website. Boston: Digital Press.