Database Development

Encodium does end-to-end database development. This ranges from data modeling, where we gather your requirements to create an optimal database schema, to database programming, where we develop highly scalable reports, forms, stored procedures, and front-end applications.

Data Modeling
In the relational database world, data modeling is the process of creating a normalized structure to store business data. It is a two step process that involves gathering requirements and generating an efficient storage structure. Encodium does data modeling for Oracle, SQL Server, MySQL, and MS Access databases.

Reports
Reports are a popular way to render and format database data. We have the ability to generate sophisticated reports using tools such as Crystal Reports and MS Access.

Forms
Encodium develops complex MS Access forms to rapidly prototype database applications and to implement user interfaces for MS Access databases.

Stored Procedures
Centralizing business logic for reuse by a pluarlity of user interfaces is the goal of contemporary database development. Encodium utilizes stored procedures, which are business rules embedded in a database, to achieve this goal. We write stored procedures in PL/SQL, Transact SQL, MySQL, and VBA.

Connectivity Libraries
Most often, reports and forms are not powerful enough to generate advanced user interfaces. Under such circumstances, we implement user interfaces using programming languages such as C#, Java, and C++. These user interfaces communicate with databases using connectivity libraries such as ODBC, JDBC, ADO.NET, and MySQL C API.