Find

Announcement

Jose-Tomas Salvador · Dec 22, 2021

#Tools #InterSystems IRIS #Open Exchange

Just wanted to give visibility to a place in GitHub where everybody can publish Enhancement Requests, Ideas and Innovations that would be great to have in our InterSystems Technology ecosystem.

If you want to add your enhancement request, or take a look and see if there is already there and vote for it, contribute, etc..., click on this link. That doesn't guarantee that Product Management decides to go on that direction, they have to balance many things to decide our products roadmap, but having the direct input from our Community is invaluable.

Come on! Go for it and make your suggestions!

1 Comment

Discussion (1)2

Article

Hiroshi Sato · Dec 21, 2021 1m read

#Security #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health

これは、InterSystems FAQサイトの記事です。

監査ログをプログラミングで出力するために、監査ログの一覧を取得する%SYS.Audit クラスのListクエリを利用することができます。

サンプルコードは以下のようになります。

 Set statement=##class(%SQL.Statement).%New()  
 Set status=statement.%PrepareClassQuery("%SYS.Audit","List")
 Set rs=statement.%Execute()  
 Set tab = $char(9)
 While rs.%Next() {    
   Write rs.%Get("TimeStamp")_tab_rs.%Get("Event")_tab_rs.%Get("Username"),!      
}

Discussion (0)1

Article

Rob Tweed · Dec 20, 2021 1m read

#Databases #Data Model #Globals #Multi-model #Caché #InterSystems IRIS

For those of you who might be new to IRIS, and even those who have used Cache or IRIS for some time but want to explore beyond its usually-assumed boundaries and practices, you might want to dive into this detailed exploration of the database engine that is at its heart, and discover just what you can really do with it, going way beyond what InterSystems have done with it for you.

You'll discover that it's actually a hugely powerful yet incredibly simple storage engine that allows you to model any kind of database you wish, once you understand and master its simple, basic principles. Its storage model can be referred to as "Global Storage" which, it turns out, can be modelled on top of any hierarchical data storage engine, and even on the Redis NoSQL database. However, the "native" implementations, eg in IRIS and Cache, are the fastest by a significant margin, outpacing what the database world normally recognise as the planet's fastest databases (eg LMDB).

Global Storage is (sadly) one of the best kept secrets of the database world, but I've distilled into this set of articles all my 40-odd years of knowledge and experience of using and pushing this database technology to its limits. It's my attempt to try to make it all at least a little bit less secret and open your eyes to what really lies beneath!

So strap yourself in and read all about it here:

https://github.com/robtweed/global_storage

5 Comments

Discussion (5)3

Please note that this post is obsolete.

Article

Iryna Mologa · Dec 14, 2021 1m read

#Developer Community FAQ #Developer Community Official

>> Udated guide <<

Hey everyone,

Need to change your PRIMARY email address (login email) and not lose all your activity on the Developer Ecosystem resources: Community, Global Masters, and Open Exchange?

It's easy! We will take care!

1️⃣ We will correctly transfer all your information from the old DC account to the new one.

All your posts, comments, mentions, likes, etc. will be saved on the new account.

2️⃣ If you are a member of Global Masters, your level, badges, points, etc. will also be transferred to your new account.

3️⃣ We will also take care of transferring your applications on Open Exchange.

4️⃣ Also, if you just need to deactivate your old account (and not to transfer your acitivity), we will do it in one click.

Just contact @Iryna Mologa in Direct Messages on DC or by email:

send a link to your old account (-s)
send a link to your new account (-s)
indicate on which resource(-s) you need to transfer your activity (DC/GM/OEX/all resources)

So!

We will do our best so that you do not feel like you have switched from one account to another!

Please feel free to contact us. Keep in touch!

P.s. You can also just add a comment on this post with links to your old and new accounts.

2 Comments

Discussion (2)2

Article

alex kosinets · Dec 9, 2021 2m read

#Caché #InterSystems IRIS

Millions of professionals use a wonderful tool, spreadsheets, for engineering calculations and financial analysis. It attracts a user-friendly interface and clear data organization. Cell formulas provide rich opportunities for automating calculations. No programming is required. (For example, Microsoft Excel)

But in order to expand the scope of the tool, it is necessary to increase the dimension of the tables and the speed of calculations. It is necessary to create a single, common database for a group of users. Cell formulas should be able to do everything. In this case, it is advisable not to change the source code of the application. It seems like an impossible mission.

However, M-technology has led to an unusual solution: the “spreadsheet m-amplifier”. An analogy is your car: the hydraulic booster helps even a fragile woman to turn the steering wheel easily. In the old days, only a strong macho could drive a car. Another example is a quantum computer. The calculations are carried out in parallel and consistently in all Universes of our Multiverse. The solution to any task is instant. So far, only in a project.

Our m-amplifier (“Shadow excel”) is implemented as parallel invisible spreadsheets inside Cache / IRIS InterSystems. There are also workbooks, worksheets, columns, rows, cells with formulas. Each main-excel sheet has a corresponding shadow-m-sheet. Each cell has a shadow cell. But formulas in the shadow cells are unusual - they are actually MUMPS commands. The m-worksheets are not two-dimensional, but multi-dimensional. The interface with users is not directly, but through “main excel”.

The possibilities of the shadow are orders of magnitude higher. Therefore, shadow does all the hard work and is much more efficient. M-globals spin faster than main sheets. All Cache / IRIS resources are available to M-formulas. You can build complex multidimensional data structures and quickly receive analytical reports with a large number of graphic elements. You can create a complex interactive game.

There is no need to keep a huge archive of workbooks with data from different periods of time. All data is stored in M-database.

"Shadow excel" is associated with several users at the same time over a network or Internet. Users see “main excel” on their screens, which is fantastically fast and performs incredibly difficult tasks.

We managed to correctly organize reliable synchronous work of shadow and main excel in real time. Everything that happens in the shadow is transferred to the main one and vice versa. They work as a single tool: MULTIEXCEL, on which it is now possible to build large complex systems of production and financial accounting and management. It is also used as UI for Cache / IRIS.

The operating experience of MULTIEXCEL has shown excellent results. This is another interesting area of application for M-technologies.

2 Comments

Discussion (2)0

Enhancement Requests, Ideas and Innovations

監査ログをプログラムで出力（ユーザやイベント指定など）する方法

Holiday Reading: What Lies Beneath!

How to Change Your Primary Email Address on Developer Ecosystem Resources

>> Udated guide <<

MULTIEXCEL