Software design with a strong focus on continuous
feedback, lean processes and reusable components.

We have a passion

to provide high quality software design and consulting services with a focus on reusability, modern architectures, delivered using lean processes in close collaboration with the customer.

We are a great team

with experts in various areas from Semantic Web and database optimization, to scalable architectures and functional programming. In addition to this we maintain a portfolio of battle-proven high quality open source frameworks.

Our customers

are large international companies like Comptel and QPR, startups like Balancion, public institutions like the National Board of Antiquities and the City of Helsinki, as well as research entities like the The Finnish Literature Society and the Society of Swedish Literature.

Showcases

Work

Edith

The Finnish Literature Society needed an XML document annotation tool for their researchers.

Literature researchers use XML documents in TEI-format that contain the subjects of their research in digital format. No suitable tool was available on the market, so Edith was born.

Working on these texts is a collaborative effort where researchers enrich the text with different kinds of information. Like explaining what "verranvastaiset" means in Nummisuutarit, a play by Aleksis Kivi, this play was the first publication for which Edith was used.

Mysema worked with the Finnish Literature Society from the very start and built the Edith annotation tool in short iterations.

Tapestry Hibernate Subversion Querydsl MySQL

http://www.finlit.fi

Comptel

Mysema helped Comptel migrate their existing product user interfaces from the Flash-based framework to a more modern architecture using HTML and JavaScript. We participated in the initial design of the new architecture and picked frameworks such as Backbone.js, jQuery and RequireJS to be used as the foundation for the new user interfaces.

We also participated in the product development of Social Links, which was purchased via the acqusition of Xtract. We wrote a functional demo of the product which was presented at the Mobile World Congress 2012 in Barcelona. After the acquisition of Xtract we participated in the product development of Social Links.

jQuery Backbone RequireJS SmartGWT

http://www.comptel.com

Linked Events

Forum Virium develops new digital services in cooperation with companies.

Mysema worked with Forum Virium to create Linked Events. It tries to solve a problem where event providers have event data in many different formats and no common way to publish them exist.

The idea is to gather and normalize the event data and publish it as open data to all interested parties. Currently the main source for event and place data is the Helsinki City Tourist & Convention Bureau.

The REST API provides data in JSON and JSON-LD, the latter is especially good for users that need the additional semantics.

Clojure MySQL Korma Noir Elastic Search

http://events.hubi.fi/

Helsinki Region Infoshare

As a part of the Helsinki Region Infoshare effort Mysema created the Semantic.hri.fi application. It provides a Linked Open Data view of the Aluesarjat statistics. Aluesarjat includes population, construction and employment statistics of the Finnish capital region.

Semantic.hri.fi provides a faceted search interface to navigate the statistical data and a Google Maps based interface to display selected statistics and external metadata of town parts. Both of these are built on top of a SPARQL endpoint.

Semantic.hri.fi provides relations between different types of statistics through the properties they share, e.g. all statistics of some area and year, thus one can make searches over diverse statistical information.

RDF Querydsl jQuery Google Maps

semantic.hri.fi

Suomen Museot Online

The National Board of Antiquities preserves Finland's cultural heritage material by collecting, studying and by distributing knowledge of it.

Mysema created Suomen Museot Online, a browsable database of almost 200 thousand items. It gathers data from almost 50 Finnish museums. The data is indexed into Lucene to provide fast access to our national heritage.

In addition to the public search interface, Mysema has created an OAI-PMH interface that is used by The National Digital Library to harvest the information into their own system. The National Digital Library has integrated with Europeana, so it is also available there.

Lucene Spring RDF OAI-PMH LIDO OAI-DC

suomenmuseotonline.fi

Balancion

Balancion is a Finnish start-up that is building a web application for managing personal finances. User's transaction information is retrieved from several different online banks, the information is automatically categorized into relevant categories by a machine learning algorithm.

Balancion was on a tight schedule especially because the work had stopped due to the challenges the previous vendor had faced. Mysema professionals revised the software design and thus Balancion was launched on time.

The development involved several interesting challenges. First of all because Finnish online banks do not offer public APIs financial data is gathered with complex screen scraping. And second due to the confidentiality of the users' data the development work has very high security and privacy requirements.

Spring Hibernate Lucene Querydsl MySQL

www.balancion.fi

ERP/Solita

Mysema participated in an ERP project for a large Finnish customer in the magazine distribution business as a subcontractor of Solita. We participated in the design, implementation and data migration parts of the project.

