DATABASE MANAGEMENT SYSTEMS

Ascent Technology fosters a heterogeneous Database Technology and Services strategy. Our expertise covers a comprehensive range of Database Technologies – including Microsoft SQL Server, Oracle Database, MySQL, MariaDB, MongoDB, Azure Cosmos DB, PostgreSQL, EnterpriseDB and Sybase.

Microsoft SQL Server 2019
Transform your business with a unified data platform. SQL Server 2019 comes with Apache Spark and Hadoop Distributed File System (HDFS) for intelligence over all your data.

SQL Server 2019 brings innovative security and compliance features, industry-leading performance, mission-critical availability, and advanced analytics to all your data workloads, now with support for big data built-in.

For more information visit Microsoft.com

Install SQL Server 2019 on Windows, Linux, and containers

Preview SQL Server 2019

More Documentation
It’s all about choice. Now, you can get SQL Server 2017’s industry-leading performance and security on Windows, Linux, and Docker containers.

For more information visit Microsoft.com

Evaluate SQL Server 2017 with the SQL Server and Microsoft Azure SQL Database Trials

Download the SQL Server 2017 trial
Get a Microsoft Azure SQL Database trial

More Documentation
Gain real-time insights across your transactional and analytical data with SQL Server 2016 – a secure, scalable database platform that has everything built in, from advanced analytics to unparalleled in-memory performance – the first database that is born in the cloud, setting a new standard for the pace of innovation.

For more information visit Microsoft.com

Evaluate SQL Server 2016 with the SQL Server and Microsoft Azure SQL Database Trials

Download the SQL Server 2016 trial
Get a Microsoft Azure SQL Database trial

Also See

Upgrade to SQL Server 2016 with Ascent Technology

More Documentation
SQL Server 2014 enables customers to build mission-critical applications and Big Data solutions using high-performance, in-memory technology across OLTP, data warehousing, business intelligence and analytics workloads without having to buy expensive add-ons or high-end appliances. SQL Server 2014 uses a common set of tools to deploy and manage databases both on-premises and in the cloud, which makes it easier for customers to take advantage of the cloud with existing skills.

For more information visit Microsoft.com

Evaluate SQL Server 2014 with the SQL Server and Microsoft Azure SQL Database Trials

Download the SQL Server 2014 trial
Get a Microsoft Azure SQL Database trial

Also See

Upgrade to SQL Server 2014 with Ascent Technology

More Documentation
Microsoft SQL Server 2012 is a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization and quickly build solutions to extend data across on-premises and public cloud, backed by mission critical confidence.

For more information visit Microsoft.com

More Documentation
Business decision makers deploying Microsoft SQL Server technologies have adopted SQL Server 2008 because it optimizes their IT infrastructure for growth and improves their alignment with key business objectives. With up to 35% faster transaction processing, advanced business intelligence solutions and enhanced developer productivity, SQL Server 2008 builds on the strengths of SQL Server 2005. Enterprise and midmarket organizations upgrading to SQL Server 2008 will not only accelerate growth but also open exciting new opportunities for database administrators, developers and IT decision makers.

For more information visit Microsoft.com

More Documentation
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.

For more information visit Oracle.com

More Documentation
Oracle Database 11g delivers performance, scalability, availability, and security. All editions of Oracle Database 11g are built using the same common code base, which means applications easily scale from small, single processor servers to clusters of multi-processor servers without any application changes or lengthy upgrades. Additional options such as Real Application Clusters, Real Application Testing, Total Recall, Advanced Compression, Content Database, Database Vault and Data Warehousing; embeddable databases; and products such as Audit Vault, Secure Enterprise Search and Secure Backup, are also available to extend the customer solution.

For more information visit Oracle.com

More Documentation
MySQL is the world’s most popular open source database. With its proven performance, reliability, and ease-of-use, MySQL has become the leading database choice for web-based applications, used by high profile web properties including Facebook, Twitter, YouTube, and all five of the top five websites*. Additionally, it is an extremely popular choice as embedded database, distributed by thousands of ISVs and OEMs.

For more information visit Oracle.com

