Overview of Sybase ASE In-Memory Database Feature

Overview of Sybase ASE In-Memory Database Feature

With the recent release of the latest version of its flagship product Adaptive Server Enterprise version 15.5, Sybase has stepped into In-Memory database area.

Unlike Oracle’s TimesTen, Sybase’s In-Memory database feature is fully integrated within the base product Adaptive Server Enterprise. In-Memory database is a part of Adaptive Server Enterprise software and hence does not require any kind of separate in-stallation, it has been tightly integrated with ASE software.

So what is In-Memory database all about? There is a constant need for today’s businesses to process real-time data while being extremely fast when responding to user queries; this is an era of sub-second query response time. With the servers becoming capable of handling more and more memory and at the same time memory being more and more affordable, it is now possible to have a database fully reside inside memory.

Disk i/o in RDBMS has been a big bottleneck in performance. In-Memory database resides inside memory and hence eliminates the need for disk i/o giving superior performance over disk resident databases.

Overview of Sybase ASE 15.5 In-Memory Database

With the introduction of In-Memory database now there are mainly 3 types of databases in ASE:

    * Disk Resident Database — Traditional ASE Databases including user created tempdb

    * In Memory (IMDB) — In-Memory Database, resides fully in memory , in-cluding user created tempdb

    * Disk Resident Relaxed — Gives you an option to have data flushed to disk with ‘polite shutdown’

Let’s take a look at how IMDB works in Sybase ASE. IMDB is not designed for recovery. A traditional ASE database always preserves data after restart. With In-memory database, data is lost after the restart of a server or system failure. The way the Relaxed Durability Database behaves is somewhere in the middle of traditional ASE and In-memory database, i.e. it gives an option to the user to preserve data if the server is shut-down using “shutdown” command (polite shutdown). Such behavior is defined with the parameter “durability” while creating a database.

There are 3 types of durability levels:

    * full — Default option, all transactions are written to disk , transactions are not lost after restart

    * no_recovery — transactions are lost after restart, database is recreated using model or template database – if defined so

    * at_shutdown — Transactions are written to disk with polite shutdown but transactions will not be written to disk in case of abrupt shutdown or system crash

The In-memory database is created using the “in-memory” parameter of “create database command”.

Controlling DML Logging Behavior with ASE 15.5

Until ASE 15.5, there was no control over transaction logging and you always thought you wanted the mechanism so that not to log bunch of transactions, voila!! it has arrived !. In ASE 15.5 it is possible to control DML transaction logging behavior. There are set of rules which govern scenarios in which DML statements are minimally logged. DML logging behavior can be controlled at different levels.

    * Database-level logging
    * Table-level logging
    * Session-level logging

There are 2 types of DML logging:

    * full – DML is logged , default behavior
    * minimal – DML is minimally logged

DML logging can be specified using “create database” or “alter database” commands for database level, using “create table”, alter table”, “select into” at table level and using “set dml_logging” command at session level

Creating In-Memory Database in Sybase ASE 15.5

Below mentioned steps explains how to create in-memory database in ASE 15.5 step by step.

    1. First step is to create memory cache. Allocate enough space to cache such that size of the cache is bigger than the size of your database.

    sp_cacheconfig IMDB_tempdb_cache, “60m”, inmemory_storage,”none”, “cache_partition=4”

    If you execute sp_cacheconfig you will see that for IMDB_tempdb_cache type is “In-Memory Storage”

    2. Once you have created cache, you need to create in-memory device. You can refer to the cache name which you created in step 1 while creating in-memory device.

    DISK INIT name = “IMDB_dev”, physname = “IMDB_tempdb_cache”,
    size = “60m”, type= ‘inmemory’

    If you execute sp_helpdevice IMDB_dev you will see “virtual cache device” in the description

    3. Once you have cache and device , you can create in-memory database using that device

    CREATE inmemory TEMPORARY DATABASE temp_IMDB
    on IMDB_dev = “40m” with durability = no_recovery

    If you execute sp_helpdb tempdb_IMDB , you can see “in-memory” displayed in the status column.

    4. To change DML logging behavior at database level you can execute below mentioned command

    alter database temp_IMDB set dml_logging=minimal

    5. There are some new functions introduced in ASE 15.5 to check “durability” and “dml_logging” status. To check the durability and dml_logging settings for the database created above , you can make use of db_attr function.

    select db_attr(“temp_IMDB”,”durability”)
    go
    select db_attr(“temp_IMDB”,”dml_logging”)
    go

As we noticed above, with the release of ASE 15.5 version, now it will be possible to have In-Memory database created within ASE and also make use of minimally logged DMLs.

devx-admin

devx-admin

Share the Post:
USA Companies

Top Software Development Companies in USA

Navigating the tech landscape to find the right partner is crucial yet challenging. This article offers a comparative glimpse into the top software development companies

Software Development

Top Software Development Companies

Looking for the best in software development? Our list of Top Software Development Companies is your gateway to finding the right tech partner. Dive in

India Web Development

Top Web Development Companies in India

In the digital race, the right web development partner is your winning edge. Dive into our curated list of top web development companies in India,

USA Web Development

Top Web Development Companies in USA

Looking for the best web development companies in the USA? We’ve got you covered! Check out our top 10 picks to find the right partner

Clean Energy Adoption

Inside Michigan’s Clean Energy Revolution

Democratic state legislators in Michigan continue to discuss and debate clean energy legislation in the hopes of establishing a comprehensive clean energy strategy for the

Chips Act Revolution

European Chips Act: What is it?

