Nouvelle publication

Rechercher

Annonce
· Avr 23, 2024

有奖调研！您最常用的代码托管平台是什么？

#Événements #Autre #Communauté des développeurs officielle

Hi 开发者们，

为了更好地优化开发者社区服务，我们希望了解中国的开发者们最常用的代码托管平台是什么，即日起我们发起一项有奖调研。详情如下。

调研时间：2024年4月23日-2024年5月14日

调研方式：

为了便于您的参与，我们准备了两种调研方式，您可以选择任意一种方式参与调研。

1. 方式一：点击【此处】进入调研表单，参与调研。

建议您从电脑端参与调研，为了快速完成调研，调研前务必准备好您的社区主页URL。

如何找到社区主页URL：在开发者社区页面点击“个人头像”后，复制浏览器中的URL即可，格式如下（例）：https://cn.community.intersystems.com/user/claire-zheng

2. 方式二：在本帖下跟帖留言，注明您最常用的代码托管平台即可。

调研奖励：

调研结束后，我们将进行随机抽奖，为参与此次调研的开发者们送出以下奖品——

  • 迷你桌面吸尘器5份
  • 充气颈枕2份
  • 以及特别奖励1份，奖品为：Apple AirTag

欢迎大家积极参与！

3 Comments
Discussion (3)2
Connectez-vous ou inscrivez-vous pour continuer
Annonce
· Avr 23, 2024

インターシステムズ主催 第14回 開発者向けウェビナー「ベクトル検索機能のご紹介」のご案内

#Webinaire #Événements #InterSystems IRIS

 

連続3回のシリーズでお届けする新機能についてのウェビナー、第二弾はベクトル検索です。

日時：5月30日（木）13:30～14:00　（参加費無料・事前登録制）

ご登録はこちらから

セッション概要：IRIS 2024.1の実験的機能として、ベクトル検索が実装されました。この機能により、ベクトル型が新たにサポートされ、ドキュメントの類似検索などが可能になります。また、大規模言語モデル(LLM)や生成AIと組み合わせて、最先端のアプリケーション開発を強力に支援します。本ウェビナーでは、ベクトル検索の概要について解説します。

ウェビナーの前に少し内容を確認されたい方は、開発者コミュニティの記事「Vector Search (ベクトル検索) をご紹介します」をぜひご参照ください。

こんな方にお勧め：

・ 文書検索に興味のある方

・ 大規模言語モデルや生成AIの活用を検討されている方

ご多用中とは存じますが、皆様のご参加をお待ち申し上げております。

Discussion (0)1
Connectez-vous ou inscrivez-vous pour continuer
Question
· Avr 22, 2024

SSL/TLS Client/OAuth2 Configuration - Testing

#Red Hat Enterprise Linux (RHEL) #SSL #Administration du système #Health Connect #InterSystems IRIS #InterSystems IRIS for Health

I am trying to setup a OAuth2.0 configuration to connect to a server within our Network using OAuth2.0. My previous attempt worked, however forgot to capture the steps before I had whipped the System so please bear with me. 

I have an SSL/TLS Client configuration setup as we use the setup for our LDAP configuration. 

When I go through the following steps within the Terminal, I am getting the following error...

%SYS>kill ^ISCLOG
%SYS>set scope="openid fhirUser"
%SYS>set jwt = ##class(%SYS.OAuth2.Authorization).GetAccessTokenJWT("EpicFHIRPOC","1fd8f5cc-18ee-4eff-990d-4606037b932e",scope,.properties,.error,123)

%SYS>

