What is NoSQL?

NoSQL refers to database management systems that follow a non-relational approach and thus use no fixed table schemas. This means that joins, i.e. the compilation of information from different tables, can be avoided. This significantly increases the query speed and enables a higher horizontal scaling of the database.

 

When does soXes rely on NoSQL?

Relational databases often reach their performance limits in data-intensive applications. This is the case, for example, with websites with high load volumes and streaming media applications. Database systems with a NoSQL architecture, on the other hand, offer high performance potential with many read/write requests.

 

Where has soXes used NoSQL?

soXes has used a NoSQL database management system, for example, in the development of the MyPortaNet application. The digitalised measurement and information system for windows, doors and gates generates large amounts of data. Because of the many write and read requests of the Internet of Things solution, a MongoDB database was used, among other things, to meet the performance requirements.

 

Why soXes?

With soXes you gain a partner with competence and reliability. For 20 years, our company has stood for the best quality in the development, programming and outsourcing of software. With its services, soXes covers the entire life cycle of an IT development (conception, consulting, development and support). Take the first step towards the successful implementation of your project and contact us for more information.

Your direct contact:

Patrick Büchler

Patrick Büchler
CTO

Reference Projects NoSQL
Celsius Pro
Kunde: CelsiusPro AG
Applikation: Celsius Pro
Technologie: C#, .NET, Python, Web services, Mongo DB, Big Data, DotNetNuke

CelsiusPro is the leading provider of weather derivatives in Europe. CelsiusPro's products enable companies to protect themselves against weather-related risks.

In order for a business model of this complexity to work, a large number of components must interact: Weather data from hundreds of global weather stations must be converted into a uniform format and their retrieval must be made efficient. Statistics and probabilities of weather events are computed and prices are calculated based on them. Prices for the weather derivatives can be queried and purchased via a web portal. CelsiusPro employees also manage customers and products within this platform.

For this task CelsiusPro relies on a completely individually developed environment that seamlessly combines the .NET Framework with the programming language Python, which is well known from the open source scene. While the website and the back office system are programmed in C# and are based on DotNetNuke, the price engine and the system for loading weather data is based on Python. A web service, which allows the calculation of a price via internet, combines both languages even within one program. Python becomes IronPython (the implementation of Python in the .NET Framework). The system is freely configurable and allows the creation of new products, pricing engines and the connection of new weather stations.

Visit the website www.celsiuspro.com and see for yourself how a combination of the programming languages IronPython and C# covers the requirements of a state-of-the-art web application including a mathematically complex pricing engine. Within this project, soXes is responsible for the entire environment and continuously develops the platform further.

Payment Modul
Kunde: Start Up
Applikation: Payment Modul
Technologie: .NET, C#, ASP.NET, Blockchain

In this project, soXes had the project lead for a young and successful start-up company in the field of cryptocurrency. A back office developed by a third party company was to be expanded cost-effectively and successfully. 

Within the scope of this project, soXes developed the payment module, which can be accessed via the web. The user then has the possibility to pay his bills via Bitcoin or Ethereum currencies. The data is transferred via an intelligent interface to the existing back office.

We at soXes have also developed the KYC (Know your Customer) module for our customer, where users can fill in their personal information and upload documents such as passport or ID. The admin can view the uploaded data from the users online and unlock the users.

soXes sat down with the third party company and defined the interface together in several meetings to enable a smooth integration into the existing back office.

The project was successfully implemented thanks to the in-depth knowledge of all parties involved in the area of crypto currency and IT. This enabled the young start-up company to take another important milestone in the company's success. 

TUS AIN
Kunde: TUS - Telekommunikation und Sicherheit
Applikation: TUS AIN
Technologie: Graylog Cluster, Microservices, Redis Sentinel, Nginx, Galera Cluster, JSON, Push-pull Methodik, Data Loss Prevention, Split Brain Prevention

In the sixties of the last century, the then PTT was looking for strong partners to operate and finance an alarm transmission service in Switzerland. Securiton AG and Cerberus AG (now Siemens Schweiz AG, Building Technologies) took up the challenge. In 1968 they founded the interest group TUS Telekommunikation und Sicherheit. The pioneering spirit was rewarded: Thanks to constant technical innovations and considerable investments, TUS today presents itself as a modern and efficient multi-technology provider with brilliant future prospects.

TUS AIN (Automatic Intelligent Notification) was developed in order to bring the notification of system faults and alarms, which until then had mainly been personalised, to more modern technologies such as SMS, push, email, pager and automated voice call. In this way, a notification can be automatically sent by TUS AIN to the responsible alarm recipients and to the desired medium. If required, it can also be displayed and edited via a mobile app. A high-performance IP-based network is used to transmit the messages.

TUS AIN is supplied by the TUS alarmDispatcher system with information on the status of the subscriber terminals and their sensors and is mainly used as a notification centre that can be configured in great detail.

