MongoDB is a typical NoSQL database. Its document-oriented structure makes both storage and access convenient and efficient. But the database has rather weak computing ability. Computations on MongoDB data, particularly complex ones, are hard to handle. A data computing engine having powerful computing capability is needed to work with MongoDB to achieve relevant computing tasks.
The open-source esProc SPL is a specialized structured data computation engine. It supplies rich class libraries and all-around, database-independent computational capabilities. SPL has an independent procedural syntax that is particularly good at handling complex computations. It can help MongoDB increase its ability to compute, accomplish grouping & aggregation, joins, subqueries, and all the other computing tasks effortlessly.
Regular queries
It is easy to achieve JOINs MongoDB finds it difficult to handle in SPL:
SPL can reuse the result of handling data of a table that is repeatedly involved in computations:
Perform IN conditional query in SPL:
SPL’s technique to turn foreign key values to objects – the object-referencing foreign key – creates efficient foreign key pointers:
SPL achieves APPLY algorithm in a simple way:
SPL’s way of performing set-oriented calculations – intersection, union, difference and concatenation:
Get sequence number of a member in a sequence in SPL:
Perform intersection of multi-member collections in SPL:
Complex queries
Getting TopN in SPL:
Summarize a nested-structure collection in SPL:
Combine subdocuments made up of multiple attributes in SPL:
Query nested List subdocument in SPL:
SPL Cross-sector aggregation:
SPL segment-based grouping:
Data writing
Export data as CSV in SPL:
SPL database update (from MongoDB to MySQL):
SPL database update (from MySQL to MongoDB):
Mixed computations
SPL enables convenient mixed computation between MongoDB and another data source:
SQL support
Besides the native syntax, SPL offers support of SQL92 standard. You can use SQL to query MongoDB. To achieve the above join operation, for instance:
Integration into application
SPL provides standard JDBC/ODBC drivers through which SPL can be conveniently integrated into an application or invoked by it. To invoke SPL code through JDBC, for instance:
…
Class.forName("com.esproc.jdbc.InternalDriver");
Connection conn = DriverManager.getConnection("jdbc:esproc:local://");
PrepareStatement st=con.prepareStatement("call splScript(?)"); // splScript is the name of SPL script file
st.setObject(1,"California");
st.execute();
ResultSet rs = st.getResultSet();
…
With all those functionalities, you’ll sure to be impressed by MongoDB’s strikingly boosted computing ability. Try your hand now.
Top comments (0)