Python:Keyword

from dataclasses import dataclass from typing import Optional import dacite @dataclass class Keyword:

   """
   a keyword
   """
   pageTitle:str
   key:Optional[str] # The keyword
   aliases:Optional[str] # optional, comma separated aliases of the keyword
   de:Optional[str] # german wikipedia article of the keyword
   wikidataid:Optional[str] # The wikidataItem
   en:Optional[str] # english wikipedia article of the keyword
   links:Optional[str] # comma separated list of links to other keywords
   literature:Optional[str] # comma separated list of publication keys
   urls:Optional[str] # comma separated list of external links that explain the keyword
   stackoverflow_tag:Optional[str] # stackoverflow tag for this keyword

   @classmethod
   def askQuery(cls):
       """
       get the ask Query for Keyword
       
       Returns:
           str: the mediawiki markup for the ask query
       """

ask="""

pageTitle	key	aliases	de	en	wikidataid	links	literature	urls	stackoverflow_tag
Keyword/1st normal form	1st normal form	1NF	Erste Normalform	First normal form	Q1366465	functional dependency, database normalisation
Keyword/2PL	2PL	2 phase locking, two-phase locking		Two-phase locking	Q2290484	Scheduler
Keyword/2nd normal form	2nd normal form	2NF	Zweite Normalform	Second normal form	Q277396	functional dependency, database normalisation
Keyword/3rd normal form	3rd normal form	3NF	Dritte Normalform	Third normal form	Q311585	functional dependency, database normalisation			3nf
Keyword/ACA	ACA	avoids cascading abort						http://dbis-vl.wikidata.dbis.rwth-aachen.de/index.php/Keyword-dbis/ACA
Keyword/ACID	ACID		ACID	ACID	Q288435	Transaction			acid
Keyword/ALTER	ALTER	Alter			Q3490806	DDL		https://www.w3schools.com/sql/sql_ref_alter.asp
Keyword/AND	AND	And				DQL		https://www.w3schools.com/sql/sql_and_or.asp
Keyword/ANSI	ANSI		American National Standards Institute	American National Standards Institute	Q180003
Keyword/ANSI-SPARC	ANSI-SPARC		ANSI-SPARC-Architektur	ANSI-SPARC Architecture	Q1531558	Three schema approach, ANSI		https://wikis.gm.fh-koeln.de/Datenbanken/ANSI-3-Ebenenmodell
Keyword/ARIES	ARIES		ARIES (Informatik)	Algorithms for Recovery and Isolation Exploiting Semantics	Q296649
Keyword/AS	AS	As, Umbenennung						https://www.w3schools.com/sql/sql_ref_as.asp
Keyword/ASC	ASC					ORDER BY		https://www.w3schools.com/sql/sql_ref_asc.asp
Keyword/AVG	AVG							https://www.w3schools.com/sql/sql_count_avg_sum.asp
Keyword/AVL-Tree	AVL-Tree		AVL-Baum	AVL tree	Q300159				avl-tree
Keyword/All	All	ALL						https://www.w3schools.com/sql/sql_ref_all.asp
Keyword/Any	Any	ANY				All		https://www.w3schools.com/sql/sql_any_all.asp
Keyword/Apache gremlin	Apache gremlin	gremlin		Gremlin (query language)	Q5607337	graph database, OLAP, OLTP	Rodriguez2015	https://wiki.bitplan.com/index.php?title=Gremlin	gremlin
Keyword/Apache tinkerpop	Apache tinkerpop				Q20942022	gremlin, graph database
Keyword/Arithmetic Expressions	Arithmetic Expressions		Arithmetik	Arithmetic	Q11205
Keyword/Armstrong's axioms	Armstrong's axioms	Armstrong Axiome		Armstrong's axioms	Q3625629
Keyword/Atomicity	Atomicity			Atomicity (database systems)	Q3306359	ACID
Keyword/Attribute	Attribute		Attribut (Programmierung)	Attribute (computing)	Q2722260	Attribute closure
Keyword/Attribute closure	Attribute closure	Attributhülle	Funktionale Abhängigkeit	Functional dependency	Q597053	functional dependency, canonical cover, Armstrong's axioms
Keyword/B+ tree	B+ tree	B+ Baum	B+-Baum	B+ tree	Q285861	B-Tree
Keyword/B-Tree	B-Tree	B-Baum, BBaum, B Baum	B-Baum	B-tree	Q677051	search tree			b-tree
Keyword/BETWEEN	BETWEEN	Between						https://www.w3schools.com/sql/sql_ref_between.asp
Keyword/Bitmap index	Bitmap index		Bitmap-Index	Bitmap index	Q878825
Keyword/Boyce-Codd normal form	Boyce-Codd normal form	BCNF	Boyce-Codd-Normalform	Boyce–Codd normal form	Q2460153	functional dependency, database normalisation			bcnf
Keyword/C2PL	C2PL			Conservative two-phase locking	Q5163111	2PL
Keyword/CHAR	CHAR		Char (Datentyp)	Character (computing)	Q32483	datatype		https://mariadb.com/kb/en/char/
Keyword/COMMIT	COMMIT			COMMIT (SQL)	Q1115672	TCL
Keyword/COUNT	COUNT	Count, Avg, Sum						https://www.w3schools.com/sql/sql_count_avg_sum.asp
Keyword/CREATE	CREATE	CREATE TABLE, CREATE INDEX, Create, TABLE			Q6969555	DDL, Table		https://www.w3schools.com/sql/sql_ref_create_table.asp
Keyword/CROSS JOIN	CROSS JOIN	Cross Join, Kreuzprodukt						https://www.w3schools.com/mysql/mysql_join_cross.asp
Keyword/CSR	CSR					Scheduler		http://dbis-vl.wikidata.dbis.rwth-aachen.de/index.php/Keyword-dbis/CSR
Keyword/Candidate Key	Candidate Key	Candidate key	Schlüsselkandidat	Candidate key	Q2113197
Keyword/Cardinality	Cardinality		Kardinalität (Datenbankmodellierung)	Cardinality (data modeling)	Q362383
Keyword/Concurrency control	Concurrency control	Concurrency Control, concurrency control		Concurrency control	Q2914952
Keyword/Consistency	Consistency			Consistency (database systems)	Q5163219	ACID
Keyword/DBMS	DBMS			Database management system	Q176165	database			rdbms
Keyword/DCL	DCL		Data Control Language	Data control language	Q604737	SQL
Keyword/DDL	DDL		Data Definition Language	Data definition language	Q1431648	ALTER, CREATE, GRANT, REVOKE			ddl
Keyword/DECIMAL	DECIMAL			Decimal data type	Q5249172	datatype
Keyword/DEFAULT	DEFAULT							https://mariadb.com/kb/en/default/
Keyword/DELETE	DELETE			Delete (SQL)	Q1153781	DML		https://www.w3schools.com/sql/sql_ref_delete.asp
Keyword/DESC	DESC					ORDER BY		https://www.w3schools.com/sql/sql_ref_desc.asp
Keyword/DISTINCT	DISTINCT	Distinct, Projektion				DQL		https://www.w3schools.com/sql/sql_ref_distinct.asp
Keyword/DML	DML		Data Manipulation Language	Data manipulation language	Q58673	SQL, DQL			dml
Keyword/DQL	DQL		Abfragesprache	Query language	Q845739	SQL
Keyword/DROP	DROP	DROP TABLE, DROP INDEX, Drop		Drop (SQL)	Q3490119	DDL		https://www.w3schools.com/sql/sql_ref_drop.asp
Keyword/Data sovereignty	Data sovereignty	data sovereignty		Data sovereignty	Q48780629
Keyword/Database theory	Database theory	database theory			Q8363916	database
Keyword/Datalog	Datalog		Datalog	Datalog	Q1172264
Keyword/Document Type Definition	Document Type Definition		Dokumenttypdefinition	Document type definition	Q212327
Keyword/Durability	Durability			Durability (database systems)	Q5316114	ACID
Keyword/ERD	ERD		Datenmodellierung	Data modeling	Q367664	ERM
Keyword/EXCEPT	EXCEPT	Except, Differenz				DQL, SQL Set operations		https://en.wikipedia.org/wiki/Set_operations_(SQL)#EXCEPT_operator
Keyword/Entity Type	Entity Type	Entitätstyp	Entität (Informatik)		Q1344928	entity
Keyword/Exists	Exists	EXISTS				DDL		https://www.w3schools.com/sql/sql_ref_exists.asp
Keyword/FDSet	FDSet					functional dependency		https://oer.gitlab.io/cs/functional-dependencies/functional_dependencies.html#functional_dependencies.FDSet	functional-dependencies
Keyword/FETCH	FETCH							https://www.w3schools.com/sql/sql_top.asp
Keyword/FOREIGN KEY	FOREIGN KEY	FK	Fremdschlüssel	Foreign key	Q1056760	DDL		https://www.w3schools.com/sql/sql_ref_foreign_key.asp
Keyword/FROM	FROM	From	From (SQL)	From (SQL)	Q3304069	DML		https://www.w3schools.com/sql/sql_ref_from.asp
Keyword/GDPR	GDPR	DSGVO	Datenschutz-Grundverordnung	General Data Protection Regulation	Q1172506
Keyword/GRANT	GRANT				Q12017965	DCL
Keyword/GROUP BY	GROUP BY	Group By		Group by (SQL)	Q13222055	DQL		https://www.w3schools.com/sql/sql_ref_group_by.asp
Keyword/Generalization	Generalization	generalization		Generalization	Q170084	Inheritance
Keyword/HAVING	HAVING	Having		Having (SQL)	Q1972511	DQL		https://www.w3schools.com/sql/sql_ref_having.asp
Keyword/HTML	HTML		Hypertext Markup Language	HTML	Q8811	Web
Keyword/Hash Join	Hash Join			Hash join	Q4060691	Join
Keyword/IEC 9075	IEC 9075			ISO/IEC 9075	Q5974436	ISO Standard
Keyword/IN	IN	In				DQL		https://www.w3schools.com/sql/sql_in.asp
Keyword/INDEX	INDEX	Index				DDL		https://www.w3schools.com/sql/sql_ref_index.asp
Keyword/INSERT	INSERT	INSERT INTO, INTO		Insert (SQL)	Q1076017	DML		https://www.w3schools.com/sql/sql_ref_insert_into.asp
Keyword/INSTEAD OF	INSTEAD OF							https://www.sqlservertutorial.net/sql-server-triggers/sql-server-instead-of-trigger/
Keyword/INTERSECT	INTERSECT					DQL, SQL Set operations, intersection		https://mariadb.com/kb/en/intersect/
Keyword/IRI	IRI		Internationalized Resource Identifier	Internationalized Resource Identifier	Q424583	URI
Keyword/ISO Standard	ISO Standard		ISO-Norm		Q15087423
Keyword/Index Join	Index Join					Join		https://www.tutorialspoint.com/teradata/teradata_join_index.htm
Keyword/Inheritance	Inheritance	inheritance, isA		Is-a	Q1101080	structure	Date2016		inheritance
Keyword/Isolation	Isolation		Isolation (Datenbank)	Isolation (database systems)	Q1674485	ACID
Keyword/JOIN	JOIN	Join	Join (SQL)	Join (SQL)	Q2003535	DQL		https://www.w3schools.com/sql/sql_ref_join.asp
Keyword/JSON	JSON		JavaScript Object Notation	JSON	Q2063
Keyword/JSON-LD	JSON-LD		JSON-LD	JSON-LD	Q6108942	JSON
Keyword/LEFT OUTER JOIN	LEFT OUTER JOIN				Q31341045	DQL, OUTER JOIN
Keyword/LIKE	LIKE	Like				DQL		https://en.wikipedia.org/wiki/Where_(SQL)#LIKE
Keyword/LIMIT	LIMIT				Q12032401	DQL		https://www.w3schools.com/sql/sql_ref_limit.asp
Keyword/MAX	MAX	Max				DQL		https://www.w3schools.com/sql/sql_min_max.asp
Keyword/MBR	MBR		Minimal umgebendes Rechteck	Minimum bounding rectangle	Q1134256
Keyword/MIN	MIN	Min				DQL		https://www.w3schools.com/sql/sql_min_max.asp
Keyword/Macintosh 128K	Macintosh 128K		Macintosh 128k	Macintosh 128K	Q1137478
Keyword/Model	Model		Struktur (erste Stufe)	Structure (mathematical logic)	Q1851710
Keyword/N-Triples	N-Triples			N-Triples	Q44044
Keyword/NOT	NOT	Not				DQL		https://www.w3schools.com/sql/sql_and_or.asp
Keyword/NULL	NULL	Null, Is Null		Null (SQL)	Q371029	DQL		https://www.w3schools.com/sql/sql_null_values.asp
Keyword/Neo4J	Neo4J		Neo4j	Neo4j	Q1628290	cypher, graph database
Keyword/Nested loop join	Nested loop join	Nested Block Loop Join, Nested Loop Join, Indexed Loop Join		Nested loop join	Q4060687	Join, Cartesian Product
Keyword/NoSQL	NoSQL		NoSQL	NoSQL	Q82231				nosql
Keyword/Notation 3	Notation 3		Notation 3 (Informatik)	Notation3	Q1424987
Keyword/OLAP	OLAP		Online Analytical Processing	Online analytical processing	Q642514
Keyword/OLTP	OLTP		Online Transaction Processing	Online transaction processing	Q1501395
Keyword/OR	OR	Or				DQL		https://www.w3schools.com/sql/sql_and_or.asp
Keyword/ORDER BY	ORDER BY	ORDER, BY		Order by	Q3299754	DQL		https://www.w3schools.com/sql/sql_ref_order_by.asp
Keyword/OUTER JOIN	OUTER JOIN					DQL, JOIN		https://de.wikibooks.org/wiki/Einf%C3%BChrung_in_SQL:_OUTER_JOIN
Keyword/PERIOD FOR	PERIOD FOR							https://mariadb.com/kb/en/application-time-periods/
Keyword/Printing press	Printing press		Druckpresse	Printing press	Q144334
Keyword/R-Tree	R-Tree		R-Baum	R-tree	Q1198051	tree
Keyword/RC	RC	recoverable						https://www.geeksforgeeks.org/recoverability-in-dbms/
Keyword/RDF	RDF		Resource Description Framework	Resource Description Framework	Q54872	IRI, SPARQL			rdf
Keyword/RDF-star	RDF-star	RDF*			Q108244697	graph database
Keyword/REDO	REDO					ARIES		https://en.wikipedia.org/wiki/Algorithms_for_Recovery_and_Isolation_Exploiting_Semantics#Redo
Keyword/RELAX NG	RELAX NG		RELAX NG	RELAX NG	Q1314117	XML
Keyword/REVOKE	REVOKE				Q12048413	DCL
Keyword/RIGHT OUTER JOIN	RIGHT OUTER JOIN				Q42214156	DQL, OUTER JOIN
Keyword/ROLLBACK	ROLLBACK		Rollback	Rollback (data management)	Q395307	TCL
Keyword/Recovery	Recovery	recovery	Logging und Recovery	Transaction log	Q948454
Keyword/Relationship	Relationship	relation	Relation	Relations (philosophy)	Q930933
Keyword/S2PL	S2PL					2PL		http://dbis-vl.wikidata.dbis.rwth-aachen.de/index.php/Keyword-dbis/S2PL
Keyword/SELECT	SELECT	Select, Selektion	Selektion (Informatik)	Select (SQL)	Q1164001	DQL		https://www.w3schools.com/sql/sql_ref_select.asp
Keyword/SET	SET	Set				DML		https://www.w3schools.com/sql/sql_ref_set.asp
Keyword/SPARQL	SPARQL		SPARQL	SPARQL	Q54871	query			sparql
Keyword/SQL	SQL	SEQUEL	SQL	SQL	Q47607	query			sql
Keyword/SQL Set operations	SQL Set operations			Set operations (SQL)	Q42196253
Keyword/SQL Syntax	SQL Syntax	SQL-Syntax		SQL syntax	Q30688993	SQL
Keyword/SQL-92	SQL-92	SQL2		SQL-92	Q4048871	IEC 9075
Keyword/SQL1	SQL1	SQL-86			Q28163355	IEC 9075
Keyword/SQL2003	SQL2003	SQL:2003			Q4048881	IEC 9075
Keyword/SQL2006	SQL2006	SQL:2006			Q7392729	IEC 9075
Keyword/SQL2008	SQL2008	SQL:2008			Q2063791	IEC 9075
Keyword/SQL2011	SQL2011	SQL:2011			Q3459982	IEC 9075
Keyword/SQL2016	SQL2016	SQL:2016			Q28941000	IEC 9075
Keyword/SQL2019	SQL2019	SQL:2019				IEC 9075		https://www.iso.org/standard/67382.html
Keyword/SQL99	SQL99	SQL:1999			Q4048878	IEC 9075
Keyword/SQLite	SQLite		SQLite	SQLite	Q319417
Keyword/ST	ST	strict schedule				Scheduler		http://dbis-vl.wikidata.dbis.rwth-aachen.de/index.php/Keyword-dbis/ST
Keyword/SUM	SUM					DQL		https://www.w3schools.com/sql/sql_count_avg_sum.asp
Keyword/Scheduler	Scheduler	scheduler	Serialisierbarkeit	Serializability	Q137712
Keyword/Schema	Schema	schema	Schema (Informatik)		Q1397073	structure
Keyword/Semantic Web	Semantic Web		Semantic Web	Semantic Web	Q54837	Web
Keyword/Sort-merge join	Sort-merge join	Sort-Merge Join		Sort-merge join	Q4060688	Join
Keyword/Specialization	Specialization	specialization				Inheritance		https://wiki.bitplan.com/index.php/Specialization
Keyword/StdDev	StdDev							https://mariadb.com/kb/en/stddev/
Keyword/Subquery	Subquery	Nested query				DQL		https://en.wikipedia.org/wiki/Select_(SQL)#Subqueries
Keyword/Super key	Super key			Superkey	Q2068684	key
Keyword/Surrogate key	Surrogate key		Surrogatschlüssel	Surrogate key	Q871776	key
Keyword/Synchronisation	Synchronisation	synchronisation	Prozesssynchronisation	Synchronization (computer science)	Q650462
Keyword/TCL	TCL		Transaction Control Language	Transaction Control Language	Q2448845	SQL
Keyword/TODO	TODO				Q11704193
Keyword/TRUNCATE	TRUNCATE			Truncate (SQL)	Q2664576	DROP, DML		https://www.w3schools.com/sql/sql_ref_truncate_table.asp
Keyword/Theta Join	Theta Join					Join		https://glossar.hs-augsburg.de/Verbundoperatoren_(Join)#Theta_Join
Keyword/Three schema approach	Three schema approach			Three-schema approach	Q7798002	schema
Keyword/Transaction	Transaction	transaction	Transaktion (Informatik)	Database transaction	Q848010				transaction
Keyword/Trigger	Trigger	Datenbanktrigger	Datenbanktrigger	Database trigger	Q835769
Keyword/Turtle	Turtle		Turtle (Syntax)	Turtle (syntax)	Q114409	RDF
Keyword/UML	UML		Unified Modeling Language	Unified Modeling Language	Q169411	structure
Keyword/UNDO	UNDO					ARIES		https://en.wikipedia.org/wiki/Algorithms_for_Recovery_and_Isolation_Exploiting_Semantics#Undo
Keyword/UNION	UNION	union,Union, Vereinigung			Q2669934	DQL, SQL, six base operations		https://www.w3schools.com/sql/sql_ref_union.asp
Keyword/UNIQUE	UNIQUE	Unique				DDL		https://www.w3schools.com/sql/sql_ref_unique.asp
Keyword/UPDATE	UPDATE		Update (SQL)	Update (SQL)	Q1076005	DML		https://www.w3schools.com/sql/sql_ref_update.asp
Keyword/URI	URI		Uniform Resource Identifier	Uniform Resource Identifier	Q61694	IRI, Web
Keyword/VALUES	VALUES					DML, INSERT INTO		https://www.w3schools.com/sql/sql_ref_values.asp
Keyword/VARCHAR	VARCHAR			Varchar	Q2715350	datatype		https://mariadb.com/kb/en/varchar/
Keyword/Variance	Variance					DQL		https://mariadb.com/kb/en/variance/
Keyword/W3C	W3C		World Wide Web Consortium	World Wide Web Consortium	Q37033	Web		https://www.w3.org/	w3c
Keyword/WHERE	WHERE	Where		Where (SQL)	Q2668363	DQL		https://www.w3schools.com/sql/sql_where.asp
Keyword/Weak entity	Weak entity		Schwache Entität	Weak entity	Q3246444
Keyword/Wide-column-store	Wide-column-store			Wide-column store	Q25099437	NoSQL, column-oriented DBMS
Keyword/World Wide Web	World Wide Web	Web	World Wide Web	World Wide Web	Q466
Keyword/XML	XML		Extensible Markup Language	XML	Q2115				xml
Keyword/XML Information Set	XML Information Set		XML Information Set	XML Information Set	Q1759545	XML
Keyword/XML Schema	XML Schema		XML Schema	XML Schema (W3C)	Q16342	XML
Keyword/XML tree	XML tree			XML tree	Q8042334	XML
Keyword/XML validation	XML validation			XML validation	Q595926	XML
Keyword/XPath	XPath		XPath	XPath	Q16340	XML			xpath
Keyword/XQuery	XQuery		XQuery	XQuery	Q850661				xquery
Keyword/abstraction	abstraction	Abstraction	Abstraktion	Abstraction	Q673661				abstraction
Keyword/analysis	analysis		Analyse	Analysis	Q217602
Keyword/anomaly	anomaly	Anomaly, Anomalie	Anomalie (Informatik)		Q15783583
Keyword/bandwith	bandwith			Bandwidth (computing)	Q1576430				bandwidth
Keyword/binary relation	binary relation		Binäre Relation	Binary relation	Q130901	relation
Keyword/book keeping	book keeping		Buchführung	Bookkeeping	Q3707847
Keyword/canonical cover	canonical cover	kanonische Überdeckung	Kanonische Überdeckung	Canonical cover	Q1723874
Keyword/cartesian product	cartesian product	Cartesian Product, Kreuzprodukt, Cartesian product	Kartesisches Produkt	Cartesian product	Q173740	six base operations
Keyword/clay tablet	clay tablet		Tontafel	Clay tablet	Q1570005
Keyword/column-oriented DBMS	column-oriented DBMS		Spaltenorientierte Datenbank	Column-oriented DBMS	Q425567	NoSQL
Keyword/composite attribute	composite attribute							https://www.scaler.com/topics/composite-attribute-in-dbms/
Keyword/composite key	composite key	compound key		Composite key	Q5156838
Keyword/conceptual design	conceptual design			Conceptual design	Q5158435
Keyword/conceptual schema	conceptual schema	conceptual model, Konzeptionelles Modell	Semantisches Datenmodell	Conceptual schema	Q2268965	Three schema approach
Keyword/cypher	cypher		Cypher (Abfragesprache)	Cypher (query language)	Q16834355
Keyword/data model	data model		Datenmodell	Data model	Q1172480
Keyword/data modeling	data modeling		Datenmodellierung	Data modeling	Q367664
Keyword/data privacy	data privacy	information privacy	Datenschutz	Information privacy	Q456632
Keyword/data quality	data quality			Data quality	Q1757694
Keyword/data security	data security			Data security	Q899388
Keyword/database	database	Database, DB, DBS, database system	Datenbank	Database	Q8513				database
Keyword/database normalisation	database normalisation		Normalisierung (Datenbank)	Database normalization	Q339072	Database theory, design			database-normalization
Keyword/database table	database table		Datenbanktabelle	Table (database)	Q278425	database table
Keyword/database transaction	database transaction		Transaktion (Informatik)	Database transaction	Q848010	transaction
Keyword/datatype	datatype		Datentyp	Data type	Q190087
Keyword/declarative programming	declarative programming	deklarative sprache	Deklarative Programmierung	Declarative programming	Q531152
Keyword/decomposition algorithm	decomposition algorithm		Normalisierung (Datenbank)	Database normalization	Q339072	BCNF		https://de.wikipedia.org/wiki/Normalisierung_(Datenbank)#Zerlegungsalgorithmus
Keyword/dependency preservation	dependency preservation	Abhängigkeitserhaltung, Abhängigkeitstreue						https://wikis.gm.fh-koeln.de/Datenbanken/Abhaengigkeitstreu
Keyword/design	design		Softwaredesign	Software design	Q857102
Keyword/difference	difference		Differenzmenge		Q845126	six base operations
Keyword/dirty-read	dirty-read		Schreib-Lese-Konflikt	Write–read conflict	Q1493853	Synchronisation
Keyword/discriminator	discriminator					inheritance, entity-relationship model		https://wiki.bitplan.com/index.php/Discriminator
Keyword/domain calculus	domain calculus	DRC		Domain relational calculus	Q5289831	relational calculus
Keyword/duplicate	duplicate		Dublette (Datenbank)		Q1263068
Keyword/edge	edge		Kante (Graphentheorie)	Edge (graph theory)	Q3297804	graph
Keyword/entity	entity	Entity	Entität (Informatik)		Q1344928	Entity Type
Keyword/entity-relationship model	entity-relationship model	ERM	Entity-Relationship-Modell	Entity–relationship model	Q624546	ERD			entity-relationship
Keyword/extensional	extensional		Extension und Intension	Extensional and intensional definitions	Q19515659
Keyword/external schema	external schema					Three schema approach		https://wiki.bitplan.com/index.php/External_schema
Keyword/file system	file system	Filesystem	Dateisystem	File system	Q174989
Keyword/full outer join	full outer join	FULL OUTER JOIN				Join		https://www.w3schools.com/sql/sql_join_full.asp
Keyword/functional dependency	functional dependency	FD	Funktionale Abhängigkeit	Functional dependency	Q597053	database normalisation
Keyword/graph	graph		Graph (Graphentheorie)	Graph (discrete mathematics)	Q141488	structure
Keyword/graph database	graph database		Graphdatenbank	Graph database	Q595971	database, graph, NoSQL
Keyword/index structure	index structure	index structures, Indexstrukturen	Indexstruktur		Q1423858
Keyword/information security	information security		Informationssicherheit	Information security	Q189900
Keyword/information system	information system		Informationssystem	Information system	Q121182
Keyword/intensional	intensional		Extension und Intension	Extensional and intensional definitions	Q19515659
Keyword/intersection	intersection			Intersection	Q17141489
Keyword/join algorithms	join algorithms		Joinalgorithmen		Q1702519	JOIN
Keyword/k-d tree	k-d tree		K-d-Baum	K-d tree	Q309949	tree
Keyword/key	key	natural key	Sprechender Schlüssel	Natural key	Q731314
Keyword/labeled property graph	labeled property graph	LPG				graph database		https://www.oxfordsemantic.tech/fundamentals/what-is-a-labeled-property-graph
Keyword/latency	latency		Totzeit (Regelungstechnik)	Latency (engineering)	Q1771903
Keyword/left semi-join	left semi-join					semi-join		https://de.wikibooks.org/wiki/Relationenalgebra_und_SQL:_Semi-Join
Keyword/lock	lock	locking, Sperre	Lock	Lock (computer science)	Q1427251	transaction			locking
Keyword/logical schema	logical schema			Logical schema	Q17146953	schema
Keyword/losslessness	losslessness	Verlustlosigkeit, Verbundtreue	Verbundtreue	Lossless join decomposition	Q1538521
Keyword/lost-update	lost-update		Verlorenes Update	Write–write conflict	Q1372673
Keyword/metadata	metadata		Metadaten	Metadata	Q180160	structure
Keyword/multidimensional array	multidimensional array							https://en.wiktionary.org/wiki/multidimensional_array
Keyword/multidimensional data	multidimensional data	mehrdimensionale Daten, multidimensionale Datenbanken	Multidimensionale Datenbank		Q356222	multidimensional array
Keyword/n:m relation	n:m relation					Cardinality		https://glossar.hs-augsburg.de/Beziehungstypen
Keyword/natural join	natural join	Natural Loin, Natural Join	Join (SQL)	Join (SQL)	Q2003535	Join
Keyword/nested queries	nested queries	Nested query		Correlated subquery	Q5172838	query
Keyword/node	node	vertex	Knoten (Graphentheorie)	Vertex (graph theory)	Q1304193	graph
Keyword/persistent identifier	persistent identifier
Keyword/personal computer	personal computer		Personal Computer	Personal computer	Q16338
Keyword/physical schema	physical schema	physical data model		Physical schema	Q17113749	Three schema approach
Keyword/primary index	primary index	database index	Datenbankindex	Database index	Q580427
Keyword/primary key	primary key	PRIMARY KEY, Primary Key, Primary key	Primärschlüssel	Primary key	Q934729	key		https://www.w3schools.com/sql/sql_ref_primary_key.asp	primary-key
Keyword/procedural programming	procedural programming	prozeduale sprache	Prozedurale Programmierung	Procedural programming	Q1418502
Keyword/projection	projection			Projection (relational algebra)	Q3134666	six base operations
Keyword/punched card	punched card		Lochkarte	Punched card	Q183414
Keyword/quadtree	quadtree		Quadtree	Quadtree	Q934791	tree
Keyword/quasi identifier	quasi identifier					identifier
Keyword/query	query				Q3428776
Keyword/query optimization	query optimization	Optimierungsgründe		Query optimization	Q2919848	query
Keyword/query optimizer	query optimizer	Regelbasiert, Kostenbasiert	Abfrageoptimierer		Q390567	query
Keyword/query plan	query plan	Auswertungsplan	Auswertungsplan	Query plan	Q784232	query
Keyword/read-write-conflict	read-write-conflict		Nichtwiederholbares Lesen	Read–write conflict	Q7300726
Keyword/recovery-class	recovery-class		Historie (Transaktionsverarbeitung)	Schedule (computer science)	Q1202008	recovery
Keyword/recursive query	recursive query			Hierarchical and recursive queries in SQL	Q5753091
Keyword/reflexive relation	reflexive relation		Reflexive Relation	Reflexive relation	Q621850	relation
Keyword/rel algebra	rel algebra	relational algebra	Relationale Algebra	Relational algebra	Q840540	relation
Keyword/relational calculus	relational calculus		Kalkül (Datenbank)	Relational calculus	Q1722436	relation
Keyword/relational database	relational database	relationales Datenbankmodell	Relationale Datenbank	Relational database	Q192588	relation
Keyword/relational model	relational model			Relational model	Q755662	relation
Keyword/renaming	renaming			Rename (relational algebra)	Q7312524	six base operations
Keyword/row pattern matching	row pattern matching	row pattern recognition, RPR					Ohara2021, Petkovic2022
Keyword/schedule	schedule		Historie (Transaktionsverarbeitung)	Schedule (computer science)	Q1202008
Keyword/schema evolution	schema evolution			Schema evolution	Q3951893	schema
Keyword/scope statement	scope statement		Pflichtenheft	Scope statement	Q427948
Keyword/search tree	search tree	Suchbaum	Suchbaum	Search tree	Q621673	B-Tree
Keyword/secondary index	secondary index		Datenbankindex	Database index	Q580427
Keyword/selection	selection			Selection (relational algebra)	Q7447725	six base operations
Keyword/selfjoin	selfjoin					JOIN		https://www.w3schools.com/sql/sql_join_self.asp
Keyword/semantic triple	semantic triple			Semantic triple	Q3539534	RDF
Keyword/semi-join	semi-join					Join	Bernstein1981
Keyword/semi-structured data	semi-structured data		Semistrukturierte Daten	Semi-structured data	Q2336004	structure
Keyword/serialisability	serialisability	Serialisability, serializability	Serialisierbarkeit	Serializability	Q137712	concurrency control
Keyword/serialization	serialization		Serialisierung	Serialization	Q1127410	concurrency control
Keyword/set operation	set operation			Set operations (SQL)	Q42196253
Keyword/six base operations	six base operations	Basis operationen				relational algebra		https://wiki.bitplan.com/index.php/Basisoperationen_Relationale_Algebra
Keyword/soundness	soundness		Korrektheit (Logik)	Soundness	Q693083
Keyword/structure	structure			Structure	Q6671777	abstraction
Keyword/subtype	subtype		Subtyp		Q1275580	specialization, entity-relationship model	Date2016
Keyword/supertype	supertype	Superentität		Subtyping	Q2713292	generalization, entity-relationship model	Date2016
Keyword/synthesis algorithm	synthesis algorithm		Synthesealgorithmus		Q2376167	3rd normal form, canonical cover, functional dependency	Bernstein1976
Keyword/table	table	Table, Relation	Relation (Datenbank)	Relation (database)	Q277521	database theory
Keyword/ternary relation	ternary relation			Ternary relation	Q3756532	relation
Keyword/transitive relation	transitive relation		Transitive Relation	Transitive relation	Q64861
Keyword/tree	tree		Baum (Datenstruktur)	Tree (data structure)	Q223655	quadtree, R-Tree, k-d tree,B-Tree, B+ tree
Keyword/triplestore	triplestore			Triplestore	Q3539533	RDF
Keyword/tupel calculus	tupel calculus	TRC, tuple calculus		Tuple relational calculus	Q1000462	relational calculus, tuple
Keyword/tuple	tuple	tupel	Tupel	Tuple	Q600590
Keyword/unique key	unique key		Schlüssel (Datenbank)	Unique key	Q3667566	Primary key, Candidate key, Super key, Surrogate key
Keyword/view	view	View	Sicht (Datenbank)	View (SQL)	Q1329910	DDL		https://www.w3schools.com/sql/sql_view.asp

"""

       return ask
       
   @classmethod
   def fromDict(cls,data:dict):
       """
       create a Keyword from the given dict
       
       Args:
           data(dict): the dict to create the Keyword from
       
       Returns:
           Keyword: the freshly created Keyword
       """
       keyword=dacite.from_dict(data_class=cls,data=data)
       return keyword