Nova postagem

Encontrar

Artigo
· Jul. 1 3min de leitura

Portuguese on Pattern Match Work Bench and other improvements

Thank you community for translating an earlier article into Portuguese.
Am returning the favor with a new release of Pattern Match Workbench demo app.

Added support for Portuguese.

The labels, buttons, feedback messages and help-text for user interface are updated.

Pattern Descriptions can be requested for the new language.

The single AI Model for transforming user prompt into Pattern match code was fully retrained.

 

Values to Pattern Code Model also retrained

The separate AI model for generating Pattern match code from a sample list of values has been retrained.
The previous model release exhibited loss of generalized pattern identification behaviors in order to support new delimiter style patterns.
The new training approach was evolved to better suit both types of challenge.

Post training benchmarking of the model stages was used to quantify the better candidate to preserve generalized pattern solving.
The principle to quantify 100% success for each generated pattern was to attempt to satisfy all its respective candidate sample records.

Overview benchmark report:

Total benchmark tests used 3895
Mean success across all matches 91.75%
Complete pattern match success 81.98%
Partial pattern match success 15.74%
Unsuccessful match records 2.28%

The following table gives examples from benchmark candidates demonstrating partial success.
It shows the percentage of sample records successfully matched to generated pattern code.

Item Sample Size Context window Rows matched % Match Actual Generated Pattern Pattern Template
1 31 31 28 90.3 4UN5AN2.3(4UNP2"/"1UP3.6LP1UP,2"/"1"Ç")5.11N 4UN5AN2(4PUN2"/"1PU3.6LP1PU,2"/"1"Ç")5.12N
2 31 31 17 54.8 5N5ANP3"7Æ6N1ŃS8"1(2"{{{",4"Û4"3"ĪĪċ")3P 5.6N5NPA3"7Æ6N1ŃS8"1(3"{{",4"Û4"3"ĪĪċ")3P
3 31 24 15 62.5 5.8"6Ã02"3(4"51704833"3"ĹĐRÞÇ",1PN,1LP1"K"4.6"7499")1"û5ُ3"4.7N 5.8"6Ã02"3(4"51704833"3"ĹĐRÞÇ",1PN,1LP1"K"4.6"7499")1"û5ُ3"4.7N
4 31 19 28 90.3 3P5UN5NP5UN5UN3AN3"JŁY"1.4"5"2U1LN 3P5NU5NP4UN5NU4NA3"JŁY"1.4"5"2U1NL
5 31 10 7 22.6 4LNP3.6AN4"×_"5"¤īĩĵ®ü"5AN3AN3LNP2UN3"ċ"5LN 4NPL2.5NA4"×_"5"¤īĩĵ®ü"3.5NA3AN3PLN2UN3"ċ"5NL
6 30 9 26 86.7 5.6"ŀ¬¦"5"!pp%"1UNP5"Ù6"4.8AP3(3N,4"8¸",5UNP)5.11P 5.6"ŀ¬¦"5"!pp%"1PNU5"Ù6"4.7PA3(3N,3UP,4"8¸")4P4.5P
7 25 12 5 20.0 2"AAHH"5"30"3(4.7UP,4L)5"ĥèßłĉ,,,"4.5N 2"AAHH"5"30"5(3UP,4L,4UP,1PL)5"ĥèßłĉ,,,"4.5N
8 31 14 30 96.8 5LP4")))¦¦§÷"4.10LN5.10UNP2"gx"1UN 5PL4")))¦¦§÷"4.11NL5.10PUN2"gx"1UN

Legend

Sample Size - The number records available for test sample. Sometimes a pattern describes less than 31 possible exact matches. Hence the lower values
Context Window - Maximum number of sample records that fit to generate a new pattern
Rows matched - This is the number of sample records that were matched by the generated pattern

Note that items 4, 6 and 8 achieve a match count greater than the context window.

When patterns are generated from values the context window used and proportion of matching is returned.

For challenging data samples it can be productive to retry the "Pattern from Values" button for improved results.

Showing the context window by row is useful to provide opportunity for specific records to be elevated into prompt for generative consideration. 

Benchmark inferencing was conducted via HuggingFace spaces to scale up available GPU for timely execution. 

Reporting is useful to analyse qualitative closeness of proposals by the LLM in terms of:
* Match type ( String, Number, Alphanumeric, Uppercase-Alpha)
* Choice of Quantity range ( 2-to-3 of ... )
* Option lists ( "123" or "456" )
* Structured elements using brackets

This opens up opportunities for training to be improved.

Please feel free to feedback on improvements for:

  • Language translations
  • Pattern match behaviors.
Discussão (0)1
Entre ou crie uma conta para continuar
Discussão
· Jul. 1

Did You Do It All at InterSystems READY 2025? Check Your Bingo!

How was your READY experience?
We’ve prepared a bingo card — take a look and see how many boxes you can check off!
Cross off the ones that match your experience or list them in the comments.
And if something memorable happened that’s not on the card — we’d love to hear about it! ✨

      

