How to design an LDAP schema?

Let’s learn how to design an LDAP schema. The most accurate or helpful solution is served by Server Fault.

There are ten answers to this question.

Best solution

LDAP schema design

I am pretty new to LDAP & trying to design a schema for a particular need. I have a Support Organization. There are three levels P1 - lowest permissions P2 - middle P3 - highest permissions. I have split the support team into subteams. TeamA manages customers A1, A2, A3 etc TeamB manages customers B1, B2, B3 etc. Customer A1 has his internal users. Internal Users of each customer have 2 levels of permissions either P1 or P2. Their P1 or P2 permissions are only for stuff relevant to themselves...

Answer:

The pedant in me is forced to point out that what you're creating here is not a schema, but a layout...

Read more

Genboy at Server Fault Mark as irrelevant Undo

Other solutions

Does SQLAlchemy discourage the modification of database schema by design?

This is a follow-up question to How can I update the structure of an existing table in SQLAlchemy? I am kinda confused on this design.  Does SQLAlchemy discourage modification?  In the FAQ they suggested us to use SQLAlchemy-Migrate (as in the previous...

Answer:

Not altering tables frequently is more a philosophy of database design generally, than of SQLAlchemy...

Read more

Gunnlaugur Þór Briem at Quora Mark as irrelevant Undo

HBase schema design for user profiling?

I'm new to HBase and I'm trying to use it for one of our projects. The background is like this: There're hundreds of mobile applications on our platform. Each user has a profile: user name, IP address, email, preferences, etc. Within each application...

Answer:

Am going to be a bit general and probably point you in the right direction of how to go about thinking...

Read more

Jahangir Mohammed at Quora Mark as irrelevant Undo

I want to use a LDAP repository as login backend for a portal. Is there a sample schema I can use?

I want to switch Jenkins-CI from a local user db, for this I need to define user groups in the LDAP.

Answer:

You may want take a look at IETF's RFC 4519 and RFC 2307. Although RFC 4519 is for "LDAP user applications...

Read more

Bora Bali at Quora Mark as irrelevant Undo

What is the etymology of term "schema" in relational database design?

I am reading this gem of a book Page on Stanford And the author uses the word "Scheme" to refer to schema. Since when the word "schema" start getting used?

Answer:

I think the use of "database schema" is pretty old and it's not clear to me at all that "...

Read more

Jan Hidders at Quora Mark as irrelevant Undo

What's the best doc for learning database schema design?

want to improve myself on db schema design.

Answer:

Fabian Pascal, Practical Issues in Database Management and other books that are listed here http://www...

Read more

Toby Thain at Quora Mark as irrelevant Undo

A/B Testing: Is a star schema database design useful for tech companies that continuously experiment?

Do companies that are leaders in continuous experimentation and analysis of user microbehavior use star schema (a la Kimball or enterprise data warehouse)? If not, what kind of database architecture do they use? The companies I'm thinking of are ones...

Answer:

Yes, these companies use a dimensional model in some way for reporting purposes.  The dimensional model...

Read more

Chris Schrader at Quora Mark as irrelevant Undo

How should I design my HBASE schema for this time series scenario?

We have a data stream that contains: time stamp, object ID, data The needed processing is: for each new entry, fetch all entries with the same object ID, and do something with all data The 1st option is to use a separate queuing service. In this case...

Answer:

Refer schema of opentsdb which has successfully solved the problem you mentioned above. You might need...

Read more

Jatinder Singh at Quora Mark as irrelevant Undo

Answer:

A star schema is used as a basic implementation of an OLAP cube. If your fact table contains a 1 to...

Read more

John Cook at Quora Mark as irrelevant Undo

Is there any point in NoSQL data modeling tools since many NoSQL solutions are schema-less?

Toad for NoSQL databases has some level of SQL to NoSQL translation, but it's really basic. Are there any good tools out there to help facilitate NoSQL data modeling, e.g. JSON document design for MongoDB or column families, columns and corresponding...

Answer:

I would say that if anything, the data model is more important in case of NoSql databases. This is because...

Read more

Hari Shankar at Quora Mark as irrelevant Undo

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.