Monday, September 30, 2013

When do you need a database consultant ?

How are databases managed?
A database is a collection of data. All data is accumulated into a bucket then organized into rows and columns using a table. Column headings are fields and the content of each row is a record

Databases are managed using database management systems (DBMS) such as Microsoft Access, MS SQL Server, MySQL, Oracle, Sybase, DB2, etc...

What does a database administrator do?
In an enterprise, the database administrator (DBA) is member of the information systems department. He monitors all changes related to all the database platforms in the company. Database administrators are project managers knowledgeable in database integrity rules, computer hardware, networking and technical writing.

What is the role of database consultant?
In addition to providing all the services that a database administrator fulfills, the database consultant provides also ensure that all current applications are compatible to your database and provides an independent bridge when planning a new software between the information systems team, the development team and the business users.

When do you need a database consultant?

1.  You are planning to purchase, design or implement a new: 
  • Enterprise resource planning software
  • Customer relationship manager software

 2. "The system is running too slow"
I once called to work an assignment where at the end of each business day, the OCR Software used by a successful company ran extremely slow. The OCR software was written in VB.NET and returned the date to SQL server 2005.
The OCR  Software collected the data locally and at the end of the day (around 3 PM), each user would finalize their day entries and most readings would fail .  
After running a trace, I discovered that although the company had paid for 8 licenses of the software, the third party vendor had installed a single license on all the 8 devices therefore at the time of finalization, transactions failed.
3. Your business is drowning in a sea of Microsoft access databases
If you are creating multiple Access databases in order to accomplish tasks such as inventory management, task managements and more. It may be a good time to discuss with a database consultant a strategy to consolidate.

4. You are migrating from a legacy system to a new database driven system.

Initial visit 
Most database consultants will discuss business goals, integration and expansion as part of the initial visit. It is easier to plan a database expansion than support one that was not properly created.

To request a quote for an effective landing page that will attract new clients. Contact us

Written by D. Brooks
Alexis Information Systems