Open Source Object-Relational Mapping (ORM) Software
Sort By:
Object-Relational Mapping (ORM) Software
View 5881 business solutionsBrowse free open source Object-Relational Mapping (ORM) software and projects below. Use the toggles on the left to filter open source Object-Relational Mapping (ORM) software by OS, license, language, programming language, and project status.
-
Outgrown Windows Task Scheduler?Windows Task Scheduler wasn't built for complex, cross-platform automation. Get a free diagnostic that shows exactly where things are failing and provides remediation recommendations. Interactive HTML report delivered in minutes.
-
Our Free Plans just got better! | Auth0You asked, we delivered! Auth0 is excited to expand our Free and Paid plans to include more options so you can focus on building, deploying, and scaling applications without having to worry about your security. Auth0 now, thank yourself later.
-
1
Hibernate
An object relational-mapping (ORM) library for Java
The Hibernate projects offer a suite of powerful Java libraries to work with data. It is best known for Hibernate ORM, which provides relational persistence for Java models and is an implementation of the Jakarta Persistence specification. Hibernate projects do not consistently release binaries or documentation to SourceForge anymore. For up-to-date information, refer to the Hibernate website: * Hibernate ORM: https://hibernate.org/orm/ * Hibernate Validator: https://hibernate.org/validator/ * Hibernate Search: https://hibernate.org/search/ That website will also be updated with newer projects, such as Hibernate Reactive. -
2
ObjectMapper
Simple JSON Object mapping written in Swift
ObjectMapper is a framework written in Swift that makes it easy for you to convert your model objects (classes and structs) to and from JSON. Once your class implements Mappable, ObjectMapper allows you to easily convert to and from JSON. Use functions to validate JSON prior to object serialization provide an existing cached object to be used for mapping, return an object of another type (which also conforms to BaseMappable) to be used for mapping. For instance, you may inspect the JSON to infer the type of object that should be used for mapping. ObjectMapper supports dot notation within keys for easy mapping of nested objects. ObjectMapper also supports custom transforms that convert values during the mapping process. To use a transform, simply create a tuple with map["field_name"] and the transform of your choice on the right side of the <- operator. -
3
Prisma
Next-generation ORM for Node.js and TypeScript
Prisma helps app developers build faster and make fewer errors with an open source ORM for PostgreSQL, MySQL and SQLite. Central to Prisma is the schema, a declarative way to define your app's data models and their relations that's human-readable. And you don't have to painstakingly create it from scratch if you already have a database - prisma introspect takes care of that. Prisma Client is a query builder that composes the way you think and gets auto-generated from the Prisma schema with types tailored to your app. We designed the API to be intuitive for both SQL veterans and people brand new to databases. Auto-completion, linting, formatting and more help Prisma developers in VSCode stay confident without distractions. Prisma Client puts extra emphasis on extensive type safety for more productive development in TypeScript. Prisma is a server-side library that helps your app read and write data to the database in an intuitive and safe way. -
4
Doctrine ORM
Doctrine Object Relational Mapper
Doctrine 2 is an object-relational mapper (ORM) for PHP 7.1+ that provides transparent persistence for PHP objects. It sits on top of a powerful database abstraction layer (DBAL). One of its key features is the option to write database queries in a proprietary object oriented SQL dialect called Doctrine Query Language (DQL), inspired by Hibernate's HQL. This provides developers with a powerful alternative to SQL that maintains flexibility without requiring unnecessary code duplication. As the term ORM already hints at, Doctrine ORM aims to simplify the translation between database rows and the PHP object model. The primary use case for Doctrine are therefore applications that utilize the Object-Oriented Programming Paradigm. For applications that do not primarily work with objects Doctrine ORM is not suited very well. Doctrine ORM requires a minimum of PHP 7.1. For greatly improved performance it is also recommended that you use APC with PHP. -
AI-powered service management for IT and enterprise teamsGive your IT, operations, and business teams the ability to deliver exceptional services—without the complexity. Maximize operational efficiency with refreshingly simple, AI-powered Freshservice.
-
5
XML Editor/Validator/Designer with CAMV
CAM XML Editor for XML+JSON+Hibernate+SQL Open-XDX sponsored by Oracle
The CAM editor is the leading open source XML Editor/Validation/Schema toolset for rapidly building / deploying XML /JSON /Hibernate /SQL data /Forms applications. Visual WYSIWYG data design, rule entry wizards + drag & drop dictionary components. Will import, analyze / refactor from XML Schema / JSON. Oracle is a proud enterprise sponsor; with NIEM.gov support. Do SQL data import/map+ Open Data API delivery+ Hibernate JPA + UI Forms/Pencil Makes XSD schema (default, flatten, NIEM, & OASIS modes) + JAXB bindings; Mindmap FreeMind or UML models(XMI); XML unit test & live SQL data; HTML docs + spreadsheets (NIEM IEPDs). Canonical component dictionaries from schema sets, SQL, JSON, ERwin XSD, or spreadsheets. The XML CAM templates (OASIS standard) store the exchange structure, content model, code lists, DBMappings, SQL lookups+business rules (XPath). Java CAMV XML/JSON validation engine is a complete exchange test framework [XMLUnit, TEAM(Schematron)]. Java/Eclipse +Saxon/XSL -
6
Sequelize
A promise-based multi SQL dialect Node.js ORM
Sequelize is a promise-based Node.js ORM for Postgres, MySQL, MariaDB, SQLite and Microsoft SQL Server. It features solid transaction support, relations, eager and lazy loading, read replication and more. Sequelize follows SEMVER. Supports Node v6 and above to use ES6 features. Sequelize v5 was released on March 13, 2019. Official TypeScript typings are now included. Sequelize can be used since the beginning in order to automate the creation of every table in your database. Models are the essence of Sequelize. A model is an abstraction that represents a table in your database. In Sequelize, it is a class that extends Model. The model tells Sequelize several things about the entity it represents, such as the name of the table in the database and which columns it has (and their data types). -
7
Beam
A type-safe, non-TH Haskell SQL library and ORM
Beam is a Haskell interface to relational databases. Beam uses the Haskell type system to verify that queries are type-safe before sending them to the database server. Queries are written in a straightforward, natural monadic syntax. Combinators are provided for all standard SQL92 features, and a significant subset of SQL99, SQL2003, and SQL2008 features. Beam is standards-compliant but not naive. We recognize that different database backends provide different guarantees, syntaxes, and advantages. To reflect this, Beam maintains a modular design. While the core package provides standard functionality, Beam is split up into a variety of backends which provide a means to interface Beam's data query and update DSLs with particular RDBMS backends. Backends can be written and maintained independently of this repository. For example, the beam-MySQL and beam-firebird backends are packaged independently. -
8
Dapper
A simple object mapper for .Net
Dapper is an open-source object-relational mapping (ORM) library for .NET and .NET Core applications. The library allows developers quickly and easily access data from databases without the need to write tedious code. Dapper allows you to execute raw SQL queries, map the results to objects, and execute stored procedures, among other things. It is available as a NuGet package. Dapper is lightweight and fast, making it an ideal choice for applications that require low latency and high performance. It is a simple yet powerful object mapping tool for any .NET language, such as C#, that enables developers to quickly and easily map query results from ADO.NET data readers to instances of business objects. It has excellent support for both asynchronous and synchronous database queries and batching multiple queries together into a single call. -
9
Diesel
A safe, extensible ORM and Query Builder for Rust
Diesel is the most productive way to interact with databases in Rust because of its safe and composable abstractions over queries. We don’t want to waste time tracking down runtime errors. We achieve this by having Diesel eliminate the possibility of incorrect database interactions at compile time. Diesel offers a high level query builder and lets you think about your problems in Rust, not SQL. Our focus on zero-cost abstractions allows Diesel to run your query and load your data even faster than C. Unlike Active Record and other ORMs, Diesel is designed to be abstracted over. Diesel enables you to write reusable code and think in terms of your problem domain and not SQL. -
Failed Payment Recovery for Subscription BusinessesFlexPay’s innovative platform uses multiple technologies to achieve the highest number of retained customers, resulting in reduced involuntary churn, longer life span after recovery, and higher revenue. Leading brands like LegalZoom, Hooked on Phonics, and ClinicSense trust FlexPay to recover failed payments, reduce churn, and increase customer lifetime value.
-
10
Ebean
Ebean ORM
Ebean provides multiple levels of query abstraction ORM Queries, mixed with SQL, DTO Queries, SqlQuery and JDBC. Work at the highest level of abstraction and drop down levels as needed. Built in DB migration generation and running. Support for "rebase" migrations as well as repeatable, init and 'normal' migrations. Ebean produces SQL that you would hand craft yourself. Use great SQL, never generate SQL cartesian product, always honor relational limit/offset. For ORM queries Ebean can profile the object graph being used and either automatically tune the query. Docker test containers for all the supported databases. Get 100% test coverage on all the features of the database we use. We can build queries using type safe query beans. IDE auto-complete when writing queries, compile time checking and it's FUN. Optimize queries to only fetch what we need (partial objects). Automatically avoid N+1 via a smart load context. -
11
FreeSql
.NET aot orm, VB.NET/C# orm, Mysql/PostgreSQL/SqlServer/Oracle orm
FreeSql is a robust ORM (Object Relational Mapper) for .NET that supports multiple databases like MySQL, PostgreSQL, SQLite, Oracle, and SQL Server. It provides advanced features such as automatic entity mapping, LINQ-style queries, caching, and database-first or code-first workflows. Designed for developers who want full control and performance without sacrificing productivity. -
12
Mikro Orm
TypeScript ORM for Node.js based on Data Mapper, Unit of Work
TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. MikroORM allows handling transactions automatically. When you call em.flush(), all computed changes are wrapped inside a database transaction. Uses source code analysis so you do not have to repeat yourself when defining entities. Simply define correct TypeScript types and you are good to go! Supports MongoDB, MySQL, MariaDB, PostgreSQL and SQLite databases, and more can be supported via custom drivers right now. Keep your schema in sync with SchemaGenerator and Migrator. Supports both up and down migrations. With the Seeder and seeding factories, we can generate fake data of any volume/shape and seed the database with ease. Thanks to the UnitOfWork, all queries it fires are automatically batched. Inserts, updates, deletes - you name it! Powerful event system allows to hook into not only the entity lifecycle. Want to alter how the UnitOfWork works? Try onFlush event! -
13
Orange ORM
The ultimate ORM for Node and Typescript
Orange ORM is a lightweight, reflection-free ORM for Go that emphasizes performance and direct control. It provides a SQL-like fluent API and struct tagging system to map Go structs to database tables. Orange ORM supports PostgreSQL, MySQL, and SQLite, making it suitable for fast, embedded, or minimal-dependency applications. -
14
Peewee-async
Asynchronous interface for peewee ORM powered by asyncio
peewee-async is an async extension for the Peewee ORM, enabling non-blocking database access in asyncio-powered Python applications. It allows you to use familiar Peewee models while benefiting from asynchronous I/O, making it ideal for web applications or services that require concurrency. -
15
Pony ORM
Pony Object Relational Mapper
Pony ORM is a Python ORM that enables developers to write database queries using generator expressions and Pythonic syntax, making code more readable and intuitive. It automatically translates Python expressions into SQL and supports multiple databases including SQLite, MySQL, PostgreSQL, and Oracle. With an emphasis on simplicity and maintainability, Pony ORM is suitable for both small projects and complex applications. -
16
Java ORM Plugin for Eclipse
User can create a java ORM framework in one click.
Java ORM Plugin for eclipse helps the user to create a Mybatis and Hibernate ORM framework in one click. 1) Mybatis ORM Framework 2) Hibernate ORM Framework URL : http://oneclicklabs.io -
17
SQLObject
SQLObject is a Python ORM.
SQLObject is an object-relational mapper for Python. It supports MySQL, PostgreSQL, SQLite, Firebird, MaxDB/SapDB, MS SQL and Sybase. It supports Python versions back to 2.7. -
18
LiteSQL is a codegenerator and C++ library that integrates C++ objects tightly to relational database and thus provides an object persistence layer. LiteSQL supports SQLite3, PostgreSQL, MySQL and oracle as backends.
-
19
Sormula
Java ORM
Simple (Easy) Object Relational Mapping for Java Sormula is a Java library that moves data between Java objects and relational database tables. * Easy to Use * Simple to Understand * Minimal Configuration * Portable It provides select, insert, update, and delete, and many other common operations. One-to-one and one-to-many cascading for unlimited levels. Simplified IN operator parameter as java.util.Collection. Custom conversions between any Java class/type and column type. * Works with any relational database. Tested with H2, HSQLDB, Derby, SQLiteJDBC, MySQL, MariaDB, Firebird, DB2, Oracle 11g, PostgreSQL. * Performs as fast as plain JDBC. Performs faster than plain JDBC when caching is enabled. * Zero-configuration, zero-annotation use is possible. * Active record pattern may be used but is not required. Maven <dependency> <groupId>org.sormula</groupId> <artifactId>sormula</artifactId> <version>4.3</version> </dependency> -
20
QsT SQL Tools - ORM system based on Qt 4.6.0 (and higher) to improve programming databases with Qt. QST has a little functionality to make simple SELECT, INSERT, UPDATE, DELETE and EXEC queries. It uses PostgreSQL but can be ported for other language
-
21
Tentacles is a Object-Relational Mapping (ORM) written in Python. It's main concept is to manipulate stored datas as you do for python data structures.
-
22
Reusable is a JPA ORM like Hibernate. But with focus on speed, speed, speed and development speed. Hibernate is like ANT - you can do everything. Reusable is like Maven - you cant do everything, but the development speed is greater.
-
23
Automated Business Logic
Transaction logic engine for JPA/Hibernate
ABL is a transaction logic engine: it allows you to declare complex, multi-table transaction logic for your persistent objects, using simple declarative annotations. ABL operates as a HIbernate/JPA event listener to eliminate recoding and automate integrity. -
24
DBvolution
Java library to remove Object/Relation Impedance
Now stored at https://github.com/gregorydgraham/DBvolution Available from Maven Central: nz.co.gregs.dbvolution Makes relational data easy and fast to use with semantic annotations and encapsulated datatypes. Simple declaration of a DB table: @DBTableName("mytable") public class MyTable extends DBRow { @DBColumn("numeric_code") @DBForeignKey(Code.class) private DBNumber numericCode = new DBNumber(); @DBColumn("uid_mytable") @DBPrimaryKey @DBAutoIncrement private DBNumber uidMyTable = new DBNumber(); } Easy Gets: List<MyTable> myRows = myDB.get(new MyTable()); MyTable row = myDB.getDBTable(new MyTable()).getByPrimaryKey(61176904); Natural and Outer Joins and Criteria: CarCo carCo = new CarCo(); carCo.name.isLiterally("GM"); List<DBQueryRow> results = myDB.get(carCo, new Marque()); dbQuery.addOptional(new CarModel()); Easy debugging: query.getSQLForQuery(); Simple processing: db.print(query.getAllRows()); List<Marque> marques = query.getAll -
25
Entity Framework Analyzer
Analyze an Entity Framework edmx file to identity mapping issues.
This app will read an Entity Framework edmx file (currently tested with V5 of EF) and show all of the stored procedures, the conceptual functions, and the mappings between the two. If there are any procedures or functions that are not mapped, those will be listed as well. This tool was built to identify mapping issues when using Entity Framework with existing stored procedures.
Guide to Open Source Object-Relational Mapping (ORM) Software
Open source object-relational mapping (ORM) software acts as an intermediary between data stored in database management systems and the applications that use them. This software provides a way to efficiently map objects in programming languages to database structures, while preserving their properties. It also provides programmers with an interface for interacting with databases without needing any knowledge of database query language syntax. ORM software is typically written in a scripting language such as Python, PHP, or Java and enables database access using Active Record, Data Mapper, and Unit of Work design patterns.
One advantage of using open source ORM software is that it can greatly reduce the amount of time spent writing code for complex queries. Additionally, developers no longer need to manually write SQL queries when interacting with databases; instead they can use higher-level abstractions provided by the ORM APIs to define data modeling requirements and reduce the size of the codebase required for application development or maintenance tasks. Using an ORM usually increases productivity and helps enforce uniform coding standards across development teams because most ORMs are designed around common web application frameworks such as Rails or Django. Furthermore, since the code powering ORMs is often open sourced it allows developers to easily collaborate on projects together or create new libraries that extend existing functionality beyond what’s available out-of-the box.
Overall, open source object-relational mapping (ORM) software provides many benefits like increased speed in coding complex queries, easier collaboration among different development teams working on the same project, and simplified access to databases for developers who may not have expertise in SQL query language syntaxes.
Open Source Object-Relational Mapping (ORM) Software Features
- Automated Database Schemas: ORM software automates the process of creating database schemas by mapping object-oriented classes to relational database tables. This makes it easier for developers to quickly create databases without having to manually define all database information and fields in the SQL language.
- Query Building: ORM software allows developers to quickly build queries using an object-oriented programming (OOP) syntax, reducing the need for manual SQL coding. This makes it easy for developers to query or update database records with minimal effort and time.
- Model Relationships: ORM software can easily model complex relationships between entities in an object-oriented environment, such as one-to-one, one-to-many, or many-to-many relationships. This helps keep data organized and reduces the amount of manual code that needs to be written when working with relational databases.
- Data Validation: ORM software provides built-in data validation features which allow users to validate user input before submitting any queries or updates so that only valid and consistent data is saved into the database. This ensures accuracy of information stored in the database and prevents redundant or invalid entries from being made accidentally by users.
- Caching Mechanisms: ORM software often includes caching mechanisms which help minimize the number of times a program needs to connect to the underlying database while still allowing applications access to frequently used data quickly, resulting in improved performance overall.
What Are the Different Types of Open Source Object-Relational Mapping (ORM) Software?
- Hibernate: Hibernate is an open source Java-based ORM which enables developers to map plain old Java objects (POJO) to relational tables. It is popular for its ability to access multiple relational databases with a single set of code.
- Kodo: Kodo is an open source Java-based ORM which provides object persistence and query technology for enterprise applications. It is designed to allow developers to store, retrieve, manipulate and manage data in a database system.
- iBATIS/MyBatis: iBATIS (now known as MyBatis) is an open source framework that maps accessed objects into SQL queries, enabling developers to quickly and easily create database-independent applications. MyBatis has been widely adopted due to its powerful mapping capabilities, support of advanced features such as type handlers, dynamic SQL and pagination, and easy integration into other frameworks such as Spring Framework or Grails.
- JDBC: JDBC (Java Database Connectivity) is the industry standard for connecting applications written in the Java language with data sources such as relational databases and spreadsheets. JDBC provides Object Relational Mapping technologies that enable developers to store data from any application without having any knowledge about the underlying database structure or SQL syntax used by the data source itself.
- JPA/EclipseLink: The Java Persistence API (JPA) provides a common way for persistent entities i.e., classes that are connected with specific instances of a particular type of data stored in a database using annotations or metadata from class fields throughout the application’s codebase while EclipseLink adds additional features above those provided by JPA including caching provider services, extended object-oriented query feature support, change tracking algorithms within session beans, versioning strategies and much more.
Benefits of Open Source Object-Relational Mapping (ORM) Software
- Increased Productivity: ORM tools provide developers with the ability to quickly and easily bridge the gap between their code and a relational database, allowing them to speed up the development process.
- Reduced Maintenance Costs: By abstracting away many of the complexities associated with relational databases, ORM software significantly reduces the amount of time needed for maintenance tasks. This leads to lower long-term costs and fewer headaches for developers.
- Safer Code: ORM software offers a better way of keeping your code safe from SQL injection attacks. By creating queries programmatically and relying on parameterized stored procedures, it’s much easier to prevent malicious code from being injected into your application’s database.
- Improved Performance: Many ORMs offer features such as object caching and query optimization that can drastically improve application performance without requiring any manual tweaking from developers.
- Easier Customization: Because most ORMs are written in an open source environment, they can be easily customized and adjusted according to specific needs without having to rewrite large amounts of code. This makes it simpler for developers to add new features or apply customizations as required.
Who Uses Open Source Object-Relational Mapping (ORM) Software?
- Web Developers: Those who develop websites and web applications can use ORM software to quickly create databases and maintain relationships between objects.
- Mobile Application Developers: Mobile application developers often need to store, access, and update data. They can use ORM software to organize the process, making it easier for them to develop their applications quickly.
- Small Businesses: ORMs are cost-effective solutions for small businesses that need database management but don’t have enough resources for buying proprietary database solutions.
- Data Scientists: Data scientists often need sophisticated database management features such as complex queries, data integration from multiple sources and dynamic object mapping capabilities, all of which can be easily achieved with an ORM tool.
- Database Administrators (DBAs): An ORM offers an easy way for database administrators to write code and query results using simple classes instead of tables. This makes it easier for them to manage large databases without having to manually write SQL scripts on an ad hoc basis.
- Software Engineers: Software engineers who specialize in creating distributed systems like microservices can benefit from the scalability offered by many popular ORMs such as Entity Framework or Hibernate OGM.
How Much Does Open Source Object-Relational Mapping (ORM) Software Cost?
Open source object-relational mapping (ORM) software typically does not cost anything, as it is open source. This means that the creators have chosen to make the software available to everyone without charging a fee. The ORM software can be downloaded and used for free by anyone who wishes to do so.
By using open source ORM software, developers gain access to powerful tools which they may use to efficiently and effectively design their databases. These tools include features such as automated database generation, auto-mapping of objects and relations between them, API integration with other languages or databases, many-to-many relationships for complex data sets, and more. All of these features help developers create better databases in less time than traditional methods.
The openness of this type of software also allows developers from all around the world to collaborate on projects with different technologies which support interoperability among them. This helps ensure that any changes made are shared across multiple platforms without extra costs or delays associated with proprietary solutions. Additionally, members of online developer communities often provide feedback on how to improve ORMs in order to benefit everyone involved in these collaboration efforts.
For those looking for enterprise level options at a cost but still benefit from the benefits associated with open source ORM solutions there are various commercial vendors that offer both free and paid packages with enhanced features compared to freely available ones including improved scalability, increased security measures, advanced automation abilities etc.
What Does Open Source Object-Relational Mapping (ORM) Software Integrate With?
Open source object-relational mapping (ORM) software is used to map objects from a programming language to relational database systems. This type of software can integrate with many other types of software, including web frameworks and query languages. ORM can be integrated with web frameworks such as Java Server Pages (JSP), Ruby on Rails or Django by providing the developer with the ability to access data in a relational database through their code. It also supports integration with query languages such as SQL, allowing developers to use existing queries for their applications. Finally, it provides an interface for popular development tools like Eclipse, Visual Studio and IntelliJ which makes it easier to work with databases within these tools. By providing an easily accessible interface between various programming elements and databases, ORM allows developers to create powerful data-driven applications while minimizing the effort required on their part.
Recent Trends Related to Open Source Object-Relational Mapping (ORM) Software
- Increased Adoption: More and more businesses are turning to open source ORM software to manage their databases because of its cost-effectiveness, scalability, and reliability.
- Improved Security: Open source ORM software is designed with robust security protocols to protect data from attackers.
- Support for Popular Databases: Open source ORM software supports popular database systems such as SQL Server, Oracle, PostgreSQL, MongoDB, and Hadoop.
- Increased Flexibility: Open source ORM software is highly customizable, allowing developers to tailor their applications to fit their specific needs.
- Reduced Time-to-Market: Open source ORM software reduces the time it takes to develop applications by removing many of the tedious tasks associated with database management.
- Faster Development Cycles: With open source ORM software, development cycles are faster due to the ability to quickly modify code and make changes on the fly.
- Automated Testing: Many open source ORM tools include automated testing capabilities, which reduces the amount of manual testing needed for applications.
- Greater Compatibility Across Platforms: Open source ORM software is designed to be platform-agnostic and can be used on multiple operating systems such as Windows, macOS, Linux, and Android.
Getting Started With Open Source Object-Relational Mapping (ORM) Software
Using open source object-relational mapping (ORM) software is a great way to save time and increase productivity when developing a web application or managing databases. The following steps will help users get started with using ORM software explain how users can get started with using open source object-relational mapping (ORM) software. Write in American English. Make your response long.
Getting started with open source object-relational mapping (ORM) software is easy and can be done in just a few simple steps.
The first step is to decide on which ORM framework you would like to use. Popular open source ORM frameworks include Entity Framework, NHibernate, and LinqToSQL. Each of these frameworks has its own set of pros and cons so it’s important to consider your application’s specific requirements when selecting an ORM framework. Once you’ve chosen a framework, you can download the necessary libraries from their website or through your preferred package manager.
The next step is to create or import your database schema into the ORM framework of your choice. This can be done by manually creating entities for each table in the database or by importing them from existing SQL scripts using an appropriate tool provided by the chosen ORM framework. Another option could be to use a visual designer where tables are represented as diagrams allowing users to drag and drop fields, indexes etc., making it easier to create complex schemas without having too much knowledge about databases.
