Data Manipulation Programming | Prepare custom data streams (data sets) using SQL queries | Develop persistent store modules (store procedures, functions) using different SQL/PSM implementations |
- SQL (from ANSI:92 to ANSI:2008 standards)
- Analytical functions
- SQL/MED, SQL/XML
| - T-SQL (MSSQL)
- PL/SQL (Oracle)
- SQL PL (IBM DB2)
- SQL/PSM (MySQL)
- External Java and C/C++ functions
|
| Develop various data manipulation scripts | Technologies applied in data manipulation programming |
- load/unload data
- prepare data using third-party software
- exchange data between DBs (db engines)
- prepare data for import
- process data after export
| - SQL Plus
- SQLCMD, iSQL
- Unix/Linux shell script languages (Kern shell, Bourne shell, C-shell, Z-shell, etc)
- Window Power Shell
- Windows Script Host
- JScript
- Perl
- Export/Import utilities (DB engine specific)
|
Data Mining Our specialists have extensive experience in utilizing Data Mining Techniques for data warehouses including:
Rule-based classifications | Sequence, Link, Text Analysis DB (Re)Design / Reverse Engineering Restoring encrypted database models and the db files structure for MS SQL, Microsoft Jet, and Oracle
physical / logical data model | DDL scripts | sizing estimates DB Administration - Data warehouse maintenance
- Creating / distributing patches for DB structure updates
- Issuing / implementing recommendations for db performance optimization
| Tuning time-consuming queries Introducing replication Automating backups Analyzing performance
|
DB Development Price List Type of task | Resource | Time unit | Price, USD |
DB Design / Redesign
| DB Specialist | 1 hour | 20 |
Reverse Engineering
| DB Specialist | 1 hour | 22
|
Data Manipulation Programming
| DB Specialist
| 1 hour | 18 |
Data Mining | DB Analyst | 1 hour | 18 |
DB Administration | DB Administrator | 1 hour | 18 |
DB development, design, and maintenance tasks are among our core competencies. Softheme’s engineers have in-depth experience in a broad array of Relational Database Management Systems such as Oracle, Microsoft SQL, mySQL, Firebird, and DB2. Our DB expertise includes data manipulation programming, db design, data mining, reverse engineering of the databases, db administration/performance tuning.
In addition to utilizing the latest technology Softheme’s db engineers strictly follow coding standards and conventions when developing, formatting and commenting program code: queries, persistent store modules (procedure and functions), and scripts. We also utilize automation testing to correspond the highest quality standards.
DB Development and Support services we offer:
- Database Design/ReDesign
- Database Redesign
- Data Mining
- Reverse Engineering
- Porting
- Performance Tuning
- Maintenance and Support
- GUI for DB Applications
- SQL
- PL/SQL
- TSQL
- Oracle
- MSSQL
- MS Jet
- mySQL
- PostgreSQL
- Firebird
- DB2
Softheme’s employees have contributed in developing automated systems for Ukraine National Railway, Ukraine Pension Fund, Credit Bureau, Banks, Financial Institutions, and Governmental Organizations.
Mantas risk and compliance behavior detection solutions, USA
The Mantas risk and compliance solutions operate within the Reveleus GRC framework as part of i-flex's Analytical Applications offering:
- Mantas Anti-Money Laundering
- Mantas Trading Compliance
- Mantas Broker Compliance
- Mantas Fraud Surveillance
K2TOR K2Tor is a freeware utility that looks inside the Oracle internal data storage mechanism. It processes db files retrieving the data structure and is at-hand in cases when the db files can not be open/read by the Oracle engine.
K2Tor knows how Oracle stores various formats of data and is indispensable tool for Oracle db administrators. Written in C/C++, optimized for Linux and Windows Operating Systems.
Ukrainian State Passport System
The automated system that covers process of issuing passports and IDs including the manufacture of ID cards and passports, data warehousing, and IT infrastructure required to issue these technologically-advanced and secure documents.
