ETL

Welcome to OpenSearch Tokyo User Group ! OpenSearch Tokyo User Groupの第一回 ミートアップイベントを開催します！ OpenSearch は検索やObservabilityのワークロードのためのOSSです。 本イベントでは、第一回イベントということで、OpenSearchプロジェクトの概要やOSSの今後のロードマップ、OpenSearchのユーザからの体験話などをご紹介します。 扱わないトピック : AWSなどのベンダーサービス固有の話 イベント概要 日時: 2026年2月5日 (木) 18:30 開場 19:00-21:00 セッション 21:00〜懇親会 (22:00完全退館） イベント会場 Amazon Web Service Japan オフィス : 東京都品川区上大崎3-1-1 目黒セントラルスクエア21F (room number 21.001) https://maps.app.goo.gl/c1Zr7ff9kndRe2fGA タイムテーブル 1\. OpenSearch プロジェクト最新情報 2.ユーザーセッション① : 弥生株式会社 Kazuma Imaizumiさん * タイトル : OpenSearch Warm Tier設計の実践 - UltraWarm経験から学ぶIndex/Shard最適化 * 概要 : OpenSearchでのUltraWarm導入経験をもとに、OSS環境でも活用できるWarm Tier設計の実践的ノウハウを共有します。ISM（Index State Management）、Index、Shardの基本概念から、シャードサイズ設計のベストプラクティスと実運用での最適化、UltraWarmとWarm Tierで共通する設計考慮事項まで、具体的な設定例とともに解説します。実運用データ（週1TB、1,000以上のシャード、1シャード約100GB）での経験をもとに、理想と現実のギャップを踏まえた時系列データの効率的な管理とコスト最適化を目指す技術者向けの内容です。 3.ユーザーセッション② : Serverless Operations, Inc. Sonu Kimさん * タイトル : 「うまく言えない」検索を叶える ― OpenSearchと生成AIで作る類似プロジェクト検索 * 概要 : 「前に似たような案件があったはずだけど、どう検索すればいいか分からない」といった、うまく言語化できない検索が必要な業務があります。本セッションでは、OpenSearch を活用して類似プロジェクトを検索できる仕組みを構築し、業務に合わせて「何をどの程度似ていると判断するか」を柔軟にチューニングできる検索体験を実現した取り組みについてお話します。 また、あいまいな検索条件でもユーザーが求める情報に辿り着けるよう、生成AIを用いてデータを前処理・構造化するアプローチや、検索精度を高めるための工夫についても合わせてお伝えします。 4.ユーザーセッション③ : 株式会社ラクス Nobuhiro Inaguma さん * タイトル : VectorDBとしてのOpenSearch\~5,000万件超のベクトル検索をコストを抑えて運用する技術選定\~ * 概要 : 全文検索・分析基盤として知られるOpenSearchは、実は大規模なベクトル検索にも活用できます。本セッションでは、5,000万件超のベクトルを対象に、ベクトルDB導入時に課題になりがちなメモリコストの増加を、Disk-based vector searchの活用で抑えた事例をご紹介します。 懇親会について セッション終了後、簡単な軽食とドリンクをご用意する予定です。 \-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\- OpenSearch Tokyo User Groupについて OpenSearch Project Tokyo ユーザーグループは、OpenSearch ユーザーを中心としたコミュニティです。オープンソース版の OpenSearch、各種マネージドサービス上で実行されている OpenSearch エンジンをご利用の方は是非ご参加ください。ユースケースは検索に限定されません。分析、可視化など、OpenSearch がカバーするあらゆるトピックについて情報・意見交換していきましょう。 Welcome to the OpenSearch Tokyo User Group! We are hosting the first meetup event of the OpenSearch Tokyo User Group! OpenSearch is an open-source software for search and observability workloads. At this inaugural event, we will be introducing the overview of the OpenSearch project, the roadmap for the open-source software, as well as experiences shared by OpenSearch users. Topics we will not cover: Specific topics related top services provided by vendors like AWS. Event Details Date & Time: Thu,Feb,5 2026 \- 6:30 PM Doors open \- 7:00 PM \- 9:00 PM Sessions \- 9:00 PM \- 10:00 PM Networking \(complete departure by 10 PM\) Venue Amazon Web Services Japan Office: Meguro Central Square, \*-\*-\*, Kamiosaki, Shinagawa-ku, Tokyo 21F (room number 21.001) https://maps.app.goo.gl/c1Zr7ff9kndRe2fGA Agenda TBD Networking After the sessions, we will provide light refreshments and drinks. \-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\- About the OpenSearch Tokyo User Group The OpenSearch Project Tokyo User Group is a community centered around OpenSearch users. If you are using the open-source version of OpenSearch or the OpenSearch engine running on managed services, please join us. The use cases are not limited to just search - we will also discuss topics around analytics, visualization, and any other areas that OpenSearch covers.

Ukulele Club is a fun group for all ages and skill levels! There is no teacher, but we all help teach each other. Think of songs you would like to learn, and we can learn them together. If you don't have an ukulele, we have extra ukuleles When: *almost* Every Saturday, 10am-11:30am Admission: food/drink order

I love my job and one of the main things I do is help customers get going with any of the data technologies at Microsoft. Right now there are a lot of my customers asking about Microsoft Fabric. It's hard to weave across all the shiny new options across the Fabric landscape, let alone figure out where it fits into your organization. In this session we'll focus on answering one question - how can I get data into Fabric? We'll talk through the "it depends" options and see some of the options in live demos.

**People Analytics 101: Making Sense of Compensation Data** Compensation data is one of the most widely used and widely misunderstood forms of people analytics. The session will cover where compensation data comes from, including market pricing data, internal payroll data, and benchmarking sources, and how companies think about structuring and analyzing that information. We will explore how compensation data is leveraged to set salary ranges, manage internal equity, support hiring and retention, and align pay with business strategy. A portion of the session will address common data challenges and limitations, such as market noise, inconsistent job matching, and incomplete datasets, while keeping the primary focus on practical use rather than technical depth. The session will also look ahead at where the space is going, including the growing impact of pay transparency laws, expanding pay equity requirements, and emerging regulations in the US and Europe that require organizations to report on gender and pay gaps. The goal is to give attendees a clear mental model for how compensation analytics works today and why getting it right is becoming increasingly critical. (note: we are back at Rev1 this month!) **About Our Speaker** [Alex Moore](https://www.linkedin.com/in/alexscottmoore/) is the founder of [Moore Cooperative](https://moorecooperative.com/), where he advises organizations on compensation strategy, pay equity, and people analytics. His work focuses on helping organizations like the Ohio Supreme Court design, analyze, and communicate compensation systems that are data-informed, defensible, and aligned with organizational goals. Alex lives in Granville, Ohio and has three little kiddos. More info at [cbusdaw.com](https://cbusdaw.com)

The February Ohio North Database Training user group meeting will be held on **February 3rd, 2025 at 5:00PM**. This will be a **HYBRID** event and we will be joined in person by **David Pickering**. You're welcome to come meet in-person at our meeting location, the offices of Improving at **[6000 Freedom Square Dr,](https://www.google.com/maps/place/Improving/@41.4004167,-81.6614462,17z/data=!3m2!4b1!5s0x8830e5b8255c5919:0xd8297060eb68fe04!4m6!3m5!1s0x8830dc7a0fe35dc9:0xbfc4710ecadfc5c!8m2!3d41.4004127!4d-81.6588713!16s%2Fg%2F1hm3hkqp3?entry=ttu&g_ep=EgoyMDI1MDQzMC4xIKXMDSoASAFQAw%3D%3D)** **[Unit 110,](https://www.google.com/maps/place/Improving/@41.4004167,-81.6614462,17z/data=!3m2!4b1!5s0x8830e5b8255c5919:0xd8297060eb68fe04!4m6!3m5!1s0x8830dc7a0fe35dc9:0xbfc4710ecadfc5c!8m2!3d41.4004127!4d-81.6588713!16s%2Fg%2F1hm3hkqp3?entry=ttu&g_ep=EgoyMDI1MDQzMC4xIKXMDSoASAFQAw%3D%3D)** **[Independence, OH 44131](https://www.google.com/maps/place/Improving/@41.4004167,-81.6614462,17z/data=!3m2!4b1!5s0x8830e5b8255c5919:0xd8297060eb68fe04!4m6!3m5!1s0x8830dc7a0fe35dc9:0xbfc4710ecadfc5c!8m2!3d41.4004127!4d-81.6588713!16s%2Fg%2F1hm3hkqp3?entry=ttu&g_ep=EgoyMDI1MDQzMC4xIKXMDSoASAFQAw%3D%3D)** [Teams Link ](https://teams.microsoft.com/meet/27861114692350?p=lHdrSV1OOELhLnCiAg)if anyone needs it after RSVP-ing for in person. If you would like to subscribe to our email list outside of Meetup, we have changed platforms recently and you will need to register [here in Kit ](https://ohio-north-data-training.kit.com/b8f036f615)instead to receive emails. Agenda: **5:00 PM EST**: Online and in-person meeting begins with a social hour. This is an unstructured hour where you can join us to catch up and meet other group members before the session starts. There will be food brought in for in-person attendees. **6:00 PM EST**: Updates and announcements, followed by our feature presentation. See below for presentation details. **7:30 PM EST**: Optionally after the main presentations, the in-person crowd may go out for snacks and drinks at a local establishment. We hope to see you there! Session Abstract **No Map Required: Geospatial Analytics Directly in Your Data Warehouse** Think geospatial analysis requires specialized GIS software? Think again. This session introduces you to shapefiles and spatial operations right inside your database—no mapping application required. We'll demystify shapefiles (what they are, how they work, and where to get them) and show you how nearly every modern database —from DuckDB to Snowflake, supports spatial operations. You'll see practical demos covering spatial joins, distance calculations, and how to determine if two shapes interact with each other. Whether you're a data engineer optimizing delivery routes, an analyst aggregating metrics by geography, or a BI developer building location-aware dashboards, this session will show you how to unlock powerful spatial capabilities already built into your database stack—no specialized tools required. \*Please note, that we will be using Microsoft Teams for the online portion of this meeting. You may want to join a few minutes early to ensure you do not have any issues. If you are attending in person, there are large TVs at the office, and you do not need to bring a laptop or use Teams.

Bring your business cards and network in person with other business professionals! Gold Star Referral Clubs is one of the most established professional networking organizations in the country, with multiple groups in central Ohio. Join us!

Join members of the local UX and Digital Design community for a casual monthly breakfast. There _might_ be a little snow, but there _will_ be effectively infinite serve-yourself coffee, so it evens out if you ask me. Just a reminder, while the other locations are great too, we’re at the Lane Ave one this time.

### Tools in your AI's Toolbox : An introduction to MCP Servers The generative AI revolution has unlocked unprecedented capabilities, but the next frontier is agency: empowering models to interact with, query, and act upon the world. The current challenge is the “N x M integration problem,” where every AI model requires a custom, brittle integration for each external tool or data source. This approach simply doesn’t scale. How can we give an AI access to our sales leads, code repositories, or IoT devices in a standardized, secure, and reusable way? This session introduces Anthropic’s Model Context Protocol (MCP), the open-source framework designed to solve this challenge and become the universal connector—the USB-C port—for AI. MCP standardizes how AI models discover and use external tools, moving beyond simple function-calling to a robust, client-server architecture. We will dive into how this open protocol is creating a new ecosystem for building powerful, context-aware AI agents. Join this session for a developer-focused introduction where you will learn how to: Understand the core concepts of the open-source Model Context Protocol and its architecture. Utilize pre-built, open-source MCP servers to instantly connect AI to tools like Git, Slack, and databases. Build a custom MCP server to securely expose your own proprietary data and APIs as tools for any compliant AI. Move beyond bespoke integrations and contribute to a standardized, collaborative, and open ecosystem. Stop building one-off connectors and start building intelligent agents. This session will give you the practical knowledge to leverage MCP and create the next generation of AI that doesn’t just talk, but does. Want to be a speaker? submit your talk to our Call for Presenters!!! [https://sessionize.com/azure-cbus-2026/](https://sessionize.com/azure-cbus-2026/)