The following technologies and solutions are used specifically: Graylog Cluster, Microservices - including Log Service, Notification Service, System Monitoring (PRTG and others), Redis Sentinel, Nginx, Galera Cluster, JSON, Push-pull Methodology, Data Loss Prevention, Split Brain Prevention.

TUS BatchMerger (BTM)
Kunde: TUS - Telecommunications and Security
Applikation: TUS BatchMerger (BTM)
Technologie: .NET, SQL, C#

In the sixties of the last century, the then PTT was looking for strong partners to operate and finance an alarm transmission service in Switzerland. Securiton AG and Cerberus AG (now Siemens Schweiz AG, Building Technologies) took up the challenge. In 1968 they founded the interest group TUS Telekommunikation und Sicherheit. The pioneering spirit was rewarded: Thanks to constant technical innovations and considerable investments, TUS today presents itself as a modern and efficient multi-technology provider with interesting prospects for the future.

The TUS BatchMerger (BTM) is mainly used as a data supplier of the object configuration for the TUS Automatic Intelligent Notification (AIN) system. The object data comes from two different ERPs and three different locations in Zurich, Lausanne and Lugano. In the first stage of expansion, a UI is still being used for processing the object data, but this UI will be removed later. The object data can be enriched with additional information in the BTM or cleansed of superfluous information.

The ERP object data is loaded cyclically into the BTM and then prepared for processing in the BTM UI. All actions on the object data are historized in order to detect changes to the ERP data and then pass the adjustments on to BTM.

The BTM runs as a classic .NET MVC Client Server application with a MS SQL database server in the background.

With the introduction of TUS AIN, the change to the new media for notifications is completed, which is a great relief for TUS.

 

Wiegand
Kunde: Wiegand AG
Applikation: Wiegand
Technologie: JAVA, SOA, SQL, Java Script, Angular JS, Python, Phone Gap, Mobile, Unit Test, Build Server

Wiegand AG, based in Bülach, specializes in drug management and hospital logistics. It develops concepts for medication processes, storage and transport of medication and consumables in hospitals and homes.
 
In a comprehensive IT project of more than 2 years duration, with a team of 7 developers, Wiegand AG has commissioned soXes to develop a secure, fast and reliable system that ensures the management of medication in hospitals. This comprehensive system is based on four pillars: WMCC (central management server) WMPS (directional station), WM5R (mobile device for dispensing) and the MedManager Cockpit (WMCP)
 
The WMPS straightening station is primarily concerned with the electronic support of the set-up or preparation of medication. Via 2D barcode readers, all medications for straightening are identified and managed - including LOT and expiry dates, if available. Step by step, the straightening station guides the nursing staff both when straightening medication into the distribution dispenser and when providing individual medication. The electronic prescription provides information about the medication, preparation and dispensing. Straightening and dispensing activities are compared with the time axis. Traffic light functions signal the urgency status of the activities.
 
WM5R is a mobile app that runs on various operating systems and devices. It ensures that medication can be traced back to the patient's bedside, thus ensuring traceability and medication safety by allowing the dispensing process to be logged directly at the patient's bedside. The WM5R app implements the 5-R rule: right patient, right drug, right dosage, right application, right time.  Both the entries from the WMPS and the WM5R are automatically fed back into the hospital system.
 
The WMM environment can be managed with the web application WMCP Cockpit. In addition to user and group administration and an overview of patients and prescriptions, this includes a very large part of logistics. The entire supply of the pharmacy and central warehouse as well as the ward can be monitored and coordinated via WMCP. The staff has an overview of the stock levels of all wards everywhere and at any time via a web-based interface. Orders are automatically triggered or manually released and transmitted to the purchasing system. Thus, every material movement is automatically saved (date, user, patient). Evaluations per package, LOT, expiration date, etc. make it possible to trace the movements in detail. The automatic ordering procedure is a central component of this solution and is implemented based on three principles:
1. directional station: according to the dispensations (consumption), the system determines a forecast of the future demand for a drug.
2. kanban: orders are automatically triggered when stock levels fall below a certain level.
3. autoinventory: special cabinets with scales, especially for consumables, allow a completely automatic warehouse, which determines the stock and the necessary orders by weight.
 
The Wiegand drug management system is based on the Java programming language with a PostgreSQL database in the background for WMCC and WMPS. The WMCP was implemented with Python on the server and AngularJS, Bootstrap and HTML5 on the frontend. The WM5R app runs under Phonegap (Apache Cordova) on all major mobile platforms. Throughout Switzerland, the system has already been successfully implemented in several hospitals and connected to the local hospital information and prescription system, while maintaining the HL7 (Health Level 7 an international standard for the exchange of data between health care organizations and their computer systems) standard.

 

MyPortaNet
google_store
apple_store
Kunde: PortaNet AG
Applikation: MyPortaNet
Technologie: Android, Angular, C#, C++, IOS, Mongo, MySQL, PHP, Python, Bluetooth, Bluetooth LE, Lora, Lorawan, Greylog, Microservices, Redis, Nginx, HTML5, Django, JSon