%SYS>zwrite error
error=""
%SYS>zwrite jwt
jwt="0 "_$lb($lb(6085,"OSUMC","error:0200100D:system library:fopen:Permission denied, error:20074002:BIO routines:file_ctrl:system lib, error:140DC002:SSL routines:use_certificate_chain_file:system lib",,,,,,,$lb(,"%SYS",$lb("e^Send+313^%Net.HttpRequest.1^1","e^Post+1^%Net.HttpRequest.1^1","e^GetAccessTokenJWT+44^%SYS.OAuth2.Authorization.1^1","e^^^0"))))/* ERROR #6085: Unable to write to socket with SSL/TLS configuration 'OSUMC', error reported 'error:0200100D:system library:fopen:Permission denied, error:20074002:BIO routines:file_ctrl:system lib, error:140DC002:SSL routines:use_certificate_chain_file:system lib' */

When I attempt to Test the SSL/TLS configuration to that same FHIR server, that I can access from my desktop I am seeing...

But that same configuration runs ok when I attempt to connect to the LDAP server.

Is this a problem with my OSUWMC SSL/TLS configuration?

Does my key/cert have the correct permissions??

[root@int-lxiris-vd01 private]# ls -lat int-lxiris-vd01_osumc_edu.key
-rw-rw-rw-+ 1 apache irisusr 3414 Jan  8 11:37 int-lxiris-vd01_osumc_edu.key

[root@int-lxiris-vd01 certs]# ls -lat int-lxiris-vd01_osumc_edu.pem
-rw-rw-rw-+ 1 apache irisusr 6521 Jan  9 10:38 int-lxiris-vd01_osumc_edu.pem
7 Comments
Discussion (7)2
Connectez-vous ou inscrivez-vous pour continuer
Discussion (4)3
Connectez-vous ou inscrivez-vous pour continuer
Annonce
· Avr 22, 2024

Beta testers needed for our upcoming InterSystems IRIS SQL Specialist certification exam

#Certification #Global Summit 2024 #Indexation #Tables relationnelles #SQL #InterSystems IRIS #InterSystems IRIS for Health

Hello IRIS Community,

InterSystems Certification is developing a certification exam for InterSystems IRIS SQL specialists, and if you match the exam candidate description given below, we would like you to beta test the exam. The exam will be available for beta testing on June 9 - 12, 2024 at InterSystems Global Summit 2024, but only for Summit registrants (visit this page to learn more about Certification at GS24). Beta testing will open for all other interested beta testers on June 24, 2024. However, interested beta testers should sign up now by emailing certification@intersystems.com (please let us know if you will be beta testing at Global Summit or in our online proctored environment). The beta testing must be completed by August 2, 2024.

What are my responsibilities as a beta tester?

You will be assigned the exam and will need to take it by August 2, 2024. The exam will be administered in an online proctored environment (live-proctored during Summit), free of charge (the standard fee of $150 per exam is waived for all beta testers), and then the InterSystems Certification team will perform a careful statistical analysis of all beta test data to set a passing score for the exam. The analysis of the beta test results will take 6-8 weeks, and after the passing score is established, you will receive an email notification from InterSystems Certification informing you of the results. If your score on the exam is at or above the passing score, you will have earned the certification! 

Note: Beta test scores are completely confidential.

Exam Details

Exam title: InterSystems IRIS SQL Specialist

Candidate description: An IT professional who uses InterSystems IRIS SQL to:

  • design InterSystems IRIS SQL applications,
  • manage InterSystems IRIS SQL operations,
  • and load and efficiently query datasets in InterSystems IRIS SQL.

Number of questions: 47

Time allotted to take exam: 2 hours

Recommended preparation: Review the content found in the table below before taking the exam

Designing InterSystems IRIS SQL Applications

Using InterSystems IRIS SQL

Managing InterSystems IRIS SQL Operations

 

 

Recommended practical experience:

  • Basic experience with standard ANSI SQL
  • 1 to 2 years of experience with designing and managing InterSystems IRIS SQL applications or expertise in other SQL platforms and has 1 year experience with managing InterSystems IRIS SQL applications.

Exam practice questions

A set of practice questions is provided here to familiarize candidates with question formats and approaches.

Exam format

The questions are presented in two formats: multiple choice and multiple response. Access to InterSystems IRIS Documentation will be available during the exam. 

