Web databases and data-oriented design

The database is an essential component in most Web applications. Web databases provide data storage and search ability. Without a database to write to and read from, there would be no way to maintain data persistence. Each time a user logged off their data would be lost. Good data architecture provides much more than mere data persistence, however. In today's application environment, users generate enormous amounts of data. Processing big data and turning it into useful information for the user requires application developers to take on a data-oriented design mentality.

May 31, 2022 31 May'22
How to create a database schema in MySQL

Want to work with MySQL databases using Java? Here's a quick walkthrough of the first step to do that: create a schema.
August 02, 2020 02 Aug'20
An example hibernate.cfg.xml for MySQL 8 and Hibernate 5

Hibernate 5 has updated dialects for various databases, and MySQL 8 has a special one of its own. Here's an example hibernate.cfg.xml for MySQL 8 for Hibernate 5 apps or newer.
August 02, 2020 02 Aug'20
Build a Hibernate SessionFactory by example

Hibernate SessionFactory tutorial If a developer uses the Hibernate core framework, they will need to build a SessionFactory before they can do any data persistence. As the name implies, the ...
July 28, 2020 28 Jul'20
The right MySQL persistence.xml example file for JPA 2.2 and Hibernate 5

Old JDBC drivers and new MySQL 8 databases don't mesh. Here's an updated MySQL persistence.xml example file for those doing JPA and Hibernate development.

Bring yourself up to speed with our introductory content

query

A query is a question or a request for information expressed in a formal manner. In computer science, a query is essentially the same thing, the only difference is the answer or retrieved information comes from a database. Continue Reading
schema

In computer programming, a schema (pronounced SKEE-mah) is the organization or structure for a database, while in artificial intelligence (AI) a schema is a formal expression of an inference rule. Continue Reading
star schema

A star schema is a database organizational structure optimized for use in a data warehouse or business intelligence that uses a single large fact table to store transactional or measured data, and one or more smaller dimensional tables that store ... Continue Reading

Weigh the pros and cons of technologies, products and projects you are considering.

Why Java devs should switch to Python or R for data science

Java devs looking to explore or work in data science may need another language up their sleeves. Python and R are common Java alternatives for data science. Continue Reading
How MySQL InnoDB vs. MyISAM data engines compare

Data integrity, performance and transactional capabilities create the MyISAM vs. InnoDB data set debate for MySQL users. Compare the two to see which one makes sense for your data. Continue Reading
JDBC vs. ODBC: What's the difference between these APIs?

There are more similarities between ODBC and JDBC than there are differences. But, the differences are significant. Here we highlight them. Continue Reading

Learn to apply best practices and optimize your operations.

How COVID-19 created a demand for COBOL basics

An uptick in COBOL interest stems from its presence in entrenched, legacy government apps, such as unemployment or apps for emergency loans. A rush to use these apps at the start of the COVID-19 pandemic reminded us all that COBOL remains a force in... Continue Reading
NoSQL technology remains key to drawing BI from big data

Both business users and vendors are challenged with managing and using big data. Learn how NoSQL technology providers are meeting the challenge. Continue Reading

We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.

JPA and Hibernate enum mapping with annotations and the hbm.xml file

Ever since they were introduced in Java 5, enums have been catching developers off guard. How do you perform JPA and Hibernate enum mapping with annotations or even XML files? It's actually not ... Continue Reading