#Caché

30 Followers · 4.5K Posts

  

InterSystems Caché is a multi-model DBMS and application server. See more details here.

Documentation.

Article Developer Community Admin · Oct 21, 2015 3m read

Providing a reliable infrastructure for rapid, unattended, automated failover

Technology Overview

Traditional availability and replication solutions often require substantial capital investments in infrastructure, deployment, configuration, software licensing, and planning. Caché Database Mirroring (Mirroring) is designed to provide an economical solution for rapid, reliable, robust, automatic failover between two Caché systems, making mirroring the ideal automatic failover high-availability solution for the enterprise.

In addition to providing an availability solution for unplanned downtime,

0
0 335
Article Developer Community Admin · Oct 21, 2015 1m read

Introduction

This document is intended to provide a survey of various High Availability (HA) strategies that can be used in conjunction with InterSystems Caché, Ensemble, and HealthShare Foundation. This document also provides an overview of the various types of system outages that can occur, as well as how each strategy would handle a given outage, with the goal of helping you choose the right strategy for your specific deployment.

The strategies surveyed in this document are based on three different HA technologies:

  • Operating System Failover Clusters
  • Virtualization-Based HA
  • Caché Database
0
0 356
Article Developer Community Admin · Oct 21, 2015 1m read

Introduction

Impedance mismatch is a term commonly used to describe the problem of an object-oriented (OO) application housing its data in legacy relational databases (RDBMS). C++ programmers have dealt with it for years, and it is now a familiar problem to Java and other OO programmers.

Impedance mismatch arises from the inherent lack of affinity between the object and relational models.

0
0 364
Article Developer Community Admin · Oct 21, 2015 2m read

InterSystems Caché 2015.1 soars from 6 million to more than 21 million end-user database accesses per second on the Intel® Xeon® processor E7 v2 family compared to Caché 2013.1 on the Intel® Xeon® processor E5 family

Overview

With data volumes soaring and the opportunities to derive value from data rising, database scalability has become a crucial challenge for a wide range of industries.In healthcare, the rising demands for healthcare services and significant changes in the regulatory and business climates can make the challenges particularly acute.

0
0 571
Article Developer Community Admin · Oct 21, 2015 2m read

Providing a reliable infrastructure for rapid, unattended, automated failover

Technology Overview

Traditional availability and replication solutions often require substantial capital investments in infrastructure, deployment, configuration, software licensing, and planning. Caché Database Mirroring (Mirroring) is designed to provide an economical solution for rapid, reliable, robust, automatic failover between two Caché systems, making mirroring the ideal automatic failover high-availability solution for the enterprise.

In addition to providing an availability solution for unplanned downtime,

0
0 606
Article Developer Community Admin · Oct 21, 2015 1m read

Abstract

A global provider of mobile telecommunications software tested the performance of InterSystems Caché and Oracle as the database in a simulated data mart application. They found Caché to be 41% faster than Oracle at building a data mart. When testing the response time to SQL queries of the data mart, Caché's performance ranged from 1.8 times to 513 times faster than Oracle.

Introduction

Telecommunications companies, because they generate and must analyze enormous amounts of information, are among the most demanding database users in the world.

0
0 404
Article Developer Community Admin · Oct 21, 2015 1m read

Introduction

With the maturation and wide acceptance of Java, object-oriented programming has moved to the foreground of the application development landscape. Because of their rich data models and support for productivity-enhancing concepts such as encapsulation, inheritance, and polymorphism, object technologies like Java, C++, and COM, are favored by today's application developers.

However, much of the world's data still resides in relational databases.

0
0 292
Article Developer Community Admin · Oct 21, 2015 1m read

Introduction

Experts estimate that 85% of all data exists in unstructured formats – held in e-mails, documents (contracts, memos, clinical notes, legal briefs), social media feeds, etc. Where structured data typically accounts for quantitative facts, the more interesting and potentially more valuable expert opinions and conclusions are often hidden in these unstructured formats. And with massive volumes of text being generated at unprecedented speed, there’s very little chance this information can be made useful without some process of synthesis or automation.

Automating text analysis is not

0
0 324
Article Developer Community Admin · Oct 21, 2015 1m read

Introduction

To overcome the performance limitations of traditional relational databases, applications - ranging from those running on a single machine to large, interconnected grids - often use in-memory databases to accelerate data access. While in-memory databases and caching products increase throughput, they suffer from a number of limitations including lack of support for large data sets, excessive hardware requirements, and limits on scalability.

InterSystems Caché is a high-performance object database with a unique architecture that makes it suitable for applications that typically use

0
0 416
Article Developer Community Admin · Oct 21, 2015 2m read

Executive Overview

One way financial services firms can improve their operational efficiency is to revamp their data management infrastructure. Creating a central repository for data that is used by multiple applications can ensure data consistency and quality across the enterprise, ease integration bottlenecks, and lower the number of failed trades.However, different applications have different database usage patterns. To satisfy them all, any central data repository must:

  • Support a large number of transactions with high performance
  • Provide fast response to queries, using up-to-date information
  • P
0
0 371
Article Developer Community Admin · Oct 21, 2015 2m read

Introduction

By now, anybody working in the technology sector will have heard of Cloud computing. But the concept is increasingly being paid attention to outside of IT departments, with growing recognition among boardlevel executives of the potential of this range of innovations. Frequently, senior personnel are hearing stories about how the Cloud helps organizations reduce costs, boost efficiency and expand their operations, so they’ll be excited about what the Cloud can do for them.

As a result, Cloud is one of the fastest-growing parts of the IT industry.

0
0 238
Article Developer Community Admin · Oct 21, 2015 1m read

Abstract

