Caché


Subscribe to Caché content with RSS Syndicate content or email

Introduction to .Net Gateway - use external .net library from Cache Object Script

Integrating Cache with .net may be difficult, as we need to know both technologies and tools involved. Let’s follow the simplest possible example and see the pitfalls lurking on our way.

 

124

views

+ 3

rating

Is there any way of paginate SQL Query in Caché?

Hi,

My doubt is about the SQL Query in Caché:

52

views

+ 1

rating

What's the best way of doing Reports in Zen Mojo.

Hi everyone, I have and Zen Mojo application, it's all working but I have some doubts about what is recommended to use: There is some reports of employees, for example, and actually I'm using some plugins : "Excel

51

views

+ 1

rating

How common is it to utilize $ZSTORAGE?

While I can see the benefits that $ZSTORAGE could have if used properly, I have not seen it used in the environments I have worked in. I was wondering if there are any developers that promote its usage.

58

views

0

rating

How to run REST.DocServer clss file in local server?

I'm new to learn Rest Services in Cache.

I have REST.DocServer class file in local system. When I tried to run this file I have the error as HTTP ERROR 403. 

43

views

0

rating

Linux Transparent HugePages and the impact to Caché

** Revised Feb-22, 2017

 

Introduction

Memory is managed in pages.  The default page size is 4KB on Linux systems.  Red Hat Enterprise Linux 6, SUSE Linux Enterprise Server 11, and Oracle Linux 6 introduced a method to provide an increased page size in 2MB or 1GB sizes depending on system configuration know as HugePages.

At first HugePages required to be assigned at boot time, and if not managed or calculated appropriately could result in wasted resources.  As a result various Linux distributions introduced Transparent HugePages with the 2.6.38 kernel as enabled by default.  This was meant as a means to automate creating, managing, and using HugePages.  Prior kernel versions may have this feature as well however may not be marked as [always] and potentially set to [madvise].  

Transparent Huge Pages (THP) is a Linux memory management system that reduces the overhead of Translation Lookaside Buffer (TLB) lookups on machines with large amounts of memory by using larger memory pages.  However in current Linux releases THP can only map individual process heap and stack space.

749

views

+ 2

rating

Using InterSystems Caché and Apache Zeppelin

I' have done some tests with Caché and Apache Zeppelin. I want to share my experince to use both systems together.

64

views

+ 5

rating

RESTForms - REST API for your classes

In this article I would like to present the RESTForms project - generic REST API backend for modern web applications.

The idea behind the project is simple -after I wrote several REST APIs I realized that generally, REST API consists of two parts:

  • Work with persistent classes
  • Custom business logic

And, while you'll have to write your own custom business logic, RESTForms provides all things related to working with persistent classes right out of the box.
Use cases

  • You already have a data model in Caché and you want to expose some (or all) of the information in a form of REST API
  • You are developing a new Caché application and you want to provide a REST API

575

views

+ 8

rating

Caché and Ensemble 2017.1 Release Candidate

I am pleased to announce that Caché and Ensemble 2017.1 Release Candidate versions are now available for all platforms.

79

views

+ 4

rating

Making encrypted datafields SQL-searchable

Overview

Encryption of sensitive data becomes more and more important for applications. For example patient names, SSN, address-data or credit card-numbers etc..

Cache supports different flavors of encryption. Block-level database encryption and data-element encryption. The block-level database encryption protects an entire database.  The decryption/encryption is done when a block is written/read to or from the database and has very little impact on the performance.

With data-element encryption only certain data-fields are encrypted.  Fields that contain sensitive data like patient data or credit-card numbers. Data-element encryption is also useful if a re-encryption is required periodically. With data-element encryption it is the responsibility of the application to encrypt/decrypt the data.

Both encryption methods leverage the managed key encryption infrastructure of Caché.

The following article describes a sample use-case where data-element encryption is used to encrypt person data.  

But what if you have hundreds of thousands of records with an encrypted datafield and you have the need to search that field? Decryption of the field-values prior to the search is not an option. What about indices?

This article describes a possible solution and develops step-by-step a small example how you can use SQL and indices to search encrypted fields. 

75

views

+ 3

rating

How to run csession command without having to supply user credentials?

Hi,

I am trying the following command in order to freeze the instance before backup is done:

    csession CACHE -U%SYS "##Class(Backup.General).ExternalFreeze()"

68

views

0

rating

Yape - Yet another pButtons extractor (and automatically create charts)

Working with customers on performance reviews, capacity planning and trouble-shooting I am often unpacking and reviewing Caché and Operating System metrics from pButtons.

75

views

+ 5

rating

CSP

Hi All,In CSP how to call one method to another method (i.e) i created one script language as cache from that one script to another script that one also a cache script ,how to call the script.

44

views

-3

rating

Regarding the AggregationId...

I use the HS_IHE_ATNA_Repository.Aggregation table a lot.  Someone just referred me to the HS_IHE_ATNA_Repository.Document table, which has an AggregationId column.  

57

views

0

rating