查找

文章
· 十二月 20, 2021 阅读大约需 1 分钟

Holiday Reading: What Lies Beneath!

#数据库 #数据模型 #Globals #多模型 #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
讨论 (5)3
登录或注册以继续
请注意，此帖子已过时。
文章
· 十二月 14, 2021 阅读大约需 1 分钟

How to Change Your Primary Email Address on Developer Ecosystem Resources

#开发者社区常见问题 #开发者社区官方

>> 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
讨论 (2)2
登录或注册以继续
文章
· 十二月 9, 2021 阅读大约需 2 分钟

MULTIEXCEL

#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
讨论 (2)0
登录或注册以继续
文章
· 十一月 29, 2021 阅读大约需 2 分钟

イメージファイルをFTPサーバからアップロード／ダウンロードする方法

#ObjectScript #提示和技巧 #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health

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

FTPサーバから、アップロード／ダウンロードする方法は以下の通りです。

1. FTPサーバにイメージファイルをアップロードする

 set tmpfile="c:\temp\test.jpg"
 set ftp=##class(%Net.FtpSession).%New() 
 // ftp サーバへ接続する
 do ftp.Connect("","<ユーザ名>","<パスワード>")
 // 転送モードをBINARYに設定
 do ftp.Binary()
 // アップロードするディレクトリに移動
 do ftp.SetDirectory("/temp/upload")
 // アップロードするファイルのストリームを用意   
 set file=##class(%File).%New(tmpfile)
 do file.Open("UK\BIN\")
 // ファイルをアップロード
 // 第１引数： アップロード先に作成するファイル名
 // 第２引数： アップロードするファイル・ストリーム
 do ftp.Store("test.jpg",file)
 // ftp サーバからログアウト
 do ftp.Logout()
 // ファイルを閉じる
 do file.Close()
 // (オプション) アップロードしたファイルを削除する
 //do ##class(%File).Delete(tmpfile)

2. FTPサーバからイメージファイルをダウンロードする

   set ftp=##class(%Net.FtpSession).%New()     // ftp サーバへ接続する
    do ftp.Connect("","<ユーザ名>","<パスワード>")     // 転送モードをBINARYに設定
    do ftp.Binary()     // ダウンロードして格納するファイル・ストリームを用意
    set stream=##class(%FileBinaryStream).%New()
    do stream.LinkToFile("c:\temp\testdownload.jpg")
   // ダウンロードするディレクトリに移動
    do ftp.SetDirectory("/temp/download")     // ファイルをダウンロードしてストリームを閉じる
    do ftp.Retrieve("test.jpg",stream)
    do stream.SaveStream()
    Set stream=""     // ftp サーバからログアウト
    do ftp.Logout()
讨论 (0)1
登录或注册以继续
Job
· 十一月 19, 2021

Job Opportunity for Caché/Ensemble/Iris develope

#SQL #XML #工作机会

A permanent job opportunity has arisen for a Caché/Ensemble /Iris developer with at least 2 years experience. My client is a specialist resource provisioner of developers for high profile clients in the finance,  healthcare, retail, distribution and credit business that are mainly based in central London. My client is looking for a highly-motivated individual who thrives in an environment where problems are open-ended. If you want to apply for the job you must be a UK resident, have a proven track record of building applications using InterSystems technologies and are able to work independently, be fluent in Caché Objects, Iris, SQL, XML, Integration.

The job is 80% remote working with fully expensed trips to London up to once a week. 

For further details please send your CV salary expectations to romina@kiotto.com

讨论 (0)0
登录或注册以继续