3 Super SQL Super SQL SQLSELECTGENERATE SQL SELECT

  • Slides: 26
Download presentation

3 Super. SQLとは ¡Super. SQLクエリの記述 ¡SQLのSELECT句をGENERATE句で置き換え SQL SELECT <ターゲットリスト> Super. SQL GENERATE <media> <TFE>

3 Super. SQLとは ¡Super. SQLクエリの記述 ¡SQLのSELECT句をGENERATE句で置き換え SQL SELECT <ターゲットリスト> Super. SQL GENERATE <media> <TFE>

4 Super. SQLとは nデータベース検索、構造化、メディア変換を統合 Super. SQL floor f_manager … name salary 1 F Smith

4 Super. SQLとは nデータベース検索、構造化、メディア変換を統合 Super. SQL floor f_manager … name salary 1 F Smith … Smith 8000 1 F Smith … Johnson 5000 1 F Smith … Williams 4000 … … … 2 F Rodriguez … Rodriguez 7000 2 F Rodriguez … Wilson 300 HTML+ CSS

5 Super. SQLとは nデータベース検索、構造化、メディア変換を統合 Super. SQLクエリ： GENERATE HTML [ {(asc 1)e. floor, e. category@{width=201}}@{bgcolor=lightgreen}!

5 Super. SQLとは nデータベース検索、構造化、メディア変換を統合 Super. SQLクエリ： GENERATE HTML [ {(asc 1)e. floor, e. category@{width=201}}@{bgcolor=lightgreen}! {"floor_manager", e. f_manager@{width=107}}! [ {"division", e. division@{width=50}, e. dept @{width=105}}@{bgcolor=lightgreen}! {"manager"@{width=80}, e. d_manager@{width=142}}! [e. name@{width=138}, (desc 1)e. salary@{width=82}]! ]! ], FROM EMPLOYEE e;

6 Super. SQLとは nデータベース検索、構造化、メディア変換を統合 Super. SQLクエリ： GENERATE HTML [ ! {(asc 1)e. floor e.

6 Super. SQLとは nデータベース検索、構造化、メディア変換を統合 Super. SQLクエリ： GENERATE HTML [ ! {(asc 1)e. floor e. category@{width=201}}@{bgcolor=lightgreen}! {"floor_manager", e. f_manager@{width=107}}! [ {"division", e. division@{width=50}, e. dept @{width=105}}@{bgcolor=lightgreen}! {"manager"@{width=80}, e. d_manager@{width=142}}! [e. name@{width=138}, (desc 1)e. salary@{width=82}]! ]! ], FROM EMPLOYEE e;

7 Super. SQLとは nデータベース検索、構造化、メディア変換を統合 Super. SQLクエリ： GENERATE HTML [ {(asc 1)e. floor, e. category@{width=201}}@{bgcolor=lightgreen}!

7 Super. SQLとは nデータベース検索、構造化、メディア変換を統合 Super. SQLクエリ： GENERATE HTML [ {(asc 1)e. floor, e. category@{width=201}}@{bgcolor=lightgreen}! {"floor_manager", e. f_manager@{width=107}}! [ {"division", e. division@{width=50}, e. dept @{width=105}}@{bgcolor=lightgreen}! {"manager"@{width=80}, e. d_manager@{width=142}}! [e. name@{width=138}, (desc 1)e. salary@{width=82}]! ]! ], FROM EMPLOYEE e;

1 9 ✔クエリ自動修正機構 サジェッション ユーザの記述したクエリ： GENERATE HTML [(asc)e. name, e. salary@{bgcolor=red}, e. dept], 3!

1 9 ✔クエリ自動修正機構 サジェッション ユーザの記述したクエリ： GENERATE HTML [(asc)e. name, e. salary@{bgcolor=red}, e. dept], 3! [e. name, e. d_manager@{width=100}]! FROM employee e; 42% ・横方向 50% ・縦方向 8% ・深度方向 [(asc)e. name, e. salary@{bgcolor=red}, e. dept], 3!% [e. name, e. d_manager@{width=100}]! [(asc)e. name, e. salary@{bgcolor=red}, e. dept], 3! [e. name, e. d_manager@{width=100}]! , [(asc)e. name, e. salary@{bgcolor=red}, e. dept], 3!! [e. name, e. d_manager@{width=100}]!

2 3 DEMO

2 3 DEMO

2 6 まとめと今後の予定 ¡論文の執筆 ¡ 2017 6 th International Conference on Educational and Information

2 6 まとめと今後の予定 ¡論文の執筆 ¡ 2017 6 th International Conference on Educational and Information Technology (ICEIT 2017) -3/7~10 Clare College, Cambridge, UK ¡修論

3 Super SQL n Super SQL n SQLSELECTGENERATE3 Super SQL n Super SQL n SQLSELECTGENERATE
EVENT SELECT WSAEvent Select WSAEvent Select WSAEvent SelectEVENT SELECT WSAEvent Select WSAEvent Select WSAEvent Select
SQL SQL SELECT SQL INSERT SQL UPDATE SQLSQL SQL SELECT SQL INSERT SQL UPDATE SQL
Open SQL SELECT SELECT INTO SELECT field 1Open SQL SELECT SELECT INTO SELECT field 1
05 Chapter SQL SELECT SELECT BNF SELECT statement05 Chapter SQL SELECT SELECT BNF SELECT statement
Super SQL Super SQL 4 PHP SQL HTMLSuper SQL Super SQL 4 PHP SQL HTML
SUPER CLEAN SUPER WAX Super Clean and SuperSUPER CLEAN SUPER WAX Super Clean and Super
SQL SELECT Basic form of the SQL SELECTSQL SELECT Basic form of the SQL SELECT
The SQL Select Statement The SQL Select StatementThe SQL Select Statement The SQL Select Statement
SQL SELECT Statement Syntax The SQL SELECT statementSQL SELECT Statement Syntax The SQL SELECT statement
SQL Super SQL SELECT target list FROM WHERESQL Super SQL SELECT target list FROM WHERE
Advanced Select Statements Select List Variations SELECT ColumnAdvanced Select Statements Select List Variations SELECT Column
Advanced Select Statements Select List Variations SELECT ColumnAdvanced Select Statements Select List Variations SELECT Column
SELECT Query SELECT FROM SELECT DISTINCTALL columnexpression tableSELECT Query SELECT FROM SELECT DISTINCTALL columnexpression table
SELECT ROWNUM B FROM SELECT A FROM SELECTSELECT ROWNUM B FROM SELECT A FROM SELECT
Select Case if Select Case Select Case ScoreSelect Case if Select Case Select Case Score
Now continue ADVANCED SELECT FROM Select SELECT selectlistNow continue ADVANCED SELECT FROM Select SELECT selectlist
Initial Login Screen Select Carrier Select Tractor SelectInitial Login Screen Select Carrier Select Tractor Select
Select 4 n select int select int nfdsSelect 4 n select int select int nfds
Select Post Select Post Select Post lifestyle dataSelect Post Select Post Select Post lifestyle data
l SELECT SELECT FROM ORDER BY SELECT FROMl SELECT SELECT FROM ORDER BY SELECT FROM
l SELECT SELECT FROM ORDER BY SELECT FROMl SELECT SELECT FROM ORDER BY SELECT FROM
SELECT 1 SELECT v SELECT DISTINCT column AliasSELECT 1 SELECT v SELECT DISTINCT column Alias
SELECT 1 SELECT Northwind Customers SELECT FROM CustomersSELECT 1 SELECT Northwind Customers SELECT FROM Customers