| DOTNUTSHELL Technologies are an experienced | | | | necessary) for data recovery and for some forms of |
| database designing company, with Oracle | | | | data replication. |
| accredicated qualification providing services both in | | | | The Oracle RDBMS stores data logically in the form |
| the OpenSource and Enterprise field. | | | | of tablespaces and physically in the form of data files. |
| Microsoft SQL Server is a relational database | | | | Tablespaces can contain various types of memory |
| management system. Its primary query language is | | | | segments; for example, Data Segments, Index |
| Transact-SQL, an implementation of the ANSI/ISO | | | | Segments etc. Segments in turn comprise one or |
| standard Structured Query Language (SQL) used by | | | | more extents. Extents comprise groups of |
| both Microsoft and Sybase. | | | | contiguous data blocks. Data blocks form the basic |
| Microsoft SQL Server uses a variant of SQL called | | | | units of data storage. At the physical level, data-files |
| T-SQL, or Transact-SQL, an implementation of | | | | comprise one or more data blocks, where the block |
| SQL-92. T-SQL mainly adds additional syntax for use | | | | size can vary between data-files. |
| in stored procedures, and affects the syntax of | | | | Oracle databases can be used to create distributed |
| transaction support. | | | | database running over contiguous or disparate |
| SQL Server includes support for database mirroring | | | | logistical locations. It can be used to store data and |
| and clustering. A SQL server cluster is a collection of | | | | information and provides high availably and |
| identically configured servers, which help distribute the | | | | performance and is used extensively as a practial and |
| workload among multiple servers. All the servers | | | | reliable database. |
| share an identical virtual server name, and it is | | | | We can design and engineer databases based on |
| resolved into the IP address of any of the identically | | | | your business model and provide tools and interfaces |
| configured machines by the clustering runtime. | | | | that can be used to mine your business data. We |
| Automatic failover clustering is also available, in which | | | | also have experience in database persistence and |
| the workload of a server is transferred to another | | | | create custom persistence frameworks and |
| system in the event of a system failure.SQL server | | | | algorythms which can be used to predict patterns |
| also supports data partitioning for distributed | | | | and trends from your data. |
| databases. Database mirroring, introduced in SQL | | | | MySQL is a multithreaded, multi-user SQL database |
| Server 2005, allows creation of mirrors (or replicas) | | | | management system which has, according to MySQL |
| of database contents, along with transaction logs, on | | | | AB, more than 10 million installations. The basic |
| another instance of SQL Server, based on certain | | | | program runs as a server providing multiuser access |
| predefined triggers. | | | | to a number of databases. |
| Microsoft and other vendors provide a number of | | | | Libraries for accessing MySQL databases are available |
| software development tools designed to allow | | | | in all major programming languages with |
| business applications to be developed using the data | | | | language-specific APIs. In addition, an ODBC interface |
| stored by Microsoft SQL Server. Microsoft SQL | | | | called MyODBC allows additional programming |
| Server 2005 now includes the common language | | | | languages that support the ODBC interface to |
| runtime (CLR) component for Microsoft .NET. | | | | communicate with a MySQL database, such as ASP |
| Applications developed with .NET languages such as | | | | or ColdFusion. The MySQL server and official libraries |
| VB.NET or C# can implement stored procedures and | | | | are mostly implemented in ANSI C/ANSI C++. |
| other functions. Older versions of Microsoft | | | | MySQL is popular for web applications and acts as |
| development tools typically use APIs to access | | | | the database component of the |
| Microsoft SQL Server functionality. | | | | LAMP (Linux-Apache-MySQL-PHP/Perl/Python) |
| We can design and engineer databases based on | | | | MAMP (Mac-Apache-MySQL-PHP/Perl/Python) |
| your business model and provide tools and interfaces | | | | WAMP (Windows-Apache-MySQL-PHP/Perl/Python) |
| that can be used to mine your business data. We | | | | Its popularity for use with web application is closely |
| also have experience in database persistence and | | | | tied to the popularity of PHP, which is often |
| create custom persistence frameworks and | | | | combined with MySQL. PHP and MySQL are essential |
| algorythms which can be used to predict patterns | | | | components for running popular content management |
| and trends from your data. | | | | systems such as WordPress and Drupal blogging |
| Oracle Database is a relational database management | | | | platforms. Wikipedia runs on MediaWiki software, |
| system released by Oracle Corporation. Oracle | | | | which can also use PHP and a MySQL database. |
| Database has become a major feature of database | | | | MySQL is the most widely used OpenSource SQL |
| computing. | | | | database in the world. It provides features and |
| An Oracle database system comprises at least one | | | | services which make it ideal for small to medium |
| instance of the application, along with data storage. | | | | enterprises to effectively manage small to reasonably |
| An instance comprises a set of operating-system | | | | large business data. It is also fulyl compliant with the |
| processes and memory-structures that interact with | | | | SQL standard and provides support for stored |
| the storage. Typical processes include PMON (the | | | | procedures and object abstraction when coupled with |
| process monitor) and SMON (the system monitor). | | | | object persistence frameworks. |
| Users of Oracle databases refer to the server-side | | | | We can design and engineer databases based on |
| memory-structure as the SGA (System Global Area). | | | | your business model and provide tools and interfaces |
| The SGA typically holds cache information such as | | | | that can be used to mine your business data. We |
| data-buffers, SQL commands and user information. In | | | | also have experience in database persistence and |
| addition to storage, the database consists of online | | | | create custom persistence frameworks and |
| redo logs (which hold transactional history). Processes | | | | algorythms which can be used to predict patterns |
| can in turn archive the online redo logs into archive | | | | and trends from your data. |
| logs (offline redo logs), which provide the basis (if | | | | |