Short question related to official anchor modeler.
While modeling ties you can setup roles properties, one of them is "first role".
What does "Make first role" option do?
I see in the xml/sql file it swaps the roles order within a Tie.
Is it only a purely technical setting or there is a business case for it?
Anchor modeling - tie: make first role?
304 views Asked by jangorecki At
1
There are 1 answers
Related Questions in DATABASE-DESIGN
- SQL schema for a fill-in-the-blank exercise
- When an E-R attribute should be perceived as a relationship attribute or as an entity set attribute?
- steps to create a web app with backend and database and web
- Use data type uuid or varchar(36) for my UUID column?
- Containing Object Design
- Many-to-many relationship between objects of the same type
- When hashing an API key, should I hash the suffix / prefix as well?
- Database design, authentication and authorization in a microservices ticketing system
- Unique index on 3 columns where NULL conflicts with all other values in one column
- Can i create a table with 2 foreign keys? These 2 foreign keys are 2 primary keys of 2 different tables
- I have a basic ms access question about a relationship between 3 tables
- how can i calculate mutual friends/followers efficiently?
- Access Table ,setting in design ,column 'Catagory' as Combobox in lookup with list "Action";"War";"Drama". in vb.net DGV and Detail how to multiselct
- Table Design for Calculating Median Over User-Defined Period from Pre-Processed Data
- Use conditional constraint or normalize table?
Related Questions in DATA-MODELING
- Does Power BI provide an OOTB Geographical Dimension Table
- Table Restructuring Options in PowerBI
- How to model such that a drill through for Order suppliers having M:1 relation with Order fact table can be configured?
- Excel formula to change sum field depending on date
- How to properly define data models in TypeScript?
- Power Bi - Modelling
- How to create a MySQL table or store the values in the MySQL table if values is of type python list
- Dynamo DB M:N relationship issue
- What data type is appropriate for star schema keys (integer or text)?
- How to fetch data from this Nested JSON using GET method in flutter using Data Model?
- How to model composite primary keys in the ER model?
- LSTM layer in Sequential model requires 3d input but only receives d2
- How can I generate many random community matrices and then apply a function to all of them?
- Model the number of available spots in dimension or fact table?
- How to get data collection from a nested list of a data collection from postman api to list<dynamic> in dart Flutter
Related Questions in DATA-WAREHOUSE
- How to blind data in data warehouse when sending from preanonymized layer to anonymized layer while keeping referential integrity of all key columns
- Run Pyspark job using Matillion
- the right grain of a fact table in data warehouse
- Model the number of available spots in dimension or fact table?
- What is the most efficient way to generate a change data set given two SQL Server backup files?
- Does it make sense to use an IDENTITY column in a raw layer?
- Power BI star (constellation) schema: 2 fact tables with relation between each other
- Rolling Period Table or CTE
- Representation of sequential rules in data mining (sequence pattern mining)
- Snowflake Bulk Inserts vs. Single Row Inserts
- Data not showing in power bi report
- Data Warehouse to Power BI Desktop
- Error initialize process greenplum major upgrade 5.29.12 to 6.25.2 on centos 7
- Modify column type in Parquet file with ruby (using parquet Gem)
- Translating Snowflake warehouse usage to BigQuery
Related Questions in TEMPORAL-DATABASE
- How to avoid breaking queries in Temporal Tables after SCHEMA changes?
- Temporal datasets calculation with "PyPardisoError: The Pardiso solver failed with error code -4" error
- How do i determine whether a given entry has foreign keys pointing to it?
- Query to find active records on a given date in a table recording "start" and "stop" dates
- Backing up MariaDB Temporal Database
- Persisting a temporal collection with JPA
- Concept of "version control" for database table rows (Not referring to storing scripts in GIT/SVN)
- Django custom creation manager logic for temporal database
- sklearn random forest search for model parameters for a model that will predict continuous temporal variables
- Add historic data to system versioned temporal table (SQL Server 2017)
- Is it possible to merge two .csv files to the nearest hour?
- Application-time period tables
- IBM DB2 Timetravel logging based on some criteria
- How to delete temporal documents from MarkLogic database physically?
- How to join with / subselect in a system-period temporal table
Related Questions in ANCHOR-MODELING
- Managing Entity Resolution in Anchor Modeling
- EMF (OCL) concatenate two enumerations into one
- Join elimination not working in Oracle with sub queries
- How to send data from OLE DB source to Anchor model tables using ETL procedure?
- Anchor modeling - tie: make first role?
- Anchor Modeling - are data types part of the Model?
- Agile/evolutionary database modelling for an evolving content management application
- What is meant by non-destructive schema evolution in Anchor Modeling?
- What are the pros and cons of Anchor Modeling?
- Temporal database design, with a twist (live vs draft rows)
- Are there any data warehouse frameworks?
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
A tie represents a relationship, which in Anchor modeling is a set of roles on type level. Sets have no ordering, for example
{isLeasing, theVehicle, withAgreement} = {withAgreement, theVehicle, isLeasing}, but names of ties are represented as strings in our naming convention. To create a string, some order must be imposed onto the set, and the "Make first role" is only a way to rearrange that order. It is just syntactic sugar, and the semantics of the tie remains the same regardless of the order of the roles in the name. So, with the mentioned example, the tie named PE_isLeasing_VE_theVehicle_AG_withAgreement is the same tie as the one named AG_withAgreement_VE_theVehicle_PE_isLeasing. The tool will even prevent you from creating duplicate ties, should you try to do so. Because of the way we read natural language some orderings are easier to interpret than others though, which would be the "business case" for changing it.