Application Of Database Deployment For A Small Growing...

Unfortunately, different areas of the business got different pieces of technology to assist in that growth, and those pieces did not interact with each other. This became a burden for the Chief Financial and Technical Office, Luis Campuzano. Eventually, the company hired a third-party programmer to write a custom application that could interpret the data between the databases and allow FileMaker Pro software to query all of them at once (Rainer, 2012). Crabby Bill’s developed different databases to manage the different types of data that they were using. They had databases for financial information, keeping track of inventory, and others. This has the advantage that for someone to access the financial records, they only have to view†¦show more content†¦This is also good security since you can easily just not give those people managing inventory access to the financial database, whereas if they were stored in the same database, you would need to configure special permissions on the data, again requiring someone with greater knowledge of information systems than the typical business owner has. The problems for these multiple databases arise when you realize that part of your financial information has to do with your inventory. Getting this data out of one system and into another can be a daunting and time consuming task. This would likely require someone to manually extract, reorganize, and import the data, just as it did in the case of Crabby Bill’s. This is expensive, as it requires someone’s time to perform these actions. It is also time consuming because the whole process could be automated. In addition to these business reasons, there also are problems for the data itself. When keeping data in multiple databases you run into problems of data redundancy, when information extracted from one database is imported into another, you are keeping the same data repeatedly. This redundancy can also lead to inconsistencies, if the data is entered incorrectly into one of your databases or changed by one party that only has access to it on a single database and not on