JP2016091560A - 企業のコンテンツ管理における複数のオブジェクトをレポーティングするためのシステム及び方法 - Google Patents
企業のコンテンツ管理における複数のオブジェクトをレポーティングするためのシステム及び方法 Download PDFInfo
- Publication number
- JP2016091560A JP2016091560A JP2015214617A JP2015214617A JP2016091560A JP 2016091560 A JP2016091560 A JP 2016091560A JP 2015214617 A JP2015214617 A JP 2015214617A JP 2015214617 A JP2015214617 A JP 2015214617A JP 2016091560 A JP2016091560 A JP 2016091560A
- Authority
- JP
- Japan
- Prior art keywords
- query
- report
- access
- index
- definition
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 50
- 230000004044 response Effects 0.000 claims abstract description 8
- 239000000284 extract Substances 0.000 claims abstract 2
- 238000003860 storage Methods 0.000 claims description 18
- 230000006870 function Effects 0.000 claims description 8
- 238000001914 filtration Methods 0.000 claims description 7
- 238000012805 post-processing Methods 0.000 claims description 7
- 238000004458 analytical method Methods 0.000 claims description 2
- 230000008878 coupling Effects 0.000 claims description 2
- 238000010168 coupling process Methods 0.000 claims description 2
- 238000005859 coupling reaction Methods 0.000 claims description 2
- 238000000354 decomposition reaction Methods 0.000 claims 1
- 238000005457 optimization Methods 0.000 abstract description 23
- 239000000047 product Substances 0.000 description 62
- 238000007726 management method Methods 0.000 description 49
- 238000012545 processing Methods 0.000 description 23
- 238000010586 diagram Methods 0.000 description 16
- 230000008569 process Effects 0.000 description 14
- 238000005516 engineering process Methods 0.000 description 9
- 238000004590 computer program Methods 0.000 description 5
- 238000004891 communication Methods 0.000 description 4
- 238000010561 standard procedure Methods 0.000 description 4
- 238000012360 testing method Methods 0.000 description 4
- 239000006227 byproduct Substances 0.000 description 3
- 238000009826 distribution Methods 0.000 description 3
- 239000003814 drug Substances 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 2
- 230000008859 change Effects 0.000 description 2
- HVYWMOMLDIMFJA-DPAQBDIFSA-N cholesterol Chemical compound C1C=C2C[C@@H](O)CC[C@]2(C)[C@@H]2[C@@H]1[C@@H]1CC[C@H]([C@H](C)CCCC(C)C)[C@@]1(C)CC2 HVYWMOMLDIMFJA-DPAQBDIFSA-N 0.000 description 2
- 229940079593 drug Drugs 0.000 description 2
- 238000013515 script Methods 0.000 description 2
- 238000000926 separation method Methods 0.000 description 2
- 239000008186 active pharmaceutical agent Substances 0.000 description 1
- 238000013459 approach Methods 0.000 description 1
- 238000013474 audit trail Methods 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000004422 calculation algorithm Methods 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 235000012000 cholesterol Nutrition 0.000 description 1
- 239000002131 composite material Substances 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000000977 initiatory effect Effects 0.000 description 1
- 238000005304 joining Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 239000000463 material Substances 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 230000002688 persistence Effects 0.000 description 1
- 230000002085 persistent effect Effects 0.000 description 1
- 239000000825 pharmaceutical preparation Substances 0.000 description 1
- 229940127557 pharmaceutical product Drugs 0.000 description 1
- 230000001737 promoting effect Effects 0.000 description 1
- 238000003908 quality control method Methods 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 238000012552 review Methods 0.000 description 1
- 238000000638 solvent extraction Methods 0.000 description 1
- 230000004083 survival effect Effects 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
- G06F16/24534—Query rewriting; Transformation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2457—Query processing with adaptation to user needs
- G06F16/24575—Query processing with adaptation to user needs using context
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/93—Document management systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/953—Querying, e.g. by the use of web search engines
- G06F16/9535—Search customisation based on user profiles and personalisation
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Business, Economics & Management (AREA)
- General Business, Economics & Management (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Primary object is product
public_key is product_with_document__c
report type definition is,
<downRelationships>
<downRelationship key="Product.document"
keyRef="reportTypeRef1403542951011" joinType="inner" />
</downRelationships>
</reportType>
とすることができる。
SELECT id,
(SELECT external_id__v FROM document_product__vr),
(SELECT name__v FROM document_country__vr)
FROM documents
WHERE name__v =‘Test’ 例(1)
SELECT id,
(SELECT external_id__v FROMdocument_product__vr WHERE name__v=
‘CLCP01’ LIMIT 100),
(SELECT name__v FROM document_country__vr)
FROM documents FIND "search term"
WHERE name__v =‘Test’ 例(2)
とすることができる。
SELECT id, name__v,
(SELECT id, name__v, major_version_number__v,
minor_version_number__v
FROM document_product__vr)
FROM product__v
WHERE id IN (SELECT product__v FROM document_product__vr)
例(3)
とすることができる。
Main Query: PRIMARY|358fac27-2248-4bb3-9df0-635a4b6b1d1d|SELECT
id FROM product__v LIMIT 1000 OFFSET 0
Sub Query: CHILD|488e0503-f579-45d3-8009-5adc5a1a345e|SELECT
product__v, id FROM documents LIMIT 250 OFFSET 0
Join: 358fac27-2248-4bb3-9df0-635a4b6b1d1d|488e0503-f579-45d3-
8009-5adc5a1a345e|id|product__v|leftOuterJoin
Sub Query: CHILD|21e79b35-542b-420e-a012-d0b042d3334a|SELECT
product__v, id FROM documents LIMIT 250 OFFSET 0
Join: 358fac27-2248-4bb3-9df0-635a4b6b1d1d|21e79b35-542b-420e-
a012-d0b042d3334a|id|product__v|innerJoin
とすることができる。
Driver, ID=358fac27-2248-4bb3-9df0-635a4b6b1d1d
Cost=4
Solr=SELECT id FROM product__v ORDER BY id asc LIMIT 1000 OFFSET 0
Joins:
(0) ID=21e79b35-542b-420e-a012-d0b042d3334a
Type=innerJoin (parent_0), CHILD Cost=10
Solr=SELECT product__v, id FROM documents LIMIT 250 OFFSET 0
(1) ID=488e0503-f579-45d3-8009-5adc5a1a345e
Type=leftOuterJoin, CHILD Cost=10
Solr=SELECT product__v, id FROM documents ORDER BY product__v asc
LIMIT 250 OFFSET 0
“WHERE product__v != null”
とすることができる。
“WHERE product__v = ‘CC’”
Execute Primary Table SQL : CREATE TEMPORARY TABLE
d358fac2722484bb39df0635a4b6b1d1d (row_num BIGINT UNSIGNED NOT NULL
AUTO_INCREMENT, id CHAR(20), PRIMARY KEY(row_num))
INSERT INTO PRIMARY : INSERT INTO d358fac2722484bb39df0635a4b6b1d1d(id)
VALUES (?)
Execute JOIN Table SQL : CREATE TEMPORARY TABLE
c488e0503f57945d380095adc5a1a345e (row_num BIGINT UNSIGNED NOT NULL
AUTO_INCREMENT, fk CHAR(20), id CHAR(20), PRIMARY KEY(row_num))
INSERT INTO JOIN TABLE : INSERT INTO
c488e0503f57945d380095adc5a1a345e(fk,id) VALUES (?,?)
Execute JOIN Table SQL : CREATE TEMPORARY TABLE
c21e79b35542b420ea012d0b042d3334a (row_num BIGINT UNSIGNED NOT NULL
AUTO_INCREMENT, fk CHAR(20), id CHAR(20), PRIMARY KEY(row_num))
INSERT INTO JOIN TABLE : INSERT INTO
c21e79b35542b420ea012d0b042d3334a(fk,id) VALUES (?,?)
Execute Primary Table SQL : CREATE TEMPORARY TABLE
j8fb43757c91f41038b4bac735cabc4f4 (row_num BIGINT UNSIGNED NOT NULL
AUTO_INCREMENT, id CHAR(20), PRIMARY KEY(row_num))
PERFORM JOIN : INSERT INTO j8fb43757c91f41038b4bac735cabc4f4(id)
SELECT d358fac2722484bb39df0635a4b6b1d1d.id FROM
d358fac2722484bb39df0635a4b6b1d1d,c488e0503f57945d380095adc5a1a345e
WHERE c488e0503f57945d380095adc5a1a345e.fk =
d358fac2722484bb39df0635a4b6b1d1d.id ORDER BY
d358fac2722484bb39df0635a4b6b1d1d.row_num
CREATE CHILD INDEX TABLE : SELECT DISTINCT
LPAD(IFNULL(j8fb43757c91f41038b4bac735cabc4f4.id,0),20,' ') INTO
OUTFILE '/data2/reports/instance_2/358fac27-2248-4bb3-9df0-
635a4b6b1d1d/358fac27-2248-4bb3-9df0-635a4b6b1d1d.idx' FIELDS
TERMINATED BY ',' LINES TERMINATED BY '\n' FROM
j8fb43757c91f41038b4bac735cabc4f4 ORDER BY row_num
CREATE FILE INDEX: SELECT j8fb43757c91f41038b4bac735cabc4f4.id,
LPAD(IFNULL(min(t.min),0),9,'0'), LPAD(IFNULL(max(t.max),0),9,'0') INTO
OUTFILE '/data2/reports/instance_2/358fac27-2248-4bb3-9df0-
635a4b6b1d1d/358fac27-2248-4bb3-9df0-635a4b6b1d1d.idx' FIELDS
TERMINATED BY ',' LINES TERMINATED BY '\n' FROM
j8fb43757c91f41038b4bac735cabc4f4 LEFT OUTER JOIN (SELECT fk AS col,
min(row_num) AS min, max(row_num) AS max FROM
c21e79b35542b420ea012d0b042d3334a GROUP BY col) AS t ON
j8fb43757c91f41038b4bac735cabc4f4.id = t.col GROUP BY 1 ORDER BY
j8fb43757c91f41038b4bac735cabc4f4.row_num
結果インデックスファイル
{
"responseStatus":"SUCCESS",
"responseDetails":{
"find":"search term",
"limit":500,
"offset":500,
"size":500,
"totalFound":2000,
"previous_page":"/api/v9.0/query/00Q12334586932?limit=500&offset=0",
"next_page":"/api/v9.0/query/00Q12334586932?limit=500&offset=1000"
},
"data":[
{
"id":1,
"document_product__vr":{
"responseDetails":{
"limit":250,
"offset":0,
"size":250,
"totalFound":500,
"next_page":"/api/v9.0/query/00Q448829222?limit=250&offset=250"
},
"data":[
{
"external_id__v":"EXTID123"
}
]
},
"document_country__vr":{
"responseDetails":{
"limit":250,
"offset":250,
"size":250,
"totalFound":1000,
previous_page":"/api/v9.0/query/00Q24845839872?limit=250&offset=0",
"next_page":"/api/v9.0/query/00Q24845839872?limit=250&offset=500"
},
"data":[
{
"name__v":"Austria"
},
{
"name__v":"Costa Rica"
}
]
}
}
]
}
であり得る。
<?xml version="1.0" encoding="utf-16"?>
<ResultSetRestResult>
<responseStatus>SUCCESS</responseStatus>
<responseDetails>
<find>search term</find>
<limit>500</limit>
<offset>500</offset>
<size>500</size>
<totalFound>2000</totalFound>
<previous_page>/api/v9.0/query/00Q12334586932?limit=500&offset=0</previous_page>
<next_page>/api/v9.0/query/00Q12334586932?limit=500&offset=1000</next_page>
</responseDetails>
<data>
<id>1</id>
<document_product__vr>
<responseDetails>
<limit>250</limit>
<offset>0</offset>
<size>250</size>
<totalFound>500</totalFound>
<next_page>/api/v9.0/query/00Q448829222?limit=250&offset=250</next_page>
</responseDetails>
<data>
<external_id__v>EXTID123</external_id__v>
</data>
</document_product__vr>
<document_country__vr>
<responseDetails>
<limit>250</limit>
<offset>250</offset>
<size>250</size>
<totalFound>1000</totalFound>
<previous_page>/api/v9.0/query/00Q24845839872?limit=250&offs t=0</previous_page>
<next_page>/api/v9.0/query/00Q24845839872?limit=250&offset=500</next_page>
</responseDetails>
<data>
<name__v>Austria</name__v>
</data>
<data>
<name__v>Costa Rica</name__v>
</data>
</document_country__vr>
</data>
</ResultSetRestResult>
であり得る。
Claims (20)
- コンテンツ管理システムにおいて複数のオブジェクトをレポーティングするためにコンピュータで実装される方法であって:
複数のオブジェクトを記憶デバイスに格納するステップと;
第1のオブジェクト、第2のオブジェクト及び前記第1のオブジェクトと前記第2のオブジェクトとの間の関係を定義するレポートタイプの定義を受け取るステップと;
前記レポートタイプの定義についてマルチオブジェクト・クエリ言語ステートメントを生成するステップと;
前記マルチオブジェクト・クエリ言語ステートメントを、第1のクエリと第2のクエリに分解するステップであって、前記第1のクエリが前記第1のオブジェクトに対応し、前記第2のクエリが前記第2のオブジェクトに対応する、ステップと;
前記第1のクエリ及び前記第2のクエリについて索引付きアクセスのクエリ定義を生成するステップと;
前記索引付きアクセスのクエリ定義内の前記第1のクエリに対応する前記第1のオブジェクトのIDと、前記索引付きアクセスのクエリ定義内の前記第2のクエリに対応する前記第2のオブジェクトのIDを、Luceneベースの検索エンジンから抽出するステップと;
前記第1のオブジェクトの抽出されたIDと、前記第2のオブジェクトの抽出されたIDを結合するステップと;
を含む、方法。 - 結合結果について、インデックスを生成するステップ
を更に含む、請求項1に記載の方法。 - 前記インデックスは、固定の2進表現である、
請求項2に記載の方法。 - 前記インデックスについて、対応するデータファイルを生成するステップ
を更に含む、請求項3に記載の方法。 - 前記インデックスに従って、前記Luceneベースの検索エンジンにおいてオブジェクトに対するインデックスアクセスを実行するステップ
を更に含む、請求項2に記載の方法。 - Solrクエリを実行して、応答を返すステップ
を更に含む、請求項5に記載の方法。 - 前記インデックスアクセスは、サイズベースである、
請求項5に記載の方法。 - 前記インデックスアクセスの応答を事後処理して、表示するためのレポートを生成するステップ
を更に含み、前記レポートは、前記第1のオブジェクト及び前記第2のオブジェクトを備える、
請求項1に記載の方法。 - 前記第1のオブジェクトで前記レポート内のデータをグループ化することを可能にするステップ
を更に含む、請求項8に記載の方法。 - 前記レポート内でデータを集計することを可能にするステップ
を更に含む、請求項8に記載の方法。 - 前記第1のオブジェクトの抽出されたIDと、前記第2のオブジェクトの抽出されたIDをMySQLへ存続させるステップ
を更に含む、請求項1に記載の方法。 - 前記インデックスアクセスの方式は、仮想記憶アクセス方式(VSAM)である、
請求項1に記載の方法。 - 前記の分解は、ANTLRベースの解析を介する、
請求項1に記載の方法。 - ハッシュ関数を使用して前記の結合を実装する、
請求項1に記載の方法。 - 前記の結合は、内部結合及び外部結合を含む、
請求項14に記載の方法。 - 前記の結合は、前記第1のオブジェクトと前記第2のオブジェクトとの間の外部キーの関係に基づく、
請求項1に記載の方法。 - 前記索引付きアクセスのクエリ定義に関与する前記第1のオブジェクト及び前記第2のオブジェクトのコストを計算するステップ
を更に含む、請求項1に記載の方法。 - 前記索引付きアクセスのクエリ定義が、前記第1のオブジェクトの更なるフィルタリングを必要とすることを決定するステップ
を更に含む、請求項17に記載の方法。 - 結果のサイズを限定するよう前記第1のクエリを書き直すステップ
を更に含む、請求項17に記載の方法。 - コンテンツ管理システムであって、
複数のオブジェクトを格納する記憶デバイスと;
第1のオブジェクト、第2のオブジェクト及び前記第1のオブジェクトと前記第2のオブジェクトとの間の関係を定義するレポートタイプの定義を受け取り、該レポートタイプの定義についてのマルチオブジェクト・クエリ言語ステートメントを生成する、レポート実行エンジンと;
前記マルチオブジェクト・クエリ言語ステートメントを、前記第1のオブジェクトと前記第2のオブジェクトにそれぞれ対応する第1のクエリと第2のクエリに分解し、前記第1のクエリ及び前記第2のクエリについての索引付きアクセスのクエリ定義を生成し、Luceneベースの検索エンジンにおいて、インデックスに従ってオブジェクトについてのインデックスアクセスを実行する、クエリ言語実行エンジンと;
前記索引付きアクセスのクエリ定義内の前記第1のクエリに対応する前記第1のオブジェクトのIDと、前記索引付きアクセスのクエリ定義内の前記第2のクエリに対応する前記第2のオブジェクトのIDを、前記Luceneベースの検索エンジンから抽出し、前記第1のオブジェクトの抽出されたIDと、前記第2のオブジェクトの抽出されたIDを結合する、索引付きアクセス実行エンジンと;
を備える、システム。
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US14/530,694 | 2014-11-01 | ||
US14/530,694 US9208200B1 (en) | 2014-11-01 | 2014-11-01 | System and method for reporting multiple objects in enterprise content management |
Publications (2)
Publication Number | Publication Date |
---|---|
JP2016091560A true JP2016091560A (ja) | 2016-05-23 |
JP5944039B2 JP5944039B2 (ja) | 2016-07-05 |
Family
ID=54360083
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
JP2015214617A Active JP5944039B2 (ja) | 2014-11-01 | 2015-10-30 | 企業のコンテンツ管理における複数のオブジェクトをレポーティングするためのシステム及び方法 |
Country Status (4)
Country | Link |
---|---|
US (2) | US9208200B1 (ja) |
EP (1) | EP3018595A1 (ja) |
JP (1) | JP5944039B2 (ja) |
CN (1) | CN105574070A (ja) |
Families Citing this family (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US11249968B2 (en) * | 2016-05-09 | 2022-02-15 | Sap Se | Large object containers with size criteria for storing mid-sized large objects |
US10664463B2 (en) * | 2016-12-30 | 2020-05-26 | Dropbox, Inc. | Event context enrichment |
JP7146921B2 (ja) * | 2017-12-19 | 2022-10-04 | ヴィーヴァ システムズ インコーポレイテッド | 電子通信を制御するためのシステム及び方法 |
US11720236B1 (en) * | 2019-01-29 | 2023-08-08 | Veeva Systems Inc. | Displaying reports in a content management system |
US11853359B1 (en) * | 2019-01-31 | 2023-12-26 | Veeva Systems Inc. | System and method for reporting multiple objects in enterprise content management |
CN111625539A (zh) * | 2020-04-28 | 2020-09-04 | 四川省金科成地理信息技术有限公司 | 一种应用于信息资源共享平台的索引创建及数据检索方法 |
US12061823B2 (en) | 2021-03-09 | 2024-08-13 | Esko Software Bv | System and method for exchanging and preflighting documents for printing and publishing |
USD1003317S1 (en) | 2021-03-09 | 2023-10-31 | Esko Software Bv | Display screen or portion thereof with graphical user interface |
US20230395208A1 (en) * | 2022-06-06 | 2023-12-07 | Commure, Inc. | Federated data platform integrating multiple healthcare data sources including fhir and non-fhir sources |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH06348562A (ja) * | 1993-06-08 | 1994-12-22 | Hitachi Ltd | データベース制御情報管理システム |
JP2004246897A (ja) * | 2003-02-12 | 2004-09-02 | Microsoft Corp | 宣言順レポートパラメータ化 |
JP2009157678A (ja) * | 2007-12-27 | 2009-07-16 | Canon Marketing Japan Inc | データベース検索装置、データベース検索システム、データベース検索方法、プログラム、記録媒体 |
JP2012185740A (ja) * | 2011-03-07 | 2012-09-27 | Ricoh Co Ltd | レポート作成装置、レポート作成システム、レポート作成方法、レポート作成プログラム及び記憶媒体 |
Family Cites Families (31)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6160549A (en) * | 1994-07-29 | 2000-12-12 | Oracle Corporation | Method and apparatus for generating reports using declarative tools |
AU1939099A (en) * | 1997-12-22 | 1999-07-12 | Roderic G. G. Cattell | Methods and apparatus for efficiently splitting query execution across client and server in an object-relational mapping |
US6748374B1 (en) * | 1998-12-07 | 2004-06-08 | Oracle International Corporation | Method for generating a relational database query statement using one or more templates corresponding to search conditions in an expression tree |
US6965891B1 (en) * | 2001-02-27 | 2005-11-15 | Oracle International Corporation | Method and mechanism for partition pruning |
US6931390B1 (en) * | 2001-02-27 | 2005-08-16 | Oracle International Corporation | Method and mechanism for database partitioning |
US7213013B1 (en) * | 2001-06-18 | 2007-05-01 | Siebel Systems, Inc. | Method, apparatus, and system for remote client search indexing |
US7546287B2 (en) * | 2001-06-18 | 2009-06-09 | Siebel Systems, Inc. | System and method to search a database for records matching user-selected search criteria and to maintain persistency of the matched records |
US7293014B2 (en) * | 2001-06-18 | 2007-11-06 | Siebel Systems, Inc. | System and method to enable searching across multiple databases and files using a single search |
US6910032B2 (en) * | 2002-06-07 | 2005-06-21 | International Business Machines Corporation | Parallel database query processing for non-uniform data sources via buffered access |
US20050010430A1 (en) * | 2003-05-13 | 2005-01-13 | Holger Gockel | Systems, methods, and software applications for modeling the structure of enterprises |
US8260764B1 (en) * | 2004-03-05 | 2012-09-04 | Open Text S.A. | System and method to search and generate reports from semi-structured data |
US20050273705A1 (en) * | 2004-06-08 | 2005-12-08 | Fortellio, Llc | Method and system for automatically creating network software applications |
US20060031206A1 (en) * | 2004-08-06 | 2006-02-09 | Christian Deubel | Searching for data objects |
US7689580B2 (en) * | 2006-03-27 | 2010-03-30 | Oracle International Corporation | Search based application development framework |
US7747562B2 (en) * | 2006-08-15 | 2010-06-29 | International Business Machines Corporation | Virtual multidimensional datasets for enterprise software systems |
US7895150B2 (en) * | 2006-09-07 | 2011-02-22 | International Business Machines Corporation | Enterprise planning and performance management system providing double dispatch retrieval of multidimensional data |
US7899837B2 (en) * | 2006-09-29 | 2011-03-01 | Business Objects Software Ltd. | Apparatus and method for generating queries and reports |
US7953727B2 (en) * | 2008-04-04 | 2011-05-31 | International Business Machines Corporation | Handling requests for data stored in database tables |
KR101380783B1 (ko) * | 2008-08-22 | 2014-04-02 | 정태우 | 영상에 포함된 객체를 식별하여 부가 서비스를 제공하는 시스템 |
US20100153432A1 (en) * | 2008-12-11 | 2010-06-17 | Sap Ag | Object based modeling for software application query generation |
US10162851B2 (en) * | 2010-04-19 | 2018-12-25 | Salesforce.Com, Inc. | Methods and systems for performing cross store joins in a multi-tenant store |
WO2011130706A2 (en) * | 2010-04-16 | 2011-10-20 | Salesforce.Com, Inc. | Methods and systems for performing cross store joins in a multi-tenant store |
US8666970B2 (en) * | 2011-01-20 | 2014-03-04 | Accenture Global Services Limited | Query plan enhancement |
CN104160394B (zh) * | 2011-12-23 | 2017-08-15 | 亚马逊科技公司 | 用于半结构化数据的可缩放分析平台 |
US9285960B2 (en) * | 2011-12-30 | 2016-03-15 | International Business Machines Corporation | Business intelligence dashboard assembly tool with indications of relationships among content elements |
US8957908B2 (en) * | 2012-07-16 | 2015-02-17 | International Business Machines Corporation | Rapid representational thumbnail images for business intelligence dashboards |
US9240061B2 (en) * | 2012-10-02 | 2016-01-19 | International Business Machines Corporation | Pattern representation images for business intelligence dashboard objects |
US9298814B2 (en) * | 2013-03-15 | 2016-03-29 | Maritz Holdings Inc. | Systems and methods for classifying electronic documents |
JP6416194B2 (ja) * | 2013-03-15 | 2018-10-31 | アマゾン・テクノロジーズ・インコーポレーテッド | 半構造データのためのスケーラブルな分析プラットフォーム |
US20140278813A1 (en) * | 2013-03-15 | 2014-09-18 | International Business Machines Corporation | Recommendation engine |
US11586600B2 (en) * | 2013-11-05 | 2023-02-21 | Varonis Systems, Inc | In-advance indexing |
-
2014
- 2014-11-01 US US14/530,694 patent/US9208200B1/en active Active
-
2015
- 2015-10-22 EP EP15191084.1A patent/EP3018595A1/en not_active Ceased
- 2015-10-30 JP JP2015214617A patent/JP5944039B2/ja active Active
- 2015-10-30 US US14/929,010 patent/US9619533B2/en active Active
- 2015-11-02 CN CN201510732523.XA patent/CN105574070A/zh active Pending
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH06348562A (ja) * | 1993-06-08 | 1994-12-22 | Hitachi Ltd | データベース制御情報管理システム |
JP2004246897A (ja) * | 2003-02-12 | 2004-09-02 | Microsoft Corp | 宣言順レポートパラメータ化 |
JP2009157678A (ja) * | 2007-12-27 | 2009-07-16 | Canon Marketing Japan Inc | データベース検索装置、データベース検索システム、データベース検索方法、プログラム、記録媒体 |
JP2012185740A (ja) * | 2011-03-07 | 2012-09-27 | Ricoh Co Ltd | レポート作成装置、レポート作成システム、レポート作成方法、レポート作成プログラム及び記憶媒体 |
Also Published As
Publication number | Publication date |
---|---|
CN105574070A (zh) | 2016-05-11 |
EP3018595A1 (en) | 2016-05-11 |
JP5944039B2 (ja) | 2016-07-05 |
US9619533B2 (en) | 2017-04-11 |
US20160125049A1 (en) | 2016-05-05 |
US9208200B1 (en) | 2015-12-08 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
JP5944039B2 (ja) | 企業のコンテンツ管理における複数のオブジェクトをレポーティングするためのシステム及び方法 | |
US11907247B2 (en) | Metadata hub for metadata models of database objects | |
Mate et al. | Ontology-based data integration between clinical and research systems | |
US8943059B2 (en) | Systems and methods for merging source records in accordance with survivorship rules | |
Lomotey et al. | Towards knowledge discovery in big data | |
Rashid et al. | The semantic data dictionary–an approach for describing and annotating data | |
CN111971666A (zh) | 优化sql查询计划的维度上下文传播技术 | |
US20130318095A1 (en) | Distributed computing environment for data capture, search and analytics | |
US10585981B2 (en) | Method of data capture, storage and retrieval through user created form templates and data item templates by executing computer-executable instructions stored on a non-transitory computer-readable medium | |
Kaur et al. | Scholarometer: A social framework for analyzing impact across disciplines | |
GB2507095A (en) | Generating synthetic data from a decision tree model of a dataset | |
Uddin et al. | Automatic api usage scenario documentation from technical q&a sites | |
Challawala et al. | MySQL 8 for Big Data: Effective Data Processing with MySQL 8, Hadoop, NoSQL APIs, and Other Big Data Tools | |
Deshpande et al. | Metadata-driven ad hoc query of patient data: meeting the needs of clinical studies | |
Owens et al. | occCite: Tools for querying and managing large biodiversity occurrence datasets | |
Jun et al. | Semantics-preserving optimisation of mapping multi-column key constraints for RDB to RDF transformation | |
Lee et al. | Hands-On Big Data Modeling: Effective database design techniques for data architects and business intelligence professionals | |
Khashan et al. | An adaptive spark-based framework for querying large-scale NoSQL and relational databases | |
US20160179476A1 (en) | Method Of Operating A Software Engine For Storing, Organizing And Reporting Data In An Organizational Environment Through User Created Templates And Data Items By Executing Computer-Executable Instructions Stored On A Non-Transitory Computer-Readable Medium | |
US11853359B1 (en) | System and method for reporting multiple objects in enterprise content management | |
Enaya | An Experimental Performance Comparison of NoSQL and RDBMS Data Storage Systems in the ERP System Odoo | |
Cejovic et al. | Using semantic web technologies to enable cancer genomics discovery at petabyte scale | |
Meadows et al. | Pentaho Data Integration Cookbook | |
Mou et al. | Visual orchestration and autonomous execution of distributed and heterogeneous computational biology pipelines | |
Szekely et al. | T2WML: table to wikidata mapping language |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
TRDD | Decision of grant or rejection written | ||
A01 | Written decision to grant a patent or to grant a registration (utility model) |
Free format text: JAPANESE INTERMEDIATE CODE: A01 Effective date: 20160426 |
|
A61 | First payment of annual fees (during grant procedure) |
Free format text: JAPANESE INTERMEDIATE CODE: A61 Effective date: 20160524 |
|
R150 | Certificate of patent or registration of utility model |
Ref document number: 5944039 Country of ref document: JP Free format text: JAPANESE INTERMEDIATE CODE: R150 |
|
R250 | Receipt of annual fees |
Free format text: JAPANESE INTERMEDIATE CODE: R250 |
|
R250 | Receipt of annual fees |
Free format text: JAPANESE INTERMEDIATE CODE: R250 |
|
R250 | Receipt of annual fees |
Free format text: JAPANESE INTERMEDIATE CODE: R250 |
|
R250 | Receipt of annual fees |
Free format text: JAPANESE INTERMEDIATE CODE: R250 |
|
R250 | Receipt of annual fees |
Free format text: JAPANESE INTERMEDIATE CODE: R250 |
|
R250 | Receipt of annual fees |
Free format text: JAPANESE INTERMEDIATE CODE: R250 |