Together with our customer PortaNet AG from Emmen, we at soXes GmbH have developed a digitalized measuring and information system for windows, doors and gates. Now, windows and doors can be digitized very easily; with a complete cloud solution based on low-power/wide-area technology.

MyPortaNet automatically measures, controls and administrates the complete usage process with information, fault reports and maintenance activities. If a service is due or if a door is open which should be closed, the system automatically signals the status or service requirement. This digital measurement data thus helps companies (but also private individuals) in particular to better design their processes, provide targeted services for their customers, reduce costs and save time, optimize repairs and maintenance of doors and windows and, last but not least, increase security.

PortaNet recognized the pulse of time early on: The earlier you jump on the bandwagon of digitalization, the more interesting your own competitive advantages and those of your customers will be. Soon the idea and vision was there to automatically control and administer the complete usage process of doors and windows with information, fault reports and maintenance activities thanks to the new possibilities of IoT (Internet of Things). Because the Internet of Things opens up completely new possibilities and added value for users in this area as well. 

Possible areas of application are very diverse, for example:

  • - Building security is increased as broken/accidentally open windows are reported early.
  • - Information on the condition and (wear and tear) of building components can be collected.
  • - Inspection tours can be significantly minimized.
  • - Heating costs can be reduced because open windows are quickly detected.
  • - The schedule for cleaning the toilets or meeting rooms can be adjusted according to the use of thesen.

Would you also like to use the IoT potential for your company within your industry?
Are you looking for successful developers to implement your IoT project?

We would be happy to support you in all aspects of the Internet of Things (IoT) and show you directly with further examples how you can digitalize your business processes. 

We at soXes look forward to many more success stories in the area of Internet of Things, where we can contribute our expertise and many years of experience in the design and development of IoT projects. Because we accompany our customers from the beginning to the successful implementation from A to Z.

Our experts and developers are there for you and will answer your questions in a non-binding discussion. Contact our consultants now at 055 253 00 53 or solutions@soxes.ch

Relevant Topics
cloud button Cloud View
list button List View

Testimonials

 
Our dedicated soXes team helps us to successfully develop Prisma World further. A big thank you to the IT professionals. Dr. J. P. Pflüger, CEO Prisma World AG
soXes convinces us with its agility paired with broad and deep know-how for complex software developments. Markus Wiegand, CEO Wiegand AG
soXes has always managed our projects to our satisfaction. CorXL Ltd. JPD Dr. med. Jan Steffel, Senior Physician Cardiology / Rhythmology at the University Hospital Zurich
With soXes we know that we are in very good hands. Belinda Stublia, Lucullus SA
The soXes team convinces with its incredible commitment and passion. Argjent Ukshini, IT Project Manager Customer Service Electrolux Schweiz AG
soXes has shown to be a very professional partner and we value their responsiveness, quick turnarounds and enthusiastic work ethics. Patrick Brigger, Co-founder & Chairman, getAbstract
We have been working successfully with soXes for over 10 years. The professionalism and flexibility of soXes continues to convince us. Mark Rüegg, CEO CelsiusPro AG
With competence, commitment and energy, soXes opens the way to success. Cornelia Nestic, Associate Director, HypothekenZentrum AG
The cooperation with the soXes project managers of my project is markedly cooperative and open. soXes shows the flexibility and agility required for such projects. For me, this is a decisive factor for the success of the project. Dan Keller, Manager Major Projects, TUS Telekommunikation und Sicherheit
With soXes at our side, we have succeeded in breaking new ground in software technology, Bruno Schmed, Member of the Executive Board, T&N Telekom und Netzwerk AG
At soXes we get competence and professional results - at any time in a completely uncomplicated way, Simon Keel, Chief Technology Officer, Tolomeo Capital AG
soXes convinces in projects with experienced solutions and close customer contact. Roman Aebi, CEO Cenprom AG
soxes has implemented our ideas into an overall solution: professional, timely and at a fair price. Andreas Lehmann, CEO, PortaNet AG
soXes has demonstrated great expertise and commitment to the complex overall IoT solution with LoRaWAN and NFC. This, and the well structured cooperation were the basis for the simplicity that distinguishes MyPortaNet. Christoph Röthlisberger, IoT/Industry 4.0, PortaNet AG

 

Are you looking for a company that offers you effective support and consulting in the implementation and support of your software projects?


Our services cover the entire life cycle of an IT solution as well as the entire spectrum of modern software development.


From business and process analysis, IT architecture to implementation. From commissioning to support. You benefit from our specialist knowledge and our experts.

With over 150 successful development projects and more than 80 active customers, we have the experience and you have the idea.

Notice

Our website uses cookies to ensure the best possible service. By using the site, you agree to the use of cookies. You can change this in your browser settings. Privacy Policy.