Apache Druid | Apache® Druid
Sub-second queries at any scaleExecute OLAP queries in milliseconds on high-cardinality and high-dimensional data sets with billions to trillions of rows without pre-defining or caching queries in advance. High concurrency at the lowest cost Build real-time analytics applications that supports 100s to 100,000s queries per second at consistent performance with a highly efficient architecture that u
GitHub - apache/pinot: Apache Pinot - A realtime distributed OLAP datastore
Apache Pinot is a real-time distributed OLAP datastore, built to deliver scalable real-time analytics with low latency. It can ingest from batch data sources (such as Hadoop HDFS, Amazon S3, Azure ADLS, Google Cloud Storage) as well as stream data sources (such as Apache Kafka). Pinot was built by engineers at LinkedIn and Uber and is designed to scale up and out with no upper bound. Performance a
リアルタイムãªãƒ‡ãƒ¼ã‚¿åˆ†æžã‚’ã™ã‚‹åˆ†æ•£OLAP「Pinotã€ã‚’LinkedInãŒã‚ªãƒ¼ãƒ—ンソースã§å…¬é–‹
LinkedInã¯ã€åŒç¤¾ãŒé–‹ç™ºã—ãŸãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ データ分æžã‚’実ç¾ã™ã‚‹åˆ†æ•£OLAPデータストア「Pinotã€ã‚’オープンソースã§å…¬é–‹ã—ãŸã“ã¨ã‚’明らã‹ã«ã—ã¾ã—ãŸã€‚ Open Sourcing Pinot: Scaling the Wall of Real-Time Analytics | LinkedIn Engineering LinkedInã¯ãƒ“ジãƒã‚¹ã«ç‰¹åŒ–ã—ãŸã‚½ãƒ¼ã‚·ãƒ£ãƒ«ãƒ¡ãƒ‡ã‚£ã‚¢ã‚µãƒ¼ãƒ“ス。 åŒç¤¾ã¯ã“ã®ã‚µãƒ¼ãƒ“スã§ç™ºç”Ÿã™ã‚‹å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’分æžã™ã‚‹ãƒ—ラットフォームã¨ã—ã¦ã€ã™ã§ã«2年以上Pinotã‚’é‹ç”¨ã—ã¦ãã¦ãŠã‚Šã€æ—¥ã€…æ•°å億件ã®ãƒ‡ãƒ¼ã‚¿ã‚’投入ã—ã€æ•°åƒå„„件もã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã€‚毎日1億クエリを実行ã—ã€10ミリ秒程度ã®ãƒ¬ã‚¤ãƒ†ãƒ³ã‚·ã§ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ 分æžã—ã¦ã„ã‚‹ã¨ã®ã“ã¨ã€‚ 例ãˆã°ã€LinedInã®ã‚µãƒ¼ãƒ“スã§ã‚る「Who's Viewed Your Profileã€ï¼ˆã‚ãªãŸã®ãƒ—ãƒãƒ•ã‚£ãƒ¼ãƒ«ã‚’誰ãŒè¦‹ãŸã‹ã€ã‚„ã€A/Bテストフレ
Welcome to Apache Kylin | Apache Kylin
Smarter and FasterKylin is a high concurrency, high performance and intelligent OLAP engine that provides low-cost and ultimate data analytics experience .
Announcing Kylin: Extreme OLAP Engine for Big Data
We are very excited to announce that eBay has released to the open-source community our distributed analytics engine: Kylin (http://kylin.io). Designed to accelerate analytics on Hadoop and allow the use of SQL-compatible tools, Kylin provides a SQL interface and multi-dimensional analysis (OLAP) on Hadoop to support extremely large datasets. Kylin is currently used in production by various busine
Materialized view - Wikipedia
In computing, a materialized view is a database object that contains the results of a query. For example, it may be a local copy of data located remotely, or may be a subset of the rows and/or columns of a table or join result, or may be a summary using an aggregate function. The process of setting up a materialized view is sometimes called materialization.[1] This is a form of caching the results
å¤šæ¬¡å…ƒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼œæƒ…å ±æŠ€è¡“ã®åŸºç¤Žï¼œï¼·ï½…ｂ教æ＜木暮
 Ｗｅｂ教æ一覧＞ データベース 多次元データベース（ï¼ï¼¤ï¼¤ï¼¢ï¼‰ å¦ç¿’ã®ãƒã‚¤ãƒ³ãƒˆ データウェアãƒã‚¦ã‚¹ã§åºƒã利用ã•ã‚Œã¦ã„る多次元データベースã«ã¤ã„ã¦ï¼Œæ¬¡ã®äº‹é …ã‚’ç†è§£ã™ã‚‹ã€‚ 多次元データベースã®åˆ©ç”¨åˆ†é‡Žã«ã¤ã„ã¦ç†è§£ã™ã‚‹ 多次元データベースã®åŸºæœ¬æ“作ã§ã‚るスライシング，ダイシング，ドリリングã«ã¤ã„ã¦ç†è§£ã™ã‚‹ ã‚¹ãƒŽãƒ¼æ§‹é€ ã«ã¤ã„ã¦ç†è§£ã™ã‚‹ 多次元データベースã®ç¨®é¡žã¨ã—ã¦ï¼Œï¼ï¼¯ï¼¬ï¼¡ï¼°ã¨ï¼²ï¼¯ï¼¬ï¼¡ï¼°ã®ç‰¹å¾´ã‚’ç†è§£ã™ã‚‹ ã‚ーワード データウェアãƒã‚¦ã‚¹ï¼Œï¼¯ï¼¬ï¼¡ï¼°ï¼Œå¤šæ¬¡å…ƒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼Œã‚¹ãƒ©ã‚¤ã‚·ãƒ³ã‚°ï¼Œãƒ€ã‚¤ã‚·ãƒ³ã‚°ï¼Œãƒ‰ãƒªãƒªãƒ³ã‚°ï¼Œã‚¹ã‚¿ãƒ¼æ§‹é€ ï¼Œã‚¹ãƒŽãƒ¼ãƒ•ãƒ¬ãƒ¼ã‚¯æ§‹é€ ï¼Œï¼ï¼¯ï¼¬ï¼¡ï¼°ï¼Œï¼²ï¼¯ï¼¬ï¼¡ï¼° 多次元データベースã®åŸºæœ¬æ“作 多次元データベースã®æ„味 データウェアãƒã‚¦ã‚¹ã®ã‚ˆã†ã«ï¼Œã‚¨ãƒ³ãƒ‰ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒç›´æŽ¥ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ¤œç´¢åŠ å·¥ã—ã¦å•é¡Œç™ºè¦‹ã‚’ã—ãŸã‚Šå•é¡Œè§£æ±ºã‚’ã™ã‚‹åˆ†æžã‚’主ã¨ã™ã‚‹åˆ©ç”¨å½¢æ…‹ã‚’，ＲＤＢã®æ唱者ã§ã‚ã‚‹E.F.Coddã¯ï¼Œï¼¯ï¼¬ï¼¡ï¼°ï¼ˆ
Blogger
Google ã®ã‚¦ã‚§ãƒ–ãƒã‚°å…¬é–‹ãƒ„ールを使ã£ã¦ã€ãƒ†ã‚ストã€å†™çœŸã€å‹•ç”»ã‚’共有ã§ãã¾ã™ã€‚
Oracleã®æ©Ÿèƒ½ã‚’使ã£ã¦è¡¨ã®çµåˆã‚’高速化ã™ã‚‹ï¼ˆ1/4） ï¼ ï¼ IT
本連載ã§ã¯ã€Oracleデータベースã®ãƒ‘フォーマンス・ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ä¸ã‹ã‚‰ã€ç‰¹ã«SQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«æ³¨ç›®ã—ã¦ã€å®Ÿè·µãƒ¬ãƒ™ãƒ«ã®æ‰‹æ³•ã‚’解説ã™ã‚‹ã€‚èªè€…ã¯Oracleデータベースã®ã‚¢ãƒ¼ã‚テクãƒãƒ£ã‚’ç†è§£ã—ã€é‹ç”¨ç®¡ç†ã®å®Ÿå‹™çµŒé¨“ã‚’ç©ã‚“ã§ã„ã‚‹ã“ã¨ãŒæœ›ã¾ã—ã„。対象ã¨ã™ã‚‹ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ç¾çŠ¶ã§åºƒã使ã‚ã‚Œã¦ã„ã‚‹Oracle9iã®æ©Ÿèƒ½ã‚’基本ã¨ã™ã‚‹ãŒã€Oracle 10gã§æœ‰åŠ¹ãªæƒ…å ±ã‚‚éšæ™‚紹介ã—ã¦ã„ã。（編集局） 連載目次 å‰å›žã€Œè¡¨ã®çµåˆã‚’極ã‚ã‚‹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ»ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã€ã§ã¯ã€çµžã‚Šè¾¼ã¿æ¡ä»¶ãŒãªã„çµåˆã‚’å«ã‚€SQLã€çµžã‚Šè¾¼ã¿æ¡ä»¶ã®ã‚ã‚‹çµåˆã‚’å«ã‚€SQLã«ã¤ã„ã¦å®Ÿä¾‹ã‚’基ã«æœ€é©ãªçµåˆæ–¹æ³•ã‚’説明ã—ã¾ã—ãŸã€‚ 今回ã¯ã€Oracleã®æ©Ÿèƒ½ã§ã‚る「マテリアライズド・ビューã€ã€ŒBITMAP JOIN INDEXã€ã€Œã‚¯ãƒ©ã‚¹ã‚¿ã€ã‚’利用ã—ãŸçµåˆå‡¦ç†ã«é–¢ã™ã‚‹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ»ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ マテリアライズド・ビューをç†è§£ã™ã‚‹ çµåˆå‡¦ç†ãª
マテリアライズドビュー - Wikipedia
データベース管ç†ã‚·ã‚¹ãƒ†ãƒ ã¯é–¢ä¿‚モデルã«å¾“ã†ãŸã‚ã€ãƒ“ュー ã¯ä»®æƒ³çš„㪠テーブル ã§ã‚ã‚Šã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾ã™ã‚‹ã‚¯ã‚¨ãƒªã®çµæžœã‚’表ã™ã€‚ビューをå‚ç…§ã¾ãŸã¯æ›´æ–°ã™ã‚‹ã¨ã€ãã®å‡¦ç†ã¯ãƒ“ューã®å¯¾è±¡ã¨ãªã£ãŸå®Ÿéš›ã®ãƒ†ãƒ¼ãƒ–ルã¸ã®å‚ç…§ã¾ãŸã¯æ›´æ–°ã¸å¤‰æ›ã•ã‚Œã€å®Ÿè¡Œã•ã‚Œã‚‹ã€‚ マテリアライズドビュー (Materialized View; 体ç¾ãƒ“ューã¨ã‚‚ã„ã†)ã¯ã“ã‚Œã¨ã¯ç•°ãªã‚‹ã‚¢ãƒ—ãƒãƒ¼ãƒã‚’å–ã‚Šã€ã‚¯ã‚¨ãƒªã®çµæžœã‚’実際ã®ãƒ†ãƒ¼ãƒ–ルã«ã‚ャッシュã™ã‚‹ã€‚ã‚ャッシュã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã¯å…ƒã®ãƒ†ãƒ¼ãƒ–ルãŒå¤‰æ›´ã•ã‚Œã‚‹ãŸã³ã«æ›´æ–°ã•ã‚Œã‚‹ã€‚ãã®ãŸã‚ã€æœ€æ–°ã§ãªã„状態をå–å¾—ã™ã‚‹å¯èƒ½æ€§ã¯ã‚ã‚‹ãŒã€åŠ¹çŽ‡çš„ãªã‚¢ã‚¯ã‚»ã‚¹ãŒå¯èƒ½ã«ãªã‚‹ã€‚特ã«ãƒ‡ãƒ¼ã‚¿ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹ã§ã¯å®Ÿéš›ã®ãƒ†ãƒ¼ãƒ–ルã«å¯¾ã—ã¦é »ç¹ã«ã‚¯ã‚¨ãƒªã‚’実行ã™ã‚‹ã“ã¨ã¯éžå¸¸ã«ã‚³ã‚¹ãƒˆãŒé«˜ã„ãŸã‚ã€ãƒžãƒ†ãƒªã‚¢ãƒ©ã‚¤ã‚ºãƒ‰ãƒ“ューãŒæœ‰åŠ¹ã§ã‚る。 ã•ã‚‰ã«ã€ãƒžãƒ†ãƒªã‚¢ãƒ©ã‚¤ã‚ºãƒ‰ãƒ“ューã¯å®Ÿéš›ã®ãƒ†ãƒ¼ãƒ–ルã¨ã—ã¦å®Ÿä½“化ã•ã‚Œã‚‹ãŸã‚ã€å®Ÿéš›ã®ãƒ†ãƒ¼ãƒ–ルã«å¯¾ã—ã¦é©ç”¨å¯èƒ½ãªæ“作ã¯
メンテナンス
ãŠçŸ¥ã‚‰ã›
障害
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
Open Knowledge Labs
Pentaho Mondrian Documentation
MongoDB - Materialized View/OLAP Style Aggregation and Performance
When Data is Worthless
[Mondrian] Mondrian OLAP Server + MongoDB
GitHub - bkaempgen/olap4ld: Automatically exported from code.google.com/p/olap4ld
高度ãªãƒžãƒ†ãƒªã‚¢ãƒ©ã‚¤ã‚ºãƒ‰ãƒ»ãƒ“ュー
No Size Fits All – Running the Star Schema Benchmark with SPARQL and RDF Aggregate Views
Institut AIFB - Inproceedings3203
Providing OLAP (On-line Analytical Processing) to User-analysts
{{#tags}}- {{label}}
{{/tags}}