Article Robert Cemper · Feb 16, 2018 2m read Adopted Bitmap The base class Bmap.Person defines persons within an organization distributedby various countries. All records are indexed by (Country, PersonalId).this structure doesn't allow use of bitmaps. So a wrapper class Bmap.PersonQ around the data eliminates the top level ofthe index (Country) and isolates the PersonalId (%Integer, MINVAL=1).We are ready to use a Bitmap index. A few performance figures on 300010 generated records.You see that Relative Cost are sometimes quite misleading. base #ObjectScript #InterSystems IRIS 14 0 1 832
Article Robert Cemper · Nov 11, 2017 3m read Summary on Local Variable Scoping This should be an overview over a subject that pops up over several places in online documentation mostly as remarks and never as dedicated chapter. Once upon a time ... No it's not a fairy tale.In the beginning of Caché (and before) you had your partition to run your code. Part of that partition was a space with all your local variables nicely sorted by %,A,..Z,a,...z #Beginner #Caché #InterSystems IRIS 14 3 1 950
Article Robert Cemper · Oct 15, 2017 3m read @Indirection and eXECUTE - why ? As I mentioned in an early post the roots of COS were laid in the late 60ies of the 20th century. Close to that time, BLISS was designed at Carnegie-Mellon University (January 15, 1970)https://en.wikipedia.org/wiki/BLISSSimilarly in 1972 C language was written at Bell Labs.https://www.bell-labs.com/usr/dmr/www/chist.html #Caché #InterSystems IRIS 12 2 0 820
Article Robert Cemper · Aug 26, 2017 3m read From The Roots to InterSystems This is a rather personal view of the history before Caché.It is in no sense meant to compete with the excellent books from Mike Kadow discussed in an earlier article.We have different histories and so this is meant to create a different perspective of the past. #Caché #InterSystems IRIS 38 15 2 1.8K
Article Robert Cemper · Aug 23, 2017 2m read Light weight EXCEL download I worked through the Community for proposals to provide end usersin an easy way with data formatted as EXCEL sheet. There is a great article Tips & Tricks - SQL to Excel there's an important message embedded: "EXCEL can interpret HTML tables and display them as usual" #CSP #ObjectScript #SQL #Caché #InterSystems IRIS Open Exchange app 20 1 1 1.5K
Article Robert Cemper · Aug 20, 2017 1m read Promoting Developer Community DC is still a hidden jewel for customers: #Caché #InterSystems IRIS #Open Exchange #Other 6 3 0 295
Article Robert Cemper · Aug 17, 2017 1m read Fix broken index the useful content is in the repliesshowing the use of $SYSTEM.OBJ.ValidateIndices() #Tips & Tricks #InterSystems IRIS 13 8 0 1.9K
Article Robert Cemper · Aug 9, 2017 1m read Symposium DACH 2017 Frankfurt Sorry,the original announcement page is not reachable or deleted. #Other 17 4 0 668
Article Robert Cemper · Aug 8, 2017 1m read Outperforming PostgreSQL and MySQL In a previous exercise, I was able to show the power of Caché.A medium-designed set of interdependent tables with some GB of data.URLs cross reference over some million pages resulting in ~3 billion records Competition was between Caché PostgreSQL MySQL Criteria were Speed + Storage consumptionI composed a customized loader fed over a "raw" TCP connectionMapping the "objects" into the final table by directly writing to Global Storage., #Globals #Object Data Model #ObjectScript #SQL #Caché 17 3 0 742
Article Robert Cemper · Aug 5, 2017 3m read Winning in GIS competition GIS stands for Geographic Information System. and it's not a typical arena for Caché. But it's definitely an environment with high data volume.You see 3 major areas - Visual front end: A mature area well covered by a bunch of commercial and open source products. No need for Caché there. #Caché 14 4 0 727