DISCLAIMER: Please note this exam has a 2-hour time limit. While InterSystems documentation will be available during the exam, candidates will not have time to search the documentation for every question. Thus, completing the recommended preparation before taking the exam, and searching the documentation only when absolutely necessary during the exam, are both strongly encouraged!

System requirements for beta testing (note that laptops will be provided and configured to meet these requirements at Global Summit)

  • Working camera & microphone
  • Dual-core CPU
  • At least 2 GB available of RAM memory
  • At least 500 MB of available disk space
  • Minimum internet speed:
    • Download - 500kb/s
    • Upload - 500kb/s

Exam topics and content

The exam contains questions that cover the areas for the stated role as shown in the exam topics chart immediately below.

Topic

Subtopic

Knowledge, skills, and abilities

1. Designs InterSystems IRIS SQL applications

 

1. Designs a SQL schema
  1. Identifies role of bitmap extent index
  2. Determines use cases for indexes
  3. Distinguishes use cases for different index types​
  4. Distinguishes primary, unique, and ID keys
  5. Identifies properties for foreign key relationships
  6. Identifies behavior of referential actions for update and delete
  7. Identifies tradeoffs for adding ever more indexes
  8. Identifies use cases for composite indexes

 

2. Designs advanced schemas
  1. Distinguishes the differences between date/time data types

 

3. Loads data
  1. Uses LOAD DATA command
  2. Uses SQL diagnostics tables (%SQL_Diag)
  3. Identifies options for exporting data (physical vs logical)
 

4. Writes business logic
  1. Defines stored procedures
  2. Defines triggers
  3. Identifies language options for writing business logic
 

5. Develops object/relational applications
  1. Recalls default object/relational mapping
  2. Recalls SQL best practices when defining classes
 

6. Deploys SQL applications
  1. Lists mechanisms for deploying SQL applications
  2. Determines what needs to be part of a deployment

2. Uses InterSystems IRIS SQL

1. Manages InterSystems IRIS query processing
  1. List considerations made by the optimizer
  2. Differentiates syntax and runtime errors
  3. Uses Statement Index to find statement metadata
  4. Distinguishes between the use of parameters and constants in a query

 

2. Interprets query plans
  1. Identifies ways to view query plans for a statement
  2. Identifies Full Table Scans in a query plan
  3. Identifies the use of indexes in a query plan
  4. Distinguishes between loops and lookups in a query plan
  5. Distinguishes modules called once vs repeatedly in a query plan
  6. Recalls role of table statistics in query planning
  7. Uses hints to troubleshoot query planning
  8. Identifies opportunities for indexes, based on a query plan
  9. Recalls the meaning of relative cost

 

3. Uses InterSystems IRIS SQL in applications
  1. Defines InterSystems IRIS connections
  2. Identifies prepare/execute steps
  3. Recalls how proper use of parameters can guard against SQL injection
  4. Leverages explicit transaction controls effectively

 

4. Uses InterSystems IRIS-specific SQL capabilities
  1. Uses SelectMode appropriately
  2. Uses arrow syntax for implicit joining

 

5. Uses transactions effectively
  1. Determines appropriate transaction boundaries
  2. Uses CommitMode appropriately
  3. Recalls impact of large or long-running transactions

3. Manages InterSystems IRIS SQL operations

1. Manages SQL operations
  1. Uses SQL Process view to monitor SQL activity (2022.2+)
  2. Gathers table statistics
  3. Uses the runtime stats in the Statement Index to find statements with optimization opportunities

 

2. Manages SQL Security
  1. Assigns SQL privileges to users and roles
  2. Differentiates SQL privilege checking and application security
  3. Identifies impact of enabling SQL auditing
 

3. Uses PTools for advanced performance analysis
  1. Distinguishes between performance metrics "time spent", "global references" and "commands executed"

Interested in participating? Email certification@intersystems.com now!

5 Comments
Discussion (5)6
Connectez-vous ou inscrivez-vous pour continuer