Database
Design
Databases are more critical than ever before in our corporate
environment. We understand that secure, reliable, and fast
database connections play an important role in delivering robust
software applications. Whether you need the flexibility of a
dynamic database driven web site or a high powered enterprise
software application, Coleman Consulting has over 15 years of
experience using Relational Database Management Systems (RDMS).
Our RDMS expertise includes Oracle, Informix, SQLServer, and
Microsoft Access.
Performance
Coleman Consulting is fluent with performance tuning techniques
of each database vendor. Whether it be the use of triggers, stored
procedures, indexes, or views, we can provide the data to your
application as fast as possible. We also have the ability to use
PL/SQL which is a sophisticated programming language that is
integrated with the database server to process data quickly and
efficiently. This also allows flexibility when accessing data from
various environments.
Security
Whether its customer data or credit card processing via the
web, Coleman Consulting understands how important security is.
Regarding e-commerce sites, all credit card transaction activity
and payment information is conducted with the protection of a SSL
Certificate. Our database servers are located behind
firewalls to protect user data from malicious attacks. Finally,
each application is written to find the correct balance between
performance and security so that each data transaction is
performed as quickly and safely as possible.
Technology
We use the latest versions of ADO and JDBC for database
connectivity in the applications we develop. These database
schemas allow connectivity to most RDMS and non-relational
database stores such as Microsoft Outlook or a multi-dimensional
database. RDMS features change frequently, so as a company we
strive to stay in front of the RDMS feature releases so we can
educate our customers.