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.
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.
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.
is a web application for managing, planning and following personal finances. It's designed to help people to really see where their money comes and goes.
provides access to collections from almost 50 different Finnish museums.
is an initiative to create a common source for scattered event information.
allows literature reasearchers to annotate XML-documents. It provides version controlled document storage with tools to search, annotate and publish the results.
is searchable crosslinked term database. It contains a collection of relevant Finnish terms that textual scholars need in their work.
provides a Linked Open Data view of the Aluesarjat statistics. Aluesarjat provides population, construction and employment statistics of the capital region.
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
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
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
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
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
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
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
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
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 JavaWe 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.
In addition to the free support services we offer around Querydsl we also offer commercial support. To mention a few of them:
If you are interested in discussing any of these commercial options further, or have something else in mind, you can get in touch with us by emailing info@mysema.com
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.
"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. "
Follow @mikataatio
"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."
Follow @timowest
"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."
Follow @mangolas
"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."
Follow @ponzao
Mysema is a member of
