6senseAdobeAnt MoneyArculesCARFAXCignaCiscoComcastDBSDell TechnologiesDentsuDirectlyApplyErnst & Young EYFactors.AIFathom AnalyticsFirstEnergyGEGoldman SachsHeap | by ContentsquareHuluIMAXimpact.comKrogerLG InnotekLiveRampOpenDialogOutreachPalo Alto NetworksPicPayRBCSamsungSegMetricsSiemensSiriusXMSK TelecomSkaiSonySTCSunRunTATAThornZoomInfo

Huge performance benefits

SingleStore’s powerful query engine brings 100x faster queries to your JSON data.

Various under the hood optimizations give improved performance on aggregations like $count, $lookup and $group.

SingleStore Kai performance benefits
SingleStore Kai query

Zero-effort improvements

No need to transform your existing data. No need to modify your queries.

Send your existing MongoDB queries through your SingleStore instance, and we’ll work our magic to give you insights on your JSON data faster than you thought possible.

Forget complex system migrations. Get set up in minutes. Reduce query time by orders of magnitude.

Easy as 1, 2, 3

Get started in three easy steps.

SingleStore works around your existing tech stack — no complex migration required.

Step 1

Set up a link to your MongoDB® instance

1

db.runCommand({

2

createLink: "myLink",

3

uri: "mongodb+srv://admin:<password>@cluster0.gsdas.example.com?retryWrites=true&w=majority",

4

});

This uses Change Data Capture (CDC) to ingest historical data and sync the continuous changes.

Step 2

Change the endpoint to SingleStore Kai

1

const mongoUri = "<your-kai-endpoint>";

2

3

mongoose.connect(mongoUri, {

4

useNewUrlParser: true,

5

useUnifiedTopology: true

6

})

7

.then(() => {

8

console.log("connected!");

9

})

10

.catch((err) => {

11

console.error("connection error:", err);

12

});

Change the URI in your app logic to use your new SingleStore Kai endpoint.

Step 3

Execute your query in Mongo syntax

1

db.sales.aggregate([

2

{

3

$addFields: {

4

totalRevenue: {

5

$multiply: ["$price", "$quantity"]

6

}

7

}

8

},

9

{

10

$group: {

11

_id: "$category",

12

totalRevenue: {

13

$sum: "$totalRevenue"

14

}

15

}

16

},

17

{

18

$sort: {

19

totalRevenue: -1

20

}

21

}

22

]);

You're all set! Enjoy much faster analytics queries on MongoDB!

Explore some sample code

View some of our Jupyter Notebooks showing how to use SingleStore Kai.

Benefits

Diagram Previous Icon

No-effort migrations

Zero code changes and zero data transformations required for supported commands and operations

Bolt Icon

Faster aggregation queries

Faster aggregation queries on your JSON data without losing transactional performance

Arrows Maximize Icon

Scale-out

Natively scaled out solution that offers superior concurrency and query speeds for no extra cost

Chart Scatter 3 D Icon

AI + vector search on JSON data

Provide semantics on vectors using dot_product, euclidean_distance, and many other functions with native vector support

Circles Overlap Icon

Best of both worlds

Developers can utilize both the MongoDB® API and a SQL API to power their applications

Puzzle Icon

Interoperability

Even if you start building your application on Mongo, you can use SingleStore to get the most meaning from your data with your preferred tool or query language.

Browser Charts Icon

Aggregations

Run aggregations on data and improve performance for things like $count, $lookup and $group

Book a demo

Book a one-on-one session with a product expert to explore SingleStore