Giter Club home page Giter Club logo

web-karma's Introduction

Karma: A Data Integration Tool

News

We released version 2.000 of Karma with many changes, new GUI, new RDF generator and many bug fixes.

Important note: we had a mishap in the repository, so if you have a clone from a previous version you cannot update it to the new version. You need to delete your existing clone and get a fresh clone from the repo.

Remember save your preloaded-ontologies and copy them back to the new clone.

We moved the semantic types to the menus in the columns. They are not in the little red and black circles.

Karma needs Java 1.7, Maven 3.0. Download Java SE from http://www.oracle.com/technetwork/java/javase/downloads/index.html

The Karma user guide is in the wiki.

Karma is an information integration tool that enables users to quickly and easily integrate data from a variety of data sources including databases, spreadsheets, delimited text files, XML, JSON, KML and Web APIs. Users integrate information by modeling it according to an ontology of their choice using a graphical user interface that automates much of the process. Karma learns to recognize the mapping of data to ontology classes and then uses the ontology to propose a model that ties together these classes. Users then interact with the system to adjust the automatically generated model. During this process, users can transform the data as needed to normalize data expressed in different formats and to restructure it. Once the model is complete, users can published the integrated data as RDF or store it in a database.

You can find useful tutorials on the project Website: http://www.isi.edu/integration/karma/

Installation and Setup

System Requirements: Java 1.7, Maven 3.0 and above.

To run the jetty server, execute the following command from webkarma top directory: mvn jetty:run. Once the server has started point your browser to http://localhost:8080/web-karma.html. To start it on a port other than 8080 (e.g. Port number 9999) mvn -Djetty.port=9999 jetty:run

To start in logging mode (where all the logs are stored in the log folder), use the following command to start the server: mvn -Dslf4j=false -Dlog4j.configuration=file:./config/log4j.properties jetty:run

Frequently Asked Questions

How to perform offline RDF generation for a data source using a published model?

  1. Model your source and publish it's model (the published models are located at src/main/webapp/publish/R2RML/ inside the Karma directory).
  2. To generate RDF of a CSV/JSON/XML file, go to the top level Karma directory and run the following command from terminal:
mvn exec:java -Dexec.mainClass="edu.isi.karma.rdf.OfflineRdfGenerator" -Dexec.args="--sourcetype 
<sourcetype> --filepath <filepath> --modelfilepath <modelfilepath> --outputfile <outputfile>" -Dexec.classpathScope=compile
Valid argument values for sourcetype are: CSV, JSON, XML. Also, you need to escape the double quotes that go inside argument values. Example invocation for a JSON file:
mvn exec:java -Dexec.mainClass="edu.isi.karma.rdf.OfflineRdfGenerator" -Dexec.args="
--sourcetype JSON 
--filepath \"/Users/shubhamgupta/Documents/wikipedia.json\" 
--modelfilepath \"/Users/shubhamgupta/Documents/model-wikipedia.n3\" 
--outputfile wikipedia-rdf.n3" -Dexec.classpathScope=compile
  1. To generate RDF of a database table, go to the top level Karma directory and run the following command from terminal:
mvn exec:java -Dexec.mainClass="edu.isi.karma.rdf.OfflineRdfGenerator" -Dexec.args="--sourcetype DB
--modelfilepath <modelfilepath> --outputfile <outputfile> --dbtype <dbtype> --hostname <hostname> 
--username <username> --password <password> --portnumber <portnumber> --dbname <dbname> --tablename <tablename>" -Dexec.classpathScope=compile
Valid argument values for `dbtype` are Oracle, MySQL, SQLServer, PostGIS, Sybase. Example invocation:
mvn exec:java -Dexec.mainClass="edu.isi.karma.rdf.OfflineRdfGenerator" -Dexec.args="
--sourcetype DB --dbtype SQLServer 
--hostname example.com --username root --password secret 
--portnumber 1433 --dbname Employees --tablename Person 
--modelfilepath \"/Users/shubhamgupta/Documents/db-r2rml-model.ttl\"
--outputfile db-rdf.n3" -Dexec.classpathScope=compile

You can do mvn exec:java -Dexec.mainClass="edu.isi.karma.rdf.OfflineRdfGenerator" -Dexec.args="--help" to get information about required arguments.

How to set up password protection for accessing Karma?

  • in /src/main/config/jettyrealm.properties change user/password (if you wish)
  • in /src/main/webapp/WEB-INF/web.xml uncomment security section at the end of the file
  • in pom.xml uncomment security section (search for loginServices)

Are there additional steps required to import data from Oracle database?

Yes. Due to Oracles binary license issues, we can't distribute the JAR file that is required for importing data from an Oracle database. Following are the steps to resolve the runtime error that you will get if you try to do it with the current source code:

  1. Download the appropriate JDBC drive JAR file (for JDK 1.5 and above) that matches your Oracle DB version. Link: http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html
  2. Put the downloaded JAR file inside lib folder of the Karma source code.
  3. Add the following snippet in the pom.xml file (present inside the top level folder of Karma source code) inside the dependencies XML element:
<dependency> 
    <groupId>com.oracle</groupId> 
    <artifactId>ojdbc</artifactId> 
    <version>14</version> 
    <scope>system</scope> 
    <systemPath>${project.basedir}/lib/ojdbc14.jar</systemPath> 
</dependency> 

Make sure that the filename mentioned in the systemPath element matches with your downloaded JAR file.

web-karma's People

Contributors

shubhamg avatar taheriyan avatar szeke avatar dkapoor avatar jasonslepicka avatar shrikanthn avatar yaoyichi avatar yingzhang avatar areshand avatar akshayrd avatar frueyang avatar ukby1234 avatar jlbbj111 avatar sanmeetshikh avatar vishalhemnani avatar

Watchers

 avatar

Forkers

codesacka

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.