|
| |
|
|
| |
The Technical team at MDT InfoTech has extensive experience in Database Application Development, setting up and using different databases, from small and fast MySQL, used for small projects, to huge and efficient Oracle database servers with complex structure. We have a strong team with strong database management background and PL-SQL programming experience.
We have database administrators who can perform operations like setting up and administration of our customers' database servers. The team at MDT has strong expertise of making complex Database Applications on
• MS SQL Server
• MySQL
• Oracle
What we do for database design / development
• Data Modeling – design and organize data structures for database,
including data objects, associations between data objects, and rules that govern
objects operations. We are familiar with Entity-Relationship (E-R) approach and the
Object Model.
• Stored Procedure – a stored procedure is a named group of DB statements that
have been previously created and stored in the server database. We develop stored
procedures to reduce network traffic, improve performance and ensure the integrity
of the database.
• Database Trigger – a DB trigger is a stored procedure that is invoked automatically
when a predefined event occurs. DB triggers enabled DBA to create additional
relationships between separate databases.
• Database Development – MDT InfoTech offers our clients the top-of-the-line
database development services tailored to client's specific needs, either for a
database driven website or a full-featured, largescale system with complex
structure.
• Database Troubleshooting – MDT InfoTech has skilled DBAs who are
knowledgeable with Oracle and SQL Server and willing to solve any
time-critical complex DB issues.
|
|
| |
|
|
|
|
|
| |
| Case Study: |
| |
An E-business System
The client required an advanced e-business system to increase management level and efficiency in sales, production, inventory, purchasing, accounting, and other aspects. Most of the corporate's departments, such as management, sales, distribution, production, warehouse, compounder etc. would be involved in this e-business system.
|
|
|
|
| |
|
