Database

DATABASE

Specializing in the administration, design, architecture,
and engineering of relational databases,

Including Oracle, PostgreSQL, MySQL, and Microsoft SQL Server.

DESIGN

At Computer Services & Innovation Enterprises, we can design a database from scratch to fit your company’s needs. We focus not just on design and implementation, but also take into account the full lifecycle of your database system. Our design process can be broken into five different stages.

In the conceptual design phase, We begin with a conceptual idea based on what you describe in terms of data and what you need. From there, we begin the logical design stage, which includes the development of entity relationships, data domains, and constraints. The logical design stage focuses heavily on analyzing the data to be stored and organizing it in a logical manner. One of the key deliverables generated during this design phase is the Entity Relationship Diagram, or ERD, which visually illustrates out the various data elements in the database and how they relate to each other.

Once the logical design stage is complete, we move on to the actual physical design. During the physical design phase, we will take the ERD and begin to implement the actual database in software while helping you with the development of a data retention policy. Also included in this stage is consideration of the physical storage requirements for the database server and how the memory is to be allocated on it.  Next is the forward engineering phase, where the conceptual database developed in earlier stages is instantiated into a physical database and existing data is loaded into it. The final phase is deployment, where you and your employees can begin using the database.

ARCHITECTURE

The architecture of a building involves for more than what you can see on the outside and includes the structure that holds the building up and makes it useful to those who inhabit it. Along similar lines, the architecture of a database may not be obvious to those who use it but it is what makes the database useful and reliable. Just as an architect may need to make modifications to a building’s design, so a database developer may need to make changes, both logical and physical, to the architecture of a database.

Changes may be requested while a database is still in the design phase, which is to be expected as both the database developer and the customer gain a better understanding of the data and relationships involved.

At Computer Services & Innovation Enterprises, we are more than happy to implement the changes necessary for a database to meet our customer’s needs. And we can also make changes to an existing database that has already been in use, including databases we did not design.

ADMINISTRATION

Database administration includes the monitoring, troubleshooting, and maintenance of an existing database. The job of a database administrator (DBA) is to make sure that the correct data is available to users when they need it.

One of the key tasks of a DBA is monitoring the performance of the database.  The tasks of a DBA also include installing and performing upgrades on the database server itself as well as any application tools that access it. Another key aspect of a DBA’s responsibilities is developing a backup and recovery strategy for the database, testing those backups to make sure they are usable, and implementing backups if data has been compromised.

A DBA is also responsible for setting up profiles for users as well as implementing access controls and user permissions to ensure that only the right people can access sensitive data. A DBA is also responsible for migrating databases to new hardware or software when needed. DBAs also generate critical reports from the data contained within the database.

Computer Services & Innovation Enterprises can perform all the tasks of a DBA for your database system, making sure that you and your employees have fast access to reliable data.

ENGINEERING

The term database engineering can be used to refer to the design and development of database objects. There are many objects within a database beyond just the data itself, including views, triggers, and tables. These often need to be added to an existing database or implemented as part of the design of a brand new database.

This is another one of the database services offered by Computer Services & Innovation Enterprises for databases we have designed as well as those designed by others.

Menu