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/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/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-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/AVL-Tree	AVL-Tree		AVL-Baum	AVL tree	Q300159				avl-tree
Keyword/Any	Any	ANY				All		https://www.w3schools.com/sql/sql_any_all.asp
Keyword/Arithmetic Expressions	Arithmetic Expressions		Arithmetik	Arithmetic	Q11205
Keyword/Armstrong's axioms	Armstrong's axioms	Armstrong Axiome		Armstrong's axioms	Q3625629
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/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/DBMS	DBMS			Database management system	Q176165	database			rdbms
Keyword/DDL	DDL		Data Definition Language	Data definition language	Q1431648	ALTER, CREATE, GRANT, REVOKE			ddl
Keyword/DECIMAL	DECIMAL			Decimal data type	Q5249172	datatype
Keyword/DELETE	DELETE			Delete (SQL)	Q1153781	DML		https://www.w3schools.com/sql/sql_ref_delete.asp
Keyword/DISTINCT	DISTINCT	Distinct, Projektion				DQL		https://www.w3schools.com/sql/sql_ref_distinct.asp
Keyword/DQL	DQL		Abfragesprache	Query language	Q845739	SQL
Keyword/Data sovereignty	Data sovereignty	data sovereignty		Data sovereignty	Q48780629
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/FOREIGN KEY	FOREIGN KEY	FK	Fremdschlüssel	Foreign key	Q1056760	DDL		https://www.w3schools.com/sql/sql_ref_foreign_key.asp
Keyword/GDPR	GDPR	DSGVO	Datenschutz-Grundverordnung	General Data Protection Regulation	Q1172506
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/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/IRI	IRI		Internationalized Resource Identifier	Internationalized Resource Identifier	Q424583	URI
Keyword/ISO Standard	ISO Standard		ISO-Norm		Q15087423
Keyword/Inheritance	Inheritance	inheritance, isA		Is-a	Q1101080	structure			inheritance
Keyword/Isolation	Isolation		Isolation (Datenbank)	Isolation (database systems)	Q1674485	ACID
Keyword/LEFT OUTER JOIN	LEFT OUTER JOIN				Q31341045	DQL, OUTER JOIN
Keyword/LIMIT	LIMIT				Q12032401	DQL		https://www.w3schools.com/sql/sql_ref_limit.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/N-Triples	N-Triples			N-Triples	Q44044
Keyword/NOT	NOT	Not				DQL		https://www.w3schools.com/sql/sql_and_or.asp
Keyword/Neo4J	Neo4J		Neo4j	Neo4j	Q1628290	cypher, graph database
Keyword/Notation 3	Notation 3		Notation 3 (Informatik)	Notation3	Q1424987
Keyword/OLAP	OLAP		Online Analytical Processing	Online analytical processing	Q642514
Keyword/OR	OR	Or				DQL		https://www.w3schools.com/sql/sql_and_or.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/RC	RC	recoverable						https://www.geeksforgeeks.org/recoverability-in-dbms/
Keyword/RDF	RDF		Resource Description Framework	Resource Description Framework	Q54872	IRI, SPARQL			rdf
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/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/SQL	SQL	SEQUEL	SQL	SQL	Q47607	query			sql
Keyword/SQL Set operations	SQL Set operations			Set operations (SQL)	Q42196253
Keyword/SQL1	SQL1	SQL-86			Q28163355	IEC 9075
Keyword/SQL2006	SQL2006	SQL:2006			Q7392729	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/SQLite	SQLite		SQLite	SQLite	Q319417
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/Specialization	Specialization	specialization				Inheritance		https://wiki.bitplan.com/index.php/Specialization
Keyword/Super key	Super key			Superkey	Q2068684	key
Keyword/Synchronisation	Synchronisation	synchronisation	Prozesssynchronisation	Synchronization (computer science)	Q650462
Keyword/TCL	TCL		Transaction Control Language	Transaction Control Language	Q2448845	SQL
Keyword/Trigger	Trigger	Datenbanktrigger	Datenbanktrigger	Database trigger	Q835769
Keyword/Turtle	Turtle		Turtle (Syntax)	Turtle (syntax)	Q114409	RDF
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/VARCHAR	VARCHAR			Varchar	Q2715350	datatype		https://mariadb.com/kb/en/varchar/
Keyword/Variance	Variance					DQL		https://mariadb.com/kb/en/variance/
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/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/XQuery	XQuery		XQuery	XQuery	Q850661				xquery
Keyword/abstraction	abstraction	Abstraction	Abstraktion	Abstraction	Q673661				abstraction
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/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/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/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/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/declarative programming	declarative programming	deklarative sprache	Deklarative Programmierung	Declarative programming	Q531152
Keyword/design	design		Softwaredesign	Software design	Q857102
Keyword/difference	difference		Differenzmenge		Q845126	six base operations
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/external schema	external schema					Three schema approach		https://wiki.bitplan.com/index.php/External_schema
Keyword/graph database	graph database		Graphdatenbank	Graph database	Q595971	database, graph, NoSQL
Keyword/index structure	index structure	index structures, Indexstrukturen	Indexstruktur		Q1423858
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/key	key	natural key	Sprechender Schlüssel	Natural key	Q731314
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/metadata	metadata		Metadaten	Metadata	Q180160	structure
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/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/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 model	relational model			Relational model	Q755662	relation
Keyword/row pattern matching	row pattern matching	row pattern recognition, RPR					Ohara2021, Petkovic2022
Keyword/search tree	search tree	Suchbaum	Suchbaum	Search tree	Q621673	B-Tree
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/serialisability	serialisability	Serialisability, serializability	Serialisierbarkeit	Serializability	Q137712	concurrency control
Keyword/serialization	serialization		Serialisierung	Serialization	Q1127410	concurrency control
Keyword/structure	structure			Structure	Q6671777	abstraction
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/triplestore	triplestore			Triplestore	Q3539533	RDF
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