In response to the intensifying worldwide technology competition, Europe has unveiled the long-awaited European Chips Act. This daring legislative proposal aims to fortify Europe’s semiconductor

USA Companies

Top Software Development Companies in USA

Navigating the tech landscape to find the right partner is crucial yet challenging. This article offers a comparative glimpse into the top software development companies in the USA. Through a

Software Development

Top Software Development Companies

Looking for the best in software development? Our list of Top Software Development Companies is your gateway to finding the right tech partner. Dive in and explore the leaders in

India Web Development

Top Web Development Companies in India

In the digital race, the right web development partner is your winning edge. Dive into our curated list of top web development companies in India, and kickstart your journey to

USA Web Development

Top Web Development Companies in USA

Looking for the best web development companies in the USA? We’ve got you covered! Check out our top 10 picks to find the right partner for your online project. Your

Clean Energy Adoption

Inside Michigan’s Clean Energy Revolution

Democratic state legislators in Michigan continue to discuss and debate clean energy legislation in the hopes of establishing a comprehensive clean energy strategy for the state. A Senate committee meeting

Chips Act Revolution

European Chips Act: What is it?

In response to the intensifying worldwide technology competition, Europe has unveiled the long-awaited European Chips Act. This daring legislative proposal aims to fortify Europe’s semiconductor supply chain and enhance its

Revolutionized Low-Code

You Should Use Low-Code Platforms for Apps

As the demand for rapid software development increases, low-code platforms have emerged as a popular choice among developers for their ability to build applications with minimal coding. These platforms not

Cybersecurity Strategy

Five Powerful Strategies to Bolster Your Cybersecurity

In today’s increasingly digital landscape, businesses of all sizes must prioritize cyber security measures to defend against potential dangers. Cyber security professionals suggest five simple technological strategies to help companies

Global Layoffs

Tech Layoffs Are Getting Worse Globally

Since the start of 2023, the global technology sector has experienced a significant rise in layoffs, with over 236,000 workers being let go by 1,019 tech firms, as per data

Huawei Electric Dazzle

Huawei Dazzles with Electric Vehicles and Wireless Earbuds

During a prominent unveiling event, Huawei, the Chinese telecommunications powerhouse, kept quiet about its enigmatic new 5G phone and alleged cutting-edge chip development. Instead, Huawei astounded the audience by presenting

Cybersecurity Banking Revolution

Digital Banking Needs Cybersecurity

The banking, financial, and insurance (BFSI) sectors are pioneers in digital transformation, using web applications and application programming interfaces (APIs) to provide seamless services to customers around the world. Rising

FinTech Leadership

Terry Clune’s Fintech Empire

Over the past 30 years, Terry Clune has built a remarkable business empire, with CluneTech at the helm. The CEO and Founder has successfully created eight fintech firms, attracting renowned

The Role Of AI Within A Web Design Agency?

In the digital age, the role of Artificial Intelligence (AI) in web design is rapidly evolving, transitioning from a futuristic concept to practical tools used in design, coding, content writing

Generative AI Revolution

Is Generative AI the Next Internet?

The increasing demand for Generative AI models has led to a surge in its adoption across diverse sectors, with healthcare, automotive, and financial services being among the top beneficiaries. These

Microsoft Laptop

The New Surface Laptop Studio 2 Is Nuts

The Surface Laptop Studio 2 is a dynamic and robust all-in-one laptop designed for creators and professionals alike. It features a 14.4″ touchscreen and a cutting-edge design that is over

5G Innovations

GPU-Accelerated 5G in Japan

NTT DOCOMO, a global telecommunications giant, is set to break new ground in the industry as it prepares to launch a GPU-accelerated 5G network in Japan. This innovative approach will

AI Ethics

AI Journalism: Balancing Integrity and Innovation

An op-ed, produced using Microsoft’s Bing Chat AI software, recently appeared in the St. Louis Post-Dispatch, discussing the potential concerns surrounding the employment of artificial intelligence (AI) in journalism. These

Savings Extravaganza

Big Deal Days Extravaganza

The highly awaited Big Deal Days event for October 2023 is nearly here, scheduled for the 10th and 11th. Similar to the previous year, this autumn sale has already created

Cisco Splunk Deal

Cisco Splunk Deal Sparks Tech Acquisition Frenzy

Cisco’s recent massive purchase of Splunk, an AI-powered cybersecurity firm, for $28 billion signals a potential boost in tech deals after a year of subdued mergers and acquisitions in the

Iran Drone Expansion

Iran’s Jet-Propelled Drone Reshapes Power Balance

Iran has recently unveiled a jet-propelled variant of its Shahed series drone, marking a significant advancement in the nation’s drone technology. The new drone is poised to reshape the regional

Solar Geoengineering

Did the Overshoot Commission Shoot Down Geoengineering?

The Overshoot Commission has recently released a comprehensive report that discusses the controversial topic of Solar Geoengineering, also known as Solar Radiation Modification (SRM). The Commission’s primary objective is to

Remote Learning

Revolutionizing Remote Learning for Success

School districts are preparing to reveal a substantial technological upgrade designed to significantly improve remote learning experiences for both educators and students amid the ongoing pandemic. This major investment, which

Revolutionary SABERS Transforming

SABERS Batteries Transforming Industries

Scientists John Connell and Yi Lin from NASA’s Solid-state Architecture Batteries for Enhanced Rechargeability and Safety (SABERS) project are working on experimental solid-state battery packs that could dramatically change the

Build a Website

How Much Does It Cost to Build a Website?

Are you wondering how much it costs to build a website? The approximated cost is based on several factors, including which add-ons and platforms you choose. For example, a self-hosted