Foren
database schema
Denis Wang, geändert vor 14 Jahren.
database schema
New Member Beiträge: 9 Beitrittsdatum: 01.09.09 Neueste Beiträge
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, geändert vor 14 Jahren.
Hi Martin,
Cannot access this file. It says permission denied. Allow me to access it.
RE: database schema
Denis Wang, geändert vor 14 Jahren.
RE: database schema
New Member Beiträge: 9 Beitrittsdatum: 01.09.09 Neueste Beiträge
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, geändert vor 14 Jahren.
RE: database schema
Liferay Master Beiträge: 993 Beitrittsdatum: 27.04.07 Neueste Beiträge
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, geändert vor 14 Jahren.
RE: database schema
Junior Member Beiträge: 75 Beitrittsdatum: 05.08.09 Neueste Beiträge
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, geändert vor 14 Jahren.
RE: database schema
Liferay Master Beiträge: 993 Beitrittsdatum: 27.04.07 Neueste Beiträge
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, geändert vor 14 Jahren.
RE: database schema
New Member Beiträge: 9 Beitrittsdatum: 01.09.09 Neueste Beiträge
Which table maps to 'Community' in the diagram?
Jonas Yuan, geändert vor 14 Jahren.
RE: database schema
Liferay Master Beiträge: 993 Beitrittsdatum: 27.04.07 Neueste Beiträge
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, geändert vor 14 Jahren.
RE: database schema
New Member Beiträge: 9 Beitrittsdatum: 01.09.09 Neueste Beiträge
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, geändert vor 14 Jahren.
RE: database schema
Liferay Master Beiträge: 993 Beitrittsdatum: 27.04.07 Neueste Beiträge
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, geändert vor 14 Jahren.
RE: database schema
New Member Beiträge: 9 Beitrittsdatum: 01.09.09 Neueste Beiträge
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, geändert vor 14 Jahren.
RE: database schema
Liferay Master Beiträge: 993 Beitrittsdatum: 27.04.07 Neueste Beiträge
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., geändert vor 11 Jahren.
RE: database schema
New Member Beiträge: 10 Beitrittsdatum: 09.08.12 Neueste Beiträge
here comes the liferay schema. its created with schemaSpy.
see attached file
see attached file
Anhänge:
Vinod Kumar Nair, geändert vor 11 Jahren.
RE: database schema
Junior Member Beiträge: 58 Beitrittsdatum: 13.07.12 Neueste BeiträgeMartin 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., geändert vor 11 Jahren.
RE: database schema
New Member Beiträge: 10 Beitrittsdatum: 09.08.12 Neueste Beiträge
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, geändert vor 11 Jahren.
RE: database schema
Liferay Legend Beiträge: 14919 Beitrittsdatum: 02.09.06 Neueste Beiträge
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., geändert vor 11 Jahren.
RE: database schema
New Member Beiträge: 10 Beitrittsdatum: 09.08.12 Neueste Beiträge
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, geändert vor 11 Jahren.
RE: database schema
Liferay Legend Beiträge: 14919 Beitrittsdatum: 02.09.06 Neueste Beiträge
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.