Author Topic: Radical proposal for our own repository structure  (Read 7344 times)

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8604
  • Karma: +256/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Radical proposal for our own repository structure
« on: February 24, 2022, 06:26:20 pm »
We maintain our own repository structure which is compatible with the standard installation.  We have tried to make the changes as minimal as we needed, for example, making column types and sizing as consistent as we could.

We need (for our own internal processes) to use 3 columns that currently are (always?) empty (as q mentions in his vademecum book - Always NULL ?!).  However, we need to index these columns and they are currently nvarchar(MAX).  nvarchar(MAX) columns in SQL Server cannot be indexed; so we are proposing to make them nvarchar(255) and then index them.

We don't believe this will cause any issues but we'd be interested in any thoughts.  We are interested in any potential "show stoppers"; we have no fear of the changes we're making, and we're not interested in "you won't have a standard installation", we haven't had one for over a decade and a half.

TIA,
Paolo
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: Radical proposal for our own repository structure
« Reply #1 on: February 24, 2022, 08:55:36 pm »
Well, on you own risk... Those question marks just say that I don't know for sure. It's an empirical value. I don't think Sparx will give you any guarantee. Probably you already know all of that ;-) Curious who will chip in.

q.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13378
  • Karma: +563/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Radical proposal for our own repository structure
« Reply #2 on: February 24, 2022, 09:07:31 pm »
I think you're probably going to be allright.

I don't really see a potential showstopper.


Geert

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8604
  • Karma: +256/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: Radical proposal for our own repository structure
« Reply #3 on: February 24, 2022, 09:35:28 pm »
Well, on your own risk... Those question marks just say that I don't know for sure. It's an empirical value. I don't think Sparx will give you any guarantee. Probably you already know all of that ;-) Curious who will chip in.

q.
We're looking at the "flag" columns:

StateFlags Always NULL ⁈
PackageFlags Always NULL ⁈
ActionFlags Always NULL ⁈


Actually, only two of these three will need to be converted (after some more design work).  I've checked two of our very large repositories and (as per your book), they are all NULL.


Paolo
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13378
  • Karma: +563/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Radical proposal for our own repository structure
« Reply #4 on: February 24, 2022, 09:44:58 pm »
PackageFlags are definitely used if you want to enable version control.

Haven't used the other ones yet

Geert

Modesto Vega

  • EA Practitioner
  • ***
  • Posts: 1121
  • Karma: +29/-8
    • View Profile
Re: Radical proposal for our own repository structure
« Reply #5 on: February 24, 2022, 10:10:17 pm »
I would be very, very careful. There are many NVARCHAR(MAX) columns in the repository, some of them are definitely use - e.g., StyleEx or PDATA2 to 5. I don't know about the ones your are referring to.

Silly question, but why aren't you using tags or a custom table extending the table you want to extend?

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8604
  • Karma: +256/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: Radical proposal for our own repository structure
« Reply #6 on: February 24, 2022, 10:11:56 pm »
PackageFlags are definitely used if you want to enable version control.

Haven't used the other ones yet

Geert
Are they used (as their name would suggest) for package objects only?  For our purposes, packages are not in scope, so we could coexist.

Since we don't use version control, they're all NULL for us.

Paolo
« Last Edit: February 24, 2022, 10:16:09 pm by Paolo F Cantoni »
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8604
  • Karma: +256/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: Radical proposal for our own repository structure
« Reply #7 on: February 24, 2022, 10:14:09 pm »
I would be very, very careful. There are many NVARCHAR(MAX) columns in the repository, some of them are definitely used - e.g., StyleEx or PDATA2 to 5. I don't know about the ones your are referring to.

Silly question, but why aren't you using tags or a custom table extending the table you want to extend?
Don't want to do unnecessary joins.  We have very large repositories (and they'll get bigger). Since these are unused...

Paolo
« Last Edit: February 24, 2022, 10:15:46 pm by Paolo F Cantoni »
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8604
  • Karma: +256/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: Radical proposal for our own repository structure
« Reply #8 on: February 25, 2022, 12:33:47 pm »
PackageFlags are definitely used if you want to enable version control.

Haven't used the other ones yet

Geert
Q, you may want to update your book!


Paolo
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: Radical proposal for our own repository structure
« Reply #9 on: February 25, 2022, 07:55:04 pm »
Q, you may want to update your book!

Paolo
Will do so. Indeed I had not turned on VC when examining that flag.

q.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13378
  • Karma: +563/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Radical proposal for our own repository structure
« Reply #10 on: February 25, 2022, 08:00:06 pm »
to be clear, I was talking about t_package.PackageFlags

Geert

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8604
  • Karma: +256/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: Radical proposal for our own repository structure
« Reply #11 on: February 25, 2022, 09:07:05 pm »
to be clear, I was talking about t_package.PackageFlags

Geert
AndI was talking about t_object.PackageFlags   ;D

Paolo
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13378
  • Karma: +563/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Radical proposal for our own repository structure
« Reply #12 on: February 25, 2022, 10:22:59 pm »
to be clear, I was talking about t_package.PackageFlags

Geert
AndI was talking about t_object.PackageFlags   ;D

Paolo

t_object.PackageFlags is always null on all of my models.
t_object.StateFlags is used when you right click on an object in a diagram and choose Advanced | Set Object State
t_object.ActionFlags is always null on all of my models as well

Geert

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: Radical proposal for our own repository structure
« Reply #13 on: February 25, 2022, 11:15:00 pm »
In any case I will perform tests with VC turned on. The only pain is that I have to setup that ancient subversion again :-/

q.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13378
  • Karma: +563/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Radical proposal for our own repository structure
« Reply #14 on: February 26, 2022, 12:35:20 am »
In any case I will perform tests with VC turned on. The only pain is that I have to setup that ancient subversion again :-/

q.
You can use Azure Devops (TFS) as well, but knowing your love for anything Microsoft I guess that won't be a better option? ;D

Geert