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
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.
Hi Martin,
Cannot access this file. It says permission denied. Allow me to access it.
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
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
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
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
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
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
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
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?
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
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
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
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
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.
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.
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
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
see attached file
Archivos adjuntos:
Vinod Kumar Nair, modificado hace 11 años.
RE: database schema
Junior Member Mensajes: 58 Fecha de incorporación: 13/07/12 Mensajes recientesMartin 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>
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>
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.
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.
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.
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.
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.