| dbo:abstract |
The MySQL Datacontroller storage engine for the MySQL relational database management system is a storage engine which allows a user to create a table that is a local representation of a foreign (remote) table.The foreign table can be located into another storage engine like Oracle or Microsoft SQL Server (MSSQL). It utilizes the MySQL client library API, Free-TDS and OCILIB as a data transport, treating the remote data source the same way other storage engines treat local data sources.Each Federated table that is defined there is one .frm (data definition file containing information such as the URL of the data source). The actual data can exist on a local or remote Oracle, Microsoft SQL Server (MSSQL), or MySQL instance. To create a Federated table, one has to specify a URL in the "CONNECTION" string: create table foo ( id int, bar varchar(255), dt date)ENGINE=DATACONTROLLER CONNECTION='oracle://username:password@hostname:1521/SID/foo' The connection URL is in the format of: scheme://user:pass@host:port/schema/tablename and for MSSQL where schema is dbo scheme://user:pass@host:port/DB/schema/tablename Upon creation of a DataController table, the user must ensure that the remote data source does indeed exist or an error will be issued. The DataController Storage engine was first based on the MySQL Federated Storage Engine was authored by Patrick Galbraith and Brian Aker and is currently being maintained by Patrick Galbraith and Antony Curtis.It was introduced in 2005 with MySQL 5.0. The DataController Storage engine was introduced in 2010 by Francis Lavalliere working with MySQL 5.1, in order to facilitate the access to other database engines. This plugin can also help in case of data migration, or migrating data to another database engine. (en) |
| dbo:computingPlatform |
dbr:X86-64 dbr:X86_architecture |
| dbo:genre |
dbr:Database_engine |
| dbo:license |
dbr:GNU_General_Public_License |
| dbo:operatingSystem |
dbr:Unix dbr:Linux dbr:Mac_OS_X dbr:Microsoft_Windows |
| dbo:wikiPageExternalLink |
http://www.acentera.com/mysql-datacontroller/ http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html https://launchpad.net/datacontroller |
| dbo:wikiPageID |
31689078 (xsd:integer) |
| dbo:wikiPageInterLanguageLink |
dbpedia-fr:DataController dbpedia-fr:Migration |
| dbo:wikiPageLength |
2855 (xsd:nonNegativeInteger) |
| dbo:wikiPageRevisionID |
993182946 (xsd:integer) |
| dbo:wikiPageWikiLink |
dbr:Brian_Aker dbr:Relational_database_management_system dbr:Unix dbr:GNU_General_Public_License dbr:MySQL dbr:Linux dbr:Mac_OS_X dbc:MySQL dbr:Database_engine dbr:Microsoft_Windows dbr:X86-64 dbr:X86_architecture |
| dbp:author |
Francis Lavalliere (en) |
| dbp:genre |
dbr:Database_engine |
| dbp:language |
C/C++ (en) |
| dbp:license |
dbr:GNU_General_Public_License |
| dbp:name |
MySQL Datacontroller Plugin Storage Engine (en) |
| dbp:operatingSystem |
dbr:Unix dbr:Linux dbr:Mac_OS_X dbr:Microsoft_Windows |
| dbp:platform |
dbr:X86-64 dbr:X86_architecture |
| dbp:released |
2010 (xsd:integer) |
| dbp:website |
https://launchpad.net/datacontroller |
| dbp:wikiPageUsesTemplate |
dbt:Infobox_Software dbt:Database-software-stub |
| dct:subject |
dbc:MySQL |
| gold:hypernym |
dbr:Engine |
| rdf:type |
owl:Thing dbo:Software schema:CreativeWork dbo:Work wikidata:Q386724 wikidata:Q7397 yago:Abstraction100002137 yago:Code106355894 yago:CodingSystem106353757 yago:Communication100033020 yago:Writing106359877 yago:WrittenCommunication106349220 yago:Software106566077 |
| rdfs:comment |
The MySQL Datacontroller storage engine for the MySQL relational database management system is a storage engine which allows a user to create a table that is a local representation of a foreign (remote) table.The foreign table can be located into another storage engine like Oracle or Microsoft SQL Server (MSSQL). To create a Federated table, one has to specify a URL in the "CONNECTION" string: create table foo ( id int, bar varchar(255), dt date)ENGINE=DATACONTROLLER CONNECTION='oracle://username:password@hostname:1521/SID/foo' The connection URL is in the format of: (en) |
| rdfs:label |
MySQL DataController (en) |
| owl:sameAs |
freebase:MySQL DataController wikidata:MySQL DataController https://global.dbpedia.org/id/fiwn |
| prov:wasDerivedFrom |
wikipedia-en:MySQL_DataController?oldid=993182946&ns=0 |
| foaf:homepage |
https://launchpad.net/datacontroller |
| foaf:isPrimaryTopicOf |
wikipedia-en:MySQL_DataController |
| foaf:name |
MySQL Datacontroller Plugin Storage Engine (en) |
| is dbo:wikiPageWikiLink of |
dbr:Outline_of_MySQL dbr:Tara_Hernandez |
| is foaf:primaryTopic of |
wikipedia-en:MySQL_DataController |