Introduction: Nowadays, NoSQL databases have taken on an increasingly important role in the storage of massive data within companies. Due to a common property called schema-less, NoSQL databases offer great flexibility, particularly for the storage of data in different formats. However, despite their success in data storage, schema-less databases are a major obstacle in areas requiring precise knowledge of this schema, especially in the field of data integration. Method: This study presents a Systematic Literature Review (SLR) to explore, evaluate, and discuss relevant existing research and endeavors using novel schema extraction approaches. Furthermore, we conducted this study using a well-defined methodology to examine and study the problem of schema extraction from NoSQL databases. Results: Our research results highlight and emphasize the scheme extraction approaches and provide knowledge to researchers and practitioners by proposing schema extraction approaches and their limitations, which contributes to inventing new, more efficient approaches. Conclusion: In our future work, inspired by the recent advances in quantum computing and the emergence of post-quantum cryptography (PQC), we aim to propose a schema extraction approach that blends cutting-edge technologies with a strong focus on database security.

Humans make irrational decisions in the presence of irrelevant distractor options. There is little consensus on whether decision making is facilitated or impaired by the presence of a highly rewarding distractor, or whether the distractor effect operates at the level of options' component attributes rather than at the level of their overall value. To reconcile different claims, we argue that it is important to consider the diversity of people's styles of decision making and whether choice attributes are combined in an additive or multiplicative way. Employing a multi-laboratory dataset investigating the same experimental paradigm, we demonstrated that people used a mix of both approaches and the extent to which approach was used varied across individuals. Critically, we identified that this variability was correlated with the distractor effect during decision making. Individuals who tended to use a multiplicative approach to compute value, showed a positive distractor effect. In contrast, a negative distractor effect (divisive normalisation) was prominent in individuals tending towards an additive approach. Findings suggest that the distractor effect is related to how value is constructed, which in turn may be influenced by task and subject specificities. This concurs with recent behavioural and neuroscience findings that multiple distractor effects co-exist.

Despite the continued focus on profiling gambling helpline callers, little is known about the characteristics of callers in Macao. To address this gap, this study aims to investigate the characteristics of problem gamblers calling the helpline in Macao and explore the regional differences between callers from Macao, mainland China, and Hong Kong. Specifically, the study examined their demographics, helpline usage, and gambling-related characteristics. The study used data collected by SKHSSCO between 2015 and 2021. The results showed that, at the aggregate level, the helpline callers in Macao were male, young, and full-time employees. The majority used the telephone and reported problems with casino table games. In addition, the referral rate was relatively low, while the rate of suicidal ideation was comparatively high. The results also revealed that callers from Macao, mainland China, and Hong Kong were notably distinct in these characteristics. The findings shed light on how to increase helpline accessibility and create tailored interventions and prevention efforts to better support individuals affected by problem gambling.

Overconfidence, a widely observed cognitive bias, has been linked to increased gambling motivations and behaviors. However, previous studies have largely overlooked overconfidence under a social comparison context, known as overplacement, i.e., the tendency of individuals to believe that they are better than their similar peers. In the present study, we tested the effect of overplacement on gambling motivations and behaviors though a Pilot Survey of Chinese college students (N = 129) and a Field Survey of Chinese Macao casino gamblers (N = 733). Our results revealed a double-edged sword effect of overplacement: Serving as a risk factor, evaluating one self's earning ability as higher than others was linked to more gambling motivations (β = 0.18, p = .005) and frequency (β = 0.18, p = .004); Serving as a protective factor, evaluating oneself as happier than others was linked to less gambling motivations (β = - 0.32, p < .001) and problem behaviors (β = - 0.26, p < .001). These findings expand the relationship between overconfidence and gambling from a cognitive bias perspective to a social comparison perspective. Our study not only revealed a typical profile of gambling motivations and behaviors among different demographic groups in Chinese casino gamblers, but also highlighted the importance of considering social factors in the study of the psychological mechanisms of gambling.

ABSTRACT This paper examines the influence of labor market power in the audit profession. Using a dataset of online job postings, we confirm that audit offices in more concentrated labor markets have greater labor market power and exercise it in the form of higher skill requirements and greater required effort from their auditors, at similar or slightly lower wages. We then show that client firms of audit offices in more concentrated labor markets are less likely to restate their earnings and have lower absolute discretionary accruals. These findings are only present when employees have lower mobility across professions and geographies, consistent with audit offices’ power in the local labor market explaining the results. Collectively, our findings highlight the importance of labor market power in understanding audit quality. Data Availability: Data are available from the sources cited in the text. JEL Classifications: J31; J40; J42; M42; M55.