Category: MongoDB
MMS • RSS
Posted on mongodb google news. Visit mongodb google news
Shares of MongoDB, Inc. (NASDAQ:MDB – Get Rating) have been assigned a consensus recommendation of “Moderate Buy” from the twenty-two ratings firms that are currently covering the firm, MarketBeat Ratings reports. Three investment analysts have rated the stock with a hold rating and seventeen have given a buy rating to the company. The average 1-year price objective among analysts that have covered the stock in the last year is $274.00.
Several brokerages recently commented on MDB. UBS Group raised their target price on MongoDB from $200.00 to $215.00 and gave the company a “buy” rating in a report on Wednesday, December 7th. Robert W. Baird lifted their target price on MongoDB from $205.00 to $230.00 in a research report on Wednesday, December 7th. Mizuho reduced their price objective on MongoDB from $190.00 to $170.00 and set a “neutral” rating for the company in a research report on Wednesday, December 7th. Credit Suisse Group reduced their price objective on MongoDB from $400.00 to $305.00 and set an “outperform” rating for the company in a research report on Wednesday, December 7th. Finally, JMP Securities upgraded MongoDB from a “market perform” rating to an “outperform” rating and set a $215.00 price objective for the company in a research report on Wednesday, December 7th.
Insiders Place Their Bets
In related news, Director Hope F. Cochran sold 1,175 shares of the business’s stock in a transaction on Thursday, December 15th. The shares were sold at an average price of $208.65, for a total value of $245,163.75. Following the transaction, the director now owns 7,674 shares in the company, valued at $1,601,180.10. The transaction was disclosed in a document filed with the SEC, which is available through this link. In other news, Director Hope F. Cochran sold 1,175 shares of the company’s stock in a transaction dated Thursday, December 15th. The shares were sold at an average price of $208.65, for a total transaction of $245,163.75. Following the transaction, the director now owns 7,674 shares in the company, valued at $1,601,180.10. The sale was disclosed in a document filed with the Securities & Exchange Commission, which is available through the SEC website. Also, CEO Dev Ittycheria sold 40,107 shares of the company’s stock in a transaction dated Monday, October 3rd. The stock was sold at an average price of $199.87, for a total transaction of $8,016,186.09. Following the completion of the sale, the chief executive officer now owns 194,646 shares in the company, valued at approximately $38,903,896.02. The disclosure for this sale can be found here. Over the last quarter, insiders have sold 59,846 shares of company stock valued at $11,956,703. 5.70% of the stock is currently owned by insiders.
Institutional Investors Weigh In On MongoDB
A number of institutional investors have recently added to or reduced their stakes in MDB. Price T Rowe Associates Inc. MD grew its position in shares of MongoDB by 0.3% during the 2nd quarter. Price T Rowe Associates Inc. MD now owns 8,258,298 shares of the company’s stock valued at $2,143,029,000 after acquiring an additional 24,197 shares during the period. Vanguard Group Inc. lifted its stake in MongoDB by 1.0% in the 3rd quarter. Vanguard Group Inc. now owns 6,127,231 shares of the company’s stock worth $1,216,623,000 after purchasing an additional 62,303 shares in the last quarter. State Street Corp lifted its stake in MongoDB by 1.8% in the 3rd quarter. State Street Corp now owns 1,349,260 shares of the company’s stock worth $267,909,000 after purchasing an additional 23,846 shares in the last quarter. Franklin Resources Inc. lifted its stake in MongoDB by 10.1% in the 2nd quarter. Franklin Resources Inc. now owns 1,346,625 shares of the company’s stock worth $349,449,000 after purchasing an additional 123,431 shares in the last quarter. Finally, 1832 Asset Management L.P. lifted its stake in MongoDB by 19.3% in the 1st quarter. 1832 Asset Management L.P. now owns 1,028,400 shares of the company’s stock worth $450,095,000 after purchasing an additional 166,400 shares in the last quarter. 84.86% of the stock is owned by institutional investors.
MongoDB Stock Performance
MongoDB stock opened at $196.84 on Friday. The stock’s 50-day moving average is $174.78 and its 200-day moving average is $237.66. The company has a market cap of $13.64 billion, a price-to-earnings ratio of -36.66 and a beta of 1.02. The company has a debt-to-equity ratio of 1.66, a current ratio of 4.10 and a quick ratio of 4.10. MongoDB has a 12 month low of $135.15 and a 12 month high of $538.08.
MongoDB Company Profile
MongoDB, Inc provides general purpose database platform worldwide. The company offers MongoDB Enterprise Advanced, a commercial database server for enterprise customers to run in the cloud, on-premise, or in a hybrid environment; MongoDB Atlas, a hosted multi-cloud database-as-a-service solution; and Community Server, a free-to-download version of its database, which includes the functionality that developers need to get started with MongoDB.
Recommended Stories
Receive News & Ratings for MongoDB Daily – Enter your email address below to receive a concise daily summary of the latest news and analysts’ ratings for MongoDB and related companies with MarketBeat.com’s FREE daily email newsletter.
Article originally posted on mongodb google news. Visit mongodb google news
MMS • RSS
Posted on mongodb google news. Visit mongodb google news
Shares of MongoDB, Inc. (NASDAQ:MDB – Get Rating) have been given an average rating of “Moderate Buy” by the twenty-two brokerages that are covering the company, MarketBeat reports. Three analysts have rated the stock with a hold rating and seventeen have assigned a buy rating to the company. The average 1-year price target among brokers that have issued ratings on the stock in the last year is $274.00.
MDB has been the topic of several recent research reports. Canaccord Genuity Group reduced their target price on shares of MongoDB from $300.00 to $270.00 and set a “buy” rating on the stock in a report on Wednesday, December 7th. Piper Sandler cut their price target on shares of MongoDB from $350.00 to $270.00 and set an “overweight” rating on the stock in a report on Thursday, October 20th. Tigress Financial cut their target price on shares of MongoDB from $575.00 to $365.00 and set a “buy” rating on the stock in a research note on Thursday, December 15th. Robert W. Baird lifted their target price on shares of MongoDB from $205.00 to $230.00 in a research note on Wednesday, December 7th. Finally, Redburn Partners raised shares of MongoDB from a “sell” rating to a “neutral” rating in a research report on Tuesday, October 18th.
MongoDB Stock Performance
Shares of MDB stock opened at $196.84 on Friday. The stock has a market capitalization of $13.64 billion, a P/E ratio of -36.66 and a beta of 1.02. The company has a current ratio of 4.10, a quick ratio of 4.10 and a debt-to-equity ratio of 1.66. The firm’s 50 day moving average is $174.78 and its 200 day moving average is $237.66. MongoDB has a 12 month low of $135.15 and a 12 month high of $538.08.
Insider Transactions at MongoDB
In related news, CEO Dev Ittycheria sold 40,107 shares of MongoDB stock in a transaction on Monday, October 3rd. The stock was sold at an average price of $199.87, for a total value of $8,016,186.09. Following the transaction, the chief executive officer now directly owns 194,646 shares in the company, valued at approximately $38,903,896.02. The sale was disclosed in a legal filing with the Securities & Exchange Commission, which is accessible through this hyperlink. In other MongoDB news, CEO Dev Ittycheria sold 40,107 shares of the business’s stock in a transaction dated Monday, October 3rd. The stock was sold at an average price of $199.87, for a total value of $8,016,186.09. Following the completion of the sale, the chief executive officer now owns 194,646 shares of the company’s stock, valued at $38,903,896.02. The sale was disclosed in a legal filing with the Securities & Exchange Commission, which is available through this link. Also, Director Hope F. Cochran sold 1,175 shares of the business’s stock in a transaction dated Thursday, December 15th. The stock was sold at an average price of $208.65, for a total value of $245,163.75. Following the transaction, the director now directly owns 7,674 shares of the company’s stock, valued at approximately $1,601,180.10. The disclosure for this sale can be found here. In the last 90 days, insiders have sold 59,846 shares of company stock valued at $11,956,703. Corporate insiders own 5.70% of the company’s stock.
Institutional Investors Weigh In On MongoDB
Large investors have recently bought and sold shares of the business. John W. Brooker & Co. CPAs acquired a new position in shares of MongoDB in the 2nd quarter valued at $26,000. Prentice Wealth Management LLC bought a new position in MongoDB during the 2nd quarter worth about $26,000. Venture Visionary Partners LLC bought a new position in MongoDB during the 2nd quarter worth about $28,000. FNY Investment Advisers LLC bought a new position in MongoDB during the 2nd quarter worth about $41,000. Finally, UMB Bank n.a. increased its holdings in MongoDB by 422.6% during the 2nd quarter. UMB Bank n.a. now owns 162 shares of the company’s stock worth $42,000 after purchasing an additional 131 shares in the last quarter. 84.86% of the stock is currently owned by institutional investors.
MongoDB Company Profile
MongoDB, Inc provides general purpose database platform worldwide. The company offers MongoDB Enterprise Advanced, a commercial database server for enterprise customers to run in the cloud, on-premise, or in a hybrid environment; MongoDB Atlas, a hosted multi-cloud database-as-a-service solution; and Community Server, a free-to-download version of its database, which includes the functionality that developers need to get started with MongoDB.
Recommended Stories
This instant news alert was generated by narrative science technology and financial data from MarketBeat in order to provide readers with the fastest and most accurate reporting. This story was reviewed by MarketBeat’s editorial team prior to publication. Please send any questions or comments about this story to contact@marketbeat.com.
Before you consider MongoDB, you’ll want to hear this.
MarketBeat keeps track of Wall Street’s top-rated and best performing research analysts and the stocks they recommend to their clients on a daily basis. MarketBeat has identified the five stocks that top analysts are quietly whispering to their clients to buy now before the broader market catches on… and MongoDB wasn’t on the list.
While MongoDB currently has a “Moderate Buy” rating among analysts, top-rated analysts believe these five stocks are better buys.
Article originally posted on mongodb google news. Visit mongodb google news
MMS • RSS
Article originally posted on InfoQ. Visit InfoQ
The ability for users to directly query and explore data has long been a hallmark of professional databases. With a vendor supplied tool and a basic understanding of SQL, users can query any type of data without extensive training in that particular product. The main exception to this is the so-called NoSQL databases. With each NoSQL database needing its own specialized syntax, training costs can skyrocket.
Studio 3T seeks to address this by providing an SQL-based user interface. This user interface looks remarkably similar to what you would find in SQL Server Management Studio or PosgreSQL’s pgAdmin. It has the standard thee-panel layout with the list of the collections on the left, an SQL editor on the top-right, and the results pane on the bottom-right.
Like many SQL-based tools, you can directly edit records in Studio 3T. While this can be useful for manual data correction, normally one would set the tool into “read-only mode” when connecting to a production database to reduce the risk of making a mistake.
SQL to JavaScript (node.JS), Java, Python, and C# Code
A unique feature of Studio 3T is the ability to convert SQL to language specific code. After verifying the query is working, you can switch the to “Query Code” tab to see what it would look like in JavaScript (node.JS), Java, Python, or C#. Besides being a useful training tool, this can save a lot of time that would otherwise be spent running lengthy integration tests.
Developers using this feature should also take advantage of the “explain query” support. As in other database engines, this will give you important information about the expected performance characteristics of the query.
Joins for MongoDB
Studio 3T adds new features fairly frequently and among the more recent updates is the ability to perform SQL-style inner and left joins against MongoDB data sets.
These joins are expressed in MongoDB’s native query language using the $lookup operator. This creates some limitations some limitations in the SQL implementation. While multiple joins are supported, each join can only reference tables to the left of it. Or in other words, right joins are not supported. Likewise full joins cannot be used.
Other SQL Features
Studio 3T’s SQL support also includes:
- GROUP BY, ORDER BY and Aggregate Functions
- Limit and Offset (i.e. data pagination)
- Wildcards using LIKE
- Testing If a Value Is a Member of a Set using IN
- Testing If a Value Lies within a Range using BETWEEN
- Accessing Embedded Fields Using Dotted Names
This last one allows you to use standard OOP style dot-notation to read child fields. For example, to read a zip code you would use "address.zip_code". As with many database engines, field names may be surrounded with brackets or double quotes. Single quotes are used for string literals.
The SQL Query and Query Code generation features require the Studio 3T Pro version.
MMS • Raul Salas
This is a quick blogpost from notes that i have gathered over time. There may be situations where support staff might be restricted from logging directly into a Mongodb instance. But there may also be a requirement for support staff to get information on the status of Mongodb environments, especially users of the Community version of Mongodb. These commands could also be run via a shell script as well that would allow a sysadmin to automate these commands into a daily routine.
You can quickly obtain information by executing the following commands:
mongo –port –username <username> –password <password> –authenticationDatabase admin –eval “mongo command”
Of course you will need to add the required authentication parameters relevant to your installation.
Obtaining host information – you can execute the mongo shell command along with some configuration options such as database, authenticatioen, and the –eval command followed by the actual mongo command you want to execute. The command is broken into the following parameters:
I setup a quick test environment, so no need to use any authentication parameters, but you can see how to execute the command and the associated output. You can see the version along with the host as well as os information.
$ mongo –eval “db.hostInfo()”
MongoDB shell version v3.4.9
connecting to: mongodb://127.0.0.1:27017/test_db
MongoDB server version: 3.4.9
{
“system” : {
“currentTime” : ISODate(“2017-10-23T20:50:43.959Z”),
“hostname” : “MacBook.local”,
“cpuAddrSize” : 64,
“memSizeMB” : 16384,
“numCores” : 8,
“cpuArch” : “x86_64”,
“numaEnabled” : false
},
“os” : {
“type” : “Darwin”,
“name” : “Mac OS X”,
“version” : “16.7.0”
},
“extra” : {
“versionString” : “Darwin Kernel Version 16.7.0: T4”,
“alwaysFullSync” : 0,
“nfsAsync” : 0,
“model” : “MacBook,3”,
“physicalCores” : 4,
“cpuFrequencyMHz” : 2900,
“cpuString” : “Intel(R) Core(TM) i7-7820HQ CPU @ 2.90GHz”,
“cpuFeatures” : “FPU VME DE PSE TSC MSR PAE MCE CX8 APIC SEP MTRR PGE MCA CMOV PAT PSE36 CLFSH DS ACPI MMX FXSR SSE SSE2 SS HTT TM PBE SSE3 PCLMULQDQ DTES64 MON DSCPL VMX SMX EST TM2 SSSE3 FMA CX16 TPR PDCM SSE4.1 SSE4.2 x2APIC MOVBE POPCNT AES PCID XSAVE OSXSAVE SEGLIM64 TSCTMR AVX1.0 RDRAND F16C SYSCALL XD 1GBPAGE EM64T LAHF LZCNT PREFETCHW RDTSCP TSCI”,
“pageSize” : 4096,
“scheduler” : “multiq”
},
“ok” : 1
}
Now, you would like to see what databases reside on this particular host with the listDatabases command.
$ mongo –eval “printjson(db.adminCommand( { listDatabases: 1 } ))”
MongoDB shell version v3.4.9
connecting to: mongodb://127.0.0.1:27017
MongoDB server version: 3.4.9
{
“databases” : [
{
“name” : “admin”,
“sizeOnDisk” : 49152,
“empty” : false
},
{
“name” : “local”,
“sizeOnDisk” : 65536,
“empty” : false
},
{
“name” : “test_db”,
“sizeOnDisk” : 65536,
“empty” : false
}
],
“totalSize” : 180224,
“ok” : 1
}
If you would like to see the collections within the database test_db, you can issue the following command to get a list of collections in json format.
$ mongo test_db –eval “printjson(db.getCollectionNames())”
MongoDB shell version v3.4.9
connecting to: mongodb://127.0.0.1:27017/test_db
MongoDB server version: 3.4.9
[ “cities”, “names” ]
That’s a quick overview of what can be done at the command line. For a more comprehensive list of commands, you can use the db.help() option to get a list of commands
As you can see it’s pretty comprehensive and is valuable for a sys admin and/or database administrator to get a quick picture of your Mongodb environment.
$ mongo test_db –eval “db.help()”
MongoDB shell version v3.4.9
connecting to: mongodb://127.0.0.1:27017/test_db
MongoDB server version: 3.4.9
DB methods:
db.adminCommand(nameOrDocument) – switches to ‘admin’ db, and runs command [ just calls db.runCommand(…) ]
db.auth(username, password)
db.cloneDatabase(fromhost)
db.commandHelp(name) returns the help for the command
db.copyDatabase(fromdb, todb, fromhost)
db.createCollection(name, { size : …, capped : …, max : … } )
db.createView(name, viewOn, [ { $operator: {…}}, … ], { viewOptions } )
db.createUser(userDocument)
db.currentOp() displays currently executing operations in the db
db.dropDatabase()
db.eval() – deprecated
db.fsyncLock() flush data to disk and lock server for backups
db.fsyncUnlock() unlocks server following a db.fsyncLock()
db.getCollection(cname) same as db[‘cname’] or db.cname
db.getCollectionInfos([filter]) – returns a list that contains the names and options of the db’s collections
db.getCollectionNames()
db.getLastError() – just returns the err msg string
db.getLastErrorObj() – return full status object
db.getLogComponents()
db.getMongo() get the server connection object
db.getMongo().setSlaveOk() allow queries on a replication slave server
db.getName()
db.getPrevError()
db.getProfilingLevel() – deprecated
db.getProfilingStatus() – returns if profiling is on and slow threshold
db.getReplicationInfo()
db.getSiblingDB(name) get the db at the same server as this one
db.getWriteConcern() – returns the write concern used for any operations on this db, inherited from server object if set
db.hostInfo() get details about the server’s host
db.isMaster() check replica primary status
db.killOp(opid) kills the current operation in the db
db.listCommands() lists all the db commands
db.loadServerScripts() loads all the scripts in db.system.js
db.logout()
db.printCollectionStats()
db.printReplicationInfo()
db.printShardingStatus()
db.printSlaveReplicationInfo()
db.dropUser(username)
db.repairDatabase()
db.resetError()
db.runCommand(cmdObj) run a database command. if cmdObj is a string, turns it into { cmdObj : 1 }
db.serverStatus()
db.setLogLevel(level,<component>)
db.setProfilingLevel(level,<slowms>) 0=off 1=slow 2=all
db.setWriteConcern( <write concern doc> ) – sets the write concern for writes to the db
db.unsetWriteConcern( <write concern doc> ) – unsets the write concern for writes to the db
db.setVerboseShell(flag) display extra information in shell output
db.shutdownServer()
db.stats()
db.version() current version of the server
Command line execution of Mongodb commands allows support staff to quickly obtain information on the Mongodb environment without running the risk of accidentally causing disruption of service
RAUL SALAS Raul@mobilemonitoringsolutions.com