(Created page with "=== Background === Persistence mapping, also known as object-relational mapping (ORM), is a technique used in MDriven to map objects in an object-oriented programming language...") |
(Adding page to Category:TOC because it contains a TOC.) |
||
| (7 intermediate revisions by 4 users not shown) | |||
| Line 4: | Line 4: | ||
Persistence mapping works by creating a mapping between each class in the programming language and a corresponding table in the database. The attributes of each class are mapped to columns in the table, and the methods of the class are mapped to the SQL statements used to manipulate the data in the table. | Persistence mapping works by creating a mapping between each class in the programming language and a corresponding table in the database. The attributes of each class are mapped to columns in the table, and the methods of the class are mapped to the SQL statements used to manipulate the data in the table. | ||
MDriven | MDriven provides an abstraction layer between the application and the database, allowing programmers to work with the database using familiar object-oriented programming concepts like classes, objects, and inheritance. The MDriven Framework takes care of translating the object-oriented programming constructs into SQL statements that are executed by the database. | ||
=== Benefits === | |||
Persistence mapping provides several benefits, including: | Persistence mapping provides several benefits, including: | ||
# Simplified data access: By providing a | # '''Simplified data access''': By providing a simple and more intuitive interface for accessing and manipulating data in databases, Persistence mapping makes it easier for developers to work with databases and reduces the amount of boilerplate code required to interact with them. | ||
# Abstraction from database implementation details: Persistence mapping provides an abstraction layer between the application and the database, allowing developers to work with data using object-oriented programming concepts | # '''Abstraction from database implementation details''': Persistence mapping provides an abstraction layer between the application and the database, allowing developers to work with data using object-oriented programming concepts without worrying about the underlying implementation details of the database. | ||
# Improved portability: By abstracting away the implementation details of the database, persistence mapping | # '''Improved portability''': By abstracting away the implementation details of the database, persistence mapping makes it easier to switch between different database platforms or even different data storage mechanisms without having to change the application code. | ||
Overall, | Overall, Persistence mapping is a powerful technique that simplifies data access, making it easier to work with databases in object-oriented programming languages. Persistence mapping helps developers write more maintainable, portable, and scalable code by providing an abstraction layer between the application and the database. | ||
=== MDriven | === MDriven Build-In Persistence Mappers === | ||
==== As XML file ==== | ==== As XML file ==== | ||
Saves all of the objects in the database by serializing the objects to XML | Saves all of the objects in the database by serializing the objects to XML | ||
==== SQL Server ==== | ==== [[SQL Server]] ==== | ||
==== MySQL ==== | ==== [[MySQL–notes to support the use of MySQL with MDriven|MySQL]] ==== | ||
==== [[SQLite]] ==== | |||
{{Edited|July|12|2024}} | |||
[[Category:TOC]] | |||
Revision as of 13:34, 26 March 2024
Background
Persistence mapping, also known as object-relational mapping (ORM), is a technique used in MDriven to map objects in an object-oriented programming language to relational database tables. The goal of persistence mapping is to make it easier for programmers to work with data stored in databases by allowing them to use familiar object-oriented programming concepts to access and manipulate that data.
Persistence mapping works by creating a mapping between each class in the programming language and a corresponding table in the database. The attributes of each class are mapped to columns in the table, and the methods of the class are mapped to the SQL statements used to manipulate the data in the table.
MDriven provides an abstraction layer between the application and the database, allowing programmers to work with the database using familiar object-oriented programming concepts like classes, objects, and inheritance. The MDriven Framework takes care of translating the object-oriented programming constructs into SQL statements that are executed by the database.
Benefits
Persistence mapping provides several benefits, including:
- Simplified data access: By providing a simple and more intuitive interface for accessing and manipulating data in databases, Persistence mapping makes it easier for developers to work with databases and reduces the amount of boilerplate code required to interact with them.
- Abstraction from database implementation details: Persistence mapping provides an abstraction layer between the application and the database, allowing developers to work with data using object-oriented programming concepts without worrying about the underlying implementation details of the database.
- Improved portability: By abstracting away the implementation details of the database, persistence mapping makes it easier to switch between different database platforms or even different data storage mechanisms without having to change the application code.
Overall, Persistence mapping is a powerful technique that simplifies data access, making it easier to work with databases in object-oriented programming languages. Persistence mapping helps developers write more maintainable, portable, and scalable code by providing an abstraction layer between the application and the database.
MDriven Build-In Persistence Mappers
As XML file
Saves all of the objects in the database by serializing the objects to XML