Bingo items:

  1. Joined Golf Tournament or Soccer Match
  2. Discovered a feature you didn’t know existed
  3. Participated in a hands-on workshop on Sunday
  4. Learned something new
  5. Had a 1:1 meeting with an InterSystems expert
  6. Attended at least one Tech Exchange Demo
  7. Answered 5 out of 5 quiz questions correctly (at Developer Community booth)
  8. Took a free certification exam
  9. Spun the Wheel of Fortune at Developer Community booth
  10. Attended Keynotes and afternoon sessions
  11. Met someone new / made a new connection
  12. Met a fellow Developer Community Member

How many out of 12 did you check off? 
Copy the ones you completed in your reply please - we’re curious to see which activities were most popular! 🤩

19 novos comentários
Discussão (19)7
Entre ou crie uma conta para continuar
Resumo
· Jul. 1

InterSystems開発者コミュニティのダイジェスト、6月 2025

6月 2025開発者コミュニティ ニュースレターへようこそ。
全体統計
16 件の新しい投稿が公開 (6月 月):
 8件の新着記事
 8の新しい発表
1 人の新メンバーが参加 (6月 月)
1,521 件の投稿が公開 (全期間)
324 人のメンバーが参加 (全期間)
トップ記事
体重のノックアウト
Andre Larsen Barbosa順
今月のトップ作家
記事
お知らせ
#InterSystems IRIS
#InterSystems公式
#IRIS contest
#開発者コミュニティ公式
6月, 2025Month at a GlanceInterSystems Developer Community
Artigo
· Jun. 30 2min de leitura

ObjectScript での日付の比較方法(ObjectScript での SQL 関数実行方法)

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

ObjectScript で日付の比較を行う場合、一旦 $HOROLOG 形式(内部数値)に変換することで算出しやすくなりますが、SQL 関数を利用して算出することもできます。

ObjectScript から SQL 関数を実行するには、%SYSTEM.SQL.Functions クラスを使用します。

※ 2021.1以前のバージョンでは、%SYSTEM.SQL クラスを使用します。

%SYSTEM パッケージは、システム・オブジェクトと呼ばれ ObjectScript では $SYSTEM 特殊変数を利用して以下の構文で実行します。

  $SYSTEM.サブパッケージ名.クラス名.メソッド名() または $SYSTEM.クラス名.メソッド名()

 

以下、SQL 関数 DATEDIFF を使用して日付の比較を行う例です。

USER>write $system.SQL.Functions.DATEDIFF("dd","2025-01-20","2025-03-20")
59

 

分での比較

USER>write $system.SQL.Functions.DATEDIFF("mi","2025-01-20","2025-03-20")
84960

 

秒での比較

USER>write $system.SQL.Functions.DATEDIFF("ss","2025-01-20","2025-03-20")
5097600

 

この他、DATEADD 関数を使って指定日付に日付や時刻を追加することもできます。

指定の日付に10年追加する

USER>write $system.SQL.Functions.DATEADD("year",10,"2025-01-20")
2035-01-20 00:00:00

 

指定の日付の25日前

USER>write $system.SQL.Functions.DATEADD("day",-25,"2025-01-20")
2024-12-26 00:00:00

 

指定日時の16時間前

USER>write $system.SQL.Functions.DATEADD("hour",-16,"2025-01-20 13:10:00")
2025-01-19 21:10:00

 

指定の日付時刻の指定箇所のみを取り出す DATEPART 関数の実行例は以下の通りです。

hour を取り出す

USER>write $system.SQL.Functions.DATEPART("hour","2025-01-20 13:10:00")
13

 

dayofyear を返す

USER>write $system.SQL.Functions.DATEPART("dayofyear","2025-10-20 13:10:00")
293

 

dayを返す

USER>write $system.SQL.Functions.DATEPART("day","2025-10-20 13:10:00")
20

 

この他のSQL関数については、ドキュメントをご参照ください。

Discussão (0)1
Entre ou crie uma conta para continuar
Anúncio
· Jun. 30

[Webinar] The Future of Healthcare Integration with Health Connect & InterSystems

Hey Community,

We're excited to invite you to the next InterSystems UKI Tech Talk webinar: 

👉The Future of Healthcare Integration with Health Connect & InterSystems

⏱ Date & Time: Thursday, July 3, 2025 10:30-11:30 UK

Speakers:
👨‍🏫 @Mark Massias, Senior Sales Engineer, InterSystems
👨‍🏫 Mike Fitzgerald. Head of Customer Solutions, ReStart

2025 Tech Talk Social Tile 19 Jun (draft) (3).png

As the NHS continues to advance its digital transformation agenda, seamless interoperability has become a crucial priority for healthcare IT professionals. InterSystems Health Connect is leading the way as a superior integration engine, offering enhanced scalability, security, and performance to support evolving data exchange needs.

This exclusive webinar will explore how you can overcome interoperability challenges, streamline system migrations, and benefit from real-world success stories—ensuring you stay ahead of NHS standards for connected care.

Join us for an insightful session where InterSystems and our highly experienced implementation partner ReStart will showcase the benefits of Health Connect, providing actionable strategies for seamless integration and transitioning from legacy solutions. Discover how Health Connect supports NHS standards out-of-the box and enhances connectivity across trust and regional healthcare networks.

This is your opportunity to future-proof your healthcare IT strategy and drive smarter, more efficient data integration.

>> REGISTER HERE <<

2 novos comentários
Discussão (2)2
Entre ou crie uma conta para continuar