Stack Overflow
Stack Overflow

Questions tagged [intersystems-cache]

Caché is a multi-model DBMS and application server developed by InterSystems.

Caché is an multi-model (object, relational, key-value) DBMS and application server developed by InterSystems.

InterSystems Caché provides several APIs to operate with same data simultaneously: key-value, relational, object, document, multidimensional. Data can be managed via SQL, Java, node.js, .NET, C++, Python. DBMS Caché has proven embedded technologies for horizontal scaling (ECP, SLM), High Availability (Mirroring), transaction support and backup. It includes embedded Caché ObjectScript language which is back compatible to and which helps to run applications' business logic close to the data and achieve maximum performance for complex logic operations with data. Caché also provides application server which hosts web apps (CSP), REST, SOAP, web sockets and other types of TCP access for Caché data.

It is commercial software sold to application partners that develop end user applications.

More information can be found in Wikipedia: http://en.wikipedia.org/wiki/InterSystems_Caché

Official website: http://www.intersystems.com/cache/index.html

InterSystems Developers Community blogs can be found here at https://community.intersystems.com/?filter=articles

3rd party solutions and examples could be found on InterSystems Open Exchange https://openexchange.intersystems.com/

396 questions
2
votes
1 answer

How can i make copy of a global automatically in my local system?

Consider, i have a global ^TEST and i want to replicate/have a copy of the same in ^TEST2 automatically.Each action set or kill on ^TEST should reflect on ^TEST2 automatically.
Krishnamuthu
  • 61
  • 6
2
votes
5 answers

Is learning the Caché database hard coming from relational databases and object oriented programming language like Delphi?

I am currently running the local version of Caché on my system in order to determine if I can (and will) take on a new possible project. The current project uses Delphi 7 as a front end calling a Caché dll where the business logic is stored in the…
Edelcom
  • 5,038
  • 8
  • 44
  • 61
2
votes
3 answers

Querying Intersystem Caché through ODBC

I'm querying Caché for a list of tables in two schemas and looping through those tables to obtain a count on the tables. However, this is incredibly slow. For instance, 13 million records took 8 hours to return results. When I query an Oracle…
user2063351
  • 503
  • 2
  • 13
  • 31
2
votes
2 answers

How to prevent errors while running Intersystems Caché terminal scripts?

I'm developing a system that needs to execute Intersystems Cache Terminal Scripts. When I run a routine inside the regular Caché terminal or a telnet terminal, Cache executes the routine until the end with no problems. But when I try to run the same…
Luis Soeiro
  • 4,262
  • 6
  • 35
  • 45
2
votes
1 answer

Implementing a client-side persistence manager in C++

I have a 2-tier application (a heavy client written in C++ which connects to the object-oriented database). The database itself is InterSystems Cache', and it is actually both a database and an application server (Cache' is also a MUMPS…
Bass
  • 4,977
  • 2
  • 36
  • 82
2
votes
1 answer

How to read a class parameter using Caché SQL?

How do I read a class parameter using Caché SQL? select * from table does not list any class parameters.
O.O
  • 11,077
  • 18
  • 94
  • 182
2
votes
1 answer

Does Intersystems Caché has "mid" function?

I would like to know if there is "mid" function on Intersystems Caché Database. I'm trying to use it to solve a problem here, where I need to read a string of any size from the 8th character and I'm receiving the following error: Error: General…
Uder Moreira
  • 865
  • 6
  • 17
  • 33
2
votes
1 answer

Using the 'SqlComputeCode' keyword to project a calculated property into the sql table

I have a class with several calculated properties. I would like to add these properties to the projected sql table so that I can query on them. However, I noticed that calculated properties are not projected into the sql table by default. To get…
Fred Altman
  • 221
  • 1
  • 2
  • 5
2
votes
1 answer

How do I find a Property in a %DIctionary.ClassDefinition by property Name?

I have the following line of code in a class: Set objDClass = ##class(%Dictionary.ClassDefinition).%OpenId("Dict.ProcCde") this creates an object reference to the class definition of another class. The Dict.ProcCde class has 173 properties…
Fred Altman
  • 221
  • 1
  • 2
  • 5
2
votes
1 answer

Does Entity Framework have a provider for Intersystems Cache?

If so, any drawbacks? Any experience using it?
O.O
  • 11,077
  • 18
  • 94
  • 182
2
votes
2 answers

How to integrate two different applications ? Web applications

Hi all i am a Student working on a project in an Hospital we designed an application where patient can book an appointment with doctor similar to this application (apphp.com/php-medical-appointment/examples/sample2/index.php) and our application…
Saransh Sharma
  • 308
  • 5
  • 19
2
votes
1 answer

Is there a rule of thumb for converting Global References per second to IOPS?

working on sizing storage for a cache' database, I have an idea of the GREF/s but I need to convert it to IOPS?
WeylCurve
  • 21
  • 1
2
votes
1 answer

Intersystems-cache log4 equivalent

Does anyone know if there is something similar to log4 available for cache? I've used log4net on a number of .Net projects and would like to have something with the same capabilities. In particular the logging level and the configuration ability…
millerwa
  • 66
  • 4
1
vote
3 answers

Accessing cache.dat through ODBC

Ok, so I am trying to extract the information from a cache.dat database sent from another business. I am trying to get at the data using the ODBC. I am able to see the globals from the samples namespace when trying to export to Access, but I can't…
Mathew Ruberg
  • 427
  • 4
  • 15
1
vote
3 answers

Intersystems Cache - Maintaining Object Code to ensure Data is Compliant with Object Definition

I am new to using intersytems cache and face an issue where I am querying data stored in cache, exposed by classes which do not seem to accurately represent the data in the underlying system. The data stored in the globals is almost always larger…
john.da.costa
  • 4,682
  • 4
  • 29
  • 30
1 2 3
…
26 27