- I particularly agree with the desire to provide a broad-ranging strategy that concerns not only technological innovation but also administrative, organisational and social innovation.
- Jag är framför allt positiv till tillhandahållandet av en omfattande strategi som inte bara rör teknisk innovation utan även administrativ, organisatorisk och social innovation.
- The EU must therefore continue to work in the spirit of the Kyoto Protocol, which has led us to bank on technological innovation.
- Det har fått oss att räkna med teknisk innovation.
- I particularly agree with the desire to provide a broad-ranging strategy that concerns not only technological innovation but also administrative, organisational and social innovation.
- Jag instämmer framför allt i önskan att erbjuda en bred strategi som omfattar inte bara teknisk innovation, utan även administrativ, organisatorisk och social innovation.
- They want to participate more and more in technological innovations;
- De vill i allt högre grad delta i tekniska innovationer, de har upptäckt de möjligheter det ger att organisera sig och bilda föreningar där de bor, där de arbetar eller i sina regioner.
- This was why the technology rating institute was set up in the Netherlands in 1995 to try to make it easier to fund promising technological innovations in SMEs.
- Därför upprättades i Nederländerna stiftelsen technology rating som sedan 1995 försöker underlätta finansieringen av lovande tekniska innovationer i små och medelstora företag.
- • for a stronger basis of support for technological innovation and for transferring technology to European companies.
- för att göra programmet mer tillgängligt, för att öka attraktionskraften hos ett europeiskt område för forskningsverksamhet, för att öka tonvikten på högsta möjliga kvalitet, för att förbättra grundförutsättningarna för teknisk innovation och överföra teknik till europeiska företag.
show query
SET search_path TO f9miniensv;
WITH
list AS (SELECT
t11.token_id AS t11,
t12.token_id AS t12,
t21.token_id AS t21,
t22.token_id AS t22,
r1.dep_id AS dep1,
r2.dep_id AS dep2
FROM
deprel r1
JOIN depstr s1 ON s1.dep_id = r1.dep_id
JOIN word_align a1 ON a1.wsource = r1.head AND a1.wsource < a1.wtarget
JOIN word_align a2 ON a2.wsource = r1.dependent
JOIN deprel r2 ON r2.head = a1.wtarget AND r2.dependent = a2.wtarget
JOIN depstr s2 ON s2.dep_id = r2.dep_id
JOIN token t11 ON t11.token_id = r1.head
JOIN token t21 ON t21.token_id = r2.head
JOIN token t12 ON t12.token_id = r1.dependent
JOIN token t22 ON t22.token_id = r2.dependent
WHERE
s1.val = 'amod' AND
s2.val = 'AT' AND
t11.ctag = 'NOUN' AND
t21.ctag = 'NOUN' AND
t12.ctag = 'ADJ' AND
t22.ctag = 'ADJ' AND
t11.lemma_id = 2937 AND
t12.lemma_id = 42203 AND
t21.lemma_id = 2937 AND
t22.lemma_id = 33566),
stats AS (SELECT
sentence_id,
count(DISTINCT token_id) AS c,
count(*) AS c_aligned,
count(DISTINCT wtarget) AS c_target
FROM
token
LEFT JOIN word_align ON wsource = token_id
WHERE
sentence_id IN (
SELECT sentence_id
FROM
list
JOIN token ON token_id IN(t11, t21)
)
GROUP BY sentence_id),
numbered AS (SELECT row_number() OVER () AS i, *
FROM
list),
sentences AS (SELECT *, .2 * (1 / (1 + exp(max(c) OVER (PARTITION BY i) - min(c) OVER (PARTITION BY i)))) +
.8 * (1 / log(avg(c) OVER (PARTITION BY i))) AS w
FROM
(
SELECT i, 1 AS n, sentence_id, ARRAY[t11,t12] AS tokens
FROM
numbered
JOIN token ON token_id = t11
UNION SELECT i, 2 AS n, sentence_id, ARRAY[t21,t22] AS tokens
FROM
numbered
JOIN token ON token_id = t21
) x
JOIN stats USING (sentence_id)
ORDER BY i, n)
SELECT
i,
n,
w,
c,
c_aligned,
c_target,
sentence_id,
string_agg(CASE WHEN lpad THEN ' ' ELSE '' END || '<span class="token' ||
CASE WHEN ARRAY[token_id] <@ tokens THEN ' hl' ELSE '' END || '">' || val || '</span>',
'' ORDER BY token_id ASC) AS s
FROM
sentences
JOIN token USING (sentence_id)
JOIN typestr USING (type_id)
GROUP BY i, n, w, c, c_aligned, c_target, sentence_id
ORDER BY w DESC, i, n;
;