In a recent benchmark test of an application based on InterSystems Caché, a sustainable rate of 8.9million database accesses/second, with peaks of 16.9 million database accesses/second, was achieved. These results were from a test performed on a connected system of eight applications servers, using Intel Xeon 5570 processors, and running Linux as the operating system. This benchmark shows that:

  1. Caché can achieve unheard of levels of performance for an object database. It provides full persistence of data at speeds that are normally only reached by in-memory databases.
  2. Caché demonstrates
0
0 251
Edit
Question Alexey Maslov · May 11, 2017

Since most of our customers moved to Cache 2015.1, I found some admins abused with CPUPct warnings (sometimes alerts) in console log without other signs of lacking CPU power.
Documentation states that:

          CPUPct               job_type              CPU usage (percent) by all processes of the listed job type in aggregate       

What does it really mean?
E.g., if total system CPU usage is 25%, and all running processes are of the same type (e.g, CSPSRV), would CPUPct be equal to 100%? If so, why this case should be a reason for alert? 

To be honest, the description of CPUPct was excluded from

0
0 11
Edit
Question Stella Ticker · Jul 7, 2017

There is a need to send a SAML token from a local cache web application to an external web application in order to grant these cache web app users access to the external web app. Is it possible to use SOAP SAML token functionality to do IDP initiated authentication with Cache acting as the IDP server? The example in this online course shows a code snippet of the service web method that adds  the token to the outbound SOAP message.So I am assuming , this would be returned to the client in response to a client request of some sort.

0
0 38
Edit
Question PILAR GUERRERO · Jun 26, 2017

Hello,

I have a problem when i take the adapter: EnsLib.FTP.OutboundAdapter. 

I want to write a file, but if the file already exist using the method ..Adapter.PutStream(name,file) and in my setting "overwrite" is true. FTP response me this message:

<descripcion><![CDATA[ERROR <Ens>ErrFTPPutFailed: FTP: error al colocar archivo '803430600001072790112416-19941214-1233287355C-347.pdf' (mensaje='Error in SFTP Put('D:\Ensemble\ABC\NAMEAPP\NAMEAPP_G\stream\HnhZ32Fb1WDatA.stream','ABC/803430600001072790112416-19941214-1233287355C-347.pdf') ERROR #7500: Error SSH '-2146426877': SFTP Error [80102003]:
2
0 21
Edit
Article GUILHERME CRUZ DA CUNHA · Jun 14, 2018 3m read

Let's create a class in Caché that will represent a teacher registry of a
University:

The name of our class will be Professor. Let's create it on
university package. To do so, make sure that your Caché
is in the Air (the small cube in your System Tray should be blue) and
right-click it, then click the
Studio, as shown in Figure 4.
When Caché Studio opens, make sure that you
is in the USER namespace. Just go to the File menu, and select the
Change Namespace option. Choose the USER namespace and press
OK.
Once you are in the USER namespace, click
Right click on the Classes item in your project window and

0
0 49
Edit
Question Theunis Pretorius · Nov 5, 2016

How do I call an excel report class from another class and name the report from the call class in cache?

This is the Report Class:

/// Class name of application this report belongs to./// the URL parameter, <var>$MODE</var>, is not present.
3
0 31
Edit
Question Alexey Maslov · May 11, 2017

Since most of our customers moved to Cache 2015.1, I found some admins abused with CPUPct warnings (sometimes alerts) in console log without other signs of lacking CPU power.
Documentation states that:

          CPUPct               job_type              CPU usage (percent) by all processes of the listed job type in aggregate       

What does it really mean?
E.g., if total system CPU usage is 25%, and all running processes are of the same type (e.g, CSPSRV), would CPUPct be equal to 100%? If so, why this case should be a reason for alert? 

To be honest, the description of CPUPct was excluded from

0
0 5
Edit
Article John Lambert · Apr 5, 2016 1m read

One of the internal changes in Cache 2016.2 is the switch from using Posix asynchronous IO on Linux platforms to native kernel asynchronous IO for improved performance. There is a kernel parameter that controls the maximum number of events that can be handled across the entire system and it is possible to hit this limit on newer versions of the Linux kernel when Cache is setting up disk IO structures in the WD or user processes. To prevent this from occurring we recommend that the kernel parameter 

0
0 0
Edit
Article Peter Cooper · Mar 18, 2018 1m read

Index to Articles

Hi All 

In this article I will showcase one of my clients applications built in ZEN.  It is what I need to replace with a new UI as ZEN is no longer being developed

This application has been created for a single client who has unique business requirements - hence the bespoke development based on Caché ZEN
It is:-

  • Large(ish)
  • Supports and Implements Complex Business Processes
  • Secure
  • Multi Lingual
  • Reasonable size of development stack
0
0 0
Edit
Question prabakaran a · Feb 14, 2017

Hi All,

          while i configure the shadowing.i got following error.         

ERROR #1043: Shadowing is unavailable for current license

Thanks,

Prabakaran A. 

3
0 37
Edit
Question Pravin Barton · Nov 7, 2017

Hello,

I have some code that reads an %XML.DataSet object that gets returned from a web service. I'd like to unit test this code by importing an XML data set from a test file. How can I do this?

I created the test file by calling WriteXML on the data set, and copying the output into the file:

do result.WriteXML(,,,,,1)

I tried to import the file using the XML reader, but the resulting data set doesn't have any rows:

USER>set reader = ##class(%XML.Reader).%New()
 
USER>w reader.OpenFile(filename)
1
USER>do reader.Correlate("SQLResult","%XML.DataSet")
 
USER>w reader.Next(.dataset,.status)
1
USER>w dataset
3@
0
0 0