Foros de discusión

database schema

Denis Wang, modificado hace 14 años.

database schema

New Member Mensajes: 9 Fecha de incorporación: 1/09/09 Mensajes recientes
I need to customize the LifeRay.
Want to know whether there is a quick way to learn the schema design of its database.

Thanks.
Denis
vcvijayan MCA, modificado hace 14 años.

RE: database schema

Denis Wang, modificado hace 14 años.

RE: database schema

New Member Mensajes: 9 Fecha de incorporación: 1/09/09 Mensajes recientes
Thanks for your kindly reply.

Is there any documentation to explain the relationship among users, groups, organizations, community, and etc.

Basically I want to know the data models before customizing it.

Best,
Denis
thumbnail
Jonas Yuan, modificado hace 14 años.

RE: database schema

Liferay Master Mensajes: 993 Fecha de incorporación: 27/04/07 Mensajes recientes
Hi Denis

You may refer to



abstracted from

Liferay Portal 5.2 Systems Development (May 26, 2009)
http://www.amazon.com/Liferay-Portal-5-2-Systems-Development/dp/1847194702

Thanks

Jonas Yuan

-----------------
Liferay Books

Liferay Portal 5.2 Systems Development
Liferay Portal Enterprise Intranets
thumbnail
Matthew Ropp, modificado hace 14 años.

RE: database schema

Junior Member Mensajes: 75 Fecha de incorporación: 5/08/09 Mensajes recientes
Jonas-

How up to date is the second book you link to below?

Liferay Portal Enterprise Intranets

Is that one updated for 5.2?

Thanks-

Matthew
thumbnail
Jonas Yuan, modificado hace 14 años.

RE: database schema

Liferay Master Mensajes: 993 Fecha de incorporación: 27/04/07 Mensajes recientes
Hi Matthew,

The book Liferay Portal Enterprise Intranets was written for Liferay portal 4.4 and 5.0. Currently I am updating it to 5.3 like: Liferay Portal 5.3 Enterprise Intranets. Hopefully it could be ready at the beginning of next year.

Your comments would be helpful.

Thanks

Jonas Yuan

-----------------
Liferay Books

Liferay Portal 5.2 Systems Development
Liferay Portal Enterprise Intranets
Denis Wang, modificado hace 14 años.

RE: database schema

New Member Mensajes: 9 Fecha de incorporación: 1/09/09 Mensajes recientes
Which table maps to 'Community' in the diagram?
thumbnail
Jonas Yuan, modificado hace 14 años.

RE: database schema

Liferay Master Mensajes: 993 Fecha de incorporación: 27/04/07 Mensajes recientes
Hi Denis

It is the table Group_ for Community, User Group, Organization, User, etc.

The table Organization_ is used for Organizations (Organizations and Locations) only.

Hope that it helps

Thanks

Jonas Yuan

-----------------
Liferay Books

Liferay Portal 5.2 Systems Development
Liferay Portal Enterprise Intranets
Denis Wang, modificado hace 14 años.

RE: database schema

New Member Mensajes: 9 Fecha de incorporación: 1/09/09 Mensajes recientes
Thanks. This is exactly what I am looking for.
Will your have a dedicated chapter to talk about the database design of LifeRay in your next version of the book?

By the way, the current version is really a decent one by all means.

Best,
Denis
thumbnail
Jonas Yuan, modificado hace 14 años.

RE: database schema

Liferay Master Mensajes: 993 Fecha de incorporación: 27/04/07 Mensajes recientes
Hi Denis,

Thank you. Your suggestions are helpful. It is planned to the database design in high level at the book: Liferay Portal 5.3 Enterprise Intranets.

Your comments or suggestions are welcome anytime.

Jonas Yuan

-----------------
Liferay Books

Liferay Portal 5.2 Systems Development
Liferay Portal Enterprise Intranets
Denis Wang, modificado hace 14 años.

RE: database schema

New Member Mensajes: 9 Fecha de incorporación: 1/09/09 Mensajes recientes
Just another recommendation to the book as well as the LifeRay product:
it's emotionally very important for a developer to have a 'Hello World' application up and running easily.
Unfortunately from the documentation and book, developers cannot see easy to follow instructions. Instead there are outdated/conflicting info everywhere.

As an architect, I may care less about the decent architecture of liferay before I can see something solid up and running.
thumbnail
Jonas Yuan, modificado hace 14 años.

RE: database schema

Liferay Master Mensajes: 993 Fecha de incorporación: 27/04/07 Mensajes recientes
Hi Denis,

Thank you. You do have good point.

It is really a good idea to have an example 'Hello World' application up and running easily, for developers.

Do you have more detailed information about an example 'Hello World' application?

Your comments would be very helpful,

Thanks

Jonas Yuan

----------------
Liferay Books

Liferay Portal 5.2 Systems Development
Liferay Portal Enterprise Intranets
Martin S., modificado hace 11 años.

RE: database schema

New Member Mensajes: 10 Fecha de incorporación: 9/08/12 Mensajes recientes
here comes the liferay schema. its created with schemaSpy.
see attached file
thumbnail
Vinod Kumar Nair, modificado hace 11 años.

RE: database schema

Junior Member Mensajes: 58 Fecha de incorporación: 13/07/12 Mensajes recientes
Martin S.:
here comes the liferay schema. its created with schemaSpy.
see attached file


Hi Martin,

Cannot access this file. It says permission denied. Allow me to access it.
Martin S., modificado hace 11 años.

RE: database schema

New Member Mensajes: 10 Fecha de incorporación: 9/08/12 Mensajes recientes
i dont know how.
i dont see a proper checkbox under "permissions".

you could also download schemaSpy (http://schemaspy.sourceforge.net/), the parameters are:
java -jar schemaSpy_4.1.1.jar -t pgsql -s public -u <username> -p <password> -host localhost -db lportal -dp /home/user/some_path/postgresql-jdbc4.jar -o <outputfolder>
thumbnail
David H Nebinger, modificado hace 11 años.

RE: database schema

Liferay Legend Mensajes: 14914 Fecha de incorporación: 2/09/06 Mensajes recientes
Please note that this really gives you no useful information outside of the table names, column names and types.

Liferay does not use nor support foreign key definitions on the tables, so you have no visibility on any of the relationships between the tables and their entities.

Given that, output from schema spy or any other tool is effectively worthless.
Martin S., modificado hace 11 años.

RE: database schema

New Member Mensajes: 10 Fecha de incorporación: 9/08/12 Mensajes recientes
Schema spy sees columns whose name and type imply a relationship to another table's primary key and generates diagrams based on it.
The output is for some tables (user_) to big to work with it but it gives you an overview some how, so imo its not completely worthless.
thumbnail
David H Nebinger, modificado hace 11 años.

RE: database schema

Liferay Legend Mensajes: 14914 Fecha de incorporación: 2/09/06 Mensajes recientes
Except many of the real relationships will not be displayed.

For example, owner id is on many records but the owner might be a user, might be a group, might be an organization, ...

Also an owner id in one table may be the user id in the user table, and I doubt that the relationship is actually on that column instead of a different owner id on the user table.

So at best the relationships are very incomplete and, at worse, not even accurate at all.

In the end, the code is the only place the relationships are truly implemented and maintained. Some columns in the database are deprecated, some are reused in multiple ways, and some columns are reused in ways that are different from their original naming.

You cannot infer or trust anything that Schema Spy gives you because it has no concept of how the code is using those tables.