MariaDB is the fastest growing Open Source database with more than 12 million users worldwide. Started by the founders of MySQL, MariaDB Corporation is reinventing the database to support today’s enterprise needs from OLTP to analytics from a single SQL compliant interface. MariaDB products include the widely adopted open source MariaDB Server and complementary products including MariaDB MaxScale and MariaDB ColumnStore, that are valuable for deploying MariaDB in large, mission-critical environments.

Key requirements that drive adoption of MariaDB products are enterprise-grade performance, industry-leading security trusted by banks and government, world-class support and a modern, unique architecture, which is extensible at every layer so users and the community can extend functionality to meet unique needs.

For more information visit MariaDB.com

More Documentation
MongoDB is a cross-platform document-oriented database. Classified as a NoSQL database, MongoDB eschews the traditional table-based relational database structure in favor of JSON-like documents with dynamic schemas.

MongoDB calls the format BSON, making the integration of data in certain types of applications easier and faster. Released under a combination of the GNU Affero General Public License and the Apache License, MongoDB is free and open-source software.

For more information visit MongoDB.com

More Documentation
Azure Cosmos DB was built from the ground up with global distribution and horizontal scale at its core. It offers turnkey global distribution across any number of Azure regions by transparently scaling and replicating your data wherever your users are. Elastically scale throughput and storage worldwide, and pay only for what you need.

Azure Cosmos DB provides native support for NoSQL choices, offers multiple well-defined consistency models, guarantees single-digit-millisecond latencies at the 99th percentile, and guarantees high availability with multi-homing capabilities and low latencies anywhere in the world— all backed by industry-leading, comprehensive service level agreements (SLAs).

For more information visit Microsoft.com

More Documentation
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, macOS, 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.

For more information visit PostgreSQL.org

The EDB Postgres Platform provides an enterprise-class Data Management Platform based on PostgreSQL, including toolkits for management, integration, and migration; flexible deployment options; and services and support to deploy Postgres responsibly at scale.

EDB develops and integrates performance, security, and manageability enhancements into PostgreSQL to support enterprise-class workloads for its database, EDB Postgres Advanced Server. EDB has also developed database compatibility for Oracle to facilitate the migration of workloads from Oracle to EDB Postgres and to support the operation of many Oracle workloads on EDB Postgres.

Gartner positioned EnterpriseDB in the 2017 Magic Quadrant for Operational Database Management Systems, making it one of just 11 vendors to be included in the report and the fifth consecutive year the company was recognised. Gartner positioned EnterpriseDB in the Leaders Quadrant in its Magic Quadrant for Operational Database Management Systems in October 2014 and again in September 2015. EnterpriseDB was recognised in the Challengers Quadrant in the Magic Quadrant for Operational Database Management Systems in October 2016.

For more information visit EnterpriseDB.com

Sybase Adaptive Server Enterprise meets the increasing demands of large databases and high transaction volumes, while providing a cost effective database management system. Its key features include on-disk encryption, smart partitions and new, patent-pending query processing technology that has demonstrated a significant increase in performance, as well as enhanced support for unstructured data management. ASE is a high-performance, mission-critical database management system that gives Sybase customers an operational advantage by lowering costs and risks.

ASE 15 has the following features/benefits:
  • Smart Partitions: ASE 15 makes large databases easy to manage and more efficient by allowing you to divide tables into smaller partitions that can be individually managed.
  • Computed Columns: Often applications repeat the same calculation over and over for the same report or query. ASE 15 supports both virtual and materialized columns based on server calculations.
  • Functional Indexes: Functional indexes allow the server to build indexes on a table based on the result of a function. When repeated searches use that function, the results do not need to be computed from scratch.
  • Next Generation Query Engine: ASE 15 dramatically enhances the reporting of complex information through a patented query optimizer, which speeds query performance by supporting new techniques to optimize performance such as improved star-joins, hash-joins, join histograms, partition elimination, and goals-based optimization.
  • Self-Management and Embedability: ASE 15 has impressive technologies for reducing management overhead and improving embedability. These include a powerful job scheduler, automatic resource management, dynamic cache management, and high performance maintenance technologies. New to ASE 15 are Automated Statistic Updates, Graphical Plan Viewer and Enterprise View.

For more information visit Sybase.com