![tutorial how to use merlin project tutorial how to use merlin project](https://i.ytimg.com/vi/wyU9gn-dKUY/maxresdefault.jpg)
![tutorial how to use merlin project tutorial how to use merlin project](https://cdn.openpr.com/P/3/P30911468_g.jpg)
"All the relational options that we looked at would have taken a lot of developer time and resources to create the data models, properties and other information that we needed." SCALABILTY "The flexibility of the schema-less approach allowed us to very quickly design an implement a catalogue solution that fitted perfectly with the needs of Leroy Merlin," added Cerri. This also enables easy automatic categorisation, which is imperative for serving up the right products in the right places on the web site. MongoDB allows administrators to save the right product information, descriptions, technical details and attributes for each single item and family. There are approximately 1,200 product information updates made every single day.
![tutorial how to use merlin project tutorial how to use merlin project](http://www.icreativeideas.com/wp-content/uploads/2014/05/How-to-Make-Beautiful-Paper-Dandelions-thumb.jpg)
For instance, nuts and bolts come in a wide variety of shapes, sizes and metals, while bathroom taps have an entirely different set of attributes. Leroy Merlin stocks around 87,000 different products, all with different attributes and belonging to one of 1,000 different families and categories. "It's so intuitive that you can run everything with just five internet product managers and no database administrator." FLEXIBILITY "The way data is stored in MongoDB makes so much sense," explained Cerri. This engine runs like a query, but is hidden through a visual interface making it easy for non-developers to add products. MongoDB also provided flexibility to simplify adding new fields or updating existing information. This means that each product family can have the attributes it requires, and no more. MongoDB's document model and schema-less design enabled rapid development of Leroy Merlin's next-generation product catalogue and provided a solid platform for delivering information to the new web site.ĭavide Panelli, Solutions Architect at Byte-Code, said: "MongoDB is at least an order of magnitude faster than traditional SQL stores for the platform we are developing, both in terms of raw performance and ease-of-use for our development team." The developers were able to easily develop a rule engine to model product data and eliminate the empty or null fields that would have occurred in a relational database. MongoDB won due to its performance, scalability and flexibility. Why MongoDB?Īs part of the complete overhaul in 2010, Leroy Merlin and the technology partner Byte-Code evaluated and benchmarked several NoSQL databases. "Using a traditional SQL database and a old style product management platform, we would have had to enter all create every product class and table, and then enter all the product information by hand, which would be an impossible task with that much information," explained Cerri. It opted to develop from scratch a new site and product management platform to deliver accurate product information quickly. In 2010, Leroy Merlin Italy decided to completely scrap its existing web site, which only offered basic information and no catalogue. "When you're dealing with so many products and all their different attributes you need something that is very fast, flexible and scalable." "Our existing database was too rigid and the static data structure was making it increasingly difficult to manage and grow," said Cerri. Demand for online product and company information grew, and it quickly became clear to Giambattista Cerri, enterprise architect at Leroy Merlin Italy, that the existing, classic SQL database did not meet the company's needs. As the company rapidly grew its presence and offering in the Italian market, evolving customer and product needs led to new challenge. With more than 87,000 products spanning 1,000 different product families - and turning over approximately 20,000 products each year - just managing Leroy Merlin's Italian catalogue is a mammoth undertaking.
#Tutorial how to use merlin project full
Leroy Merlin Italy turned to MongoDB to unlock the full potential of an easy, flexible NoSQL solution to get new products loaded faster and more accurately. The company's online presence has grown exponentially over the last few years alongside its product catalogue. It boasts revenues of over €1bn, made possible by the dedication of more than 5,800 employees – 99 percent of whom are also shareholders in the company. Leroy Merlin has held a presence in Italy for more than 16 years and now has 49 stores in the region. The company owns more than 300 home improvement stores in 13 countries and specializes in sales of homeware products and solutions. As a major player in the worldwide home improvement market, Leroy Merlin helps residents and homeowners with their home-improvement projects.