Relational Database - Capabilities and Services

SMH Systems has over 20 years experience with relational database. We have designed and developed solutions operating on several database platforms including:

• DB2
• Oracle
• SQL Server
• Informix

The great majority of databases used by businesses today were designed many years ago, are well established, and have been accumulating data captured over years of operation of the applications that were constructed around them.  Our services for Relational Database focus on maximising value to your business of the data asset, and facilitating its exploitation through approaches such as data mining and data warehouse:

• Retrospective Documentation of established databases - accessible and high-quality documentation of data content and business purpose, as well as technical structure, is the key to unlocking additional value through projects such as data mining.
• Data Content and Quality Review - reliable data mining and reporting depends on being able to trust the assumptions that are made about content and quality of the data that is being analysed and aggregated
• Relational / XML Integration - interest is growing with the increasing use of XML for business documents and data transfers, and the major vendors offering their falvours of XML add-ons, and the emergence of searchable repositories for XML-based data these
• Analysis, Modelling and Design - there's still a need for the classic methodologies, to develop reporting databases and to assess and qualify existing assets
• Client-Server Network Performance - to ensure good network performance for the new reporting and business intelligence usages, particularly when deployed to remote offices over WANs or internet