During this project Mysema developed a data migration tool to transfer data from the old system to the new one. Existing related commercial software, such as Oracle Warehouse Builder, weren't flexible enough to adapt to the fast changing schema of the target model. The lightweight and agile ETL-tool enabled cost-effective data migration.

Spring Hibernate Lucene Oracle

www.solita.fi

LibNet/BDO

As a subcontracter of BDO (formerly known as A-ware) Mysema was responsible to a high degree for the design and implementation of the LibNet service, a web based magazine ordering system. The implementation happened during spring to summer 2006 and after that Mysema took care of the maintenance and change requests until spring 2007. The service integrates all features related to journal subscription handling such as issue search, subscription, arrival tracking, circulation list management, reclamation, subscription renewal, reporting and expense tracking.

The end customer was LM Information Delivery which is one of Europe’s leading subscription and information services providers. Their company offers cost-efficient and time-saving solutions in subscription management to over 10,000 customers across Europe.

Spring Hibernate JasperReports SQL Server

LibNet

QPR

QPR offers business process optimization services and products to its customers. Products include modeling and analysis tools and related consulting.

Mysema helped QPR to evaluate the feasibility of using Java for interfacing with SAP ERP systems for data extraction and loading. We designed a method for automated data extraction from multiple external SAP ERP systems.

SAP Java

www.qpr.com

Products

Querydsl

We were not satisfied with any of the query abstractions for Java, so we created Querydsl. Querydsl is a framework which enables the construction of type-safe SQL-like queries for multiple backends including JPA, MongoDB, JDO and SQL.

It is licensed as open source under the liberal Apache License 2.0, used in multiple critical production systems and has thousands of users around the world.

www.querydsl.com

Edith

Edith is an XML annotation tool targeted to literature researchers that need to annotate XML documents in TEI format.

It provides versioned document storage, document import and export functionality, searchability, annotiation via visual selection, localized user interfaces and support for multiple users.

Please contact us for more information on Edith licensing.

Services

Development

We offer project development services with a focus on Java and HTML5 based technology stacks.

We utilize lean methods in our project development and involve the customer actively in the design and development phases of the projects.

See the references section for some examples of projects we've done in the past.

Consulting

In addition to project development our expertise is also available as consulting services. We have provided consulting to our customers in the following technology areas

  • HTML5 and Javascript
  • Hibernate and Querydsl
  • Lucene usage
  • Java Enterprise best practices

We have participated in development projects in various roles and have also organized code reviews and custom trainings.

Auditing

We audit projects and whole organisations covering the technology stack, service costs and development/maintenance process issues.

Auditings and reviews are customized with the following aspects

  • environments and tools for development, testing and production
  • architecture and security
  • database usage, schemas and tools
  • processes and methods

In the auditings we try to find answers to questions like these

  • Are Continuous Integration (CI) tools used? What are the build triggers?
  • What are the licenses of external components? What are their restrictions?
  • How is testing organized? What is tested and what is the coverage?
  • Which databases are used? How are schema changes handled?

Querydsl services

Querydsl is our flagship open source product. It solves the problem of writing and maintaining database queries in Java in an intuitive and typesafe way. In addition to the free support services we offer around Querydsl, we also offer commercial support. To mention a few of them:

  • Adding features into existing Querydsl modules, support for new databases or even integrations into other technologies
  • Customizable Querydsl trainings for your teams: introductions, module specific trainings, delving into advanced issues or anything else you might need.

For more details see http://www.querydsl.com/support.

Buzzwords

People


Mika Kivimäki

"I want to get technology work for people, not the other way around. The way of doing this is to understand the users' needs and the value we can bring with new technologies. I have done jobs from programming, product management, vendor management and sales, it helps me understand how to work with different parties of development projects. "


Timo Westkämper

"I'm a programmer/architect with interests in persistence technologies, domain specific languages and new programming languages. At work I solve our customers' problems and maintain Querydsl, and in my freetime I spend time with my family and hack on too many projects."


Lassi Immonen

"I'm a programmer with project management experience. Or project manager with programming experience. You can choose! Temporary interests come and go, now it's Clojure and NoSQL, but I will always be interested in creating useful software for real use. Preferably in a good team with great spirit."


Vesa Marttila

"Currently enjoying Clojure on the back-end and JavaScript on the front. Most of my free time revolves around playing football (or futsal), hanging around with friends, annoying my girlfriend or coding."

Blog

See all posts