#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 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
Article Developer Community Admin · Oct 21, 2015 1m read

Introduction

With the growing popularity of smart phones and tablet computers, consumers are coming to expect that software solutions will be presented as "apps" on their mobile devices. The challenge for most application developers is to find ways to make their existing solutions run on modern mobile platforms without incurring the delay and cost of a complete rewrite.

This paper will describe the approach taken by HAPO Community Credit Union when they adapted their online banking application, developed on InterSystems' high performance object database system called Caché, for use with mobile

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

Introduction

Because of increasing business and governmental pressures to integrate their operations, the financial services industry is developing a number of standards for data exchange and other common functions. Standards such as XBRL, FpML, MDDL, RIXML, and FIXML are all specialized dialects of XML (Extensible Markup Language). Any financial services application with good support for XML will be able to communicate effectively using one or more of the emerging industry standards.

Efficient data exchange increases the need for fast, scalable data persistence.

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

Executive Summary

For twenty years or more, large financial institutions have been locked in a battle between the need for extremely high performance transaction processing and the demands of downstream applications that can deliver competitive advantage if they can get real time access to this transactional data.When individual database servers could no longer handle simultaneous transaction and query workloads, many firms turned to replication, offloading data access onto read-only copies of production databases.

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

InterSystems has implemented a broad set of MultiValue extensions for its Caché multidimensional database. These extensions enable the migration of MultiValue applications to Caché and bring the full range of Caché object and SQL development technologies to MultiValue developers. The result: your existing MultiValue investments are preserved, you gain a broad spectrum of highly scalable deployment options, and your developers can combine the best of MultiValue, object, relational, and technologies to extend existing applications and build new ones.

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

Introduction

In today's world, an ever-increasing number of purchases and payments are being made by credit card.Although merchants and service providers who accept credit cards have an obligation to protect customers' sensitive information, the software solutions they use may not support "best practices" for securing credit card information.To help combat this issue, a security standard for credit card information has been developed and is being widely adopted.The Payment Card Industry (PCI) Data Security Standard (DSS) is a set of guidelines for securely handling credit card information.

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

InterSystems encourages the adoption of a flexible, practical approach to application development, rather than strict adherence to one of the prevalent development theories. This paper offers advice based upon our experience. However needs, attitudes, and styles vary; we recommend that each programmer choose the development approach that works best for them. Caché supports a wide range of development methodologies, not just those recommended here.

0
0 150
Edit
Question sansa stark · Nov 28, 2016

hi all,

        how to configure the crystal report in iis?

        how to generate the crystal report via intersystem cache ?

info :

  sap crystal report 2011

  iis 6 and windows 3 server

cache 5.02

Thanks,

sansa.

0
0 22
Edit
Article Mike Kadow · Jul 22, 2016 2m read

NewBie's Corner Session 14 Inline Do & Nested Do with Implied Quit and For Loop

Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.

InterSystems Caché provides a GUI (Graphical User Interface) based Integrated Development Environment (IDE) called Caché Studio. Developers can use Studio to create and maintain applications.

The following concepts of Inline Do, Nested Do, Implied Quit and For Loop is difficult to explain in a manner that everyone understands.However, these concepts work well with each other.

0
0 2
Edit
Article Jose Ruperez · Dec 16, 2016 1m read

The first step when dealing with performance is the ability to measure it. In this article, we will show you a way to measure the performance of your CSP and/or ZEN applications. You will be able to answer questions such as: Which pages of my application are hit the most? or Which pages in my application are the slowest?

1
0 21
Edit
Article GUILHERME CRUZ DA CUNHA · Jun 18, 2018 2m read

For those who are interested, or want to do something different with the cache language, I leave here two codes of animations.

They serve to run on the terminal while executing a routine, or a method.

To escape the monotony of seeing that static code in the terminal.

Examples:

1 - 

S S="",S1="",O="" F L=1:1:40{ S M0=$C(13,10),M1=$C(32,111,13,10,32,124,32,32,O,13,10,32,124),M2=$C(32,32,111,13,10,32,47,32,32,O,13,10,47,124),M3=$C(32,32,111,13,10,32,47,45,124,O,13,10,47,62),S=$S(L<=21:$S(L#4=3:S_" ",1: S),1:S),S1=$S(L<=21:$REPLACE($S(O'="":$S(S1="":"O",1:" "_S1),1:""),"    ",$C(79)_"   "),1:$E("

2
0 25
Edit
Article Alexey Maslov · Nov 12, 2016 14m read

This article is about how to gain as much transparency in controlling processes in ECP environment as in traditional (non ECP) one.

The technology of load balancing between several servers with relatively low capacity has been a standard feature of Caché for quite a while. It is based on the distributed cache technology called ECP (Enterprise Cache Protocol); note that we are referring to “cache”, not “Caché”, here. ECP provides a host of possibilities for horizontal scaling of an application, ensuring high performance and fault-tolerance, and yet keeping the project budget fairly low. Another apparent advantage of ECP network is the possibility to conceal its architecture in the depths of Caché configuration so that applications developed for the traditional (vertical) architecture can be fairly easily migrated to a horizontal ECP environment. The ease of this process is so mesmerizing, that you start wishing it was always this way. For instance, everybody is used to having a possibility to control Caché processes: the $Job system variable and associated classes/functions work magic in skilful hands. Stop, but now processes can end up being on different Caché servers… The text below is about how I managed to cope with this problem.

0
0 0
Edit
Question Ferran Olle · Nov 23, 2016

Hello,

Our Intersystems Cache database is running in a Windows 2008 R2, and is installed and configured as "UNICODE" .

We are using Apache+PHP with  ODBC to get data but we have some problems with character encoding.

We also have two configurations:

  • Ubuntu 16.04 LTS + Apache2 + PHP 5.6 + UnixODBC
    • using isql command everything works fine, data returned is OK   (all special characters  in Spanish displayed ok).
    • using PHP with  PDO function to connect the database and libcacheodbcu35.so driver
      • with  default_charset=""  in  php.ini
      • Special characters in spanish not displaying   (  like   ü , é , ó , à , .
2
0 63
Edit
Question sansa stark · Nov 29, 2016

Hi all,

    i need one help regrading telnet.In cache 5.02 while we take telnet it open some program(By using ^login Global in %Sys nameSpace).But i could not create same process in cache 2016.

example:

telnet 127.0.0.1 it open some routine in "TRAIN" namespace.

Thanks,

Sansa.

2
0 24