Hi Dave, Thank you.
I was not aware that the mappings to tables were so natural or fine-grained. That's very helpful -- it brings up a big decision, do you want to import the pieces or the "things" that get assembled from them (or import the pieces and re-assemble them from your own queries. It seems like it depends on whether you are transitioning and dropping SQL or you want to reflect your data and do graph queries etc. Best, Hank BTW, has anyone noted that ML8 is like MongoDB on ACID ? On Thu, Jun 11, 2015 at 3:00 PM, Dave Cassel <[email protected]> wrote: > Hank, to get you started here's a set of mappings from the SQL ideas you're > familiar with to the analogous item in MarkLogic. (I should note that this > is due for an update.) I can also point you to MLSAM, a library used to > execute SQL queries and generate XML suitable for storing in MarkLogic. > > Here's a talk from 2013 about moving from Relational Modeling to XML. Here's > one from this year about Multi-Model Data Integration in the Real World. > > I'm sure others will chime in with additional resources. > > -- > Dave Cassel, @dmcassel > Developer Community Manager > MarkLogic Corporation > MarkLogic World Tour: > Houston, New York > > > From: Hank Ratzesberger <[email protected]> > Reply-To: MarkLogic Developer Discussion <[email protected]> > Date: Thursday, June 11, 2015 at 5:47 PM > To: MarkLogic Developer Discussion <[email protected]> > Subject: [MarkLogic Dev General] Transitioning from SQL > > Hello, > > We have several Oracle databases that we access through different > users/schemas and even Database Links. Altogether a fairly complex > data set. > > Our applications are mostly J2EE, so we have a lot of entities or we > could create others, that are complete objects representing the > "things" that the application is built on, for example, an Invoice > with all its Line Item and Funding documentation. We might be able to > use the Java API to iterate through these and serialize them to ML. > > Any white papers or case studies or your general feedback on how to > reap data from an SQL database into MarkLogic would be appreciated. > I've just begun to think about this, hopefully my question is not too > vague and with some feedback I can narrow my questions to something > more specific. > > Thank you, > Hank > > --Hank Ratzesberger > _______________________________________________ > General mailing list > [email protected] > Manage your subscription at: > http://developer.marklogic.com/mailman/listinfo/general > > > _______________________________________________ > General mailing list > [email protected] > Manage your subscription at: > http://developer.marklogic.com/mailman/listinfo/general > -- Hank Ratzesberger XMLWerks.com _______________________________________________ General mailing list [email protected] Manage your subscription at: http://developer.marklogic.com/mailman/listinfo/general
