ddms: Database Services

By: Ddms  06-Dec-2011
Keywords: User Interfaces, Database Administrators

Benefits of Relational Databases

A properly configured relational database can not only increase the speed and efficiency which data are accessed, but by connecting disparate pieces of data, can also yield new information that is not otherwise obvious. In a relational database, each record of data is related to other data records in other tables by a key identifier. This allows the collective database to store information more efficiently than simply storing one massive table of data.

Traditionally, data has been analyzed in smaller, more manageable segments. Analyzing data as a whole allows one to realize trends and interactions that may not be obvious when they are considered on an individual basis. Analyzing larger sets of data is also more efficient in that procedures that often need to be repeated for each set of data can be performed a single time. There are also great advantages in the ability to store all the data associated with a site in one location. This is not only a more efficient manner to store data, but also provides a mechanism to query data for specific desirable parameters associated with a specific project.

Types of Databases

The type or brand of database one uses depends on the:

  • The end use of the database;
  • Who will need direct access to it and what their skill sets are;
  • The applications which it will support; and
  • The expertise at hand to manage it

Microsoft Access® is the most common "desktop" grade database. Larger applications and needs require databases that run on a dedicated server and are often referred to as enterprise databases. These databases include commercial applications including Oracle® and Microsoft SQL Server® and Open Source database applications such as MySQL® and PostgreSQL®. Databases can also be configured to store spatial or GIS data; examples of these include ArcSDE Server®, Oracle Spatial®, and PostGIS for PostgreSQL.

User Interfaces

The data stored within a database is only useful if it is accessable to users realizing not everyone's strengths lie in database administration or SQL (a database language used to cull and manipulate data). To make a database more accessible to more users, ddms's database administrators create user interfaces or forms which are commonly used to access and possibly enter data into a database. Many software applications available today are nothing more than a front end user interface used to access a database which operates behind the scenes.

ddms excels in user interface design and creation. We have built front end interfaces for applications from robust time and expense tracking utilities to field applications which run on a Tablet PC used to record soil boring lithology. User interfaces can be created using a variety of platorms (i.e. Java, Visual Basic .Net, etc.). Visual Basic for Applications is commonly used to rapidly create user interfaces as a front end to databases such as Micoroft Access.

ddms Database Management Services

Whether you are interested in migrating data from hard copy documents or spreadsheets or currently use databases but would like to build on or have them managed, ddms can help you attain your database goals.

Keywords: Database Administrators, User Interfaces

Other products and services from Ddms


ddms: Environmental Data Services

This unique combination of expertise enables ddms to provide its clients with a true depth and understanding of not only environmental database systems, but also the myriad of analytical, field measurement, lithological and quality assurance data within. These projects generate reams of data in a myriad of formats from hard copy documents to spreadsheets to complicated proprietary databases.


ddms: Environmental Chemistry Services

Our personnel can assist to determine appropriate analytical methods to achieve the project goals, coordinate the analytical efforts with the laboratory, provide oversight or audits of field activities, track delivery of samples to the analytical laboratory, and follow the samples through the laboratory to help ensure on-time results.


ddms: Environmental Litigation Support

One of the most cost intensive aspects of any litigation is the simple day-to-day management and organization associated with tracking schedules, finding key documents and working through the mechanics of communicating and distributing data in a secure and appropriate fashion within the team.


ddms: Environmental Visualization

Earth and environmental visualization and analysis differs from environmental data management in that the latter is the process of organizing existing data and the former is the process of translating that data into knowledge through the utilization of sophisticated software.


ddms: EMIS

Ddms does not utilize a one tool fits all scenario approach, but instead listens to what the specific needs and challanges associated with any one effort are before recommending whether a third party system or custom implementation be utilized.


ddms: GIS

ArcObjects is a programming language created by Environmental Systems Research Institute for its industry leading GIS applications including ArcGIS ArcMap®, ArcCatalog®, ArcToolBox®, ArcSDE®, ArcGIS ArcEngine®, ArcGIS ArcServer® and many other applications and extensions.