《【软件自由日】红帽：Build Teiid VDB.pdf》由会员分享，可在线阅读，更多相关《【软件自由日】红帽：Build Teiid VDB.pdf（19页珍藏版）》请在三一文库上搜索。
1、Build Teiid VDB Xian Liu Red Hat Asia Pacific Teiid Teiid Teiid is a data virtualization system that allows applications to use data from multiple, heterogeneous data stores. Teiid is comprised of tools, components and services for creating and executing bi-directional data services. Through abstra
2、ction and federation, data is accessed and integrated in real-time across distributed data sources without copying or otherwise moving data from its system of record. Virtual Databases A virtual database (or VDB) is a container for components used to integrate data from multiple data sources, so tha
3、t they can be accessed in an integrated manner through a single, uniform API. A VDB contains models, which define the structural characteristics of data sources, views, and Web services. Models A model is a representation of a set of information constructs. A familiar model is the relational model,
4、which defines tables composed of columns and containing records of data. Another familiar model is the XML model, which defines hierarchical data sets. Translators A Translator provides an abstraction layer between Teiid Query Engine and physical data source, that knows how to convert Teiid issued q
5、uery commands into source specific commands and execute them using the Resource Adaptor. It also have smarts to convert the result data that came from the physical source into a form that Teiid Query engine is expecting. Resouce Adaptors A Resouce Adaptor provides the connectivity to the physical da
6、ta source. This also provides way to natively issue commands to the source and gather results. A Resource Adaptor can be a RDBMS data source, Web Service, text file, connection to main frame or to a custom source you defined. This is often is JCA Connector, however there is no restriction how somebo
7、dy provides the connection semantics to the Translator. Data Services Modeling environment, to define the abstraction layers - views and Web services Execution environment, to actualize the abstract structures from the underlying data, and expose them through standard APIs. A query engine is a requi
8、red part of the execution environment, to optimally federate data from multiple disparate sources. Build Teiid VDB Set up the Teiid server Build Teiid Instance Teiid Runtime Download http:/www.jboss.org/teiid/downloads Teiid offers a highly scalable and high performance solution to information integ
9、ration. By allowing integrated and enriched data to be consumed relationally or as XML over multiple protocols, Teiid simplifies data access for developers and consuming applications. Config the jboss server Add the modules from teiid-8.4.0.final-jboss-dist standlone-teiid.xml teiid-security-users.p
10、roperties teiid-security-roles- properties Teiid Designer Download http:/www.jboss.org/teiiddesigner/downloads Teiid Designer is an Eclipse-based graphical modeling tool for modeling, analyzing, integrating and testing multiple data sources to produce Relational, XML and Web Service Views that expos
11、e your business data. Defining a Teiid Server New teiid server Edit teiid properties Set the default teiid server Teiid Designer Guide Define Teiid Model Project Create JDBC connection Create source model for JDBC data source Preview Data Define VDB Execute VDB Permissions Row-Based Security A condi
12、tion is applied conjunctively to update/delete/select where clauses against the affected resource. Those queries will therefore only ever be effective against the subset of rows that pass the condition, i.e. “SELECT * FROM TBL WHERE blah AND condition“. The condition will be present regardless of ho
13、w the table/view is used in the query, whether via a union, join, etc XML Definition https:/docs.jboss.org/author/display/teiid84final/XML +Definition Lets have a try from scratch Simple Demo Local mysql database Jdbc:mysql:/127.0.0.1:3306/demoDB Requirements Access one table in demo DB by teiid Q&A