Database Development, Logical Data Modeling, Physical Database Design, DDL
General Blue experts have extensive experience with data management and data modeling (logical and physical) for numerous large scale database designs of online transaction processing (OLTP) databases to enable operational systems and online analytical processing (OLAP) cubes for data warehouses, data marts and business intelligence (BI) activities. We utilize Erwin and Embarcadero products to help create effective logical and physical designs. Our services include the ability to generate scripted database changes and new database DDLs, to include tables, indexed views, indices, and file allocation of your tables to enhance the performance of your database.
SQL Server 2000 / SQL Server 2005
Highly Trained SQL Server Expert Developers and Database Administrators
Our database experts are highly skilled with SQL Server. All of our experts have experience with the following versions of SQL Server 6.5, SQL Server 7.0, SQL Server 2000 and SQL Server 2005.
Extensive SQL Server Development (Departmental or Enterprise)
Our Database Developers and Database Administrators have extensive experience with designing smaller departmental database design, as well as high-volume OLTP systems. Our DBA's have extensive experience with exploiting the latest techniques in SQL Server 2005 to give you robust and high performance database designs.
Transact SQL (T-SQL) Development
Our database developers are highly effective with T-SQL development and can either review or development new stored procedures to keep your database application up to date.
Upgrade to SQL Server 2005
We can help you upgrade to the latest version of SQL Server 2005, no matter what version you are currently on. Our team can review your existing code bases to check for upgrade issues, once all of those issues are resolved we can perform the upgrade to your existing database in a controlled manner enabling a timely and controlled switch to the latest database server.
Performance Problems with SAN and RAID Configurations
Our DBA's are highly trained in the latest techniques for setting up sophisticated SAN/RAID configurations for SQL Server. We will help you choose the correct RAID levels from RAID 1, RAID 5, RAID 1+0, RAID 10 for your data files, log files and back up files. Setting up multiple data files can help your corporate databases serve up more users and achieve higher transaction rates.
Remote DBA Services
To learn more out about our remote DBA services for SQL Server follow the link below.
MySQL
Our MySQL experts can assist you in the design and development of your databases.
Many different table types exist within MySQL furthering the need for expertise in choosing the correct type for your application. We will help you choose from MyISAM, MERGE, ISAM, HEAP, InnoDB, or Berkeley-DB (BDB).
ADABAS
What is ADABAS?
ADABAS a product of Software AG is probably the world's most misunderstood data base management system (DBMS) born from innovation in Darmstadt, Germany as the "Adaptable" database. It's ability to adapt comes from the internal Inverted List architecture, making it easy to modify key data access where any field, compound of multiple fields or partial fields may be created on-demand.by database administrators. Adding new fields is just as easy. The Inverted List enables ADABAS to project multiple views for any set of fields from a single normalized data file (table) or a complex structured data with repeating data fields. The Inverted List easily supports pure relational data models. These key features makes it highly adaptable to rapidly changing business requirements and data modeler preference.
Leverage the Adaptable Feature of ADABAS
General Blue database specialists and architects have the expertise to help you leverage the full adaptable features of ADABAS for demanding business environments. Services we provide for ADABAS adaptable features are: logical data modeling, physical data modeling for efficiency, transactional analysis, application analysis for obtaining efficient data access, schema design with leverage of null data feature, ADABAS utility setup and execution for schema changes, data migration, file compression, space management, and implementation of the PREDICT Data Dictionary for pro-active schema management.
Achieve High-Performance for your Applications
ADABAS is famous for high-volume transaction processing, providing optimal throughput for large scale applications worldwide. The ultra-high processing speed of over 300,000 transactions per second exceeds the relational data base system (RDBMS) of the competitors with less IT investment.
Exceed High-Volume Transaction Processing Goals
General Blue performance specialists help you configure your computing environment and ADABAS to achieve these spectacular results at a lower cost. Services we provide for achieving your performance objectives with all important technical factors to optimize a specific ADABAS implementation: ADABAS nucleus parameter tuning, physical and logical file placement layout on data storage, data base sizing, space management strategy, and scheduled utility maintenance of internal data components.
Complex Systems Integration
Following with the adaptable philosophy ADABAS has as evolved to be a sophisticated integrated solution deployed with multiple computing technologies. Costly systems integration project costs can be greatly reduced with ADABAS using SQL, Web services, XML, Java and .NET standards freeing development staff from being required to have knowledge of ADABAS. ADABAS preserves common features across mainframe, Linux, UNIX and Windows platforms. This gives you multiple options to help you adapt ADABAS to your changing infrastructure and architecture. General Blue Architects use their extensive experience with multiple technologies and numerous implementations of ADABAS for major corporate customers to best service you integration requirements.
Expert Systems Administration Services
General Blue administrators can keep your database current and reliable with Systems Administration Services: ADABAS software installation, upgrades, distributed environment configuration, data backup and recovery, maintenance utility setup and systems integration configuration.
Quality Architecture Services
General Blue architects prepare you the road-map to optimize your investment in computing resources and technical staff with professional systems integration and architecture design services. Starting with a Systems of Principles (SOP) statement prepared during the planning sessions setting out your integration requirements for your ADABAS system, we set out your specific goals and requirements for seamless integration with your in-house technology mix. The SOP initiated with a General Blue model framework for integrating four domains: business process architecture, application architecture, data architecture and technical architecture. Special attention is given to utilize ADABAS capabilities to deliver high system performance, reliability, support for rapid software development, adaptability for change, data integrity, lowering cost of on-going maintenance, and establishing an architecture with ADABAS being the core component for scalability and growth.