Database Development and Administration

Maintaining data integrity and consistency


G2’s database development and administration solutions place data integrity, consistency, and high availability as top priorities. The G2 team accomplishes these goals by designing and implementing elegant database solutions for a wide range of needs, such as these:   

• Documenting database designs and entity relationship diagrams using unified modeling language (UML) and XML schema with tools such as Rational, Enterprise Architect, and MySQL Workbench

• Developing and maintaining applications and databases using WebLogic, JBoss, Tomcat, Glassfish, Apache, Java, .NET, C#, MS SharePoint, Oracle, MySQL, MS SQL Server, and PostgreSQL

• Defining, refining, designing, and developing the architecture for:

  • GCCS-J track servers fed from multiple external sources such as Joint Range Extender (JRE) feeds from N-NC mission partners that feed an internal web-service-enabled track database for all SAGE, A/EISS, and M/EISS mission application needs
  • An internal set of N-NC track databases using PostgreSQL to expose various database views as net-centric service endpoints for N-NC mission apps and JIIM partners

• Designing and implementing database layer for geospatial data marshaling as OGC features in geographic markup language (GML) and providing tailored and tuned environments in MySQL, PostgreSQL, and Microsoft SQL Server. (This database tier holds the business logic for program access and process C4I data from all the legacy, exercise, operational, and experimental data sources and provides the basis for data fusion.)