Database servers are essential to the majority of internet based businesses. Many applications including CRM, ERP, content management systems and shopping carts require lightening fast databases to provide content in real time. CoreSpace’s SQL database servers are optimized to run your database at its highest performance. Our dedicated Technical Staff is available 24/7/365 to assist you in all of your SQL needs.
Microsoft SQL Server 2008 and 2012 are available as an Add-On to all of the CoreSpace Managed Windows Servers. MSSQL Server offers a very quick and robust database engine and SQL Query Language to fit any SQL DB Admin’s needs. Talk to your CoreSpace Sales Professional to add Microsoft SQL Server 2008 or 2012 to your Managed Windows Server today!
Multiple Pages or Same Page for Multiple Editions: MySQL Community Edition
MySQL Community Edition is the freely downloadable version of the world’s most popular open source database. It is available under the GPL license and is supported by a huge and active community of open source developers.
The MySQL Community Edition includes:
Pluggable Storage Engine Architecture
Multiple Storage Engines:
NDB (MySQL Cluster)
MySQL Replication to improve application performance and scalability
MySQL Partitioning to improve performance and management of large database applications
Stored Procedures to improve developer productivity
Triggers to enforce complex business rules at the database level
Views to ensure sensitive information is not compromised
Performance Schema for user/application level monitoring of resource consumption
Information Schema to provide easy access to metadata
MySQL Connectors (ODBC, JDBC, .NET, etc) for building applications in multiple languages
MySQL Workbench for visual modeling, SQL development and administration
Available on over 20 platforms and operating systems including Linux, Unix, Mac and Windows.
PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.
An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance. It supports international character sets, multibyte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. It is highly scalable both in the sheer quantity of data it can manage and in the number of concurrent users it can accommodate. There are active PostgreSQL systems in production environments that manage in excess of 4 terabytes of data. Some general PostgreSQL limits are included in the table below.
Maximum Database Size Unlimited
Maximum Table Size 32 TB
Maximum Row Size 1.6 TB
Maximum Field Size 1 GB
Maximum Rows per Table Unlimited
Maximum Columns per Table 250 – 1600 depending on column types
Maximum Indexes per Table Unlimited
MariaDB is a drop-in replacement for MySQL.
MariaDB strives to be the logical choice for database professionals looking for a robust, scalable, and reliable SQL server. To accomplish this, Monty Program works to hire the best and brightest developers in the industry, work closely and cooperatively with the larger community of users and developers in the true spirit of Free and open source software, and release software in a manner that balances predictability with reliability.
MongoDB (from “humongous”) is an open-source document database, and the leading NoSQL database. Written in C++, MongoDB features:
Document-Oriented Storage »
JSON-style documents with dynamic schemas offer simplicity and power.
Full Index Support »
Index on any attribute, just like you’re used to.
Replication & High Availability »
Mirror across LANs and WANs for scale and peace of mind.
Scale horizontally without compromising functionality.
Rich, document-based queries.
Fast In-Place Updates »
Atomic modifiers for contention-free performance.
Flexible aggregation and data processing.
Store files of any size without complicating your stack.
Professional Support by MongoDB »
Enterprise class support, training, and consulting available.
Oracle Database 12c introduces a new multitenant architecture that makes it easy to deploy and manage database clouds. Innovations such as Oracle Multitenant, for consolidating multiple databases quickly, and Automatic Data Optimization with Heat Map, for compressing and tiering data at a higher density, maximize resource efficiency and flexibility. These unique advancements, combined with major enhancements in availability, security, and big data support, make Oracle Database 12c the ideal platform for private and public cloud deployments.
Oracle Database 12c comes in three editions and features a wide range of enterprise edition options to meet specific customer requirements in the areas of performance and availability, security and compliance, data warehousing and analytics, unstructured data, and manageability.