What is your use-case for importing the DWH data? How are you going to model the data of the DWH in neo4j. How does the domain-model look like?
BI data is normally denormalized. So for creating a good graph structure it would be sensible to normalize it during the import. 10k rows is not that much. You can import them using the normal neo4j transactional facilities in a few seconds. For building up your graph model you probably want to index your data or create category nodes to access certain parts of your domain model. Peter wrote a tool to import relational data into neo4j but that was normalized data where each table was represented by a certain type of node in the graph and foreign key relationships were converted to graph relationships. I don't know if that also handled m:n connection tables efficiently by converting them to relationships too. HTH Michael Am 08.10.2011 um 23:05 schrieb jiteshks: > I am very new to neo4j.So I don't know all of its features.I am reading its > documentation to understand how it works. > > My project's requirement is to import the data from a data warehouse( which > is an oracle db) once every month.We are thinking of implementing neo4j in > our project which means we will have to read the data from oracle db and put > it into neo4j. > There will be around 1 lakh rows(10^5) to be fetched from oracle db.What is > the fast/efficient way of doing it? > > Thanks! > > -- > View this message in context: > http://neo4j-community-discussions.438527.n3.nabble.com/Importing-data-from-oracle-to-neo4j-tp3406024p3406024.html > Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. > _______________________________________________ > Neo4j mailing list > [email protected] > https://lists.neo4j.org/mailman/listinfo/user _______________________________________________ Neo4j mailing list [email protected] https://lists.neo4j.org/mailman/listinfo/user
