InterSystems Caché is a multi-model DBMS and application server. See more details here.
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.
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.
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.
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.
Customers who switch to Caché from relational databases report that their average performance is up to 20 time faster, running on the same hardware, with no changes to the application. What is it about Caché that lets applications run so fast?
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.
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:
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.
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.
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.
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.
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.
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.
Using Intel® Advanced Encryption Standard New Instructions with InterSystems Caché Substantially Improves Encryption Performance and Reduces Computational Overhead
Executive Summary
Financial services companies have an ever-growing need to encrypt databases containing sensitive customer and trade data. However, using encryption on these databases can require significant computational resources, potentially impacting trading latencies.
Executive Summary
The best way to compare the performance of database products is in a head-to-head test using a real application, preferably one of your own. This is especially true when evaluating Caché's post-relational technology, because "standard" transaction processing benchmarking methodologies assume the restrictive "row and columns" format of a relational database. They cannot accurately predict the performance of real applications, which often use complex data models.
Exactly a year ago I posted this article about how it's possible to define mappings for packages, routines and globals in one place and have them apply to (almost) every namespace.
hi ,
How to install and configure intersystem cache ODBC in CENTOS7 linux box.
Thanks,
sansa.
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.
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.
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:
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.
In our last lesson, we added a form to Edit our existing Widgets, and save them back to the server. However, our Form was not well strcutured and our Save button had no intelligence, and was not fully visible. So today, we will apply some Material components and Angular style to make the form more useful
Let's open EditWidget.csp, and make some changes. First, we want to change the component from an md-card to an md-dialog.
DraftDraftDraftDraftDraftDraftDraftDraftDraftDraft
NewNewNewNewNewNewNewNewNewNewNew
Hi all,
Is there any possibilities to set the null password for user account in cache 2016?
Thanks,
sansa.
This code snippet uses GZIP to compress and decompress a file in the file system. Change default file paths to customize code to compress/decompress your files:
Class objectscript.GZIP Extends %RegisteredObject
{
classmethod test() {
//Export Global(s) uncompressed
set filename="C:\Temp\myglobal.xml"
do $System.OBJ.Export("^oddEXTR.gbl",filename)
//Open exported Globals
set uncompressed = ##class(%FileBinaryStream).%New()
set uncompressed.Filename=filename
Set compressed = "C:\temp\mycomglobal.xml"
//Open File Device over Gzip and Copy Uncompressed information to it
Open compressed:("WUNK":::/GZIP=1:/NOXY=1:/OBUFSIZE=32768):0
Use compressed
do uncompressed.OutputToDevice()
close compressed
//Create New File
set out = ##class(%FileBinaryStream).%New()
set out.Filename= "C:\Temp\decomp.xml"
//Open compressed File and save information uncompressed over gzip
Set file=##class(%File).%New(compressed)
Do file.Open("RUK:::/GZIP=1:/NOXY=1")
while ' file.AtEnd
{
set line = file.ReadLine()
do out.Write(line)
}
do out.%Save()
}
}
GitHub: https://github.com/intersystems-community/code-snippets/blob/master/src/cls/objectscript/GZIP.cls