Caché Objects


Subscribe to Caché Objects content with RSS Syndicate content or email

How to add the case insensitive index to a class?

Hi!

Consider I have a class Package.Data with Property UniqueStringValue as %String.

I introduced the Index for this property:

6

views

0

rating

Parse %ObjectIdentity

Hi!

I'm trying to implement %OnAfterDelete ClassMethod for persistent class. As a parameter it gets oid As %ObjectIdentity for the deleted object.

39

views

0

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 Export Data to Excel in Cache Object.

Please Give a simple program for how to export data to Xls format in Cache Objects.

60

views

0

rating

Property as Simple list of string values

I have a property, Emails, that needs to contain a list of comma-delimited values, or "".

87

views

0

rating

How to rewind results of %SQL.StatementResult

Hi, is possible rewind results of %SQL.StatementResult?

I not find a solution.

63

views

0

rating

Connecting using factory

   

  The following code in .Net using  CacheObject.dll  version 2016.1.2.206 com library

 

37

views

0

rating

Lookup Time Complexity of a Global

If I were trying to access an index of a global variable, what time complexity would this operation have?

77

views

0

rating

ODBC_connection problem

Hi ,

     i installed and configure the cache odbc ODBC-2016.1.1.107.0-lnxrhx64.tar in centos7.

     it connected  while executing  in terminal .(i.e isql -v DSN) 

55

views

0

rating

<ENDOFFILE> zOutputToDevice %Library.FileBinaryStream.1

Hello!

I'm getting error <ENDOFFILE> zOutputToDevice %Library.FileBinaryStream.1 when sending XML request to Web Server.  How I can avoid this error? Can anyone help me?

 

28

views

0

rating

Where can I find information on document repositories?

In the table/class HS_Registry.document there is a column/property named RepositoryUniqueId.

32

views

0

rating

Android push notifications with InterSystems Ensemble using Road Police fines as a sample application

Many mobile applications that enable users to get information about road fines and pay them, send notifications about newly added fines. This functionality can be efficiently implemented using push notifications sent to users’ devices.

Our application was not an exception. The server side is based on the Ensemble platform that offers integrated support of push notifications starting from version 2015.1.

82

views

+ 1

rating

How to use %Library.Global.Export() to export a global subtree

The Management Portal allows you to Export one or more globals to a file that you can then Import into that or another namespace.

77

views

+ 7

rating

error #6235 unexpected namespace for tag

Hello,

I am a new member here . Could you help me to resolve the problem?

While sending request to WebServer I'm getting error: ERROR #6235: Unexpected namespace for tag CardData :

55

views

0

rating

Visualizing the data jungle -- Part I. Let's make a graph

This is the first article of a series diving into visualization tools and analysis of time series data.

220

views

+ 5

rating